WorksheetsExcel Formulas - Francis Bacon
Total questions: 20
Worksheet time: 13mins
All formulas must begin with
parenthesis
sign
equal sign
uppercase
Data without this sign is considered a (a)
SUM
Calculates the average of a range of numbers.
Counts the number of cells in a range that contain numbers.
Adds up all the numbers in a range.
Finds the largest value in a range of numbers.
Calculate the sum total of all cells in a range which meet the logical test.
(a)
Calculates the average of a range of numbers.
=AVERAGEIF
=AVERAGE
=COUNT
IF
Counts the number of cells in a range that contain numbers.
(a)
Join two or more strings together to create one text string
(a)
Count the number of cells in a range that contain a non-blank value and meet the logical test
COUNT
COUNTBLANCK
COUNTA
COUNTIF
It counts the number of non-blank cells in a cell range.
(a)
Counts the number of empty (do not contain any value) cells in the specified range.
COUNT
COUNTA
COUNTBLANK
COUNTIF
This function evaluates a logical test and performs one of two different
calculations based on the result
AVERAGEIF
COUNTIF
SUMIF
IF
Finds the largest value in a range of numbers.
(a)
Calculate the average value of all cells in a range which meet the logical test.
AVERAGE
AVERAGEIF
IF
COUNTIF
Convert the first letter of the text string to uppercase; all other characters are set to lowercase
(a)
Convert all characters in a text string to lowercase.
(a)
Extract the specified number of characters starting from any position in the text string
LEFT
RIGHT
MID
TRIM
Extract the specified number of characters starting from the left side of the text string
(a)
Remove any blanks from the text string
MID
TRIM
LEFT
RIGHT
Convert all characters in a text string to uppercase
(a)
Where can you find the formulas in Excel?
Insert tab
Formulas tab
fx
Home tab
