Short Answer Type Questions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9 PDF Download

Q.1. Name the three alignment types of:
(i) Horizontal Alignment 
(ii) Vertical Alignment

(i) Left, Right and Center
(ii) Top, Bottom and Middle

Q.2. What is the function of 'Autofill'? Which Tab option allows you to fill up a series using Autofill?

Autofill is a featurein Excel, that automatically fills certain boxes with data based on information the user has entered elsewhere.
Home Tab

Q.3. State the difference between a Worksheet and a Workbook.

Excel Workbook is like a book that contains a number of pages while Excel Worksheet is a single page or sheet of a workbook like a page in a book. Linking two worksheets is more easy than linking two workbooks. Workbook is not a place where we manipulate with data.

Q.4. Name the Toolbar that contains the 'Save' button in Excel.

Quick Access Toolbar

Q.5. What is the last row heading and column heading in Excel?

Last column heading: XFD
Last row heading: 1048576

Q.6. Name the three methods by which you can edit the contents of a cell in Excel.

• Replace Content
• Direct Cell Editing
• Formula bar Editing

Q.7. What is a cell reference? How would you declare a cell range using a cell reference?

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.
A cell range is a group or block of cells in a worksheet that has been selected or highlighted. When cells have been selected they are surrounded by an outline or border as shown in the image to the left.

Q.8. State the difference between 'Shift cells up' and 'Entire row' option used with deletion.

Shift cells up option to fill the space produced by the deleted cell with the cell underneath it.

Entire rows option after selecting at least one cell, deletes the entire row from the sheet.

Q.9. Which Tab host the New, Save and Open option in Excel?

File

Q.10. What is the alignment by default in Excel for Numbers and Text?

Numbers: Right Aligned
Text: Left Aligned