Spreadsheets1

25 Questions | Attempts: 617
Share
SettingsSettings
Please wait...
  • 1/25 Questions

    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?

    • Addition operator
    • Dovision operator
    • Equal sign
    • Substraction sign
Please wait...
About This Quiz

This spreadsheet exam measures your knowledge of spreadsheet terms and concepts.

Computer Program Quizzes & Trivia

Quiz Preview

  • 2. 

    An advantage of a spreadsheet is the speed of accomplishing what?

    • Calculating numbers

    • Grammar checking

    • Newsletter creating

    • Searching and retrieving

    Correct Answer
    A. Calculating numbers
  • 3. 

    The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 31?

    • =MAX(A1:A6)

    • =MIN(A1:A6)

    • =ROUND(A1:A6)

    • =SUM(A1:A6)

    Correct Answer
    A. =SUM(A1:A6)
  • 4. 

    Which function would be used to indicate the smallest value in a range of spreadsheet cells?

    • COUNT

    • MAX

    • MIN

    • SUM

    Correct Answer
    A. MIN
  • 5. 

    The intersection of a column and row in a spreadsheet is called what?

    • Cell

    • Column

    • Function

    • Row

    Correct Answer
    A. Cell
  • 6. 

    What specific format would change 29.99 to $29.99?

    • Currency

    • Number

    • Percentage

    • Scientific

    Correct Answer
    A. Currency
  • 7. 

    What is a statement that performs a calculation in a spreadsheet?

    • Cell

    • Formula

    • Label

    • Value

    Correct Answer
    A. Formula
  • 8. 

    The cell in which you are currently working is known as what?

    • Active cell

    • Cell address

    • Cell reference

    • Spreadsheet cell

    Correct Answer
    A. Active cell
  • 9. 

    The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?

    • =MAX(A1:A6)

    • =MIN(A1:A6)

    • =AVERAGE(A1:A6)

    • =SUM(A1:A6)

    Correct Answer
    A. =AVERAGE(A1:A6)
  • 10. 

    What are the three most common types of charts used to illustrate spreadsheet data?

    • Bar, line, and pie

    • Bar, line, and scattergram

    • Line, pie, and area

    • Pie, scattergram, and stacked bar

    Correct Answer
    A. Bar, line, and pie
  • 11. 

    Which function would return the same answer as the formula =B2+B3+B4+B5+B6+B7?

    • =SUM(B2/B7)

    • =SUM(B2+B7)

    • =SUM(B2:B7)

    • =SUM(B2*B7)

    Correct Answer
    A. =SUM(B2:B7)
  • 12. 

    A mathematical operation that is built into a spreadsheet program to perform shortcut calculations is called what?

    • Cell

    • Function

    • Label

    • Value

    Correct Answer
    A. Function
  • 13. 

    What is the vertical portion of a spreadsheet that is identified by a letter?

    • Cell

    • Column

    • Reference

    • Row

    Correct Answer
    A. Column
  • 14. 

    The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 2.  What function would return the answer 2?

    • =MAX(A1:A6)

    • =MIN(A1:A6)

    • =ROUND(A1:A6)

    • =SUM(A1:A6)

    Correct Answer
    A. =MIN(A1:A6)
  • 15. 

    What is the horizontal portion of a spreadsheet that is identified by a number?

    • Cell

    • Column

    • Reference

    • Row

    Correct Answer
    A. Row
  • 16. 

    What are cells that need to remain the same when copied?

    • Absolute

    • Automation

    • Relational

    • Relative

    Correct Answer
    A. Absolute
  • 17. 

    A series of dialog boxes used to provide steps in creating a chart is called what?

    • Chart helper

    • Chart wizard

    • Guide master

    • Wizard maker

    Correct Answer
    A. Chart wizard
  • 18. 

    How is spreadsheet software used for personal use?

    • Doing language art homework

    • Keying a personal business letter

    • Organizing a baseball card collection

    • Predicting entertainment expenses

    Correct Answer
    A. Predicting entertainment expenses
  • 19. 

    Repeated pound signs in a spreadsheet cell indicate what?

    • Column width too narrow

    • Column width too wide

    • Row height too narrow

    • Row height too wide

    Correct Answer
    A. Column width too narrow
  • 20. 

    What is the first step in creating a chart or graph?

    • Choose page setup for orientation

    • Choose the chart wizard for help

    • Select print preview to see graph

    • Select the data you wish to plot

    Correct Answer
    A. Select the data you wish to plot
  • 21. 

    Numerical data entered into a spreadsheet is called what?

    • Formula

    • Label

    • Text

    • Value

    Correct Answer
    A. Value
  • 22. 

    What are bar charts MOST effectively used to show?

    • Compare groups of similar data

    • Present scientific data

    • Show data as part of a whole

    • Show changes over a period of time

    Correct Answer
    A. Compare groups of similar data
  • 23. 

    Cells that automatically change when copied are called what?

    • Absolute

    • Automation

    • Relational

    • Relative

    Correct Answer
    A. Relative
  • 24. 

    What is one advantage of a spreadsheet program?

    • Answers "what does" questions

    • Answers "what if" questions

    • Checks for inaccurate data

    • Writes formulas automatically

    Correct Answer
    A. Answers "what if" questions
  • 25. 

    What is alphabetical text entered into a spreadsheet?

    • Formula

    • Label

    • Text

    • Value

    Correct Answer
    A. Label

Quiz Review Timeline (Updated): Dec 26, 2012 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 26, 2012
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 18, 2009
    Quiz Created by
    Gthomp
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.