# Excel - Formulas - Dates

16 Questions | Total Attempts: 59  Settings  Learning how to enter formulas into worksheets and perform simple calculations

Related Topics
• 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