Advanced Excel For Actuaries Quiz
5 Questions
| Total Attempts: 247
See if you got the correct answers to the assignment.
Questions and Answers
- 1.Using the INDEXMATCH method, what formula did you enter into cell D7 to get the Plus brand Camera warranty price?
- 2.On the Summary tab, what formula did you use to get Region 6's Aug value (cell G9)?
- A.
=INDIRECT("'"&F$1&"'!"&$L9)
- B.
=INDIRECT("'"&G$1&"'!"&$L2)
- C.
=INDIRECT("'"&G$1&"'!"&$L9)
- D.
=SUM(INDIRECT(H1&"!"&"B2:B13"))
- 3.To create a dynamic range for the last 10 sales values, what does "COUNT(DynamicCharts!$B$3:$B$1000)-1" in the formula: "=OFFSET(DynamicCharts!$B$3,COUNT(DynamicCharts!$B$3:$B$1000)-1,0,-10,1)"
- A.
It is the new range width
- B.
It represents the number of rows down from the reference point
- C.
It represents the height of the new dynamic range
- D.
It represents the number of columns over from the reference point
- 4.What Total Warranty Sales for 2015 did you get as an answer?
- A.
12964
- B.
19753
- C.
22975
- D.
27852
- 5.What is the correct formula to parse the Region number for the first part of the text string cell F2?
- A.
=if(left(F2,2)="10","10",left(F2,1))
- B.
=left(F2,1)
- C.
=if(find(F2,2,2)="10","10",left(F2,2))
- D.
=left(F2,2)
Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your...
Questions: 50 | Attempts: 3101 | Last updated: May 18, 2021
-
Sample Question_______ tab, in the Editing group, click Find & Select, and then click Go To.
Knowledge Excel Level 3 (Advanced)
Questions: 10 | Attempts: 692 | Last updated: Feb 28, 2013
-
Sample QuestionHow many conditions can the sumif check for?
Questions: 22 | Attempts: 6041 | 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?
Are You Really Best Friends? Take The Quiz & Prove It
Are You Really Best Friends? Take The Quiz & Prove It
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Back to top