Gent Technologies - www.gent.ie - Free Online Practice Tests
Return to Gent Technologies - Online
Tests and Notes page
Quick
Links
Excel
Test 1 Excel Test 2 Excel
Test 3 - Cell References and Ranges Excel Test 4 - Charts Excel
Test 5 - Excel Errors Excel
Test 6 - Excel Formatting
Excel Test 7 - External Files
and Templates Excel Test 8 - Editing Excel Test 9 - Formulas Excel Test 9 - Formulas Excel: Selecting Cells Excel: Forumlas Excel: Cell Referencing Word
Test 1 Word Test 2 Word
Test 3 PowerPoint Test 1 Access
Test 1 Internet Test 1
© Maureen O'Neill, All Rights Reserved
Microsoft
Office Excel Test 9
- 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