TF-TECH INSTITUTIONS IN BALOCHISTAN
7th Module Test of (Shadenzai Branch)
Course Name: Basics of Computer & Office Management
Topic: Working with Tables, Filters, and advanced Filters, Data crunching, and
Consolidation
Total Marks: 40
Duration:
Student Name: _______________________________________________________
Date: _____________________________________________________________________
Section A: Multiple Choice Questions (1 mark each)
1. Records Management mainly deals with:
a) Designing websites
b) Handling and organizing important data
c) Writing code
d) Creating animations
2. Which of the following is NOT a principle of Records Management?
a) Create
b) Classify
c) Hide
d) Dispose
3. Which feature ensures only authorized people can access records?
a) Reliability
b) Organization
c) Security
d) Consistency
4. What is the main benefit of Records Management?
a) Reduces entertainment
b) Saves time & improves efficiency
c) Hides information permanently
d) Creates duplicate data
5. A doctor keeping patient history for future treatment is an example of:
a) Data crunching
b) Records Management
c) Chart making
d) Filtering
6. What is Data Crunching?
a) Playing games on Excel
b) Splitting names into columns
c) Processing large data to find useful info
d) Saving Excel files
7. Which formula finds the average in Excel?
a) =SUM()
b) =MAX()
c) =AVERAGE()
d) =MIN()
8. Which of these is NOT used in Data Crunching?
a) =SUM()
b) =AVERAGE()
c) =VLOOKUP()
d) =MIN()
9. Data Crunching can help identify:
a) Movie reviews
b) Top scorers in exams
c) Paint colors
d) Phone contacts
10. Which analysis tool shows trends over time?
a) Bar Chart
b) Line Chart
c) Pie Chart
d) Filter
11. "Text to Columns" is used for:
a) Splitting data into multiple columns
b) Creating charts
c) Deleting files
d) Formatting text
12. Which Data Tool automatically fills values based on patterns?
a) Flash Fill
b) Filter
c) Pivot Table
d) Validation
13. The "Remove Duplicates" tool is used to:
a) Delete empty rows
b) Keep only unique data
c) Highlight numbers
d) Add totals
14. Data Validation is useful to:
a) Allow only certain inputs in a cell
b) Combine text automatically
c) Remove repeated data
d) Insert slicers
15. Which tool is used to combine data from multiple sheets?
a) Consolidate
b) Flash Fill
c) Filter
d) Slicer
16. PivotTables are mainly used for:
a) Drawing pictures
b) Summarizing and analyzing large data
c) Deleting duplicates
d) Formatting cells
17. Which area in PivotTable shows calculated values (e.g., sum of sales)?
a) Rows
b) Columns
c) Filters
d) Values
18. Which option makes PivotTables easier to print?
a) Conditional Formatting
b) Classic Layout (Tabular Form)
c) Chart Formatting
d) Remove Duplicates
19. A Slicer in Excel works as:
a) A formula
b) A visual filter
c) A storage tool
d) A chart style
20. If you click on "Chocolate" in a Slicer, what happens?
a) Deletes chocolate data
b) Filters PivotTable to show only chocolate sales
c) Splits text into columns
d) Combines chocolate with other products
Section B: Fill in the Blanks (1 mark each)
1. _________ means processing a large amount of data to find useful information.
2. The tool that combines data from multiple sheets is called __________.
3. The four main areas in a PivotTable are Rows, Columns, Values, and __________.
4. _________ are used in Excel to quickly filter data visually.
5. The command to remove repeated entries is called __________
Section C: Short Questions (3 mark each)
1. What are the essentials of Records Management? With real-life examples.
2. What are Data Tools in Excel? Discuss Flash Fill, Remove Duplicates, and Data Validation
with examples.
3. Explain step-by-step how to create a PivotTable in Excel and describe the use of Rows,
Columns, Values, and Filters.
4. Write a step-by-step guide to create an invoice template in Excel.
5. What is a Slicer in Excel? Name two types of filters.
