Page 58 - 2502_Pakistan-kifayat_C-8

DOWN 2
1 R 3
2. A toolbar that contains tabs and
commands. R

3. The horizontal sections of a table. 4

4. Predefined formulas in Excel.
5 O U
7. A key that shows the meaning of symbols and
colours in a chart. 7
6 C

8 O E

2. Competency-based/Application-based questions.

a. Zainab, a student, is preparing a spreadsheet of monthly expenses. Which Excel function should
she use to calculate and automatically update the total amount?
b. Hassan created a bar chart in Excel to display the number of books read by each student in his
class. Which chart feature should he use to display the actual values on top of each bar?

21 st
DIY In The Lab Century #Technology Literacy
#Flexibility
Skills
To
Subject Using Formulas and Charts

1. In Excel, enter the data for your daily expenses. Now, create a chart based on the entered data.

2. Create a similar invoice in Excel.
Fill-up details of five items, their quantities
and unit prices.

Using Product function, calculate the
amount for each item.

Using SUM function, calculate the total
amount.

Using formula, calculate the Sales Tax according to the given rate.
Calculate Invoice amount payable.

For The Teacher

Demonstrate to the students the concepts of Excel discussed in the chapter.

Explain to the children the use of Excel at homes, shops, business, industries, etc.

56 Premium Edition-VIII