Excel Basics for Data Analysis | Coursera Quiz Answers

Excel Basics for Data Analysis | Coursera

Enroll Course

---

Graded Quiz 1

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

• Collecting data
• Visualizing data
• Analyzing data
• Cleaning data

2. How are Excel worksheet cells referenced?

• Cell number first then row number
• Row number first then column letter
• Column letter first then row number
• Column number first then row letter

3. 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+End
• CTRL+Home
• CTRL+Up
• CTRL+Down

Graded Quiz 2

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

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

2. 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
• Right-click on a cell and select Number Format
• Select "More Number Formats" from the Number Format drop-down list in the Number group
• Select the data and click the Decrease Decimal button

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

• Percentage sign '%'
• Division sign '/'
• Plus sign '+'
• Equal sign '='

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

• Count Numbers
• Accounting
• General
• Number

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

• Medical
• Analytical
• Lookup & Reference
• Functional

6. 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 plus sign (+) between the column and row identifiers in the formula
• Put a dollar sign ($) in front of the column and/or row identifiers in the formula

7. 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 multiple errors
• Formula is missing a cell reference
• Formula contains unrecognized text

Graded Quiz 3

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

• Reliability
• Completeness
• Timeliness
• Relevance

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

• Completeness
• Timeliness
• Reliability
• Accuracy

3. 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?

• Shorten the text so it fits
• Drag a divider across
• Select all columns and double-click one of the selected column dividers
• Click the Format button

Graded Quiz 4

1. What is one of the issues that empty rows cause in your spreadsheet?

• Formula errors
• Indexing function error
• Data will be hidden
• Spell-check will fail

2. How can you remove all empty rows at the same time in your imported spreadsheet?

• Use Remove Duplicates to remove empty rows
• Select all rows and then filter for Blanks, select these and then delete
• Use Search & Replace to look for empty rows and delete
• You must delete the empty rows one at a time

3. There are two methods to locate and remove duplicated rows in Excel, what is the easiest way?

• Use the HLOOKUP function
• Select a column and choose Conditional Formatting > Highlight Cells Rules > Duplicate Values
• Search for the first character in rows
• Select all data and click the Remove Duplicates button

4. What does the PROPER function do?

• Repairs a REF error
• Changes text to sentence case
• Converts upper case text to lower case
• Converts lower case text to upper case

5. Why do you need to use the Paste Values option when you paste contents from a helper row to the original row?

• Validates the copied function
• Makes sure formulas aren’t also copied
• Keeps cell formatting the same
• Ensures consistency

6. What is one of the ways to apply new data formats to the rest of a column?

• Text Import wizard
• Format Painter tool
• Format button
• Paste Special tool

7. What tools or features can we use to split a single column with two names in, into two separate columns with a name in each? Select all that apply

• Format Painter tool
• Flash Fill feature
• Paste Special
• Text to Columns feature

Graded Quiz 5

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

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

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

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

3. 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 IFor function
• Use the nesting capabilities of the IF function

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

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

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

HLOOKUP = by row
VLOOKUP = by column
XLOOKUP = all directions

HLOOKUP = by column
VLOOKUP = by row
XLOOKUP = in all directions

HLOOKUP = in all directions
VLOOKUP = by column
XLOOKUP = by row

HLOOKUP = by row
VLOOKUP = in all directions
XLOOKUP = by column

Graded Quiz 6

1. According to the video checklist, what should you remove before making a Pivot Table?

• Blank rows, columns, and cells
• Row labels
• Date fields
• Value fields

2. What is automatically added after formatting data as a table?

• Data bars
• Column headers
• Alternate light/dark rows
• Filter drop-downs at top of columns

3. After creating a pivot table and selecting it, what pane appears to the right of the pivot table?

• The PivotTable Fields pane
• The PivotTable Metadata pane
• The PivotTable Properties pane
• Additional pivot table examples

4. What do Timelines provide in pivot tables?

• Previews views of different filters
• Sets the pivot table to an earlier view
• Lets you filter specifically on date-related data
• Provides details of all actions performed during a given period

5. What is one way to remove a slicer or timeline?

• Press CTRL+Z
• Right-click it and select cut
• Remove all filters from pivot table
• Create a new one

Related Articles