Spreadsheets1
Settings
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
- 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)
- 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
- 4.The intersection of a column and row in a spreadsheet is called what?
- A.
Cell
- B.
Column
- C.
Function
- D.
Row
- 5.What is the horizontal portion of a spreadsheet that is identified by a number?
- A.
Cell
- B.
Column
- C.
Reference
- 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
- 7.Numerical data entered into a spreadsheet is called what?
- A.
Formula
- B.
Label
- C.
Text
- D.
Value
- 8.What is alphabetical text entered into a spreadsheet?
- A.
Formula
- B.
Label
- C.
Text
- D.
Value
- 9.What is a statement that performs a calculation in a spreadsheet?
- A.
Cell
- B.
Formula
- C.
Label
- D.
Value
- 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
- 11.What is the vertical portion of a spreadsheet that is identified by a letter?
- A.
Cell
- B.
Column
- C.
Reference
- D.
Row
- 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
- 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)
- 14.Cells that automatically change when copied are called what?
- A.
Absolute
- B.
Automation
- C.
Relational
- 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
- 16.What are cells that need to remain the same when copied?
- A.
Absolute
- B.
Automation
- C.
Relational
- D.
Relative
- 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)
- 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)
- 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
- 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
- 21.What specific format would change 29.99 to $29.99?
- A.
Currency
- B.
Number
- C.
Percentage
- D.
Scientific
- 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
- 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
- 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
- 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
Back to top