Starry Gold Academy Members Hub

Advanced Excel 71 – 80

Video 71 – 80

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 the correct formula for a FINDING function
- (a) =find (“G”, A)
- (b) =(A2, G)
- (c) =find(G,“A2”)
Question 2 of 10

2. Question
What is the difference between a FIND function and Search function
- (a) Find function will point out directly what you are looking for while search functions will not
- (b) A find function is case sensitive while a search function is not
- (c) a find function will locate only in the existing worksheet while a search function will locate the entire workbook.
Question 3 of 10

3. Question
What is the use of right and left function in excel
- (a) To correct errors in your worksheet
- (b) To extract values on the spreadsheet
- (c) To take care of complex data.
Question 4 of 10

4. Question
What is the use of CONCATENATE Function in excel
- (a)Used to add new columns to your worksheet
- (b) Used to create space in between your work sheet
- (c) Used to join columns together
Question 5 of 10

5. Question
Where in the formulas tab can you find your PROPER function
- (a) Math & Trig
- (b) More functions
- (c) Text
Question 6 of 10

6. Question
What is the difference between a REPLACE function and SUBSTITUTE function
- (a) A replace function work with content while a substitute function work with location
- (b) Replace will replace the entire cell while substitute will just replace the given character
- (c) Replace is automatic while substitute is manual.
Question 7 of 10

7. Question
……. Is the correct formula for REPLACE function
- (a)= Replace (X”,A2, 5)
- (b)= Replace (“X”,A2,5,1)
- (c)= Replace (A2,5,1,”X”)
Question 8 of 10

8. Question
Where in your formulas tab can you find your TRIM function
- (a)Text
- (b) Financial
- (c) Logical
Question 9 of 10

9. Question
What is the TRIM function used for in Excel?
- (a)Used to adjust your data to fit with the table
- (b)Used to remove all spaces from the text except space between the word
- (c) Used to remove all unwanted text/errors
Question 10 of 10

10. Question
where in the formula tab can you get your OFFSET function?
- (a) Logical
- (b) AutoSum
- (c) lookup & Reference

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

Click here to chat with us on WhatsApp now