Ml1 Final Exam Part1 Day1

10 Questions | Total Attempts: 69

SettingsSettingsSettings
Ml1 Final Exam Part1 Day1 - Quiz

Each question is 4 points.


Questions and Answers
  • 1. 
    How do you format a cell for currency?
    • A. 

      Format --> Font

    • B. 

      Right click menu --> Clear Contents...

    • C. 

      Right click menu --> Format Cell...

    • D. 

      Tools--> Options

  • 2. 
    The following formula =D12*4%
    • A. 

      Finds what is 4% of the the value in D12

    • B. 

      Divides the value in cell D12 by 4

    • C. 

      Multiplies the value in cell D12 by 4

    • D. 

      Finds the value in cell D12 as 12 multiplied by 4

  • 3. 
    If A5 = 1, then the following formula =A5^2 + 2*A5 will produce?
    • A. 

      0

    • B. 

      3

    • C. 

      5

    • D. 

      4

  • 4. 
    2.45% as a decimal is
    • A. 

      2.45

    • B. 

      0.245

    • C. 

      0.0245

    • D. 

      24.5

  • 5. 
    The volume of a cube is s3. What would be an Excel formula to to find the volume of cube whose side value is placed in cell D3.
    • A. 

      =B3*D3

    • B. 

      =D3*3

    • C. 

      =D3^3

    • D. 

      =D3*D3

  • 6. 
    What function counts the average value of the items in a list?
    • A. 

      AVERAGE

    • B. 

      SUM

    • C. 

      IF

    • D. 

      MEDIAN

  • 7. 
    What function adds up the values in the highlighted cells?
    • A. 

      Count

    • B. 

      Sum

    • C. 

      If

    • D. 

      Average

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

    • B. 

      A

    • C. 

      X

    • D. 

      Σ

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

      Alt &

    • B. 

      Ctrl x

    • C. 

      Shift F7

    • D. 

      Control ~

  • 10. 
    Which menu allows you to change the page orientation (Portrait/Landscape)?
    • A. 

      Edit

    • B. 

      Format

    • C. 

      File

    • D. 

      Tools

Back to Top Back to top