Excel - Formulas - Dates
Learning how to enter formulas into worksheets and perform simple calculations
- 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 - ProProfs]( "The button shown below is use for ________ in Excel")
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
Questions: 22 | Attempts: 5458 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Questions: 29 | Attempts: 3197 | Last updated: May 4, 2016
-
Sample QuestionFrom the following list, select the choice that is a 3D formula in Excel.
Questions: 8 | Attempts: 3133 | Last updated: Jun 7, 2019
-
Sample QuestionThe advantage of using a spreadsheet is:
Back to top