Graded Quiz-5 | Quizerry

Graded Quiz >> Excel Basics for Data Analysis

Data tab > Sort & Filter group > Clear ✓

Turn sorting off

You must clear each filter separately

Refresh the column

Correct: If you have multiple filters set, and you want to clear all of them at once, then on the Data tab, in the Sort & Filter group, press Clear

Each column header now has a filter control ✓

Only selected cells have filter controls

You must manually select data for filtering

Each row has filter controls

Correct: After you enable filtering, each column header will have a filter control, and this is where you can see and access the filter controls

Use separate IF functions

Use the IF-Then function

Use the nesting capabilities of the IF function ✓

Use the IFor function

Correct: if you need to apply multiple conditions, you can use the nesting capabilities of the IF function

Semi-colon between each function

Each function must be alphabetically ordered

A set of parentheses for each function ✓

=IF to begin each function

Correct: When you use nested functions, a set of parantheses are required for each of the functions

HLOOKUP = by row

VLOOKUP = in all directions

XLOOKUP = by column

HLOOKUP = by row

VLOOKUP = by column

XLOOKUP = all directions

HLOOKUP = by column

VLOOKUP = by row

XLOOKUP = in all directions

HLOOKUP = in all directions

VLOOKUP = by column

XLOOKUP = by row

Correct: This is how each function looks for data

Graded Quiz >> Excel Basics for Data Analysis