IT Mid-Term Examination Form 5_T1_2025

A school accountant uses a spreadsheet to monitor monthly expenses and automatically calculate totals and balances. What best describes the purpose of the spreadsheet?

• To present data in graphical form only

• To display static data without calculations

• To store, manipulate, and analyze numerical data

• To create long textual documents

In a spreadsheet, the intersection of a column and row is known as:

• A record

• A cell

• A range

• A label

Which notation correctly represents a range from cell B2 to cell D6?

• (B2-D6)

• B2:D6

• B2;D6

• D6/B2

If cell B3 = 10 and cell C3 = 4, what will the formula `=B3*C3+5` return?

• 45

• 50

• 40

• 35

What formula should be entered in cell B5 to find the total of B1:B4?

• =ADD(B1:B4)

• =SUM(B1:B4)

• =TOTAL(B1:B4)

• =AVERAGE(B1:B4)

Which formula calculates the average score?

• =AVG(B2:B5)

• =AVERAGE(B2:B5)

• =MEAN(B2:B5)

• =SUM(B2:B5)/B2

A teacher wants to determine if students passed (≥60) or failed (<60).
If the mark is in B2, which formula correctly displays “Pass” or “Fail”?

• =IF(B2>60,Fail,Pass)

• =IF(B2="60","Pass","Fail")

• =IF(B2=60)

• =COUNTA(B2:B5,">=60")

If a spreadsheet of employees is sorted by “Department” (A–Z) and then by “Salary” (Highest to Lowest), what type of sort is being used?

• Simple sort

• Primary and secondary sort

• One-level sort

• Descending only

A user filters a table to show employees in “IT” with salary > 3000. What is this an example of?

• Multi-criteria filter

• Data grouping

• One-field sort

• Chart filtering

Which numeric format would best represent a sales commission rate?

• General

• Percentage

• Accounting

• Text