Page 1
7th March, 2025
Excel (TEST 2)
Time Allowed: 1hr 45 mins
SECTION A: MULTIPLE CHOICE [10 Marks]
Answer the whole of this question in MS Word. You do not have to copy the
questions. You are advised not to spend more than 15 minutes on this
section.
1. Which function is used to count the number of cells in a range that
contain numbers only in Excel?
A) COUNTA B) AVERAGE C) MAX D) COUNT
2. What is the result of the formula "=MAX(A1:A5)" if cells A1, A2, A3, A4,
and A5 contain the values 10, 20, 30, 40, and 50, respectively?
A) 50 B) 60 C) 70 D) 80
3. Consider the spreadsheet below:
To determine the number of sales people by region who have 50 or
more orders, we use the:
A) COUNT B) COUNTA C) COUNTIF D) COUNTIFS
4. Which of the following is not a valid Excel Function?
A) SUM() B) SUBTRACT() C)COUNT() D)COUNTA
5. What does the formula =IF(A1>10, "Over 10", "10 or less") return if A1 is 12?
A) "Over 10" B) "10 or less" C) 12 D) TRUE
6. Which of the following is an example of a nested IF function?
There is no knowledge that is not power
Page 2
A) =IF(A1>10, "High", "Low")
B) =IF(A1>10, "High", IF(A1>5, "Medium", "Low"))
C) =IF(A1=10, "Ten", "Not Ten")
D) =IF(A1<5, "Low")
7. Which function would you use to count how many cells meet a
specific condition?
A) COUNT B) COUNTA C) COUNTIF D) SUMIF
8. In Microsoft Excel spreadsheets, rows are designated as _______.
A) 1, 2, 3, ....
B) A, B, C, ....
C) A1, B1, C1, ....
D) I, II, III, ....
9. In MS Excel, the keyboard shortcut “Ctrl+S” can be used to_______
A) Save As B) Save
C) Start new workbook D) Switch between opened tabs
10.What is the purpose of the Filter feature in Excel?
A) To sort the data
B) To delete data
C) To display only the data that meets certain criteria
D) To add rows
There is no knowledge that is not power
Page 3
SECTION B [40 Marks]
QUESTION ONE
Answer the whole of this question in MS Excel. Use font Lucida Sans,
Size 12. You are advised not to spend more than 45 minutes on this
section.
1. Create a new MS Excel document and save it [Full Name - Test 2]
2. Rename sheet 1 to Worker Data Sheet.
3. Copy the following onto the sheet. Ensure that you copy as
accurately as possible.
4. Use appropriate means to calculate
a. the commission [at 28% of the sales].
b. The gross pay for each worker
c. The tax [at 2.5 of the gross pay]
5. Use the Name and Sales columns to create a 3D - Stacked Bar.
6. Counter-check your work and save.
There is no knowledge that is not power
Page 4
QUESTION TWO. You are advised not to spend more than 45 minutes on
this section.
1. Open a new document in MS Excel and copy the following table use
font face, Bookman old style, Font Size 13.
2. Use appropriate means to calculate;
a. the gross profit for the three months.
b. The tax is applicable at a rate of 12% only when the gross profit
exceeds 20,000. If the profit is less than 20,000, the tax amount is
0.
c. The net profit after deducting the tax
d. The sum of the profit made on Phones in January, only for
profit above 8,000
e. The profit made on Laptops in March
f. The sum of the profit made on TVs for profits is less than 7,000
in February
g. The Profit made on Phones sold by Musonda in March for
profits above 5,000.
2. Use the column for TXN ID and Mar to create a clustered column.
3. Include a Header to indicate your Full Name, Current Time, and
Phone number.
4. Save the Document as Full Name - Kale Bwangu.
Zip your files and save them as [Full Name - Excel Test 2]
There is no knowledge that is not power
