Starry Gold Academy Members Hub

Advanced Excel 1 – 10

Video 1 -10

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
……….. Is used in selecting records based on specified criteria in Excel;
- Splitting
- Filter
- Grouping.
Question 2 of 10

2. Question
Where in the ribbon bar, can you find a filter option?
- Data tab
- Insert tab
- ) format tab
Question 3 of 10

3. Question
………. are the ranges used in Excel advance filter except;
- (a) Criteria ranges
- (b) list ranges
- (c) status ranges.
Question 4 of 10

4. Question
) ……. Are the types of consolidation excel support;
- (a) consolidation by range and position
- (b) Consolidation by position and category
- (c) Consolidation by category and range
Question 5 of 10

5. Question
……. Are some of the correct steps used to consolidate data;
- (a) click on format tab, then click of consolidate
- (b) click on data tab, then click on consolidate & then function
- (c) click on insert tab, click of consolidation & then function.
Question 6 of 10

6. Question
Where in the ribbon bar can you find subtotal option?
- (a) insert tab
- (b) home tab
- (c) data tab.
Question 7 of 10

7. Question
What is the use of a subtotal option in Excel?
- (a)to summarize our data
- (b) to create new headings
- (c) to give us the total of our data.
Question 8 of 10

8. Question
……… are the steps used in splitting data into multiple columns
- (a) click on formula tab then select more functions
- (b) click on data tab then select Text to columns
- (c) click on insert tab then select Text to columns.
Question 9 of 10

9. Question
Where in the ribbon bar can you find your duplicate transaction option?
- (a) Data tab
- (b) Home tab
- (c) Formula tab.
Question 10 of 10

10. Question
What is the function of a duplicate transaction option in Excel workbook?
- (a) To create a new sheet of the same data information
- (b) To split our data into sections
- (c) To remove repeated information or data.

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

Click here to chat with us on WhatsApp now