Learning Data Analytics- Questions with
Solutions| Latest Update
Which is the following is not true of pasting charts into Microsoft Powerpoint?
a. It gives you a smart tag to adjust the options.
b. It allows you to modify how the chart interacts with the data.
c. It allows you to update the data.
d. It pastes as an image. D
You can easily select data in an Excel data sheet by using the shortcut Ctrl + ____.
a. CTRL + C
b. Ctrl + A
c. CTRL + V
d. CTRL + X B
What is likely the most common type of delimiter you will find in data when you want to split it?
a. ~
b. /
c. ,
d. fixed width C
, Data analysis is the process of ____ data for business decision-making.
a. cleaning
b. transforming
c. inspecting
d. all of these answers D
What is a useful strategy to use when you are missing data?
a. concatenate (tie fields together to create a single field)
b. use IF or and/or case statements
c. use basic math functions like addition, subtraction, division, and multiplication
d. all of these answers D
Finding existing data is critical to an analyst. What is not a great way to accomplish this?
a. Determine how the report is built today
b. Learn where the report is generated and how
c. Start completely from scratch
d. Work backwards from existing data or reports C
When should you use a pivot in your data?
a. when you are learning your data
b. when you are trying to determine the best ways to display your data
Solutions| Latest Update
Which is the following is not true of pasting charts into Microsoft Powerpoint?
a. It gives you a smart tag to adjust the options.
b. It allows you to modify how the chart interacts with the data.
c. It allows you to update the data.
d. It pastes as an image. D
You can easily select data in an Excel data sheet by using the shortcut Ctrl + ____.
a. CTRL + C
b. Ctrl + A
c. CTRL + V
d. CTRL + X B
What is likely the most common type of delimiter you will find in data when you want to split it?
a. ~
b. /
c. ,
d. fixed width C
, Data analysis is the process of ____ data for business decision-making.
a. cleaning
b. transforming
c. inspecting
d. all of these answers D
What is a useful strategy to use when you are missing data?
a. concatenate (tie fields together to create a single field)
b. use IF or and/or case statements
c. use basic math functions like addition, subtraction, division, and multiplication
d. all of these answers D
Finding existing data is critical to an analyst. What is not a great way to accomplish this?
a. Determine how the report is built today
b. Learn where the report is generated and how
c. Start completely from scratch
d. Work backwards from existing data or reports C
When should you use a pivot in your data?
a. when you are learning your data
b. when you are trying to determine the best ways to display your data
