WorksheetsMS Excel Functions Quiz
Total questions: 15
Worksheet time: 8mins
What function adds all the numbers in a range of cells?
SUM
DIFFERENCE
PRODUCT
QUOTIENT
How can you calculate the difference between two numbers in Excel?
Using the DIFFERENCE function
Using subtraction (-)
Using addition (+)
Using the AVERAGE function
What function multiplies all the numbers in a range of cells?
SUM
PRODUCT
AVERAGE
COUNT
What function returns only the integer portion of a division?
QUOTIENT
ROUND
AVERAGE
MAX
What function calculates the average of a range of numbers?
SUM
AVERAGE
MAX
MIN
What function returns the largest number in a range of cells?
MAX
MIN
COUNT
NOW
What function returns the smallest number in a range of cells?
MAX
MIN
AVERAGE
SUM
What function performs a logical test and returns one value for TRUE and another for FALSE?
IF
SUM
AVERAGE
COUNT
What function counts the number of numeric values in a range of cells?
COUNT
SUM
AVERAGE
MAX
What function returns the current date and time?
NOW
TODAY
AVERAGE
SUM
What function returns the current date without the time?
NOW
TODAY
AVERAGE
SUM
What function rounds a number to a specified number of digits?
ROUND
ROUNDUP
ROUNDDOWN
AVERAGE
What function rounds a number up, away from zero?
ROUNDUP
ROUND
ROUNDDOWN
AVERAGE
What function rounds a number down, toward zero?
ROUND
ROUNDUP
ROUNDDOWN
AVERAGE
Which software is commonly used for creating spreadsheets, performing data analysis, and generating charts?
MS Word
MS PowerPoint
MS Excel
MS Access
