Spreadsheets1

25 Questions | Total Attempts: 613

SettingsSettingsSettings
Please wait...
Computer Program Quizzes & Trivia

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


Questions and Answers
  • 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