Computer Applications I 4.01 (Td)

30 Questions | Total Attempts: 45

SettingsSettingsSettings
Please wait...
Computer Application Quizzes & Trivia

4. 01 Objective: Spreadsheets in business.


Questions and Answers
  • 1. 
    Ed arranged his speadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179.  This is an example of which operation?
    • A. 

      Embed

    • B. 

      Fill Series

    • C. 

      Freeze

    • D. 

      Link

  • 2. 
    Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades.  Which function should she use to calculate a final grade for each student?
    • A. 

      Average

    • B. 

      Count

    • C. 

      If

    • D. 

      Sum

  • 3. 
    Mr. Evans sorted the students athletes in order by GPA, last name, first name, and homeroom.  GPA is an example of which part of the sort operation?
    • A. 

      Ascending

    • B. 

      Desending

    • C. 

      Primary

    • D. 

      Secondary

  • 4. 
    What Operation will Eve use to keep rows and columns visible so that they don't scroll off the screen as she moeves around the worksheet?
    • A. 

      Embed

    • B. 

      Freeze

    • C. 

      Link

    • D. 

      Fill series

  • 5. 
    What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost?
    • A. 

      Average

    • B. 

      Max

    • C. 

      Min

    • D. 

      Sum

  • 6. 
    What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25%, and her daily work counts 50%?
    • A. 

      Average

    • B. 

      If

    • C. 

      Max

    • D. 

      Min

  • 7. 
    In the formula =f10*$J$4, F10 is an example of a/an?
    • A. 

      Absolute reference

    • B. 

      Mixed reference

    • C. 

      Range

    • D. 

      Relative reference

  • 8. 
    In the formula =f10*$j$4,$j$4 is an example of a/an?
    • A. 

      Absolute reference

    • B. 

      Mixed reference

    • C. 

      Reange

    • D. 

      Relative reference

  • 9. 
    In the formula =$A1+B1, $A1 is an example of  a/an:
    • A. 

      Absolute reference

    • B. 

      Mixed reference

    • C. 

      Range

    • D. 

      Relative reference

  • 10. 
    What formula will divide the value in Cell E5 by the value in Cell E6?
    • A. 

      =E5/E6

    • B. 

      =E5:E6

    • C. 

      =E6/E5

    • D. 

      =E6:E5

  • 11. 
      A B  C  D E 1 Name Instrument  Per Month Fee   Number of Months Total Cost 2 Tom saxphone  $   45.00 10  $    450.00 3 Joan clarinet  $   35.00 10  $    350.00 4 Heather trumpet  $   60.00 5  $    300.00 5 Stan drums  $   55.00    $           -   6 Jose flute  $   42.00    $           -   7 Total Rental Fee  $ 1,100.00 In the MiddleSchool Band spreadsheet, what formula will calculate the total cost per year for the saxophone?
    • A. 

      =B2*C2/10

    • B. 

      =B2/10*C2

    • C. 

      =C2/D2

    • D. 

      =C2*D2

  • 12. 
      A B  C  D E 1 Name Instrument  Per Month Fee   Number of Months Total Cost 2 Tom saxphone  $   45.00 10  $    450.00 3 Joan clarinet  $   35.00 10  $    350.00 4 Heather trumpet  $   60.00 5  $    300.00 5 Stan drums  $   55.00    $           -   6 Jose flute  $   42.00    $           -   7 Total Rental Fee  $ 1,100.00 What format has been applied to Cells C1 and D1?
    • A. 

      Border

    • B. 

      Merge

    • C. 

      Wrap

    • D. 

      Shade

  • 13. 
      A B  C  D E 1 Name Instrument  Per Month Fee   Number of Months Total Cost 2 Tom saxphone  $   45.00 10  $    450.00 3 Joan clarinet  $   35.00 10  $    350.00 4 Heather trumpet  $   60.00 5  $    300.00 5 Stan drums  $   55.00    $           -   6 Jose flute  $   42.00    $           -   7 Total Rental Fee  $ 1,100.00 What formula is used to calculate the Toal Rental Fee?
    • A. 

      =sum(E2:E6)

    • B. 

      =sum(C2:E6)

    • C. 

      =Total(c2:C6)*(D2:D6)

    • D. 

      =Sum(D2:D6)

  • 14. 
    C4 is known as the_________ in spreadsheet
  • 15. 
    A file that contains one or more speadsheets
  • 16. 
    Text or numbers that will not be used in calculations is known as?
  • 17. 
    Data that has potential to be used in calculation.
  • 18. 
    Name the 4 functions that can be used?
  • 19. 
    What is the default setting of a label?
  • 20. 
    What is the default setting of a value?
  • 21. 
    What does ###### mean?
  • 22. 
    Used to combine two or more cells;
  • 23. 
    Used to alighn multi-lined text within a cell
  • 24. 
      A               B C 1 Budget 2 Income   3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses   8 Rent  575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss  $ 580.00 The placement of the individual income items in Cells A3:A6 and expense items in Cells A8:A15 is the result of which formatting?
    • A. 

      Border

    • B. 

      Indent

    • C. 

      Merge

    • D. 

      Wrap

  • 25. 
      A               B C 1 Budget 2 Income   3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses   8 Rent  575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss  $ 580.00 The Net Income/Loss value in Cell C16 is the result of which operation?
    • A. 

      Addition

    • B. 

      Division

    • C. 

      Multiplication

    • D. 

      Subtraction

  • 26. 
      A               B C 1 Budget 2 Income   3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses   8 Rent  575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss  $ 580.00 Which operation was used to calculate the vaule in Cell C6?
    • A. 

      Addition

    • B. 

      Division

    • C. 

      Multiplication

    • D. 

      Subtraction

  • 27. 
    What symbol is used for addition?
  • 28. 
    What symbol is used for division?
  • 29. 
    What symbol is used for multiplication?
  • 30. 
    What is the symbol for subtraction?