Bell Quiz 9/6 - Spreadsheet Math

9 Questions | Total Attempts: 69

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Using the tutorial at : http://www. Tutorialsforopenoffice. Org/tutorial/Spreadsheet_Math. Html Answer the following questions:


Questions and Answers
  • 1. 
    To add the numbers in two cells A1 and B1 you would type:
    • A. 

      A1+ B1

    • B. 

      A1 + B1 =

    • C. 

      = A1+B1

  • 2. 
    To add a collection of numbers you might use a special Function called :
    • A. 

      Sum

    • B. 

      Add

    • C. 

      Total

  • 3. 
    The special function has it's own icon, a Greek Letter which looks like:
    • A. 

      Σ

    • B. 

      Ε

    • C. 

      Π

    • D. 

      Ω

  • 4. 
    A "cell range" of A!, A2, A3, A4, and A5 used with a Function would look like
    • A. 

      =A1:A5

    • B. 

      A1,A5

    • C. 

      (A1:A5)

    • D. 

      (A1, A5)

  • 5. 
    A multiplication of cell C3 and Cell C4 ,used in a spreadsheet, would look like:
    • A. 

      C3 X C4

    • B. 

      =C3XC4

    • C. 

      =C3*C4

    • D. 

      C3*C4

  • 6. 
    To find the average value of a cell range from A1 to A5, you could use the following formula:
    • A. 

      =A1+A2+A3+A4+A5/5

    • B. 

      =Avg(A1:A5)

    • C. 

      =Average(A1:A5)

    • D. 

      =Ave(A1:A5)

  • 7. 
    PEMDAS stands for the order of operations-- Parends (brackets), Exponents, Multiply-Divide, Add-Subtract. If you type =A1+10/B1 + 20 into a spreadsheet, where A1 is 20 and B1 is 10, the answer it will show is:
    • A. 

      1

    • B. 

      41

    • C. 

      31

    • D. 

      21

  • 8. 
    To copy a formula to another cell or cells you:
    • A. 

      Right click, copy, select new cell(s), paste

    • B. 

      Right click, copy, select new cell(s), paste special, uncheck formulas and paste all

    • C. 

      Right click copy, paste, select cells

  • 9. 
    To compute 10 to an exponent of 4 in a cell on a spreadsheet, you would type ____________ then hit enter:
    • A. 

      10 X 10 X 10 X 10

    • B. 

      10^4

    • C. 

      =10^4

    • D. 

      =10*4