- 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
Class 6 | Calculations in Excel 2016
Reply