Table of Contents
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
Get All Course Quiz Answers of Entrepreneurship Specialization
Entrepreneurship 1: Developing the Opportunity Quiz Answers
Entrepreneurship 2: Launching your Start-Up Quiz Answers
Entrepreneurship 3: Growth Strategies Coursera Quiz Answers
Entrepreneurship 4: Financing and Profitability Quiz Answers
