MOS Excel: Formulas and Functions 4

Question 1

Which function returns a value from a table based on both row and column positions?

Accepted Answer

INDEX

Answer

INDEX returns a value from a table by specifying a row number and column number within the range.

Question 2

What does =MOD(17, 5) return?

Accepted Answer

2

Answer

MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2, so MOD(17,5) = 2.

Question 3

Which function counts only the cells in a range that contain numbers?

Accepted Answer

COUNT

Answer

COUNT counts only numeric values, while COUNTA counts all non-empty cells regardless of data type.

Question 4

You want to look up a value in column A and return a corresponding value from column C without using VLOOKUP. Which combination works best?

Accepted Answer

INDEX + MATCH

Answer

INDEX(range, MATCH(lookup_value, lookup_column, 0)) is a flexible alternative to VLOOKUP that can look left and isn't limited to the first column.

Question 5

What does the TODAY() function return?

Accepted Answer

The current date only

Answer

TODAY() returns only the current date as a serial number formatted as a date, with no time component.

MOS - Microsoft Office Specialist Certification Practice Test