Microsoft Excel Microsoft Excel General 1

Question 1

Which symbol is used to make a cell reference absolute in Excel formulas?

Accepted Answer

$

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?

Accepted Answer

Ctrl+S

Answer

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?

Accepted Answer

COUNT

Answer

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?

Accepted Answer

1,048,576

Answer

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?

Accepted Answer

Conditional Formatting

Answer

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.

Excel Practice Test

Excel Practice Test

Microsoft Excel Microsoft Excel General 1