# Excel Basics for Data Analysis Coursera Quiz Answers

### Excel Basics for Data Analysis Week 01 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

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

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

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

##### Get All Course Quiz Answers of Entrepreneurship Specialization

Entrepreneurship 1: Developing the Opportunity Quiz Answers