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

#DIV/0! is the error Excel displays whenever a formula tries to divide by zero or an empty cell.

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

VLOOKUP searches the first column of a range vertically and returns a value from a specified column in the same row.

Question 3

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

Accepted Answer

=B2*15%

Answer

Multiplying the cell value by 15% (which Excel treats as 0.15) calculates the percentage of that value.

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

=TODAY() is a volatile function that returns the current system date and updates every time the workbook recalculates.

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

CONCATENATE and the & operator both join (combine) multiple text strings into a single combined text string.

MCAS - Microsoft Certified Application Specialist Practice Test