CA404
Science & Technology Consultancy
Excel Test 5 - Microsoft Excel Formulas
Test Instructions: You should have Excel open and a blank spreadsheet visible to do this test. You should not use notes or books. Only use Excel and its associated help files.
Answers: Are displayed using white text so they are not immediately visible. If you select the text, as if you were going to copy it, on the Answer line, it will appear.
Q1. What is the purpose of the following formula?
=Sheet2!D28+Sheet2!E28
a. This would select D28 and E28 and create an average from sheet2
b. This would select D28 and E28 and add the two together from sheet1
c. This would select D28 and E28 and add the two together from sheet2
d. This forumla doesn't do anything.
Q1. Answer = c
Q2. Which of the following operators can be used in a logical test? = < > <>
a. = < >
b. < > <>
c. all of the above
Q2. Answer = c
Q3. What would be the result of =SUM(G16,300), if G16=50?
a. 350
b. 250
c. 15000
d. 6
Q3. Answer = a
Q4. Each part of a nested formula can be checked by which dialog box?
a. Watch Window
b. Evaluate Formula
c. Consolidate
d. Data Validation
Q4. Answer = b
Q5. Which formula would result in TRUE if A1 is less than 20 and A2 is less than 50?
a. =AND(A1>20, A2>50)
b. =AND(A1>20, A2<50)
c. =AND(A1<20, A2>50)
d. =AND(A1<20, A2<50)
Q5. Answer = d
Q6. Which of the following characters is used in Excel as the wildcard that represents a single character?
a. &
b. ?
c. !
d. *
Q6. Answer = b
Q7. A "3-D reference" refers to cells from one worksheet being used within a formula in another worksheet.
a. True
b. False
Q7. Answer = a
Q8. What is the correct forumla to calculate an average based upon cells H7 to H10?
a. =AVE(H7:H10)
b. =AVERAGE(H7:H10)
c. =AVERAGE(H7+H8+H9+H10)/4
d. =AVE(H7,H8,H9,H10)/4
Q8. Answer = b
Q9. When using financial formula functions which argument specifies whether payments are made at the beginning or the end of the period?
a. Type
b. PV
c. Nper
d. Rate
Q9. Answer = a
[ Back to top ]
