Page 54 - modular4.0
P. 54
Chapter Profile
The month of the current date will appear. We can also give the reference of a cell containing the
date to the MONTH() function. Similarly, we can use the YEAR() and DAY() functions to get the year
and day from a date respectively.
Tech Funda
The common functions like Sum, Average, Max, Min, can also be used
by using the down arrow of the AutoSum command.
To use other functions click on More Functions option.
Recap
A cell or a range of cells that you want to use in your calculation is called reference.
Formulas in Excel 2019 begin with an equal to (=) sign.
Excel calculates consecutive operators with the same level of precedence from left to right.
A cell reference is a cell address that can be used in a formula to denote a specific cell.
A group of selected cells is called a range.
Functions are predefined formulas in Excel to perform both simple and complex calculations.
Exercise
A. Tick ( ) the correct option.
1. What is the output of the formula = 5+5*2?
a. 20 b. 15
c. 10 d. 5
2. Which tab in Excel is used to assign a name to a cell range?
a. Page layout b. Formula
c. Data d. Review
3. Which symbol is used for absolute referencing?
a. @ b. #
c. $ d. ^
52 Modular (Ver. 4.0)-VII

