Which Excel chart type is best suited to show trends over time, like monthly sales?
Correct answer: D
A line chart is well suited to displaying trends over a continuous period, such as time.
Computer
✓ 0
✗ 0
Your Result
0 correct out of 0 attempted (0%)
Which Excel chart type uses horizontal or vertical rectangular bars to compare values across categories?
Correct answer: C
Bar or column charts use rectangular bars to compare values across different categories.
Which Excel chart type is best suited for showing the relationship or correlation between two numeric variables?
Correct answer: B
A scatter chart plots pairs of numeric values, useful for showing correlation between variables.
What symbol, when placed before a column or row reference (e.g. $A$1), makes that reference absolute in a formula?
Correct answer: A
The dollar sign fixes a column and/or row reference so it doesn't change when the formula is copied.
What term describes a cell reference like A1, which automatically adjusts when a formula is copied to other cells?
Correct answer: D
A relative reference adjusts automatically based on the position where a formula is copied.
What term describes a cell reference like $A$1, which stays fixed when a formula is copied elsewhere?
Correct answer: A
An absolute reference remains fixed to a specific cell, regardless of where the formula is copied.
What term describes a cell reference like $A1 or A$1, where only the row or only the column is fixed?
Correct answer: A
A mixed reference fixes either the row or the column, but not both, using a single dollar sign.
What is it called when a formula refers back to its own cell, directly or indirectly, causing a calculation loop?
Correct answer: C
A circular reference occurs when a formula depends, directly or indirectly, on its own result.
What term describes giving a cell or range a descriptive label, like 'TaxRate', to use in formulas instead of its address?
Correct answer: A
A named range assigns a descriptive name to a cell or range for easier use in formulas.
What error value appears in Excel when a formula tries to divide a number by zero?
Correct answer: D
#DIV/0! appears when a formula attempts to divide by zero.
What error value appears in Excel when a lookup function cannot find the requested value?
Correct answer: D
#N/A indicates that a value is not available, often from a failed lookup.
What error value appears in Excel when a formula references a cell that has been deleted?
Correct answer: B
#REF! appears when a formula refers to a cell that no longer exists, often due to deletion.
What error value appears in Excel when a formula contains the wrong type of argument, like text where a number is expected?
Correct answer: A
#VALUE! indicates that a formula's argument is of the wrong data type.
What error value appears in Excel when it doesn't recognize text used in a formula, often due to a typo in a function name?
Correct answer: C
#NAME? typically indicates a misspelled function name or an unrecognized reference.
What is the maximum number of rows in a worksheet in modern versions of Excel (2007 and later)?
Correct answer: D
Since Excel 2007, worksheets support up to 1,048,576 rows.
What is the maximum number of columns in a worksheet in modern versions of Excel (2007 and later)?
Correct answer: B
Since Excel 2007, worksheets support up to 16,384 columns, labeled up to XFD.
What is the keyboard shortcut to insert the current date in a cell in Excel?
Correct answer: A
Ctrl+; inserts the current date as a static value into the active cell.
What is the keyboard shortcut to insert the current time in a cell in Excel?
Correct answer: D
Ctrl+Shift+; inserts the current time as a static value into the active cell.
What is the keyboard shortcut to move to cell A1 (the beginning of a worksheet) in Excel?
Correct answer: B
Ctrl+Home moves the cursor directly to cell A1.
What is the keyboard shortcut to jump to the last used cell in a worksheet in Excel?
Correct answer: A
Ctrl+End moves the cursor to the last cell containing data in the worksheet.
What is the keyboard shortcut to create a chart from selected data in Excel?
Correct answer: A
F11 quickly creates a chart on a new sheet from the selected data.
What is the keyboard shortcut to edit the contents of the currently selected cell in Excel?
Correct answer: A
F2 puts the currently selected cell into edit mode.
What is the keyboard shortcut to repeat the last action or toggle absolute/relative references in a formula in Excel?
Correct answer: B
F4 repeats the last action, or cycles reference types ($) when editing a formula.
What is the keyboard shortcut to open the 'Go To' dialog box in Excel?
Correct answer: C
F5 (or Ctrl+G) opens the Go To dialog to jump to a specific cell or named range.
Which Excel feature lets multiple people edit the same workbook file at the same time online?
Correct answer: C
Co-authoring allows multiple users to edit a shared Excel workbook simultaneously, typically via cloud storage.