# Excel Basics for Data Analysis Coursera Quiz Answers

**All Weeks Excel Basics for Data Analysis Coursera Quiz Answers**

This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet.

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

##### Excel Basics for Data Analysis Course Review:

In our experience, we suggest you enroll in the Excel Basics for Data Analysis Course and gain some new skills from Professionals completely free and we assure you will be worth it.

Excel Basics for Data Analysis course is available on Coursera for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Networking Funda to get Excel Basics for Data Analysis Coursera Quiz Answers.

This Course is a part of the IBM Data Analyst Professional Certificate.

##### Conclusion:

I hope this Excel Basics for Data Analysis Coursera Quiz Answers would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Coursera Quiz Answers.

This course is intended for audiences of all experiences who are interested in learning about Data Analytics in a business context; there are no prerequisite courses.

Keep Learning!

#### Get all Course Quiz Answers of IBM Data Analyst Professional Certificate

Introduction to Data Analytics Coursera Quiz Answers

Excel Basics for Data Analysis Coursera Quiz Answers

Data Visualization and Dashboards with Excel and Cognos Quiz Answers

Python for Data Science, AI & Development Coursera Quiz Answers

Python Project for Data Science Coursera Quiz Answers

Databases and SQL for Data Science with Python Coursera Quiz Answers

Data Analysis with Python Coursera Quiz Answers

Data Visualization with Python Coursera Quiz Answers

IBM Data Analyst Capstone Project Coursera Quiz Answers