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.

Questions and Answers

 1 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
 2 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
 3 In Excel 2007 you can write simple formulas that cannot automatically update their results when values change
 A. True
 B. False
 4 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
 5 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
 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 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
 8 A 'function' in Excel is :
 A. There is no such thing as a function in Excel
 B. Prewritten formula
 C. Non of the above
 9 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
 10 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!
 11 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
 12 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
 13 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
 14 Formula =C4*\$D\$9 - absolute cell reference is:
 A. =C4*\$D\$9
 B. \$D
 C. =
 D. \$D\$9
 15 \$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
 16 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
Take Another Quiz