TF-TECH INSTITUTIONS IN BALOCHISTAN
6th Module Test of (Shadenzai Branch)
Course Name: Basics of Computer & Office Management
Topic: Intro of MS Excel, Creating various templates in excel
Total Marks: 40
Duration:
Student Name: _______________________________________________________
Date: _____________________________________________________________________
Section A: Multiple Choice Questions (1 mark each)
1. Which function returns the average of numbers?
a) SUM
b) AVERAGE
c) COUNT
d) MAX
2. Which is a relative cell reference?
a) $A$1
b) A1
c) A$1
d) $1$A
3. What is MS Excel mainly used for?
a) Drawing pictures
b) Playing games
c) Watching videos
d) Organizing and analyzing data
4. What is a workbook in Excel?
a) A file with many sheets
b) A single cell
c) A printed book
d) A tool for photos
5. What is a worksheet?
a) A photo
b) A group of files
c) A music file
d) A single sheet in Excel
6. Which key is used to save a file quickly?
a) Ctrl + P
b) Ctrl + S
c) Ctrl + C
d) Ctrl + X
7. What is the name of a single box in Excel?
a) Tab
b) Sheet
c) Page
d) Cell
8. Which part shows the selected cell’s name?
a) Name box
b) Formula bar
c) Header
d) Title bar
9. Which chart is best for showing parts of a whole?
a) Bar Chart
b) Pie Chart
c) Line Chart
d) Scatter Chart
10. Which function will count only numeric values in a range?
a) COUNTA
b) COUNT
c) COUNTIF
d) COUNTBLANK
11. SUMIF is used to:
a) Subtract values
b) Add based on condition
c) Filter data
d) Average values
12. The result of =MAX(5, 9, 3) is:
a) 3
b) 5
c) 9
d) 0
13. Which symbol is used for multiplication in Excel?
a) +
b) X
c) /
d) *
14. What does the formula =IF(A1>100, "High", "Low") return if A1=120?
a) High
b) Low
c) 120
d) Error
15. Which tab is used to insert charts and images?
a) Home
b) Insert
c) View
d) File
16. Which operator shows TRUE only when both are true?
a) IF
b) NOT
c) OR
d) AND
17. What is a Nested IF?
a) IF inside another IF
b) Two worksheets
c) Chart making
d) Formula for printing
18. Which option is used to set a password in Excel?
a) Print file
b) Save As
c) Check spelling
d) Encrypt with password
19. Which option helps people with disabilities?
a) Check Compatibility
b) Insert Chart
c) Check Accessibility
d) Freeze Pane
20. Which chart is best to show trends over time?
a) Bar chart
b) Pie chart
c) Line chart
d) Dot chart
Section B: Fill in the Blanks (5 Marks)
1. The equal sign (=) is used to begin every ______.
2. ______ Function adds all numbers in a range.
3. ______ formatting highlights values based on rules.
4. In a workbook, a ______ contains rows and columns.
5. A ______ operator checks for greater or lesser values.
Section C: Short Answer / Formula Tasks (3 Marks)
1. Explain the difference between SUM, AVERAGE, and COUNT functions with examples?
2. Write a formula to add cells A1 and B1?
3. Write an IF formula: If score in B2 > 50, display “Pass”, else “Fail”?
4. Write SUMIF formula to add values in C2:C6 where category in B2:B6 is “Books”?
5. Describe the use of Nested IF statements with an example?
