C268 BUIT 2200
Spreadsheets
Final Exam (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question before
ANSing.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANSs. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANSs before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which function is used to find the largest value in a range?
a) MAX
b) MIN
c) LARGE
d) SUM
- ANS: a) MAX
2. What does the VLOOKUP function do?
a) Looks up a value in a vertical column
b) Looks up a value in a horizontal row
c) Looks up a value in a table array
d) Looks up a value in a pivot table
- ANS: a) Looks up a value in a vertical column
3. Which of the following is NOT a type of chart in Excel?
a) Line chart
b) Pie chart
c) Bubble chart
d) Matrix chart
©2024/2025
, - ANS: d) Matrix chart
4. What is the shortcut key to insert a new worksheet in Excel?
a) Ctrl + N
b) Shift + F11
c) Alt + F11
d) Ctrl + F11
- ANS: b) Shift + F11
5. Which function is used to count the number of cells that meet
a criterion?
a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK
- ANS: c) COUNTIF
### Fill-in-the-Blank Questions
6. The __________ function returns the current date and time.
- ANS: NOW
©2024/2025
Spreadsheets
Final Exam (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question before
ANSing.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANSs. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANSs before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which function is used to find the largest value in a range?
a) MAX
b) MIN
c) LARGE
d) SUM
- ANS: a) MAX
2. What does the VLOOKUP function do?
a) Looks up a value in a vertical column
b) Looks up a value in a horizontal row
c) Looks up a value in a table array
d) Looks up a value in a pivot table
- ANS: a) Looks up a value in a vertical column
3. Which of the following is NOT a type of chart in Excel?
a) Line chart
b) Pie chart
c) Bubble chart
d) Matrix chart
©2024/2025
, - ANS: d) Matrix chart
4. What is the shortcut key to insert a new worksheet in Excel?
a) Ctrl + N
b) Shift + F11
c) Alt + F11
d) Ctrl + F11
- ANS: b) Shift + F11
5. Which function is used to count the number of cells that meet
a criterion?
a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK
- ANS: c) COUNTIF
### Fill-in-the-Blank Questions
6. The __________ function returns the current date and time.
- ANS: NOW
©2024/2025
