**1.Fill in the blanks.**

(1) Excel is a

__electronic spreadsheet__program in the Microsoft Office suit.
(2) The intersection of a column and row is called a

__cell__.
(3) A selected cell is called a/an

__Active__cell.
(4) The

__Name Box__displays the address of the active cell.
(5) The data entered in a cell is also displayed in the

__Formula Bar__.
(6) By default, a number is displayed

__Right__aligned in a cell.
(7) By default, text data type in a cell is

__Left__aligned.
(8) A worksheet in excel can have a maximum of

__65536__rows.
(9) Excel adds the extension

__.xls__to every workbook file.
(10) A

__Chart__is a graphical representation of spread sheet data.**2.State whether the following statements are true or false:**

(1) You can press CTRL
+ N key combination on the keyboard to create a new blank workbook in excel True.

(2) The Menu bar in
Excel has a main menu item data.True

(3) In Excel, by
default, data Type Date is left aligned in a cell True.

(4) The address of
active cell can be seen in Formula Bar True.

(5) To select all
cells in a workbook column, you can double click on any cell of that column False.

(6) You can give
meaningful name to a worksheet in excel True.

(7) The formula,
=A5+D5, will return the sum of the numbers in the rage of A5 to D5.False.

(8) The formula
=MEAN(A5:D5), will return the arithmetic mean of the numbers in the rage A5 to
D5.True.

(9) The formula
=POWER(4,-2), is a valid formula. False.

(10) You can hide or
close the Task pane in Excel from the View menu. True.

**3.Answer the questions in one or two sentences each:**

(1) What is mean by spreadsheet?

**Ans.**A spread sheet contains rows and columns to record and compare financial or numerical data.

(2)Name any two spreadsheet programs.

**Ans.**Mark sheet of class, Payroll sheet for employees.

(3) What are the different types of data that can be
entered in a worksheet cell?

**Ans.**Numbers with symbols, Text, Formula and date and time can be entered in a worksheet cell.

(4) What is the use of the Formula bar in Excel?

**Ans.**Formula bar displays the content of a cell which is active. It help us to edit the formula or content of active cell.

**4. Which menu command or tool will you use to perform each of the following functions:**

(1) Create a new workbook.

**Ans.**Select file menu and click on new.

(2)Delete a sheet from a workbook.

**Ans.**Select edit menu and click on delete sheet.

(3) Insert new worksheet in workbook.

**Ans.**Select insert menu and click on worksheet.

(4) Adjust the area of worksheet that will be printed on page.

**Ans.**Select file menu and click on Print Area.

## No comments:

## Post a Comment