The City School
Peshawar Campus
Assessment Test Nov 2021
Class: 7 Subject: computing Term-1
NAME:
Data Handling
Q1: Fill in the blanks.
1. ___________________ reference is the cell reference.
2. ___________________ reference is used when we want to keep a cell, a row or a
column constant when copying a formula.
3. Values can be changed from a decimal number to a percentage by applying the
_________________________ format.
4. ______________ is a graphical representation of data.
5. ________________ chart is used to illustrate comparisons between a series of data.
6. _________________ Chart used to display only one series of data.
7. _________________ tab allows to switch the rows and columns.
8. ____________________________ allows you to automatically apply formatting.
Q2: Choice the correct option.
1. ___ files are comma-separated values and can be incorporated in any software or
database.
a) CSV b) BSV c) Excel d) Access
2. _____ can help make your worksheets more manageable by summarizing your data.
a) table b) Pivot Table c) Database d) Word
3. A ____ is an organized collection of data.
a) name() b) Basic c) database d) sum()
4. ______ message appears when the column is not wide enough to display all of its
content.
a) @@@@ b) $$$$ c) !!!! d) #####
5. ________ error message appears when you divide something by 0.
a) #DIV/0! b) Min() c) Change() d) Mid()
Q3: Select true or false statement.
1. Line chart use to display trends.
2. Pie Chart is used to display only two series of data.
3. Slicers are just like filters.
4. A database is an organized collection of data.
5. Pivot table can help make your worksheets more manageable by summarizing your
data.
Q4: Answer the following questions
i) Define Database.
ii) What is Pivot table?
iii) What is the purpose of using Slicers?
