Starry Gold Academy Members Hub

ADvanced Excel 11 – 20

Video 11 – 20

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
What is the use of validation in Excel?
- (a) Used to guide against errors
- (b) Used to approve Excel activities
- (c) used to relate information to other workbook.
Question 2 of 10

2. Question
Where can you locate your data validation option in excel worksheet?
- (a) Formatting tab
- (b)filter tab
- (c) data tab.
Question 3 of 10

3. Question
Where in Excel workbook can you locate an IF function?
- (a) Auto-Sum Function
- (b) Logical function
- (c) Insert function.
Question 4 of 10

4. Question
What is a Nested IF in excel?
- (a) An IF function that is used to apply a condition
- (b)An IF function that is embedded in another IF
- (c) An if function that is used to override the initial IF.
Question 5 of 10

5. Question
One of the following is the correct way of applying a nested in Excel;
- (a) =IF(D2<=2,5%*B2,IF(D2<=4,10%*B2,IF(D2>4,15%*B2)))
- (b) =IF(D2<=2,5%*B2,IF(D2<=4,10%*B2,IF(D2>4,15%*B2)
- (c) =IF(D2<=2,5%*B2,IF(D2<=4,10%*B2,IF(D2>4,15%*B2))
Question 6 of 10

6. Question
The given formula; =IF(AND(D2)=“FULLTIME”,J2>=3),10%*H2,0) is termed …..
- (a) A compound IF
- (b) A Nested IF
- (c) A Count IF.
Question 7 of 10

7. Question
Where in the ribbon bar can you find your COUNT IF?
- (a) Data tab
- (b) Formula Bar
- (c) Insert tab
Question 8 of 10

8. Question
…… are steps used in locating a COUNT IF
- (a) Click on the formulas tab, click on financial dialog box, then select your COUNT IF
- (b) Click on the data tab, click on what if dialog box, then select your count IF
- (c) Click on the formula tab, click on more functions, and click on statistics, then select count IF.
Question 9 of 10

9. Question
Where in excel workbook can you find your COUNT BLANK FUNCTION?
- (a) Logical function
- (b) Statistical function
- (c) Insert function.
Question 10 of 10

10. Question
What is the use of a PIVOT table in Excel? .
- (a) Used to summarize large data
- (b) Used to create a new table
- (c) Used to calculate data or a table

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

Click here to chat with us on WhatsApp now