Coursera was launched in 2012 by Daphne Koller and Andrew Ng with the goal of giving life-changing learning experiences to students all around the world. In the modern day, Coursera is a worldwide online learning platform that provides anybody, anywhere with access to online courses and degrees from top institutions and corporations.

### Excel Basics for Data Analysis Week 01 Quiz Answers

#### Quiz : Graded Quiz Answers

Q1. Which of the following key Data Analyst tasks is typically done last?

- Collecting data
**Visualizing data**- Cleaning data
- Analyzing data

Q2. How are Excel worksheet cells referenced?

**Column letter first then row number**- Row number first then column letter
- Cell number first then row number
- Column number first then row letter

Q3. Which of the following Excel keyboard shortcuts could be used to find how many rows of data you have in a worksheet, assuming you have no empty rows in your data? **Select all that apply.**

- CTRL+Home
**CTRL+Down****CTRL+End**- CTRL+Up

### Excel Basics for Data Analysis Week 02 Quiz Answers

#### Quiz : Graded Quiz Answers

Q1. Which of the following is a valid way of editing existing data in a cell? **Select all that apply**

**Press F2****Select the cell you want to edit and then click in the formula bar**- Select the cell you want to edit and press Enter
- Press CTRL+N

Q2. In Excel for the web, how can you format data in cells to use a currency? **Select all that apply**

- Select “Format cells” from the Format drop-down list in the Cells group
**Select “More Number Formats” from the Number Format drop-down list in the Number group**- Select the data and click the Decrease Decimal button
**Right-click on a cell and select Number Format**

Q3. What character do you type first when you want to start writing a formula?;

- Division sign ‘/’
- Plus sign ‘+’
- Percentage sign ‘%’
**Equal sign ‘=’**

Q4. What is one of the functions found in the AutoSum drop-down list?

- General
- Accounting
**Count Numbers**- Number

Q5. In Excel Desktop, what is one of the function categories on the Formulas tab, in the Function Library group?

- Functional
- Medical
**Lookup & Reference**- Analytical

Q6. How do you make a cell reference absolute in a formula?

- Put an asterisk (*) in front of the column or behind the row identifiers in the formula
- Put a percentage sign (%) behind the column or row identifiers in the formula
**Put a dollar sign ($) in front of the column and/or row identifiers in the formula**- Put a plus sign (+) between the column and row identifiers in the formula

Q7. Formula errors in Excel are preceded by a hash symbol (#). What does it mean when multiple hash symbols exist in a cell?

**Column isn’t wide enough or it contains negative date or time values**- Formula contains unrecognized text
- Formula contains multiple errors
- Formula is missing a cell reference;

### Excel Basics for Data Analysis Week 03 Quiz Answers

#### Quiz : Graded Quiz Answers

Q1. Which data quality trait can be summarized by asking if the data is really necessary?

- Timeliness
- Reliability
**Relevance**- Completeness

Q2. Which data quality trait refers to the availability and accessibility of the data?

- Accuracy
- Completeness
**Timeliness**- Reliability

Q3. After importing a text file into Excel, you find some columns aren’t showing all data. How can you fix all column widths at the same time?

- drag a divider across
- shorten the text so it fits
**select all columns and double-click one of the selected column dividers**- click the Format button

### Excel Basics for Data Analysis Week 04 Quiz Answers

#### Quiz : Graded Quiz Answers

Q1. If you have multiple filters set, how can you clear all of them at once?

- You must clear each filter separately
- Refresh the column
- Turn sorting off
**Data tab > Sort & Filter group > Clear**

Q2. After enabling Filtering, where can you see and access the filter controls?

- Each row has filter controls
- You must manually select data for filtering
- Only selected cells have filter controls
**Each column header now has a filter control**

Q3. The IF function applies to one or two conditions, but what if you need to apply multiple conditions?;

- Use separate IF functions
- Use the IF-Then function
**Use the nesting capabilities of the IF function**- Use the IFor function

Q4. When you use nested functions, what is required for each of the functions?

- Each function must be alphabetically ordered
- =IF to begin each function
- Semi-colon between each function
**A set of parentheses for each function**

Q5. The difference between HLOOKUP, VLOOKUP, and XLOOKUP is how they look for data. How does each look for data?

**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

- HLOOKUP = by row

VLOOKUP = in all directions

XLOOKUP = by column;

**Review: **

Based on our knowledge, we urge you to enroll in this course so you can pick up new skills from specialists. It will be worthwhile, we trust.