Starry Gold Academy Members Hub

Advanced Excel 61 – 70

Video 61 – 70

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 CONVERT Function in the formula bar
- (a)Math & Trig
- (b) More functions
- (c) Financial.
Question 2 of 10

2. Question
….. is the correct formula for converting kilometers to mile
- (a) =convert(A2,M1,Km)
- (b)=convert(A2 M1”,KM”)
- (c) =convert(A2,“Km”,“M1”).
Question 3 of 10

3. Question
Where can you locate your TRUNC Function in the formula tab
- (a) Math & Trigs
- (b) More Functions
- (c) Auto Sum.
Question 4 of 10

4. Question
What is use of MACROS in Excel?
- (a) Use to evaluate aggregates
- (b) Used in automating our tabs
- (c) Used in analysis large documents.
Question 5 of 10

5. Question
Where in the ribbon bar can you find your MACROS option?
- (a) Data tab
- (b) Insert tab
- (c) View tab.
Question 6 of 10

6. Question
What is the process involved in recording Macros?
- (a) Click on datatab, select macros, then click on record
- (b) click on view tab, select macros, and then click on record
- (c) None of the above
Question 7 of 10

7. Question
What is the shortcut for an ARRAY FUNCTION
- (a) ctrl + shift + enter
- (b) shift + enter
- (c) ctrl + alt + enter.
Question 8 of 10

8. Question
What is the use of TRANSPOSE Function in excel?
- (a) To return the vertical range of cell as horizontal and vice versa
- (b) to transport data out of Excel
- (c) none of the above
Question 9 of 10

9. Question
……. Are the correct steps to transpose
- (a) click on view tab, then select transpose
- (b) Highlight the data,copy, right click to paste,select paste special then transpose.
- (c) highlight the data, click on format tab, then select transpose
Question 10 of 10

10. Question
Where in the formula tab can you locate FIND FUNCTION
- (a) Math & Trigs
- (b) Text
- (c) Logical

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

Click here to chat with us on WhatsApp now