FBA-Lab6-Working with Functions MCQs

(Tab to RIGHT OPTION to see the answer.)

Which function calculates geometric mean?

AVERAGE()

HARMEAN()

GEOMEAN()

MEDIAN()

Correct! Wrong!

Which of the following is an example of a function?

B2*C2

Correct! Wrong!

What is the purpose of GEOMEAN in business analytics?

Add numbers

Find maximum

Calculate growth rate

Count values

Correct! Wrong!

Which formula calculates total frames sold?

=MAX(B2:B31)

=SUM(B2:B31)

=AVERAGE(B2:B31)

=COUNT(B2:B31)

Correct! Wrong!

Which function calculates harmonic mean?

AVERAGE()

COUNT()

HARMEAN()

GEOMEAN()

Correct! Wrong!

Which function counts the number of days in a dataset?

COUNT()

MAX()

SUM()

AVERAGE()

Correct! Wrong!

What is a function in Excel?

A formatting option

A chart tool

A worksheet name

A predefined formula

Correct! Wrong!

Which function is used to find average daily sales?

COUNT()

AVERAGE()

MAX()

SUM()

Correct! Wrong!

Which of the following is a key difference between formula and function?

Formula is predefined

Both are same

Function is predefined

Function cannot calculate

Correct! Wrong!

Which measure is best for average speed?

Geometric Mean

Median

Harmonic Mean

Correct! Wrong!

Which function calculates the mean of values?

MIN()

MAX()

SUM()

AVERAGE()

Correct! Wrong!

Which function identifies the lowest number of units sold?

MAX()

SUM()

COUNT()

MIN()

Correct! Wrong!

Which function counts numeric values in a range?

MIN()

SUM()

AVERAGE()

COUNT()

Correct! Wrong!

Which formula represents midrange correctly?

(MAX + MIN) / 2

MIN / MAX

MAX + MIN

MAX / MIN

Correct! Wrong!

Which function returns the largest value?

MIN()

AVERAGE()

COUNT()

MAX()

Correct! Wrong!

What is the correct syntax of a function?

FUNCTION_NAME(argument1, argument2)

FUNCTION_NAME argument

FUNCTION_NAME=argument

=FUNCTION_NAME argument

Correct! Wrong!

Which AutoSum function calculates total revenue?

SUM()

COUNT()

MAX()

MIN()

Correct! Wrong!

Which function is used to add a range of numbers?

AVERAGE()

COUNT()

MAX()

SUM()

Correct! Wrong!

What does AutoSum provide quick access to?

Only SUM

Five core functions

Formatting tools

Charts

Correct! Wrong!

Which function finds the middle value in a dataset?

MEDIAN()

MAX()

AVERAGE()

COUNT()

Correct! Wrong!

Which function returns the smallest value?

MIN()

MAX()

COUNT()

SUM()

Correct! Wrong!

Which of the following is NOT part of AutoSum functions?

IF()

COUNT()

Correct! Wrong!

FBA-Lab6-Working with Functions MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements