Ml1 Excel Mid-term Review Part 1

10 Questions | Total Attempts: 159

SettingsSettingsSettings
Please wait...
Ml1 Excel Mid-term Review Part 1

ML1 Excel MiD-Term Review Part 1


Questions and Answers
  • 1. 
    What is the keyboard command to undo a previous action?
    • A. 

      Alt ~

    • B. 

      ctrl b

    • C. 

      shift f3

    • D. 

      ctrl z

  • 2. 
    What is the symbol for auto-sum?
    • A. 

      A

    • B. 

      X

    • C. 

    • D. 

  • 3. 
    What is the keystroke to reveal all formulas?
    • A. 

      Ctrl ~

    • B. 

      Alt &

    • C. 

      Shift F7

    • D. 

      Ctrl x

  • 4. 
    What feature automatically copies a formula to a range?
    • A. 

      Ctrl x

    • B. 

      Paste function

    • C. 

      Autofill

    • D. 

      Paste

  • 5. 
    A formula in MS Excel starts with
    • A. 

      ~

    • B. 

      =

    • C. 

      (

    • D. 

      0

  • 6. 
    An interest rate of 13.54% is represented as the decimal:
    • A. 

      0.001354

    • B. 

      0.1354

    • C. 

      13.54

    • D. 

      135.4

  • 7. 
    Which menu allows you to enter headers / footers?
    • A. 

      View

    • B. 

      Edit

    • C. 

      Format

    • D. 

      File

  • 8. 
    Which menu allows you to reset page orientation?
    • A. 

      Format

    • B. 

      Insert

    • C. 

      File

    • D. 

      View

  • 9. 
    The correct formula that sums up the range B2:B8 is:
    • A. 

      (B2+B8)

    • B. 

      SUM(B2:B8)

    • C. 

      =SUM(B2:B8)

    • D. 

      B2+B8

  • 10. 
    . Which of these formulas divides the value in cell D2 by 3?
    • A. 

      D2:3

    • B. 

      D2/3

    • C. 

      (D2/3)

    • D. 

      =D2/3

Back to Top Back to top