Spreadsheets1
This spreadsheet exam measures your knowledge of spreadsheet terms and concepts.
- 1.
An advantage of a spreadsheet is the speed of accomplishing what?
- A.
Calculating numbers
- B.
Grammar checking
- C.
Newsletter creating
- D.
Searching and retrieving
Correct Answer
A. Calculating numbers -
- 2.
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 31?
- A.
=MAX(A1:A6)
- B.
=MIN(A1:A6)
- C.
=ROUND(A1:A6)
- D.
=SUM(A1:A6)
Correct Answer
D. =SUM(A1:A6) -
- 3.
When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?
- A.
Addition operator
- B.
Dovision operator
- C.
Equal sign
- D.
Substraction sign
Correct Answer
C. Equal sign -
- 4.
The intersection of a column and row in a spreadsheet is called what?
- A.
Cell
- B.
Column
- C.
Function
- D.
Row
Correct Answer
A. Cell -
- 5.
What is the horizontal portion of a spreadsheet that is identified by a number?
- A.
Cell
- B.
Column
- C.
Reference
- D.
Row
Correct Answer
D. Row -
- 6.
A mathematical operation that is built into a spreadsheet program to perform shortcut calculations is called what?
- A.
Cell
- B.
Function
- C.
Label
- D.
Value
Correct Answer
B. Function -
- 7.
Numerical data entered into a spreadsheet is called what?
- A.
Formula
- B.
Label
- C.
Text
- D.
Value
Correct Answer
D. Value -
- 8.
What is alphabetical text entered into a spreadsheet?
- A.
Formula
- B.
Label
- C.
Text
- D.
Value
Correct Answer
B. Label -
- 9.
What is a statement that performs a calculation in a spreadsheet?
- A.
Cell
- B.
Formula
- C.
Label
- D.
Value
Correct Answer
B. Formula -
- 10.
The cell in which you are currently working is known as what?
- A.
Active cell
- B.
Cell address
- C.
Cell reference
- D.
Spreadsheet cell
Correct Answer
A. Active cell -
- 11.
What is the vertical portion of a spreadsheet that is identified by a letter?
- A.
Cell
- B.
Column
- C.
Reference
- D.
Row
Correct Answer
B. Column -
- 12.
Which function would be used to indicate the smallest value in a range of spreadsheet cells?
- A.
COUNT
- B.
MAX
- C.
MIN
- D.
SUM
Correct Answer
C. MIN -
- 13.
Which function would return the same answer as the formula =B2+B3+B4+B5+B6+B7?
- A.
=SUM(B2/B7)
- B.
=SUM(B2+B7)
- C.
=SUM(B2:B7)
- D.
=SUM(B2*B7)
Correct Answer
C. =SUM(B2:B7) -
- 14.
Cells that automatically change when copied are called what?
- A.
Absolute
- B.
Automation
- C.
Relational
- D.
Relative
Correct Answer
D. Relative -
- 15.
Repeated pound signs in a spreadsheet cell indicate what?
- A.
Column width too narrow
- B.
Column width too wide
- C.
Row height too narrow
- D.
Row height too wide
Correct Answer
A. Column width too narrow -
- 16.
What are cells that need to remain the same when copied?
- A.
Absolute
- B.
Automation
- C.
Relational
- D.
Relative
Correct Answer
A. Absolute -
- 17.
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?
- A.
=MAX(A1:A6)
- B.
=MIN(A1:A6)
- C.
=AVERAGE(A1:A6)
- D.
=SUM(A1:A6)
Correct Answer
C. =AVERAGE(A1:A6) -
- 18.
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 2?
- A.
=MAX(A1:A6)
- B.
=MIN(A1:A6)
- C.
=ROUND(A1:A6)
- D.
=SUM(A1:A6)
Correct Answer
B. =MIN(A1:A6) -
- 19.
What are the three most common types of charts used to illustrate spreadsheet data?
- A.
Bar, line, and pie
- B.
Bar, line, and scattergram
- C.
Line, pie, and area
- D.
Pie, scattergram, and stacked bar
Correct Answer
A. Bar, line, and pie -
- 20.
What is one advantage of a spreadsheet program?
- A.
Answers "what does" questions
- B.
Answers "what if" questions
- C.
Checks for inaccurate data
- D.
Writes formulas automatically
Correct Answer
B. Answers "what if" questions -
- 21.
What specific format would change 29.99 to $29.99?
- A.
Currency
- B.
Number
- C.
Percentage
- D.
Scientific
Correct Answer
A. Currency -
- 22.
What are bar charts MOST effectively used to show?
- A.
Compare groups of similar data
- B.
Present scientific data
- C.
Show data as part of a whole
- D.
Show changes over a period of time
Correct Answer
A. Compare groups of similar data -
- 23.
A series of dialog boxes used to provide steps in creating a chart is called what?
- A.
Chart helper
- B.
Chart wizard
- C.
Guide master
- D.
Wizard maker
Correct Answer
B. Chart wizard -
- 24.
What is the first step in creating a chart or graph?
- A.
Choose page setup for orientation
- B.
Choose the chart wizard for help
- C.
Select print preview to see graph
- D.
Select the data you wish to plot
Correct Answer
D. Select the data you wish to plot -
- 25.
How is spreadsheet software used for personal use?
- A.
Doing language art homework
- B.
Keying a personal business letter
- C.
Organizing a baseball card collection
- D.
Predicting entertainment expenses
Correct Answer
D. 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.
-
Current Version
-
Dec 26, 2012Quiz Edited by
ProProfs Editorial Team -
Mar 18, 2009Quiz Created by
Gthomp
Back to top