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

Leave a Reply