Dive into the essentials of MS Excel with this trivia quiz! Explore key concepts like cell addresses, columns, rows, sheet tabs, and built-in functions. Perfect for enhancing your Excel skills and understanding, this quiz is tailored for learners aiming to master workbook operations and formula usage.
$
\
*
Rate this question:
* (asterisk)
\ (forward slash)
= (equal sign)
Rate this question:
Formula
Operator
Cell address
Rate this question:
(D4:D9)
(D4,D9)
(D4+D9)
Rate this question:
The formula is missing the math operator.
The column width is not wide enough to display the results.
You entered an invalid cell reference.
Rate this question:
True
False
Rate this question:
Column
Row
Absolute reference
Rate this question:
=
(A10:A15)
SUM
Rate this question:
1
3
5
Rate this question:
True
False
Rate this question:
Active cell
Formula bar
Worksheet name
Rate this question:
True
False
Rate this question:
Ctrl + ~
Ctrl + F5
Ctrl + $
Rate this question:
A vertical range of cells referred to by a number.
A horizontal range of cells referred to by a number.
A vertical range of cells referred to by a letter.
Rate this question:
Function
Value
Sort
Rate this question:
=C5*$D$9
=C4*$D$9
=C5*D9
Rate this question:
True
False
Rate this question:
The cell reference automatically changes when the formula is copied down a column or across a row.
The cell uses the A1 reference style.
The cell reference is fixed or locked.
Rate this question:
True
False
Rate this question:
Quiz Review Timeline (Updated): Mar 17, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.