Spreadsheet software enables us to perform calculations on data easily.
A formula is an expression that help us perform calculations in a worksheet.
We begin formulas with an equal to (=) sign.
Formula Bar displays the formula used in the cell.
Cell References are the addresses on the cells.
Operators are symbols that specify the type of operations to be performed.
Functions are built-in formulas in Excel.
Press the F2 key to modify the formula in a cell.
The text operator & concatenates or joins two strings.
The default cell referencing is relative referencing.
What are the various arithmetic operators? +, -, *, /, ^
What is the hierarchy of operators? Brackets → Exponent → Multiplication & Division → Addition & Subtraction
The AutoSum feature helps us calculate the sum of data arranged in contiguous rows/columns.
The symbol of AutoSum feature is ∑
Arguments are the values passed to a function.
The AutoSum option includes which functions? Sum, Average, Count Numbers, Max, Min
Identify the functions: a. To add all the numbers: SUM b. To find the average (arithmetic mean): AVERAGE c. To count the cells with numeric entries: COUNT d. To find the highest value: MAX e. To find the smallest value: MIN f. To return the current system date: TODAY() g. To return the remainder: MOD() h. To return the exponentiation: POWER() i. To return the LCM: LCM() j. To return the GCD or HCF: GCD()
Identify the type of cell referencing: a. B2 – Relative Referencing b. $B$2 – Absolute Referencing c. $B2 – Mixed Referencing d. B$2 – Mixed Referencing
Identify the error results: a. Formula contains invalid data: #VALUE! b. Number is divided by 0: #DIV/0! c. Formula is not recognized: #NAME? d. Column not wide enough: ######
Evaluate the following expressions: a) 4 ^ 2 = 16 b) 9 / 2 = 4.5 c) 4 * 2 = 8
How do we refer to cell A5 in Sheet2? Sheet2!A5
Name the three types of referencing. a. Relative Referencing b. Absolute Referencing c. Mixed Referencing
Write the full form: a. LCM – Least Common Multiple b. GCD – Greatest Common Divisor