Worksheet Solutions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9 PDF Download

Q.1. Fill in the blanks with the given words.

(i) In a cell you can have either a Horizontal or/and Vertical alignment.
(ii) To default name of an Excel workbook is Book1.
(iii) The XFD is the last column name in Excel.
(iv) A workbook is a file in which data in kept in worksheets.
(v) Cell reference refers to a location of a cell which is the column name followed by row number.
(vi) Use the keyboard combination Ctrl+1 to activate Format Cells.
(vii) An intersection point of a row and a column is called a Cell.
(viii) By default text is aligned to the left and numbers are aligned to the right.
(ix) The Editing group of the Home Tab contains the Fill command.
(x) Shift cells up option of the Delete dialog is used to fill the space produced by the deleted cell with the cell underneath it.

Q.2. State whether the following statements are True (T) or False (F).
(i) The default name for a worksheet in Excel is Sheet1. True
(ii) The address of a cell is referred by the row number followed by the column number. False
(iii) You can have maximum 10000 rows in an Excel worksheet. False
(iv) An Excel worksheet there are maximum 1028 columns. False
(v) A cell range is used to represent a group of cells. True
(vi)  An Active Cell always have a thick border around it. True
(vii) The Function Key F3 is used for direct cell editing. False
(viii) It is not possible to select an entire worksheet at the click of a button. False
(ix) The Name Box is used to show the address of the current selection or active cell in the form of Column and Row Headings. True
(x) The content of a row or column cannot be deleted. False