Microsoft Excel General 1 Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Microsoft Excel General 1 flashcards as text
Which symbol is used to make a cell reference absolute in Excel formulas?
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.
What keyboard shortcut saves an Excel workbook?
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.
Which Excel function counts only cells that contain numerical values in a range?
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.
What is the maximum number of rows supported in a single Excel 2016 worksheet?
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).
Which Excel feature automatically applies colors or icons to cells based on their values?
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.
Which Excel view shows the spreadsheet exactly as it will look when printed, including headers, footers, and margins?
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.