We have sent an email with your new password.


Excel - Formulas - Dates

16 Questions  I  By Agazaheer
Excel - Formulas - Dates
Learning how to enter formulas into worksheets and perform simple calculations

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Formula =C4*$D$9 - absolute cell reference is:
A.
B.
C.
D.
2.  A 'function' in Excel is :
A.
B.
C.
3.  Relative references:
A.
B.
C.
D.
4.  What would happen if you used a formula to do math with dates?
A.
B.
C.
D.
5.  A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
A.
B.
C.
6.  In Excel if you write =TODAY() in the formula bar (Fx)
A.
B.
C.
D.
7.  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.
B.
C.
D.
8.  How would you print formulas?
A.
B.
C.
D.
9.  The ##### error value indicates
A.
B.
C.
D.
10.  The button shown below is use for ________ in Excel
A.
B.
C.
D.
11.  If you copy the formula =C1*$D$9 from cell C1 to cell C2, what will the formula be in cell C5?
A.
B.
C.
D.
12.  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.
B.
13.  Excel will calculate date :1/20/1900 (month/day/year) as:
A.
B.
C.
D.
14.  In Excel 2007 you can write simple formulas that cannot automatically update their results when values change
A.
B.
15.  The MAX function finds the _______
A.
B.
C.
D.
16.   $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.
B.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz