This spreadsheet exam measures your knowledge of spreadsheet terms and concepts.
Calculating numbers
Grammar checking
Newsletter creating
Searching and retrieving
=MAX(A1:A6)
=MIN(A1:A6)
=ROUND(A1:A6)
=SUM(A1:A6)
Addition operator
Dovision operator
Equal sign
Substraction sign
Cell
Column
Function
Row
Cell
Column
Reference
Row
Cell
Function
Label
Value
Formula
Label
Text
Value
Formula
Label
Text
Value
Cell
Formula
Label
Value
Active cell
Cell address
Cell reference
Spreadsheet cell
Cell
Column
Reference
Row
COUNT
MAX
MIN
SUM
=SUM(B2/B7)
=SUM(B2+B7)
=SUM(B2:B7)
=SUM(B2*B7)
Absolute
Automation
Relational
Relative
Column width too narrow
Column width too wide
Row height too narrow
Row height too wide
Absolute
Automation
Relational
Relative
=MAX(A1:A6)
=MIN(A1:A6)
=AVERAGE(A1:A6)
=SUM(A1:A6)
=MAX(A1:A6)
=MIN(A1:A6)
=ROUND(A1:A6)
=SUM(A1:A6)
Bar, line, and pie
Bar, line, and scattergram
Line, pie, and area
Pie, scattergram, and stacked bar
Answers "what does" questions
Answers "what if" questions
Checks for inaccurate data
Writes formulas automatically
Currency
Number
Percentage
Scientific
Compare groups of similar data
Present scientific data
Show data as part of a whole
Show changes over a period of time
Chart helper
Chart wizard
Guide master
Wizard maker
Choose page setup for orientation
Choose the chart wizard for help
Select print preview to see graph
Select the data you wish to plot
Doing language art homework
Keying a personal business letter
Organizing a baseball card collection
Predicting entertainment expenses
Quiz Review Timeline +
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.