Take Another Quiz

Excel - Formulas - Dates

16 Questions
Excel - Formulas - Dates

Learning how to enter formulas into worksheets and perform simple calculations

Questions and Answers
  • 1. 
    In Excel 2007 you can write simple formulas that cannot automatically update their results when values change
    • A. 

      True

    • B. 

      False

  • 2. 
    The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the CD expense for the month. You can add these values in Excel by typing a simple formula in a cell:
    • A. 

      =12.99+16.99

    • B. 

      2.99+16.99

    • C. 

      (12.99+16.99)

    • D. 

      =12+16

  • 3. 
    A 'function' in Excel is :
    • A. 

      There is no such thing as a function in Excel

    • B. 

      Prewritten formula

    • C. 

      Non of the above

  • 4. 
    The button shown below is use for ________ in Excel
    • A. 

      Adds up all the values in Excel Sheet

    • B. 

      Calculate exponent of any given cell

    • C. 

      Adds up all the values in a range of cells

    • D. 

      Non of the Above

  • 5. 
    A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
    • A. 

      Click in cell C6, and then press CTRL+SHIFT.

    • B. 

      Click in cell C6, and then press F5.

    • C. 

      Click in cell C6

  • 6. 
    Relative references:
    • A. 

      Are absolute references

    • B. 

      Stay the same as they are copied.

    • C. 

      Change as they are copied

    • D. 

      Are references you give in an interview to get job

  • 7. 
    Formula =C4*$D$9 - absolute cell reference is:
    • A. 

      =C4*$D$9

    • B. 

      $D

    • C. 

      =

    • D. 

      $D$9

  • 8. 
     $A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes
    • A. 

      True

    • B. 

      False

  • 9. 
    If you copy the formula =C1*$D$9 from cell C1 to cell C2, what will the formula be in cell C5?
    • A. 

      C2*$D$9

    • B. 

      C1*$D$9

    • C. 

      C5*$D$9

    • D. 

      Cant say from the given question

  • 10. 
    The MAX function finds the _______
    • A. 

      Largest number in Excel Sheet

    • B. 

      Largest number in a range of numbers

    • C. 

      Smallest number in a range of numbers

    • D. 

      It does nothing

  • 11. 
    The ##### error value indicates
    • A. 

      That wrong formula has been entered into the cell

    • B. 

      Divide Error

    • C. 

      You are trying to apply formulas on text

    • D. 

      That the column is too narrow to display the contents of this

  • 12. 
    How would you print formulas?
    • A. 

      Click the Microsoft Office Button and then click Print.

    • B. 

      Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.

    • C. 

      Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.

    • D. 

      You cant print formulas in Excel 2007

  • 13. 
    In the practice, you learned that if you misspell SUM in this formula =SUME(B4:B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again.
    • A. 

      True

    • B. 

      False

  • 14. 
    Excel will calculate date :1/20/1900 (month/day/year) as:
    • A. 

      1921

    • B. 

      Excel treats dates as text and cannot calculate dates

    • C. 

      20

    • D. 

      Non of the above

  • 15. 
    What would happen if you used a formula to do math with dates?
    • A. 

      Excel will give Error : #####

    • B. 

      Excel will give Error : ?Name

    • C. 

      Excel will not give any Error as you can do math with dates in Excel

    • D. 

      Excel will give Error : #VALUE!

  • 16. 
    In Excel if you write =TODAY() in the formula bar (Fx)
    • A. 

      It will do nothing

    • B. 

      It will give you today's date

    • C. 

      It will give you today's news

    • D. 

      It will give you today's Tip

Related Topics