You must be logged in to view this content.
MS Excel Intermediate SET B
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
Fill in the blank.
-
To open a workbook, click the File menu and select Workbook and click create.
CorrectIncorrect -
-
Question 2 of 24
2. Question
Fill in the blank.
-
To select non-adjacent rows; hold down the key as you select the row headings with the left mouse button.
CorrectIncorrect -
-
Question 3 of 24
3. Question
What is the keyboard shortcut keys to edit a formula in a cell?
CorrectIncorrect -
Question 4 of 24
4. Question
Fill in the blank.
-
To access the find and replace commands, click the Find & Select button in the group on the Home tab.
CorrectIncorrect -
-
Question 5 of 24
5. Question
Fill in the blank.
-
is a command that provides navigation to a specific place in the document.
CorrectIncorrect -
-
Question 6 of 24
6. Question
Fill in the blank.
-
is a command that reapplies the last action.
CorrectIncorrect -
-
Question 7 of 24
7. Question
Fill in the blank.
-
is a command that reverses the last action.
CorrectIncorrect -
-
Question 8 of 24
8. Question
Based on the figure above, how many active cell you have?
CorrectIncorrect -
Question 9 of 24
9. Question
What is SmartArt Graphic?
-
It is a representation of to effectively communicate your or ideas.
CorrectIncorrect -
-
Question 10 of 24
10. Question
What is Screenshot?
-
It is one of the new and useful especially if you are writing articles that needs you to provide .
CorrectIncorrect -
-
Question 11 of 24
11. Question
What is the fastest way to copy the format of the boys to girls table?
CorrectIncorrect -
Question 12 of 24
12. Question
Fill in the blanks.
-
inches at the top and bottom and inches to the left and right is the default margin size setting in MS Excel.
CorrectIncorrect -
-
Question 13 of 24
13. Question
You want to put 2 decimal places on your numeric data. What will you click?
CorrectIncorrect -
Question 14 of 24
14. Question
Fill in the correct answer.
-
Headers and footers are found in group of Insert tab.
CorrectIncorrect -
-
Question 15 of 24
15. 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 16 of 24
16. Question
Fill in the blank.
-
divides a worksheet into separate pages for printing.
CorrectIncorrect -
-
Question 17 of 24
17. Question
What is the function that allows us to look up data in a table that has been formatted in columns?
CorrectIncorrect -
Question 18 of 24
18. Question
Fill in the blank.
-
The command allows you to designate certain rows and columns to repeat on every printed page.
CorrectIncorrect -
-
Question 19 of 24
19. Question
Fill in the blank.
-
are used to control the amount of blank space around the edges of the worksheet data.
CorrectIncorrect -
-
Question 20 of 24
20. Question
Based on the figure below. What is the formula to extract the data for cell reference L2?
CorrectIncorrect -
Question 21 of 24
21. Question
A MS Excel file in which you enter and store related data.
CorrectIncorrect -
Question 22 of 24
22. Question
What are the types of data you can enter on a worksheet?
CorrectIncorrect -
Question 23 of 24
23. Question
Fill in the blanks.
How to Insert ClipArt.
-
Step 1: MS Excel.
Step 2: Click tab.
Step 3: Click .
Step 4: In the search for box, any word, say “Computer”.
Step 5: Click .
Step 6: Finally, click the .
CorrectIncorrect -
-
Question 24 of 24
24. Question
Using the column of Gross Salary, what is the formula to get the Maximum Gross Salary?
CorrectIncorrect