Question 2Fill in the blank: Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.1 pointfiltersborderspivot tablesitalics

Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?1 pointSortingFiltersPivot TablesSparklines

What is an Excel feature that displays only the data in column (s) according to specified criteria? *1 pointFilteringSortingFormulaPivot

Question 2Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill?1 pointData strategyHaving a technical mindsetCuriosityUnderstanding context

The following is a part of the data table generated in this exercise: 6.1.1.png The best description of the purpose of a data table among the ones below is: Group of answer choices To display values automatically calculated by Excel based on different input values To display data values that are properly formatted for visualisation To work as a depository for data that is being processed To facilitate efficient processing of data To hold data in a spreadsheet

Question 7A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet? 1 pointIt adds contextIt eliminates unnecessary detailsIt clarifies the business strategy It improves the aesthetic appeal