We have sent an email with your new password.

Close this window

Excel - Formulas - Dates

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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz