MCAS Formulas, Functions & Calculations 2

Question 1

In Excel, what error value appears when a formula attempts to divide a number by zero?

Accepted Answer

#DIV/0!

Answer

#VALUE!

Answer

#REF!

Answer

#NULL!

Question 2

Which Excel function is used to look up a value in the first column of a table and return a value in the same row from another column?

Accepted Answer

VLOOKUP

Answer

HLOOKUP

Answer

INDEX

Answer

MATCH

Question 3

In Excel, what is the correct syntax to calculate 15% of the value in cell B2?

Accepted Answer

=B2*15%

Answer

=B2/15%

Answer

=15%+B2

Answer

=PERCENT(B2,15)

Question 4

What does the Excel function =TODAY() return?

Accepted Answer

The current date, updated automatically each time the workbook is opened or recalculated

Answer

The date and time when the workbook was first created

Answer

The date of the last time the file was saved

Answer

A static date that was entered when the function was first used

Question 5

In Excel, what does the CONCATENATE function (or the & operator) do?

Accepted Answer

Joins two or more text strings into one string

Answer

Adds two numbers together

Answer

Compares two cells and returns TRUE if they match

Answer

Converts a number to text format

Question 6

In Excel, what is the difference between COUNT and COUNTA?

Accepted Answer

COUNT counts only numeric cells; COUNTA counts all non-empty cells regardless of type

Answer

COUNT sums values; COUNTA finds averages

Answer

COUNT counts visible cells; COUNTA counts all cells including hidden rows

Answer

COUNT includes blank cells; COUNTA excludes blank cells