WorksheetsExcel: Basic Calculations and Formatting
Total questions: 19
Worksheet time: 10mins
Any formula must start with an (a) sign
If you type "A1+B1" in cell C1, the value of cell C1 would be
A1+B1
3
=A1+B1
C1
If you type =A1/B1 in cell C1, the value of cell C1 would be
2
1
0.5
A1/B1
"=A1+B1" is called a
formula
function
"=SUM(A1:B1)" is a
function
formula
both
if you type "=A1*B1" in cell C1
the value of cell C1 would be
2
3
1
A1*B1
The formula to DIVIDE cell A1 by cell B1 would be
=A1/B1
=B1/A1
=DIV(A1:B1)
-
the FUNCTION to add cell A1 and B1 would be
=A1+B1
=SUM(A1:B1)
=ADD(A1:B1)
=A1*B1
the formula to calculate the DIFFERENCE between A1 and B1 would be
=DIFF(A1:B1)
=A1-B1
=MIN(A1:B1)
ALL functions are formulas
True
False
ALL formulas are functions
True
False
"=(A1+B1)/2" is a ___ that will calculate the average value of cells A1 and B1
Formula
Function
=AVERAGE(A1:B1) is a ___ that will calculate the average value of cells A1 and B1
Function
Formula
to find out which cell value is HIGHER, A1 or B1, you would type:
=MAX(A1:B1)
=HIGHER(A1:B1)
=MAXIMUM(A1:B1)
=SUM(A1:B1)
to find out the average value of cells A1 and B1, using a FUNCTION, you would type:
=AVG(A1:B1)
=AVERAGE(A1:B1)
=MAXIMUM(A1:B1)
=SUM(A1:B1)/2
"=SUM(A1:B1)/2"
this formula would calculate the AVERAGE value of cells A1 and B1
TRUE
FALSE
This is not a formula
Cell FORMATTING means
Adding borders to a cell
Manipulating the way a cell looks
Changing the font in a cell
Changing the background colour of a cell
Changing the value of a cell
Choose ALL that is considered formatting
changing font size
merging cells
adding/deleting borders
changing row height
typing a formula in a cell
changing the cell value
ALL Functions are Formulas,
but NOT all Formulas are Functions
True
False
