Excel Expert 2019 - Module 2 Review

In a VLOOKUP or a HLOOKUP function, what should you enter in the fourth segment of the formula to specify that you want an approximate match return?

"True" or "1"

WEEKDAY function - Meaning of Numbers

1 --> Sunday 2 --> Monday 3 --> Tuesday 4 --> Wednesday 5 --> Thursday 6 --> Friday 7 --> Saturday

Which of the following tabs are available in Excel Options?

Advanced, Data, Ease of Access

By default, how are formulas set to update?

Automatically

To break a link from one workbook to another, select the Data tab and then select Edit Links. Select the link to break and then select ____________________.

Break Link

To work out how many entries in a list are equal to three specific conditions, you can use the ____________________ function.

COUNTIFS

What is the keyboard shortcut to enter the current time into a cell?

Ctrl + Shift + semicolon

When referencing a named range in another workbook, what keyboard shortcut can you use to open the Paste Name dialog box?

F3

To return an exact match by using the MATCH function, what value would you use for the match_type?

FALSE, 0

Which of the following Excel Options tabs can you use to change the default font type and font size?

General

You can use an IFS function instead of which of the following functions?

IF, Nested IF, CountIF, AND

Which of the following categories does the IFS function belong to?

Logical

The HLOOKUP function belongs to which category of functions?

Lookup/Reference

To which category of functions does MATCH belong?

Lookup/Reference

Which of the following functions does not exist in Excel 2019?

MAXIF (there's only a MAXIFS function)

Which of the following categories does the SUMIFS function belong to?

Math/Trig

If the content of A2 is 100 and the contents of B2 is 200, what result would you get using the formula =IF(AND(A2>50,B2>200),"Excellent","Needs improvement")

Needs improvement

Which of the following functions do NOT belong to the Lookup & Reference function category?

REPLACE, SWITCH

Which of the following options can you use to set calculation options?

Select File, select Options, and then select Formulas.

When you reference another workbook in a formula, what type of brackets enclose the source workbook within the formula?

Square brackets [sales .xlsx]

Which of the following categories does the AVERAGEIF function belong to?

Statistical

When the value you are searching for is not in the first column of a table array, you can use the ____________________ functions.

VLOOKUP, or Index/Match

What does the V in VLOOKUP mean?

Vertical

If you want to calculate the next three working days from a specific date, which of the following functions would you use?

WORKDAY

When you reference another workbook in a formula, what symbol is after the source worksheet name within the formula?

exclamation mark (Sheet2! A1)

VLOOKUP function checks the ____________________ column in a table array to match it with the lookup value.

first / leftmost

VLOOKUP will return a value from a column index number, and HLOOKUP will return a ____________________ index number.

row