NEW
Font size
WorksheetsMS Excel
Total questions: 20
Worksheet time: 18mins
What is Excel?
A spreadsheet software developed by Microsoft
A word processing software
A database management system
A presentation software
What does the SUM function do?
Adds the values of cells
Calculates the average
Counts the number of cells
Finds the maximum value
What is Excel?
A spreadsheet software developed by Microsoft
A word processing software
A database management system
A presentation software
What is a formula in Excel?
A predefined calculation
An expression that operates on values
A type of chart
A function library
What does the AVERAGE function do?
Calculates the average of values
Counts the number of cells
Finds the maximum value
Adds the values of cells
Excel will display _______________________ if the cell is not wide enough.
******
^^^^^
######
>>>>>
What is the syntax for the sum function in excel that sums a range from B1 to E1?
Sum(B1:E1)
Sum( B1:E1)=
=( B1:E1)Sum
=Sum(B1:E1)
Which of these symbols is used to do a division on a computer?
\
*
/
|
The _______ function counts the numbers in a range of cells.
SUM
COUNT
AVERAGE
COUNTIF
True or False:
The IF function tests for a true or false condition and then returns one value or another.
True
False
What is the formula to multiply two cells in Excel?
A1+B1
A1/B1
=A1*B1
A1-B1
