MS Excel Workbook And Formulas! Trivia Quiz

20 Questions | Total Attempts: 268

SettingsSettingsSettings
Please wait...
MS Excel Workbook And Formulas! Trivia Quiz

.


Questions and Answers
  • 1. 
    The location of a cell in a worksheet indicated by the column and a row.
    • A. 

      Formula

    • B. 

      Operator

    • C. 

      Cell address

  • 2. 
    In the example C5, the "C" represents the cells.
    • A. 

      Column

    • B. 

      Row

    • C. 

      Absolute reference

  • 3. 
    A row is
    • A. 

      A vertical range of cells referred to by a number.

    • B. 

      A horizontal range of cells referred to by a number.

    • C. 

      A vertical range of cells referred to by a letter.

  • 4. 
    A sheet tab is located at the bottom of the worksheet window and is used to display the...
    • A. 

      Active cell

    • B. 

      Formula bar

    • C. 

      Worksheet name

  • 5. 
    This is a built-in formula that enables you to perform common calculations in a workbook.
    • A. 

      Function

    • B. 

      Value

    • C. 

      Sort

  • 6. 
    All formulas begin with this symbol.
    • A. 

      * (asterisk)

    • B. 

      \ (forward slash)

    • C. 

      = (equal sign)

  • 7. 
    In the formula =SUM(A10:A15), which part is the cell reference?
    • A. 

      =

    • B. 

      (A10:A15)

    • C. 

      SUM

  • 8. 
    What is an absolute cell reference?
    • A. 

      The cell reference automatically changes when the formula is copied down a column or across a row.

    • B. 

      The cell uses the A1 reference style.

    • C. 

      The cell reference is fixed or locked.

  • 9. 
    What cell reference refers to a range of cells in column D, rows 4 through 9?
    • A. 

      (D4:D9)

    • B. 

      (D4,D9)

    • C. 

      (D4+D9)

  • 10. 
    If you copy the formula =C4*$D$9 from C4 to C5, what will the formula be in cell C5?
    • A. 

      =C5*$D$9

    • B. 

      =C4*$D$9

    • C. 

      =C5*D9

  • 11. 
    If you enter a formula and #### shows in the cell, what does that mean?
    • A. 

      The formula is missing the math operator.

    • B. 

      The column width is not wide enough to display the results.

    • C. 

      You entered an invalid cell reference.

  • 12. 
    If you entered in the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you have to delete the formula and start again.
    • A. 

      True

    • B. 

      False

  • 13. 
    The symbol for multiplication is a(n)...
    • A. 

      $

    • B. 

      \

    • C. 

      *

  • 14. 
    The symbol for division is...
    • A. 

      $

    • B. 

      \

    • C. 

      *

  • 15. 
    When entering data across a row, you should use the TAB key to move the cursor to the next cell.
    • A. 

      True

    • B. 

      False

  • 16. 
    The only way to view a formula you entered in a cell is to look at the formula bar.
    • A. 

      True

    • B. 

      False

  • 17. 
    To easily add a header or footer to your worksheet you should be in page layout view.
    • A. 

      True

    • B. 

      False

  • 18. 
    In the cell reference $F9, the column is fixed, but the row will change when copied.
    • A. 

      True

    • B. 

      False

  • 19. 
    The shortcut to show formulas in your worksheet is...
    • A. 

      Ctrl + ~

    • B. 

      Ctrl + F5

    • C. 

      Ctrl + $

  • 20. 
    When you open up a new workbook it comes with how many ready to use worksheets?
    • A. 

      1

    • B. 

      3

    • C. 

      5