Quiz Summary
0 of 20 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 20 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
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 20
1. Question
Based on the data below, what is the formula to know the number (count) of Gross Salary that is more than 900?
Note: 1 condition only given
CorrectIncorrect -
Question 2 of 20
2. 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 3 of 20
3. Question
What is the function that counts the number of cells within a range that contains numbers only?
CorrectIncorrect -
Question 4 of 20
4. Question
What is the function that counts non-empty cells (counts both numbers & texts)?
CorrectIncorrect -
Question 5 of 20
5. Question
What is the function that adds (total) the cells specified by a given condition (1 condition only)?
CorrectIncorrect -
Question 6 of 20
6. Question
What is the correct way of entering formula into a cell?
CorrectIncorrect -
Question 7 of 20
7. Question
What is the name of this?
CorrectIncorrect -
Question 8 of 20
8. Question
What’s the SUM formula that adds up the following cells C2, C3 and C4?
CorrectIncorrect -
Question 9 of 20
9. Question
What’s the formula, or function that finds the highest # among the cells G6, G7, G8?
CorrectIncorrect -
Question 10 of 20
10. Question
What functions will convert the word “de’ heritage”, to uppercase, in cell A9.
CorrectIncorrect -
Question 11 of 20
11. Question
What is the MS Excel functions that allows us to know the number of characters in a certain cell.
CorrectIncorrect -
Question 12 of 20
12. Question
What is MS Excel function that used to extract the leftmost letters of a text.
CorrectIncorrect -
Question 13 of 20
13. Question
__________ is a tool that you can use to communicate your data graphically?
CorrectIncorrect -
Question 14 of 20
14. Question
__________ an Excel file containing worksheets.
CorrectIncorrect -
Question 15 of 20
15. Question
Rows are the horizontal lines in the worksheet numbered from 1,2,3… until row _______ (the last row).
Use commas to separate the values without spaces.
-
Rows are the horizontal lines in the worksheet numbered from 1,2,3… (the last row).
CorrectIncorrect -
-
Question 16 of 20
16. Question
If you want to make absolute reference to cell E2, what would it look like?
CorrectIncorrect -
Question 17 of 20
17. Question
__________ an Excel features that automatically inserts previously-entered data.
CorrectIncorrect -
Question 18 of 20
18. Question
An MS Excel function that calculates the average range of cells.
CorrectIncorrect -
Question 19 of 20
19. Question
The keyboard shortcut for absolute references is __________?
CorrectIncorrect -
Question 20 of 20
20. Question
Which of these symbols means that the row does not change when copied to another cell.
CorrectIncorrect