Microsoft Excel Microsoft Excel General 1 — Questions and Answers
Question 1: Which symbol is used to make a cell reference absolute in Excel formulas?
- @
- #
- $ (Correct answer)
- &
Correct answer: $
The dollar sign ($) locks a row, column, or both in a cell reference (e.g., $A$1), making it absolute so it does not change when the formula is copied to another cell.
Question 2: What keyboard shortcut saves an Excel workbook?
- Ctrl+W
- Ctrl+P
- Ctrl+S (Correct answer)
- Ctrl+Z
Correct answer: Ctrl+S
Ctrl+S is the standard Save shortcut across most Windows applications, including Excel. Ctrl+W closes a workbook, Ctrl+P opens Print, and Ctrl+Z undoes the last action.
Question 3: Which Excel function counts only cells that contain numerical values in a range?
- COUNTA
- COUNTIF
- SUM
- COUNT (Correct answer)
Correct answer: COUNT
COUNT counts only numeric values in a range. COUNTA counts all non-empty cells (including text), COUNTIF counts cells meeting a condition, and SUM adds values together.
Question 4: What is the maximum number of rows supported in a single Excel 2016 worksheet?
- 65,536
- 999,999
- 1,048,576 (Correct answer)
- 16,384
Correct answer: 1,048,576
Excel 2007 and later supports 1,048,576 rows (2^20) per worksheet. The 65,536-row limit applied to Excel 2003 and earlier (.xls format).
Question 5: Which Excel feature automatically applies colors or icons to cells based on their values?
- Data Validation
- Format Painter
- Cell Styles
- Conditional Formatting (Correct answer)
Correct answer: Conditional Formatting
Conditional Formatting applies rules (color scales, data bars, icon sets, or custom rules) that change a cell's appearance automatically based on its value. Format Painter copies existing formats manually; Data Validation restricts input; Cell Styles apply preset static formats.
Question 6: Which Excel view shows the spreadsheet exactly as it will look when printed, including headers, footers, and margins?
- Normal View
- Page Break Preview
- Full Screen View
- Page Layout View (Correct answer)
Correct answer: Page Layout View
Page Layout View displays the worksheet with rulers, margins, headers, and footers as they will appear on the printed page. Page Break Preview shows where pages will break but does not show the full print layout.
Microsoft Excel Microsoft Excel General 1
Which symbol is used to make a cell reference absolute in Excel formulas?