Spreadsheet: An Introduction — Important Questions

Name Box

Step 1: Let us understand what each option does. Step 2: The Title Bar shows the file name and application name at the top of the screen. Step 3: The Formula Bar is used to write and display formulas or data entered in the active cell. Step 4: The Sheet Tab indicates which worksheet you are currently working on. Step 5: The NAME BOX displays the cell address (like A1, B3, etc.) of the currently active or selected cell. So the correct answer is Name Box.

1

Step 1: A workbook in MS Excel is a file that can contain multiple worksheets. Step 2: In older versions of Excel, a new workbook contained 3 sheets by default. Step 3: However, in MS Excel 2013 and later versions (including 2016), a new workbook contains only 1 worksheet (Sheet1) by default. Step 4: The chapter clearly states: 'By default, only one worksheet (Sheet1) is present in a workbook.' Step 5: You can always add more worksheets using the 'New Sheet' button. The correct answer is 1.

String (Text) data

Step 1: MS Excel automatically aligns different types of data differently to help you identify them quickly. Step 2: NUMBER data is right-aligned by default (e.g., 1500, -345, 645.67). Step 3: FORMULA data produces a numeric result, which is also right-aligned. Step 4: STRING (text) data such as names, labels, and alphanumeric values are LEFT-aligned by default. Step 5: This is an important way to distinguish between text and numeric entries in Excel. So the correct answer is String (Text) data.

= A1 + A2 + A3

Step 1: In MS Excel, ALL formulas must begin with an equal sign (=). Step 2: Without the equal sign, Excel treats what you type as plain text, not a calculation. Step 3: Writing just 'A1 + A2 + A3' without '=' would be treated as a text string, not a formula. Step 4: '+ A1 + A2 + A3' is incorrect because formulas must start with '=' not '+'. Step 5: The correct formula is '= A1 + A2 + A3' which tells Excel to add the values in those three cells. The answer is = A1 + A2 + A3.