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