Nc Computer Skills Quiz-spreedsheets

19 Questions | Total Attempts: 548

SettingsSettingsSettings
Please wait...
Nc Computer Skills Quiz-spreedsheets

NC Computer Skills Quiz-Spreedsheets


Questions and Answers
  • 1. 
    The most useful functions of a spreadsheet are:
    • A. 

      Lines and pictures

    • B. 

      Fonts and borders

    • C. 

      Formulas and graphs

    • D. 

      Labels and envelopes

  • 2. 
    Mathematical calculations in a spreadsheet are called
    • A. 

      Words

    • B. 

      Labels

    • C. 

      Formulas

    • D. 

      Values

  • 3. 
    Your math teacher has asked you to create a chart comparing candy sales for the last 3 years. Which chart will best display your data?
    • A. 

      Pie chart

    • B. 

      Bar chart

    • C. 

      Scattergram

    • D. 

      Line graph

  • 4. 
    Which of the following is an example of an addition formula?
    • A. 

      =B4+D7

    • B. 

      2+3+6=11

    • C. 

      F3*G7

    • D. 

      B9/B6

  • 5. 
    Which of the following is an example of a subtraction formula?
    • A. 

      A-B

    • B. 

      =C10-B9

    • C. 

      $14.00-$5.00=$9.00

    • D. 

      B9/B6

  • 6. 
    Which of the following is an example of a multiplication formula?
    • A. 

      =L3*C7

    • B. 

      B2+B3/C4

    • C. 

      B4 X B6

    • D. 

      46 X 39

  • 7. 
    Which type of chart best illustrates values as part of a whole picture?
    • A. 

      Line graph

    • B. 

      Scattergram

    • C. 

      Bar chart

    • D. 

      Pie chart

  • 8. 
    All of the following tasks can be completed using a spreadsheet, except:
    • A. 

      Create a graph comparing class attendance rate

    • B. 

      Create a brochure for the band camp

    • C. 

      Track batting averages for the softball team

    • D. 

      Keep track of field trip payments for the class trip

  • 9. 
    What is the relationship between spreadsheets and graphs?
    • A. 

      There isn’t one

    • B. 

      Graphs generate spreadsheets

    • C. 

      Graphs generate formulas

    • D. 

      Graphs depict the spreadsheet data

  • 10. 
    The numbers in a spreadsheet from cell A1:A49 show candy bar sales last year. How can you find the total number of candy bars sold?
    • A. 

      Add the numbers in cell A1 and A49 together

    • B. 

      Subtract the number in cell A49 from cell A1

    • C. 

      Multiply cell A1 by cell A49

    • D. 

      Add the range of numbers from A1 through A49

  • 11. 
    • A. 

      Address label

    • B. 

      Title bar

    • C. 

      Formula bar

    • D. 

      Active cell

  • 12. 
    Which of the following is an example of a questions that can be answer by a spreadsheet?
    • A. 

      Where?

    • B. 

      Why?

    • C. 

      What if?

    • D. 

      When?

  • 13. 
    A spreadsheet is a tool that allows you to:
    • A. 

      Manipulate data with numbers and text

    • B. 

      View and manipulate text

    • C. 

      Manipulate graphics

    • D. 

      Make nice banners and posters

  • 14. 
    How could the total cost of food sold in the cafeteria for one day be calculated?
    • A. 

      Add cells C2 through C6

    • B. 

      Add cells A2 through A6

    • C. 

      Add cells D2 through D6

    • D. 

      Add cells A6 through D6

  • 15. 
    If 189 more hamburgers were sold, which cell would change?
    • A. 

      A3 and A5

    • B. 

      A4 and B4

    • C. 

      A3 and D3

    • D. 

      B3 and C3

  • 16. 
    What does COST/UNIT mean?
    • A. 

      Quantity multiplied by Total Cost

    • B. 

      Total cost of today’s menu

    • C. 

      Cost of one single item

    • D. 

      Quantity multiplied by Item

  • 17. 
    Which of the following best describes the places where the costs in Column C are entered?
    • A. 

      Fields

    • B. 

      Values

    • C. 

      Formulas

    • D. 

      Cells

  • 18. 
    Which column contains data generated by formulas?
    • A. 

      Column A

    • B. 

      Column B

    • C. 

      Column D

    • D. 

      Column 6

  • 19. 
    If you wanted to predict how many fries would have to be sold for the TOTAL COST of fries to be equal to $200.00, which cell would you change the value until the desired was reached?
    • A. 

      A6

    • B. 

      B6

    • C. 

      C6

    • D. 

      D6