FBA-Lab6-Working with Functions MCQs

(Tab to RIGHT OPTION to see the answer.)

Which of the following is an example of a function?

B2*C2

Correct! Wrong!

What does AutoSum provide quick access to?

Five core functions

Formatting tools

Only SUM

Charts

Correct! Wrong!

What is the correct syntax of a function?

FUNCTION_NAME=argument

FUNCTION_NAME argument

=FUNCTION_NAME argument

FUNCTION_NAME(argument1, argument2)

Correct! Wrong!

What is a function in Excel?

A chart tool

A worksheet name

A formatting option

A predefined formula

Correct! Wrong!

Which function is used to add a range of numbers?

SUM()

AVERAGE()

MAX()

COUNT()

Correct! Wrong!

Which function calculates the mean of values?

MIN()

AVERAGE()

MAX()

SUM()

Correct! Wrong!

Which function calculates harmonic mean?

GEOMEAN()

AVERAGE()

HARMEAN()

COUNT()

Correct! Wrong!

Which function returns the largest value?

COUNT()

AVERAGE()

MIN()

MAX()

Correct! Wrong!

Which function identifies the lowest number of units sold?

MIN()

MAX()

SUM()

COUNT()

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()

COUNT()

SUM()

MIN()

Correct! Wrong!

Which formula calculates total frames sold?

=COUNT(B2:B31)

=SUM(B2:B31)

=MAX(B2:B31)

=AVERAGE(B2:B31)

Correct! Wrong!

Which function counts the number of days in a dataset?

AVERAGE()

SUM()

MAX()

COUNT()

Correct! Wrong!

Which function finds the middle value in a dataset?

MEDIAN()

COUNT()

AVERAGE()

MAX()

Correct! Wrong!

Which of the following is NOT part of AutoSum functions?

IF()

COUNT()

Correct! Wrong!

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

Formula is predefined

Both are same

Function cannot calculate

Function is predefined

Correct! Wrong!

Which function calculates geometric mean?

MEDIAN()

AVERAGE()

HARMEAN()

GEOMEAN()

Correct! Wrong!

What is the purpose of GEOMEAN in business analytics?

Count values

Calculate growth rate

Add numbers

Find maximum

Correct! Wrong!

Which AutoSum function calculates total revenue?

MIN()

MAX()

COUNT()

SUM()

Correct! Wrong!

Which function is used to find average daily sales?

AVERAGE()

SUM()

COUNT()

MAX()

Correct! Wrong!

Which function returns the smallest value?

COUNT()

MIN()

SUM()

MAX()

Correct! Wrong!

FBA-Lab6-Working with Functions MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements