Page 32 - modular4.0
P. 32
Chapter Profile
Values or Numbers: Values are numeric data on which mathematical calculations are performed.
This type of data includes characters 0–9 and special characters, such as -, +, [, /, ?, >, <, %. The
numbers and characters are always aligned on the right side of the cell.
Formula: A formula is a mathematical expression used to do simple and complex calculations
of the numeric data inserted in a cell or a range of cells. A formula always begins with an equal
to (=) sign e.g. = A2 + B2.
Recap
Excel 2019 is an application software to store and analyse numerical data.
A worksheet has grid-like divisions.
Vertical divisions are called columns whereas the horizontal divisions are known as rows.
The intersection of a row and column is called a cell.
There are mainly three data types in Excel that are label, number and formula.
Exercise
A. Tick ( ) the correct option.
1. Excel 2019 is a/an software to store and analyse data.
a. System b. Application
c. Utility d. programming
2. What is the default file name of an Excel 2019 file?
a. Book1 b. Sheet1
c. Worksheet1 d. Document1
3. Which tab should be clicked to activate a specific worksheet?
a. Formula tab b. Status Tab
c. Worksheet Tab d. Name Tab
4. What is the default alignment of values in a spreadsheet?
a. Left b. Right
c. Center d. Justify
B. Fill in the blanks using the words given below:
Quick access toolbar, spreadsheet, name box, alphabets
1. A single page in Excel is called .
30 Modular (Ver. 4.0)-VII

