You must be logged in to view this content.
MS Excel Intermediate SET C
Quiz Summary
0 of 24 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 24 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
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 24
1. Question
What is the keyboard shortcut to create a new workbook?
CorrectIncorrect -
Question 2 of 24
2. Question
__________ an equation that makes calculations based on the data in your spreadsheet.
CorrectIncorrect -
Question 3 of 24
3. Question
Fill in the blank.
-
feature saves a lot of time typing repetitive series.
CorrectIncorrect -
-
Question 4 of 24
4. Question
You want to arrange the Net Salary of the employees from largest to smallest value, which one you should click?
CorrectIncorrect -
Question 5 of 24
5. Question
Fill in the blank.
-
feature is used to temporarily hide everything hide everything in a table except the data you want to view.
CorrectIncorrect -
-
Question 6 of 24
6. Question
Fill in the blank.
-
series fills date unit either by date, weekday, month or year.
CorrectIncorrect -
-
Question 7 of 24
7. Question
What is the keyboard shortcut key to lock the cell refences in a formula?
CorrectIncorrect -
Question 8 of 24
8. Question
Fill in the blank.
-
series multiplies the number with the value.
CorrectIncorrect -
-
Question 9 of 24
9. Question
Fill in the blank.
-
You can rearrange data in a worksheet in ascending or descending order or temporarily filter out specific values by the selected data.
CorrectIncorrect -
-
Question 10 of 24
10. Question
Fill in the blank.
-
The AutoFill options button appears after you drag the .
CorrectIncorrect -
-
Question 11 of 24
11. Question
Fill in the blank.
What are Formulas?
-
It is considered as the heart of a .
CorrectIncorrect -
-
Question 12 of 24
12. Question
What is the MS Excel function that used to extract the day from an Excel date?
CorrectIncorrect -
Question 13 of 24
13. Question
Fill in the blanks.
What is Functions?
-
It allows you to a result such as adding numbers or finding the of a range of .
CorrectIncorrect -
-
Question 14 of 24
14. Question
Using the column of Net GDP, what is the formula to get the Average GDP?
CorrectIncorrect -
Question 15 of 24
15. Question
Fill in the blanks.
Why is Formulas important?
-
Without formulas, MS Excel would be nothing more than a for displaying text and .
CorrectIncorrect -
-
Question 16 of 24
16. Question
Fill in the blanks.
What is Adjacent Cell?
-
It is beside one another or .
CorrectIncorrect -
-
Question 17 of 24
17. Question
You want to sort your data alphabetically. Which button you will click?
CorrectIncorrect -
Question 18 of 24
18. Question
Fill in the blanks.
What is a chart?
-
It allows you to present , relationships or trends .
CorrectIncorrect -
-
Question 19 of 24
19. Question
Refer to the highlighted section below. Assume that you want to put the currency style on the selected values. Which option could you use.
CorrectIncorrect -
Question 20 of 24
20. Question
Pick the correct answers.
What types of charts you can use in MS Excel? Click all the correct answers.
CorrectIncorrect -
Question 21 of 24
21. Question
Pick the correct answer.
All of them is a chart type except one. Which one is it?
CorrectIncorrect -
Question 22 of 24
22. Question
Pick the correct answer.
What chart type plots clusters of values using single points?
CorrectIncorrect -
Question 23 of 24
23. Question
Pick the correct answer.
What chart type shows values as a percentage of a whole?
CorrectIncorrect -
Question 24 of 24
24. Question
What is the formula to get the value of D5?
CorrectIncorrect