excel basics for data analysis coursera week 4 quiz answers
Practice Quiz
1. Which of the following are valid sorting orders you can choose when adding sorting levels to your data? Select all that apply.
- Youngest to OldestÂ
- Oldest to Newest
- Smallest to Largest
- Z to A
2. After filtering a column and getting the results, in which two ways can you return to showing all the data in a column? Select two answers.
- refresh the columnÂ
- clear the filter
- refresh the worksheet
- turn filtering off
3. What do custom filters provide that AutoFilters don't?
- associate a formula with the filter controlÂ
- display more dataÂ
- set multiple filters at the same time
- filter a column to see only above or below a certain value
4. According to the video 'Useful Functions for Data Analysis', what is one of the most common functions a Data Analyst might use?
- Countif
- Int
- RandbetweenÂ
- Average
5. What does VLOOKUP stand for?
- Volume LookupÂ
- Variable Lookup
- Virtual LookupÂ
- Vertical Lookup
Graded Quiz
6. If you have multiple filters set, how can you clear all of them at once?
- You must clear each filter separately
- Turn sorting off
- Data tab > Sort & Filter group > Clear
- Refresh the column
7. After enabling Filtering, where can you see and access the filter controls?
- Only selected cells have filter controls
- Each column header now has a filter control
- You must manually select data for filtering
- Each row has filter controls
8. The IF function applies to one or two conditions, but what if you need to apply multiple conditions?
- Use separate IF functions
- Use the nesting capabilities of the IF function
- Use the IF-Then function
- Use the IFor function
Shuffle Q/A 1
9. When you use nested functions, what is required for each of the functions?
- =IF to begin each function
- A set of parentheses for each function
- Semi-colon between each function
- Each function must be alphabetically ordered
10. The difference between HLOOKUP, VLOOKUP, and XLOOKUP is how they look for data. How does each look for data?
HLOOKUP = by row
VLOOKUP = in all directions
XLOOKUP = by column
HLOOKUP = by column
VLOOKUP = by row
XLOOKUP = in all directions
HLOOKUP = by row
VLOOKUP = by column
XLOOKUP = all directions
HLOOKUP = in all directions
VLOOKUP = by column
XLOOKUP = by row