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


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz