Coursera – STUDY GUIDEClick To Enroll in Coursera Show
More Spreadsheet basicsTest your knowledge on working with spreadsheets1. When giving a spreadsheet a title, what are some best practices to follow? Select all that apply.
Correct: Spreadsheet titles should be short, clear, and state exactly what the data in the spreadsheet is about. 2. Fill in the blank: Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.
Correct: Data analysts use borders to highlight the area around cells in order to see spreadsheet data more clearly. 3. Within a spreadsheet, data analysts use which tools to save time and effort by automating commands? Select all that apply.
Correct: Data analysts use formulas and functions to save time and effort by automating commands. Test your knowledge on using formulas in spreadsheets1. Which of the following are examples of operators used in formulas? Select all that apply.
Correct: The asterisk, hyphen, and forward slash are examples of operators used in formulas. 2. In a spreadsheet, a formula should always start with which of the following operators?
Correct: In a spreadsheet, a formula should always start with an equal sign. 3. What is the term for the set of cells that a data analyst selects to include in a formula?
Correct: The set of cells a data analyst selects to include in a formula is called the data range. 4. In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction.
Correct: In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction. 5. Which of the following functions quickly counts how many items in a range of cells meet a given criterion?
Correct The COUNTIF function quickly counts how many items in a range of cells meet a given criterion. Using functions to make calculations and analyze data is an important skill for a data analyst. Going forward, you will continue to develop this skill as you work with more complex datasets. Test your knowledge on using functions in spreadsheets1. Data analysts use which of the following functions to quickly perform calculations in a spreadsheet? Select all that apply.
Correct: AVERAGE, MIN, and SUM are functions used to quickly perform calculations in a spreadsheet. 2. What is the term for a preset command in a spreadsheet?
Correct: A preset command in a spreadsheet is called a function. 3. You are working with spreadsheet data about a cross-country relay race. Each runner’s times are located in cells H2 through H28. To find the runner with the slowest time, what is the correct function?
Correct: The function is =MAX(H2:H28). The largest numeric value corresponds to the slowest time in the race. MAX returns the largest numeric value from a range of cells. And H2:H28 is the specified range. 4. When you created a complete and thorough mock SOW, which foundational pieces of content did you include? Select all that apply.
Correct: In your mock scope-of-work, you should have included four foundational pieces of content: the deliverables, milestones, timeline, and reports. Once these items are in place, the SOW will help keep you, your team, and your project stakeholders organized and on the same page. Going forward, you can use this industry-standard tool to clarify a project’s business goals and how to accomplish them—just like a professional data analyst! Test your knowledge on Structured thinking1. What are the key elements of structured thinking? Select all that apply.
Correct: Structured thinking is the process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options. Correct: Considering inclusive sample populations, social context, and self-reported data enable fairness in data collection. 2. Fill in the blank: A scope of work is an agreed-upon _____ of the work you’re going to perform on a project.
Correct: A scope of work is an agreed-upon outline of the work you’re going to perform on a project. 3. What are some strategies to ensure your data is accurate and fair? Select all that apply.
Correct: To ensure your data is accurate and fair, make sure you start with an accurate representation of the population in the sample; collect the data in an objective way; and ask questions about the data. *Weekly Challenge 3*1. Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=).
Correct: In spreadsheets, data analysts begin formulas with an equal sign (=). 2. What do data analysts use to label the type of data contained in each column in a spreadsheet?
Correct: To label the type of data contained in each column in a spreadsheet, data analysts use attributes. 3. To determine an organization’s annual budget, a data analyst might use a slideshow.
Correct: To determine an organization’s annual budget, a data analyst might use a spreadsheet. 4. Which of the following statements describes a key difference between formulas and functions?
Correct: Formulas are written by the user, and functions are already defined. 5. In the function =MAX(A1:A12), what does A1:A12 represent?
Correct: In the function, A1:A12 represents the range. A range is a collection of two or more cells. 6. What is the correct spreadsheet formula for multiplying cell D5 times cell D7?
Correct: The correct spreadsheet formula for multiplying cell D5 times cell D7 is =D5*D7. The asterisk (*) is the operator for multiplication. 7. Fill in the blank: By negatively influencing data collection, ____ can have a detrimental effect on analysis.
Correct: By negatively influencing data collection, bias can have a detrimental effect on analysis. 8. Which of the following are ways that data analysts can add context to their data? Select all that apply.
Correct: To add context to their data, data analysts ask questions about the data, consider where it came from, and use descriptive column headers. Which of the following tasks can data analyst Do using both spreadsheets and SQL?Which of the following tasks can data analysts do using both spreadsheets and SQL? Select all that apply. Correct. Analysts can use SQL and spreadsheets to perform arithmetic, use formulas, and join data.
In which of the following situations would a data analyst use spreadsheets instead of SQL?Correct. An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset.
Which phase of data analysis would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions 1 point Act analyze process?The analyze step involves using data analytics tools such as spreadsheets and query languages to transform data in order to draw conclusions and make informed decisions.
What are the first steps a data analyst takes when working with data in a spreadsheet?Step 1: Get familiar with data analysis. Explanation. ... . Step 2: Start with Excel, with an eye on Tableau. Explanation. ... . Step 3: Start working with pivot tables. ... . Step 4: Participate in Data Visualization Competitions. ... . Step 5: Run analysis on non-profit data sets.. |