Starry Gold Academy Members Hub

Advanced Excel 21 – 30

Video 21 – 30

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 PIVOT TABLE in excel sheet
- (a) Data tab
- (b) Insert tab
- (c) page layout
Question 2 of 10

2. Question
How do you group your data on a PIVOT table? .
- (a) By selecting the column, click on data, then select group
- (b)Right click on the column, then select group
- (c) Double click on the column, then select group as
Question 3 of 10

3. Question
Where can you find your percentage option in your PIVOT table?
- (a) sum value option
- (b) In no calculation
- (c) In IF option.
Question 4 of 10

4. Question
How do you group your data on a PIVOT table?
- (a) By selecting the column, click on data, then select group
- (b)Right click on the column, then select group
- (c) Double click on the column, then select group as.
Question 5 of 10

5. Question
…… is one of the criteria in using a PIVOT table
- (a) You need to have a minimum of five columns
- (b) You need to have a minimum of six columns
- (c) You need to have a minimum of three columns.
Question 6 of 10

6. Question
Where in the ribbon bar can you locate your PIVOT chat?
- (a) Formulas tab
- (b) Data tab
- (c) Insert tab.
Question 7 of 10

7. Question
What’s the processes involved in formatting your PIVOT chart title
- (a)Click on insert tab, then select chat title
- (b) Click on insert, then select chat title
- (c) Click on format tab,then select format title.
Question 8 of 10

8. Question
What is the process involved in moving your PIVOT chat to another location.
- (a) Click on data tab and select move chat
- (b) Click on design tab and select move chat
- (c) Click on format tab and select move chat.
Question 9 of 10

9. Question
What is the use of LOOK UP FUNCTION in excel
- (a) Use to look at information in one table and make use of it in another table
- (b) Use to create table in reference to another table
- (c) None of the above.
Question 10 of 10

10. Question
——- are examples of LOOK UP FUNCTION in excel except
- (a) V-look up function
- (b) H-look up function
- (c) W-look up function.

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

Click here to chat with us on WhatsApp now