NEW
Font size
WorksheetsIT Mid-Term Examination Form 5_T1_2025
Total questions: 60
Worksheet time: 3600secs
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
If A2=10, B2=5, C2=3, evaluate `=(A2+B2)*C2`.
65
45
25
30
If you delete a cell referenced in a formula, what typically occurs?
The formula automatically repairs
The formula shows `#REF!`
The result becomes zero
The entire row is deleted
What best describes the use of a Pivot Table?
To manually type totals
To summarize and analyze large datasets dynamically
To store unrelated data in rows
To plot data graphically only
A Pivot Chart differs from a regular chart because it:
Automatically updates when the Pivot Table changes
Must be redrawn manually
Can’t show totals
Ignores filters
If monthly sales increase steadily, which chart type best shows the trend?
Bar chart
Column chart
Line chart
Pie chart
The main purpose of labeling the axes in a chart is to:
Add decoration
Provide context to the data
Increase performance speed
Prevent editing
If Sheet1 cell B2 contains `=Sheet2!A5`, what does it mean?
It references a cell from the same sheet
It links to Sheet2 cell A5
It performs a lookup
It creates a pivot
A manager keeps sales by region in separate worksheets. To create a summary, they link all totals into one sheet. This is an example of:
Replication
Consolidation
Data validation
Range naming
Why are named ranges useful in formulas?
They make formulas easier to read
They reduce file size
They stop recalculation
They hide formulas
Which of the following best defines a database?
A single spreadsheet containing unrelated data
A collection of related tables that stores and organizes data
A set of text documents linked by formulas
A flat file used only for calculations
The main purpose of a database in an organization is to:
Display charts and graphs
Store, manage, and retrieve structured data efficiently
Replace an operating system
Perform arithmetic calculations
In a database table, a *record* refers to:
A single field
A column
A row containing related data items
A formula
In the table below, what data type would be most appropriate for the “Date of Hire” field?
Text
Date/Time
Logical
Currency
Why is it important for a table to have a primary key?
To allow duplicate records
To ensure each record is uniquely identifiable
To limit data entry
To store foreign keys
When creating a one-to-many relationship, which field should be used to connect the two tables?
Candidate Key
Foreign Key
Secondary Key
Duplicate Key
Which scenario represents a one-to-one relationship?
One teacher assigned to many students
One student with multiple subjects
One employee with one assigned ID badge
Many products in one category
A database administrator adds a new field “Email” to an existing “Customers” table. This action is an example of:
Creating a relationship
Modifying a table structure
Creating a form
Deleting a record
What happens when referential integrity is enforced between two related tables?
Records can be deleted from either table freely
The database prevents orphaned records
All relationships are removed
The primary key is automatically hidden
The form wizard in a database is primarily used to:
Design queries
Enter and view records easily
Create reports
Sort and group data
In a student database, a subform showing each student’s courses is an example of displaying data from which relationship?
One-to-one
One-to-many
Many-to-many
Many-to-one
Given the database table shown, which query returns students who passed?
SELECT * FROM Students WHERE Status="Pass";
SELECT * FROM Students WHERE Grade=70 AND Status="Pass" will:
SELECT Status FROM Students;
SELECT Name FROM Students WHERE Status="Fail";
In a query, the expression [Quantity]*[UnitPrice] is an example of:
A lookup
A calculated field
A foreign key
A validation rule
To display employees from the “HR” department OR those with salaries above 5000, which logical operator should be used?
AND
OR
NOT
XOR
The report wizard helps users to:
Create tables automatically
Generate formatted output with grouping and summaries
Edit queries directly
Import external data
If a report is sorted first by Department and then by Salary, this represents:
Grouping
Nested sorting
Filtering
Key indexing
In a report showing the number of students per grade, the COUNT function is used to:
Total numeric fields
Calculate the number of records
Sum averages
Sort by name
Which output destination is NOT valid for a database report?
Printer
Screen
File
Web browser
Renaming a report title affects:
The data source
Only the report’s header display
The database relationships
The form design
Which of the following ensures that entered data conforms to specific rules (like valid dates or ranges)?
Query wizard
Validation rule
Referential integrity
Primary key constraint
If “OrderDetails” has a field “CustomerID” linked to “Customers.CustomerID”, then “CustomerID” in “OrderDetails” is a:
Primary Key
Foreign Key
Candidate Key
Index Key
Which field below would most appropriately use the Currency data type?
EmployeeID
Salary
DateOfHire
Status
A field that could serve as a unique identifier but is not selected as the primary key is called:
Alternate Key
Candidate Key
Foreign Key
Secondary Key
If deleting a record in the parent table also deletes related records in the child table, what option is active?
Cascade Delete
Cascade Update
Referential Lock
Null Constraint
In a spreadsheet, the formula =SUM(A1:A3) adds the values in cells A1 through A3.
True
False
In a database, a primary key can contain duplicate values.
True
False
Relative cell references in a spreadsheet change when formulas are copied to another location.
True
False
The COUNT function in spreadsheets counts both text and numeric entries.
True
False
In a database, relationships are established to eliminate data redundancy.
True
False
The IF function can only compare numeric data.
True
False
Sorting data in ascending order means arranging it from Z to A.
True
False
The PMT function in spreadsheets is used to calculate loan payments.
True
False
A report in a database can include grouping and summary calculations.
True
False
A Pivot Table in spreadsheets is used mainly to enter raw data.
True
False
A bar chart is best used to show trends over time.
True
False
When a formula in cell C2 references A2 and B2 (=A2+B2) and is copied to C3, what will the new formula read?
=A2+B2
=A3+B3
=A2+B3
=A3+B2
If a formula in C2 is =A2*$B$1 and it’s copied down to C3, what happens?
Both references change
Neither reference changes
Only A2 changes to A3
Only $B$1 changes
Given this data snippet, what function returns the price of “Pencil”?
=VLOOKUP("Pencil",A2:C4,3,FALSE)
=VLOOKUP("A02",A2:C4,3,FALSE)
=LOOKUP("Pencil",B2:C4,2,FALSE)
=VLOOKUP("A02",A2:C4,2,TRUE)
Which formula counts how many students scored ≥60?
=COUNTIF(B2:B5,">=60")
=COUNTIF(B2:B5,">60")
=COUNT(B2:B5>=60)
=COUNTA(B2:B5,">=60")
Which function counts only the numeric entries in a range?
COUNTA
COUNT
COUNTIF
NUMCOUNT
Which formula correctly calculates the monthly loan payment for $10,000 at 10% annual interest over 2 years?
=PMT(10%,2,10000)
=PMT(10,2,10000)
=PMT(0.10,24,-10000)
=PMT(10%/12,24,10000)
