Spreadsheet Formulas And Functions Quiz #3

15 Questions | Total Attempts: 1295

SettingsSettingsSettings
Please wait...
Spreadsheet Quizzes & Trivia

Spreadsheet Formulas and Functions Quiz #3 from Atomic learning exercises


Questions and Answers
  • 1. 
    You do not need to take the time to create a formula for specific set of cells you can use the ________ __________ to do it for you.
    • A. 

      Auto Fix

    • B. 

      Auto Calculate

    • C. 

      Auto Default

    • D. 

      Sum

  • 2. 
    The Auto Calculate can be changed to display different features/ functions.
    • A. 

      True

    • B. 

      False

  • 3. 
    Creating formulas in Excel begin with using what symbol?
    • A. 

      *

    • B. 

      -

    • C. 

      +

    • D. 

      =

  • 4. 
    Each cell address is colored differently.
    • A. 

      True

    • B. 

      False

  • 5. 
    By using the cell name, such as C4, you do not have to go back into a formula and make changes when your information is changed or updated.
    • A. 

      True

    • B. 

      False

  • 6. 
    The function wizard will help you do what?
    • A. 

      Set up a cell

    • B. 

      Set up a formula

    • C. 

      Set up a number

    • D. 

      Save your work

  • 7. 
    Expanding and collasping the function dialoge box allows you to easily select the cell you wish to enter into your formula.
    • A. 

      True

    • B. 

      False

  • 8. 
    If there is an error in your formula, Excel will not identify the error.
    • A. 

      True

    • B. 

      False

  • 9. 
    What would a formula look like?
    • A. 

      2.38+3.588.25

    • B. 

      (C12:B12)

    • C. 

      =3.65+ (3.65*0.03)

    • D. 

      *A9+B9+C9=

  • 10. 
    You can copy and auto fill in a formula. This is called?
    • A. 

      Referencing

    • B. 

      Auto Formatting

  • 11. 
    There is no way to set a cell in a formula so that it will not change when using the Auto Fill.
    • A. 

      True

    • B. 

      False

  • 12. 
    What icon appears when you are about to Auto Fill
    • A. 

      Black plus sign

    • B. 

      White plus sign

    • C. 

      Question mark

    • D. 

      Hand

  • 13. 
    What is added to the formula to create an absolute reference?
    • A. 

      ?

    • B. 

      &

    • C. 

      $

    • D. 

      #

  • 14. 
    An example of a formula that includes and absolute reference look like?
    • A. 

      =C12+D12+E12

    • B. 

      =C12*D12*E12

    • C. 

      =C12+$B12$

    • D. 

      =C12= B12=D12

  • 15. 
    What could you do to add an absolute reference?
    • A. 

      Add dollar signs around the cell

    • B. 

      Click F4

    • C. 

      All of the Above

    • D. 

      None of the ones listed

Back to Top Back to top