Ml1 Final Exam Review Part I

10 Questions | Total Attempts: 188

SettingsSettingsSettings
Ml1 Final Exam Review Part I - Quiz

ML1 Final Exam Review Part I


Questions and Answers
  • 1. 
    Which of the icons shown stands for "Save"? (1) (2) (3) (4)
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

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

      Ctrl x

    • B. 

      Paste function

    • C. 

      AutoFill

    • D. 

      Paste

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

      #

    • B. 

      ~

    • C. 

      &

    • D. 

      =

  • 4. 
    What is 7.54% represented as the decimal:
    • A. 

      7.54

    • B. 

      0.754

    • C. 

      0.0754

    • D. 

      75.4

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

      View

    • B. 

      Edit

    • C. 

      Insert

    • D. 

      Tools

  • 6. 
    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

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

      D2:3

    • B. 

      D2/3

    • C. 

      (D2/3)

    • D. 

      =D2/3

  • 8. 
    Which Excel function is used to choose one of 2 given values?
    • A. 

      COUNT

    • B. 

      MAX

    • C. 

      AVERAGE

    • D. 

      IF

  • 9. 
    What is the way to underline text in a cell?
    • A. 

      Format Cells ----> Font

    • B. 

      Format Cells ----> Number

    • C. 

      Format Cells ----> Alignment

    • D. 

      Format Cells ----> Patterns

  • 10. 
    Which menu is used to change the height of a row?
    • A. 

      View

    • B. 

      Insert

    • C. 

      Format

    • D. 

      Tools

Back to Top Back to top