**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