Excel Basics for Data Analysis Coursera Quiz Answers

by

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.

Join Now

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.

 

Leave a Comment