1. What is data analytics? Please select the most appropriate option.

Data analysis is the process of gathering, cleaning, analyzing, and mining data, interpreting results, and reporting the findings

2. What is the relevance of visuals to your presentation?

They helps to tell a story make data relatable

3. What additional attributes, besides technical skills, are employers looking for in Data Analysts?

A growth mindset and willingness to learn

4. Say you are tasked to calculate the revenues of all sales per region. After collecting the data, you discover that no regions were specified. In this case, the data would be considered _

incomplete

5. Which Excel feature helps divide a column that contains <firstname surname> into two columns: <firstname> <surname>?

Text to colums

6. Which character is the default delimiter in a .csv file?

Comma

7. Say you are trying to display a part of the data set for all products made after 2015. Which Excel command/function would be the best to use?

custom filter

8. A company ships its products at no charge to the customer if the purchase exceeds $75 and $10 otherwise. The purchase price is in cell C11. Which of the following formulas would be used to create another cell that either contains “free ship” or indicates the shipping cost?

=IF(C11>75, “free ship”, 10)

9. What is the lookup value in this formula?

B3

10. Which of the following is true about an area chart?

It contains a filled area under a series of data points

11. Which of the following is true about tree maps?

They can show a lot of data at once because of features like the color and shape of components

12. What part of an Excel sheet does Sparklines occupy?

Single Cell

13. Which of the following statements best describes the main purpose of a digital dashboard?

To display the most important or relevant information in a single plac

14. Which of the following statements about filters is correct in the context of dashboards and reports?

Filters help control and refine the data displayed in reports and dashboards.

15. Airlines automatically adjust ticket prices based on customer demand, indicates what type of analytics

Prescriptive Analytics

16. Which data professional predicts the future using data from the past?

Data scientist

17. Why is it important to understand the underlying data that was used to generate a data set in the context of reliability?

To ensure accurate and meaningful analysis

18. Why is it important to understand the information needs of your audience?

It will help you decide what and how much information is needed to help them better understand your findings

19. What additional attributes, besides technical skills, are employers looking for in Data Analysts?

A growth mindset and willingness to learn

20. After importing a text file into Excel, some columns aren’t showing all the data. How can you fix all column widths at the same time?

Select all columns and double-click one of the selected column dividers.

21. A user’s phone number is best described as what type of information?

personally Identifiable information

22. What should you do if you have data in Excel that is in all upper-case letters and want to change it so the first letter of each word is capitalized?

use the PROPER function

23. For which situation is the “text to columns” feature most appropriate?

Splitting a column containing “<firstname> <surname>” into two columns.

24. What is the difference between Bar and Column charts?

One uses vertical bars, and one uses horizontal bars

25. What is the purpose of the IFS function in Excel?

 replace nested IF functions where more than one condition is tested.

26. In this VLOOKUP function, =VLOOKUP (B3, A2:B12,2, FALSE), What does the FALSE parameter indicate in this VLOOKUP function,=VLOOKUP(B3, A2:B12,2, FALSE)?

FALSE indicates that the match found must be exact

27. If you have created a column chart, you can expand a single field of data using:

Pivot table

28. Which of the following is true of scatter charts?

They plot one set of data onto an xy axis

29. What part of an Excel sheet does Sparklines occupy?

Single cell

30. Which of the following statements best describes the main purpose of a digital dashboard?

To display the most important or relevant information in a single place

31. What is the purpose of “excluding” a feature or data point in the context of dashboards?

to focus on other areas of interest by removing specific data point

32.Airlines automatically adjust ticket prices based on customer demand, indicates what type of analytics?

prescriptive analytics

33. Which of the following is true about filled map charts?

They are best used to show information related to geographic areas

34. Which of the following formulas contains only absolute references?

=SUM($A$1:3A$10)

33. What data type is data from emails, XML, zipped files, binary executables, and TCP/IP protocols?

Semi-structured

34. For a financial information analysis, what would you suggest be considered as a preliminary step to ensure data reliability?

performing logic checks on high-level expectations

35. In the “Introduction to Data Analytics” course, you learned, “The success of your communication depends on how well others can understand and trust your insights to take further action.” What are the key elements of a successful communication?

data, narrative, and visuals

36. Why is it necessary for data analysts to be dynamic and adaptable?

to handle sudden changes in data sets

37. What does CSV stand for?

comma-separated values used for storing tabular data in plain text

38. When gathering data, you find agents keep their records and do not constantly update the information in the shared company database. In this case, the data would be considered ________________.

Unreliable

39. Ritchie Zitomer describes data analytics using what metaphor? A) Storytelling with data

40. Which data professional predicts the future using data from the past? A) Data scientist

41. In Week 3 video titled “Viewpoints: Data Preparation and Reliability”, what according to Richie Zitomer can you do to make your data more reliable? A)  Run summary statistics on individual columns to see if they make sense

42. In Week 1 video titled “Key Players in Data Ecosystem”, which of these is shared as an example of the kind of problems you can solve using Data Analysis A) Understanding how the recent marketing campaigns have impacted the sales of your products

43. In Week 1 video titled “What is Data Analytics”, Asha Barnes defines data analysis as “the use of information around you to make decisions” and shares examples of how we use data analysis to make everyday decisions. What is one of the examples she shares? A) Using the weather report to decide what to wear and what activities you can do

44.  Week 4 video titled “Overview of Communicating and Sharing Data Analysis Findings”, you learned that “the success of your communication findings depends on how well others can understand and trust your insights to take further action”. What are the key elements of a successful communication? A) Data, Narrative, Visuals

45. What is the relevance of visuals to your presentation? A) They help tell a story and make data reliable

46. In Week 5 video titled “Viewpoints: What do Employers loom for in a Data Analyst”, why does Richie Zitomer say that communication skills are vital? A) Because even brilliant analysis is worth nothing if a data analyst can’t communicate results

47. In Week 5 video titled “Viewpoints: What do Employers loom for in a Data Analyst”, Asha Barnes talks about “integrity” as a desirable trait for Data Analysts. Which of the following statements reflects what she means? A) Getting to the right answer

48. Which of the following is a grouping of buttons on the Home tab? A) Font

49. How do you select an entire column?  A) Click on the letter at the top of the column

50. Which of the following formulas contains only absolute references? A) =SUM($A$1:$A$10)

51. Which of the following formulas contains a mixed reference? A) =SUM($A1:A$10)

52. Which of the following statements best describes the output of the function =SUMIF(B1:B7,”=10″,A1:A7)  A) It sums all values in the range A1:A7 if the corresponding values in B1:B7 are equal to 10

53. When gathering data, you find agents keep their own records and do not always update the information in the shared company database. In this case the data would be considered _______ A) unreliable

54. When reviewing the data related to the sales revenue per customer, you find that customer birthdays are also included. You clean the data to remove the birthdays. You are attempting to make the data more _______?  A) relevant

55. Which of the following acts govern privacy rules around the collection of health-related information?  A) HIPAA

56. If you have data in Excel that is in all upper-case letters and you want to change it all to lowercase, what should you do?  A) Use the LOWER function

57. Say you have the text, “NEW YORK” in cell A1. Which of the following is the correct syntax to change that text to “New York”?   A) =PROPER(A1)

58. For which situation is the “text to columns” feature most appropriate to use?  A) Splitting a column containing “<firstname> <surname>” into two columns

59. Sparklines occupy which part of an Excel sheet?  A) Single column

60.  Which of the is true of sparklines?  A) They are used to show data trends

61. What does Excel do when you attempt to open a .csv file with it? A)   Open the Text Import Wizard

62.  Which character is a delimiter in a .csv file? A)   comma

1. A company ships its products at no charge to the customer if the purchase is greater than 75 and 10 otherwise. The purchase price is column C. Which of the following formulas would be used to create another column of values either containing “free shipping” or providing them a shipping cost?   =IF(C1>75, “free ship”, 10)
2. A PivotChart is different from a regular chart in what way? The source data in a PivotChart is contained in a Pivot Table
3. A user’s phone number is best described as what type of information?  Personally Identifiable Information
4. Companies are using data to uncover opportunities and differentiate themselves from competitors. What’s one way of doing this?  Mining social media posts for customer voice
5. How do you select all of the data in a worksheet?  CTRL+A
6. If you have created a column chart, you can expand a single field of data using   Pivot table
7. If you have data in Excel that is in all upper-case letters and you want to change it so the first letter of each word is capitalized, what should you do?  Use the PROPER function
8. In this HLOOKUP function, =HLOOKUP(B3,A2:B12,1) what does the number 1 indicate?  A) TRUE
9. In this VLOOKUP function, =VLOOKUP(B3,A2:B12,2,FALSE), what does the FALSE parameter indicate?   Indicates that the match found has to be exact
10. In Week 3 video titled “Viewpoints: Data Preparation and Reliability”, what according to Nikki Winston makes data gathering relatively simple? When the data resides in a central repository
11. In Week 5 video titled “Viewpoints: What do Employers loom for in a Data Analyst”, Joyce Sistrunk says she tries to hire “over-achivers”. How does she define this?  People who can think outside the box and who want to go further than assigned
12. Say you are given the task to calculate the revenues of all sales per region. After collecting the data, you discover that no regions were specified. In this case the data would be considered ________   incomplete
13. Say you are trying to create a data set of all products made after 2015. Which Excel command/function would be the best to use?  A) Custom filter
14. What is Cognos Analytics? A multifaceted data tool that contains several other tools
15.  What is one of the key steps in signing up for Cognos Analytics?  Select a data center that is geographically close to you
16. What is the LOOKUP value in this formula?
    
    =VLOOKUP(B3,A2:B12,1)   A) B12
17. What is the purpose of the IFS function in Excel?   A) It is used to replace nested IF functions where more than one condition is tested
18. What type of chart is most appropriate for a data set to show the average change in stock price each month for XYZ company over a five-year period?  Line chart
19.  When completing an online application, the user is asked their race. This type of data is best described as which of the following?   Sensitive personal information
20. Which of the following file types are not native Excel files but can be easily imported? A) .csv
21. Which of the following is true about an area chart?   It contains a filled area under a series of data points
22. Which of the following is true about Cognos Analytics?   It can create advanced data visualizations
23. Which of the following is true about filled map charts?   They are best used to show information related to geographic areas
24. Which of the following is true about histograms?  They are used to show distribution of data
25. Which of the following is true about treemaps?   They can show a lot of data at once because of features like the color and shape of components
26. Which of the following is true of scatter charts?  They combine two sets of values on the x and y axes into single points of data and then display them in clusters in the chart
27. Which statements best describe filtering your data?  A) It enables you to gain more control over which parts of your data are displayed
28. Which type of chart is used to show the relative contribution of different categories compared to the overall total?  Pie chart
29. Which type of chart shows trends in data at equal time intervals, such as days, months, quarters, or years?  Line chart
30. Why is it important to understand the information needs of your audience?  It will help you understand what, and how much information is needed to help them better understand your findings
31. What technical skills are mentioned as essential for Data Analysts? programming skills including python, R, and sql
32. Which of the following file types are supported in Excel? .csv, .xls, .txt
33. Which of the following formulas contains only relative references? =Sum(A1:A10)
34. Which statement best describes the purpose of filtering your data? it enables you to gain more control over which parts of your data are displayed
35. Which of the following is true of sparklines? they are used to show data trends
36. Which professional predicts the future using data from the past? data scientist
37. What is one of the essential steps to ensure data reliability? Running summary statistics on individual columns
38. What should you do if you have Excel data in all upper-case letters and want to change it to all lowercase? use the lower function
39. In which situation would the Flash Fill feature in Excel be useful? combining a column with last names and a column with first names into a single column
40. What benefits do dashboards offer in data analysis? dashboards provide a dynamic and user-friendly way to explore and analyze data
41. Which of the following acts governs privacy rules around collecting health-related information? hipaa
42. In this HLOOKUP function, =HLOOKUP (B3, A2:B12,1), what does the number 1 indicate? the row index number
43. What is the essential first step in the data analytics process? defining the problem
44. A relational database is designed to manage structured data primarily. Which of the following is an example of structured data? data from OLTP systems, spreadsheets, online forms, and sensors

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG