Advanced Excel For Actuaries Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Actuwaiter
A
Actuwaiter
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,762
| Attempts: 541
SettingsSettings
Please wait...
  • 1/5 Questions

    Using the INDEXMATCH method, what formula did you enter into cell D7 to get the Plus brand Camera warranty price?

Please wait...
About This Quiz

See if you got the correct answers to the assignment.

Microsoft Office Quizzes & Trivia

Quiz Preview

  • 2. 

    On the Summary tab, what formula did you use to get Region 6's Aug value (cell G9)?

    • =INDIRECT("'"&F$1&"'!"&$L9)

    • =INDIRECT("'"&G$1&"'!"&$L2)

    • =INDIRECT("'"&G$1&"'!"&$L9)

    • =SUM(INDIRECT(H1&"!"&"B2:B13"))

    Correct Answer
    A. =INDIRECT("'"&G$1&"'!"&$L9)
    Explanation
    The formula used to get Region 6's Aug value (cell G9) is =INDIRECT("'"&G$1&"'!"&$L9). This formula uses the INDIRECT function to reference the value in cell G1 (which contains the name of the sheet) and combines it with the value in cell L9 to create a cell reference in the form 'SheetName'!$L9. The INDIRECT function then returns the value from that cell.

    Rate this question:

  • 3. 

    What Total Warranty Sales for 2015 did you get as an answer?

    • 12964

    • 19753

    • 22975

    • 27852

    Correct Answer
    A. 27852
    Explanation
    The correct answer for the Total Warranty Sales for 2015 is 27852.

    Rate this question:

  • 4. 

    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)"

    • It is the new range width

    • It represents the number of rows down from the reference point

    • It represents the height of the new dynamic range

    • It represents the number of columns over from the reference point

    Correct Answer
    A. It represents the number of rows down from the reference point
    Explanation
    The expression "COUNT(DynamicCharts!$B$3:$B$1000)-1" in the formula represents the number of rows down from the reference point. The COUNT function counts the number of cells in the range B3 to B1000 that contain values. By subtracting 1 from this count, the formula determines how many rows down from the reference point (B3) the new dynamic range should start. This allows the formula to create a dynamic range for the last 10 sales values by specifying the appropriate height and starting position.

    Rate this question:

  • 5. 

    What is the correct formula to parse the Region number for the first part of the text string cell F2?

    • =if(left(F2,2)="10","10",left(F2,1))

    • =left(F2,1)

    • =if(find(F2,2,2)="10","10",left(F2,2))

    • =left(F2,2)

    Correct Answer
    A. =if(left(F2,2)="10","10",left(F2,1))
    Explanation
    The correct formula to parse the Region number for the first part of the text string in cell F2 is "=if(left(F2,2)="10","10",left(F2,1))". This formula checks if the first two characters of the text string in cell F2 are equal to "10". If they are, it returns "10". If they are not, it returns the first character of the text string.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 20, 2013
    Quiz Created by
    Actuwaiter
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.