FBA-Lab6-Working with Functions MCQs

(Tab to RIGHT OPTION to see the answer.)

Which function calculates the mean of values?

MIN()

MAX()

AVERAGE()

SUM()

Correct! Wrong!

Which formula calculates total frames sold?

=MAX(B2:B31)

=COUNT(B2:B31)

=AVERAGE(B2:B31)

=SUM(B2:B31)

Correct! Wrong!

Which function returns the largest value?

COUNT()

MIN()

AVERAGE()

MAX()

Correct! Wrong!

Which of the following is NOT part of AutoSum functions?

IF()

COUNT()

Correct! Wrong!

Which function calculates geometric mean?

AVERAGE()

GEOMEAN()

MEDIAN()

HARMEAN()

Correct! Wrong!

Which function counts the number of days in a dataset?

MAX()

SUM()

COUNT()

AVERAGE()

Correct! Wrong!

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

Function cannot calculate

Both are same

Formula is predefined

Function is predefined

Correct! Wrong!

Which function returns the smallest value?

COUNT()

MIN()

SUM()

MAX()

Correct! Wrong!

Which function identifies the lowest number of units sold?

COUNT()

MIN()

MAX()

SUM()

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!

What is a function in Excel?

A predefined formula

A chart tool

A formatting option

A worksheet name

Correct! Wrong!

What is the purpose of GEOMEAN in business analytics?

Add numbers

Count values

Find maximum

Calculate growth rate

Correct! Wrong!

Which formula represents midrange correctly?

MIN / MAX

(MAX + MIN) / 2

MAX / MIN

MAX + MIN

Correct! Wrong!

Which measure is best for average speed?

Geometric Mean

Harmonic Mean

Median

Correct! Wrong!

Which function counts numeric values in a range?

AVERAGE()

SUM()

MIN()

COUNT()

Correct! Wrong!

Which function calculates harmonic mean?

COUNT()

GEOMEAN()

HARMEAN()

AVERAGE()

Correct! Wrong!

Which function is used to find average daily sales?

COUNT()

MAX()

AVERAGE()

SUM()

Correct! Wrong!

Which function finds the middle value in a dataset?

MEDIAN()

AVERAGE()

COUNT()

MAX()

Correct! Wrong!

Which function is used to add a range of numbers?

COUNT()

AVERAGE()

SUM()

MAX()

Correct! Wrong!

Which AutoSum function calculates total revenue?

COUNT()

SUM()

MAX()

MIN()

Correct! Wrong!

What does AutoSum provide quick access to?

Charts

Five core functions

Formatting tools

Only SUM

Correct! Wrong!

Which of the following is an example of a function?

B2*C2

Correct! Wrong!

FBA-Lab6-Working with Functions MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements