Spreadsheet Management

50 Questions | Total Attempts: 100

SettingsSettingsSettings
Please wait...
Data Management Quizzes & Trivia

Mrs. Vance's Spreadsheet Management class will take this written test, along with a performance exam, that will count as part of your final semester grade. GOOD LUCK!


Questions and Answers
  • 1. 
    In English 102, Mrs. Gerlach tells you that a passing grade for her class is 70%.  Which IF Statement would be correct if you were to receive a passing grade for the class (assuming C5 is your final grade)?
    • A. 

      =if(C5 >70%,"PASS","FAIL")

    • B. 

      =IF(C5>70%,PASS,FAIL)

    • C. 

      =if(C5>=69.5%,"PASS","FAIL")

    • D. 

      =IF(C5>=70%,"Pass","Fail")

  • 2. 
    A Sony digital camera price is listed as $300.00 in Cell D5.  The digital camera discount price is listed in Cell E5 as $20.00.  You are going to insert a formula in Cell F5 to list the final price.  Which formula is correct?
    • A. 

      =D5+E5

    • B. 

      =D5-E5

    • C. 

      =E5-D5

    • D. 

      =PRICE(D5-E5)

  • 3. 
    A Kodak digital camera price of $559.00 is listed in Cell B10.  The sales tax of 6% is listed in Cell C10.  You are going to insert a formula in Cell D10 to list the final price of the camera.  Which formula is correct?
    • A. 

      =B10*6%

    • B. 

      =B10*C10

    • C. 

      =B10*6%+B10

    • D. 

      =(B10+C10)*6%

  • 4. 
    Paris Hilton worked 20 hours this week designing her new cologne.  She was paid $5,000.00 an hour.  The Federal Tax is 2%; the Social Security Tax is 3.5%; the State Tax is 1.5%; and the Medicare Tax is 2.4%.  Her Gross Pay is _____, and her Net Pay is _____.   
    • A. 

      $100,000, $90,600

    • B. 

      $100,000, $96,000

    • C. 

      $10,000, $9,600

    • D. 

      $10,000, $9,060

  • 5. 
    Lisa's SAT scores for Reading are 540 (Cell A1); Math 625 (Cell A2), and Writing 566 (Cell A3).  Which formula would give the correct total for all three scores?
    • A. 

      =SUM(A1;A3)

    • B. 

      =540+625+566

    • C. 

      =A1+A2+A3

    • D. 

      Both B and C are correct

    • E. 

      All answers are correct

  • 6. 
    To save an existing file using a different name, you would choose the _____ command.
    • A. 

      Save

    • B. 

      Retrieve

    • C. 

      Save as

    • D. 

      Store file

  • 7. 
    When you choose the Alignment drop-down arrow, and the Number Category, the 1000 Separator _____.
    • A. 

      Inserts a dollar sign format

    • B. 

      Inserts a percentage format

    • C. 

      Inserts a decimal format

    • D. 

      Inserts a comma format

  • 8. 
    Cell B5 is 45; Cell B6 is 45; Cell B7 is 44.  Which is the correct formula for B8 that will return the answer 45 (do not use decimal places).
    • A. 

      =MAX(B5:B7)

    • B. 

      =AVERAGE(B5:B7)

    • C. 

      =SUM(B5:B7)

    • D. 

      Both A and B are correct

    • E. 

      None of the above is correct

  • 9. 
    Which of the following is NOT a use of the tab at the bottom of each worksheet?
    • A. 

      Moving from one worksheet to another

    • B. 

      Inserting new columns and rows

    • C. 

      Rearranging the order of worksheets

    • D. 

      Identifying the worksheet

    • E. 

      B and D only

  • 10. 
    If you select a cell with a date in it and drag the fill handle down several cells, what happens is _____.
    • A. 

      The date is copied to each cell

    • B. 

      The date is increased by one day into each cell

    • C. 

      The date is increased by one week into each cell

    • D. 

      Nothing happens because the fill applies only to numbers

  • 11. 
    The settings to wrap text in a cell and to merge cells are found in the Format Cells dialog box on the _____ tab.
    • A. 

      Number

    • B. 

      Alignment

    • C. 

      Font

    • D. 

      Border

  • 12. 
    Values, by default, are aligned _____.
    • A. 

      To the left

    • B. 

      To the right

    • C. 

      Centered in the cell

    • D. 

      At the top of the cell

  • 13. 
    • A. 

      A - S - M - D - E - P

    • B. 

      P - A - M - D - E - S

    • C. 

      P - M - D - A - S - E

    • D. 

      P - E - M - D - A - S

    • E. 

      None of the above

  • 14. 
    It is best to write formulas using cell references so that a spreadsheet _____.
    • A. 

      Has no hidden information

    • B. 

      Has all correct values

    • C. 

      Can be easily updated

    • D. 

      Can be easily graphed

  • 15. 
    When inserting a column, it will always appear _____.
    • A. 

      To the left of the active cell/column

    • B. 

      Highlighted

    • C. 

      To the right of the active cell/column

    • D. 

      As a new Column A

  • 16. 
    What online resource can you use for Excel training, clip art, videos, or help and support?
    • A. 

      Excel.com

    • B. 

      Yahoo Questions and Answers

    • C. 

      Microsoft.com

    • D. 

      Spreadsheet Support

  • 17. 
    To arrange rows in alphabetical order based on Column A, you need to use the command _____.
    • A. 

      Home, Sort and Filter

    • B. 

      Data, Sort

    • C. 

      Edit, Data, Sort

    • D. 

      None of the above

    • E. 

      Both A and B

  • 18. 
    The formula that will add the value of D4 to the value of C2 and then multiply by the value in B2 is _____.
    • A. 

      (D4+C2)*B2

    • B. 

      D4+C2*B2

    • C. 

      =D4+C2*B2

    • D. 

      =(D4+C2)*B2

  • 19. 
    A quick way to get to Cell A1 (Home) is to _____.
    • A. 

      Press CTRL + Home

    • B. 

      Press Shift A1

    • C. 

      Use Find and Replace

    • D. 

      Click on File, Home

  • 20. 
    The feature that allows you to arrange rows in alphabetical order is _____.
    • A. 

      Sorting

    • B. 

      Conditional formatting

    • C. 

      Filtering

    • D. 

      Autofill

  • 21. 
    If a cell displays #######, it means that _____.
    • A. 

      There is a formatting error

    • B. 

      The column is too narrow to display all the digits of the number

    • C. 

      There is an error in your formula

    • D. 

      You need to center the text within the cell

  • 22. 
    A fast way to add up a column of numbers is to click the cell below the numbers and then _____.
    • A. 

      Click subtotals on the Data Menu

    • B. 

      View the sum in the Formula Bar

    • C. 

      Click the AutoSum button on the Home or Formulas Tab

    • D. 

      Use a formula

    • E. 

      Use a function

  • 23. 
    To display a comment in a worksheet _____.
    • A. 

      Roll the mouse over the red triangle

    • B. 

      Choose View, comment

    • C. 

      Highlight the cell

    • D. 

      Both A and B

  • 24. 
    A chart placed as an object within a worksheet is called a/an _____.
    • A. 

      Chart sheet

    • B. 

      Embedded chart

    • C. 

      Category

    • D. 

      Linked object

  • 25. 
    All charts use an X-axis and a Y-axis EXCEPT a _____ chart.
    • A. 

      Bar

    • B. 

      Line

    • C. 

      Column

    • D. 

      Pie

    • E. 

      XY scatter plot