Mastering Excel Quiz
Quiz Summary
0 of 10 Questions completed
Questions:
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
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
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 10
1. Question
What is the Shortcut of Hiding a Row
CorrectIncorrect -
Question 2 of 10
2. Question
Shortcut of Select all Data
CorrectIncorrect -
Question 3 of 10
3. Question
From which Tab you can Remove the Duplicates
CorrectIncorrect -
Question 4 of 10
4. Question
Which option you will use to Highlight / Color the Data on the Basis of Condition ?
CorrectIncorrect -
Question 5 of 10
5. Question
Which formula you will use to Remove Unwanted Spaces from the Data
CorrectIncorrect -
Question 6 of 10
6. Question
Which is the correct CountIF Formula
CorrectIncorrect -
Question 7 of 10
7. Question
Correct SumIF Formula is
CorrectIncorrect -
Question 8 of 10
8. Question
Steps in Recording Macro ?
CorrectIncorrect -
Question 9 of 10
9. Question
Steps for IF Condition
CorrectIncorrect -
Question 10 of 10
10. Question
What is the difference between Count & CountA Function ?
CorrectIncorrect