Page 82 - TGPT_V5.0_C5_Flipbook
P. 82
Interdisciplinary Learning
#Mathematics
Make a progress report of 10 students of your class.
1. Create a new workbook.
2. Enter their roll numbers, names, class, ages and subjects (Science, English and Mathematics).
3. Now add two more columns for total and percentage and enter their values.
4. Save the workbook with your name and close Excel.
Roll No. Name Class Age Subjects
#Lab Activity
USING FORMULAS TO PERFORM CALCULATION
Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with equal to
sign, Excel understands that user has enter a formula here. If you don’t enter the equal sign,
Excel will treat your entry as text and the calculation will fail.
Different Ways to Enter A Formula
There are mainly two ways to enter a formula in a worksheet:
Typing the Formula Directly in the Cell: In this way, the formula is directly typed in the cell
after typing an equal sign as follows:
After entering the formula in the cell, press the Enter key. When the Enter key is pressed,
result of the formula appears in the cell.
Typing the Formula in the Formula Bar: In this way, we can type the formula in Formula
bar after selecting the cell. After entering the formula, when we press the Enter key from
the keyboard. The result will appear.
80 Premium Edition-V

