DataAnalyticsFinalExamAnswers

.pdf

School

Conestoga College *

*We aren’t endorsed by this school

Course

1870

Subject

Electrical Engineering

Date

Feb 20, 2024

Type

pdf

Pages

19

Uploaded by SuperHumanCoyotePerson1024

Report
Question 1 (1 point) * Saved A slicer is a filtering object that contains buttons for each unique value from the field or category of the table that it is associated with. (@) True () False Question 2 (1 point) Saved Slicers are an easy way to filter your data table, yet still see (visually) all of the possible filtering categories available regardless of which buttons/filters have been applied using the slicer dashboards. (@) True () False
Question 4 (1 point) Saved You are trying to delete a worksheet and the Delete option is not available as shown in the image below. The most likely cause of this is: —J Yiew Code B Protect Sheet Select All Sheets S coemaman @ Worksheet protection has been enabled O The file needs to be saved before the worksheet can be deleted. Worksheets can't be deleted until the contents of the cells have been deleted first. O Workbook protection has been enabled Question 5 (1 point) Saved You are trying to move a worksheet and the Move of Copy option is not available as shown in the image below. The most likely cause of this is: : Yiew Code B Protect Sheet Select All Sheets S ceemamn O The file needs to be saved first @ Workbook protection has been enabled O Worksheets can never be moved after they have been created
Question 6 (1 point) Saved You are trying to rename a worksheet and the Rename option is not available as shown in the image below. The most likely cause of this is: Select All Sheets SR O The file needs to be saved first @ Workbook protection has been enabled O Worksheets can never be renamed Question 7 (1 point) * Saved Filtering data permanently removes (deletes) the rows whose values do not match the search criteria. () True (@) False Previous Page m Page 7 of 32 Question 8 (1 point) Saved When using a structured table with filter buttons in the header row, you can have more than one filter applied at a time. (@) True () False Previous Page Next Page Page 8 of 32
Question 9 (1 point) Saved Your boss has given you a set of data and asked you to use it to make an x-y scatter chart. Your boss is most likely trying to show: O The change in a continuous variable over time O The relative proportion of different components @ The relationship that a change in one variable has on a second variable O The difference in performance between two or more different variables Previous Page Next Page Page 9 of 32 Question 10 (1 point) Saved Your boss has given you a set of data and asked you to use it to make a column chart. Your boss is most likely trying to show: Q The relationship that a change in one variable has on a second variable Q The change in a continuous variable over time @ The difference in performance between two or more different variables O The relative proportion of different components Previous Page Page 10 of 32 Question 11 (1 point) Saved Your boss has given you a set of data and asked you to use it to make a line chart. Your boss is most likely trying to show: O The difference in performance between two or more different variables @ The change in a continuous variable over time O The relationship that a change in one variable has on a second variable O The relative proportion of different components Previous Page Next Page Page 11 of 32
Question 12 (1 point) Saved Your boss has given you a set of data and asked you to use it to make a pie chart. Your boss is most likely trying to show: @ The relative proportion of different components O The relationship that a change in one variable has on a second variable Q The difference in performance between two or more different variables Q The change in a continuous variable over time Previous Page Page 12 of 32 Question 13 (1 point) Saved Excel provides a number of horizontal alignment options (left, right, center). When entering a number into an empty cell on a new worksheet the default alignment is: Q Left alignment Q center Center alignment ight @ Right alignment " O User specified after entry Previous Page Page 13 of 32
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help