SCHOOL YEAR: 2022-2023
3RD QUARTER EXAMINATION IN ICF 9
NAME: _____________________________________________________ SCORE: ____________
GRADE & SECTION: _________________________________________ DATE: ______________
I. DIRECTIONS: Read the questions carefully. Write the letter of the correct answer (BIG
LETTERS) in your answer sheet. (10 points)
1. The intersection of a row and a column is called a ________________________.
A. sum B. worksheet C. chart D. cell
2. A group of cells is called a __________________________.
A. multicell B. cell range C. chart D. cell cluster
3. Where is the fill handle located?
A. At the beginning of any formula or function C. on the right side of the ribbon
B. In the bottom-right corner of the selected cell D. In backstage view
4. Which of the following is an absolute cell reference?
A. the cell reference changes when copied or dragged to other cell
B. the cell reference never change when copied or dragged to other cell
C. the column in the cell reference changes once copied or dragged to other cell
D. the cell reference changes when highlighted or selected
5. What value would excel return for this formula, =(82-32)/5+8*2?
A. 91.6 B. 36 C. 26 D. 7.69
6. Which is a correct example of a formula in MS Excel?
A. 13+14= B. 13+14 C. =13+14 D. (13+14)=
7. In this example, what’s wrong with the formula in cell B5?
A. Nothing. The formula is correct.
B. It should use subtraction instead of addition.
C. Without parentheses, multiplication is performed too early.
D. it should use division instead of multiplication.
8. What is formula in cell B3 doing?
1
A. Multiplying inventory costs by the total budget
B. Subtracting inventory costs from the total budget
C. Finding the average budget total
D. Subtracting the total budget from the inventory costs
9. Select the formula that will subtract the inventory costs from the monthly budget.
A. =B3-B2 B. B3/B2 C. B2-B3 D. B3*B2
10. This refers to the location or address of any cell that can be used in a formula so that
Microsoft Office Excel can find the values or data that you want that formula to calculate.
A. cell reference B. cell range C. cell box D. name box
II. DIRECTIONS: Fill out the table below with correct [Link] you answer in your answer
sheet. (15 points)
CELL WHAT TYPE OF
WHAT IS CELL
STATION REFERENC WHAT DOES IT LOOK LIKE IN EXCEL?
HELD? REFRENCE IS
E IT?
1. X13
2. G$21
3. $B1
4. $J5
5. $E$7
2
III. A. DIRECTIONS: Identify the following cell range whether VERTICAL, HORIZONTAL,
MIXED or MULTIPLE. Write you answer in your answer sheet. (10 points)
____________________ 1. A1:A12 ____________________ 6. F21:L21
____________________ 2. B18:B76 ____________________ 7. AB45:AD50
____________________ 3. AC13:AC24 ____________________ 8. G16:L28, D12:D14
____________________ 4. J1:M28 ____________________ 9. S5:V19
____________________ 5. D4:Z4, R6:T9 ____________________ 10. Y8:Z8
III. B. DIRECTIONS: What are the cell ranges of the highlighted colors below in the spreadsheet
area? Write the cell range in you answer sheet. (9 points)
IV. DIRECTIONS: What could be the formula in MS Excel of each value in the cell? Write your
answer in your answer sheets. (6 points)