NEW
Font size
WorksheetsMS Excel practice
Total questions: 18
Worksheet time: 10mins
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
Which functionin Excel checks whether a condition is true or not ?
SUM
COUNT
IF
AVERAGE
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
SHORT CUT FOR CUT
CTRL+C
CTRL+V
CTRL+D
CTRL+X
The absolute cell reference uses which symbol:
$
%
*
&
To create a drop-down list in a cell or cell range, you would use:
the LIST function
DATA VALIDATION
NAME MANAGER
a VLOOKUP function
To count how many cells have text in them, use the function:
COUNT
COUNTIF
COUNTA
SUMIF
What is this?
Cell
Formula Bar
Tell Me Search Window
Name Box
The function that lets you add up a range of cells or values
SUM
AVERAGE
MIN
MAX
To sort names in a worksheet, we can use this button.
This is a valid simple formula
A2+A4
=AB3+Y5
(a2*t3)/100
=(a2*t3)/100
* is a symbol for:
Multiplication
Addition
Subtraction
Dividing
