Learning Data Analytics – LinkedIn Questions and Answers

Learning Data Analytics – LinkedIn Questions
and Answers

When can data truth can be incorrect?



when not all data is entered

when dta updates are not complete

when historical data is not represented properly

all of these answers all



When it exists, a data dictionary can give you a document of the _____.



fields

relationships

tables

all of these answers all



When should you use a pivot in your data?



when you are learning your data

when you are trying to determine the best ways to display your data

when you want to answer basics questions about your data

all of these answers all

, When working with data sets that are built for us, they may often have _____ data. You can use
Remove Duplicates to remove these this data.



redundant

calculated

duplicate

highlighted duplicate



Which is the following is not true of pasting charts into Microsoft Powerpoint?

It gives you a smart tag to adjust the options.

It allows you to modify how the chart interacts with the data.

It allows you to update the data.

It pastes as an image. It pastes as an image.



Which shortcut allows you to create a basic chart visual in Microsoft Excel?



F12

F3

F4

F11 f11



You can easily select data in an Excel data sheet by using the shortcut Ctrl + ____.