Starry Gold Academy Members Hub

Advanced Excel 31 – 40

Video 31 – 40

Time limit: 0

Quiz-summary

0 of 10 questions completed

Questions:

1
2
3
4
5
6
7
8
9
10

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10

Answered
Review

Question 1 of 10

1. Question
Where can you find your look up function in your ribbon bar?
- (a) Formulas tab
- (b) Data tab
- (c) Inset tab.
Question 2 of 10

2. Question
What is a NESTED LOOK-UP FUNCTION?
- (a) A look up function that is giving a command manually (
- b) A look up function automatically operated .
- (c) A look up function that is embedded with another look up function
Question 3 of 10

3. Question
……. Are the correct steps in getting the MATCH FUNCTION
- (a) Click on formulas tab, then click on look-up & reference and then select match.
- (b) Click on data tab, then click on look-up & reference and then select match
- (c) Click on insert tab, then click on look-up & reference and then select match
Question 4 of 10

4. Question
What is the use of a CHOOSE FUNCTION?
- (a) Used to select a particular destination in a data sheet
- (b)Used to pick a value from a list based on the index number.
- (c) None of the above
Question 5 of 10

5. Question
What is the unique feature of the INDEX/MATCH FUNCTION?
- (a)It boost the performance of the V look up function
- (b) It take cares of limitation of the H & V look up function
- (c) It correct errors of the look up function.
Question 6 of 10

6. Question
When your look up values is arrange horizontally, which look up function will you use?
- (a) V look up function
- (b) H-look up function
- (c) W look up function.
Question 7 of 10

7. Question
What-IF analysis is the same thing as?
- (a) Sensitivity analysis
- (b) Match analysis
- (c) Reference analysis
Question 8 of 10

8. Question
The following variables can be found in what-IF analysis except
- (a) scenario manager
- (b) Goal seeks
- (c) Validation analysis.
Question 9 of 10

9. Question
The following steps are used to enable solver in your excel workbook;
- (a) Go to file, select option, click add-ins solver
- (b) Go to file, click on setting, then select solver.
- (c) All of the above
Question 10 of 10

10. Question
Where can you find your solver option in the ribbon bar?
- (a)Insert tab
- (b) Formulas tab
- (c) Data tab.

Copyright © 2007 - 2016 · OptimizePress.com · All Rights Reserved

Click here to chat with us on WhatsApp now