These are the results of four tests for a class
of COL 110 students. Each test is out of a
Total (using the
Total (by adding Excel function,
maximum of 100.
Max
Samira
Hind
Shaikha
Khawla
Salma
Rabea
Nada
Marwa
Badriya
Muna
Maisoona
Layla
Hawaa
Amina
Asma
Lesson 3 Excel Functions
We can find the excel functions from Home Editing AutoSum OR FormulasInsert Function OR from fx near to the formula bar
Selecting a range of contiguous (together) and noncontiguous (apart) cells:
Contiguous: selecting cells toge
Unit 2: Basic Math & Formulas (PC)
Math operations:
Brackets
Exponents
Multiplication/Division ( Start by first coming)
Addition/Subtraction
Start by equal sign before any formula
Relative Cell Referencing:
To generalize a formula, type it in the form
Formulas
=
Order of Operations
Brackets
( )
Exponentiation
^
Division
/
Multiplication
*
Addition
+
Subtraction

Create a formula in the green cell in Column F that will give
the correct answer to the formula shown in Column E.
93*2 =
3 Correct
(93)*2