DataAnalyticsFinalExamAnswers

pdf

School

Conestoga College *

*We aren’t endorsed by this school

Course

1870

Subject

Electrical Engineering

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by SuperHumanCoyotePerson1024

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

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

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

Question 14 (1 point) Saved Excel provides a number of horizontal alighnment options (left, right, center). When using the merge tool on a group of cells, the default alignment is: O Left alignment @ center Center alignment igh O Right alignment nent Q User specified after entry Previous Page Next Page Page 14 of 32 Question 15 (1 point) Saved Excel provides a number of horizontal alighment options (left, right, center). When entering a date into an empty cell on a new worksheet the default alignment is: O Left alignment O center Center alignment igh @ Right alignment night O User specified after entry Previous Page m Page 15 of 32

Question 16 (1 point) Saved Excel provides a number of horizontal alignment options (left, right, center). When entering text into an empty cell on a new worksheet the default alignment is: @ Left alignment O center Center alignment igh Q Right alignment gt Q User specified after entry Previous Page ~Next Page Page 16 of 32 Question 17 (1 point) Saved You are doing analysis on a set of data from a solar energy project and you have entered the query shown in the table below. A ‘ B C ‘ D E ‘ F | Max. PV Max. PV Min. battery Max. battery 1 |Date Yield(Wh) power(W) voltage(V) voltage(V) voltage(V) 2 |>2021-07-14 10 3 [<2021-07-21 12.8 4_ If the Advanced Filter Tool is used, the data that is returned will be: Records between July 14 and July 21 where the Yield was 10WH and the Min. battery voltage was 12.8V Records where either the date was after July 14 and the Min battery voltage was 12.8V OR the date was before July 21 and the Yield was 10Wh Records where either the date was after July 14th OR the date was before July 21st and the Yield was 10Wh and the Min battery voltage was 12.8V. Records where either the date was after July 14 and the Yield was 10Wh OR the date was before July 21st and the Min battery voltage was 12.8V Previous Page Next Page Page 17 of 32

Question 18 (1 point) Saved Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,1,FALSE) return? DAY v X v =VLOOKUP(A25,A2:820,1,FALSE) C D E F 1 - - — 2 |AC220 16.95 [FaLse) 3 |ACS50 24.95 4 |AC780 37.95 5 [AC930 41.95 6 (AT100 0.45 7 |aT110 0.90 8 |AT120 1.50 9 |AT130 2.00 10 |AT140 2.25 11 ATISN 2 45 The number for the product in column A (or #N/A if the exact product number can't be found). The number for the product found in column A if the exact product number corresponding to A25 can be found, or the product number for the closest matching product number found if the exact product number can't be found. The price for the product found in column A (or #N/A if the exact product number can't be found). The price for the product found in column A (or the closest product if the exact product number can't be found).

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

Question 19 (1 point) Saved Three important elements that all charts with horizontal and vertical axes should have are: () Trendline D Data Table () Vertical axis title Vertical gridlines Horizontal axis title Title describing the entire chart Previous Page m Page 19 of 32 Question 20 (1 point) Saved Three important elements that all charts with horizontal and vertical axes should have are: (] Data labels x- axis title y- axis title D Legend Descriptive Chart Title D Horizontal gridlines Previous Page Page 20 of 32

Question 21 (1 point) Saved Three important elements that all charts with horizontal and vertical axes should have are: O Legend Descriptive Chart Title Horizontal axis title D Axis labels on the horizontal axis Vertical axis title () Trendline Brevious Page m Page 21 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

Question 23 (2 points) Saved | | Sert | | gadt ¥ Debete Level ‘ Colunn 'R Sart oy v Then by > o rfi Lopy Level v Cell Valges Qptions.. My dala eaders Crder | v o] oo Your task is to sort a list of customer order data. You want to sort the data so that it is sorted first by Part Number (an alphanumeric field - e.g PN1000J5648) so that [PN9...] precedes [PN8 .... ] and then by Quantity so that the smallest number is at the top of the list. Use the matching options below to show how you would apply the advanced filter tool. Field D Field B Field A Field C Part Number Quantity AtoZ Smallest to Largest ZtoA Largest to Smallest Oldest to Newest Newest to Oldest Page 23 of 32

Question 24 (1 point) Saved The following screenshot shows an MS Excel dialog box: Fualuate Formula ? X Relerence: Cyaluation Sheet2:$C$5 - |R3*D5/100" Amount) i : B C D oh | [ Swon Gose Which answer best describes the action produced by the button identified with the red letter B? O Calculate the results obtained from the full expression O Calculate the results obtained from B5°D5 O Calculate the results obtained from B5 (e) Display the source data from B5 O Display the source data from B5°D5 O Display the source data from the cell named "Amount” S Page 24 of 32 Question 25 (1 point) Saved When using Scenario Manager to create a scenario, it is possible to use a setting to prevent changes. (@) True () False Previous Page Page 25 of 32 Question 26 (1 point) Saved When using Scenario Manager, naming cells before starting makes scenario management easier. @ True Q False Previous Page m Page 26 of 32

Question 27 (1 point) Saved You are creating a bar chart to show quality improvements and you want to find the total dollars saved by project category. The best calculation to select from the value field settings list is: @ Sum O Count O Average Q Max Previous Page Page 27 of 32 Question 28 (1 point) Saved Select the answer which best describes a Dashboard. Q A dashboard is another name for a Workbook. A dashboard is a collection of Charts that represent all the data in your workbook. A dashboard is a visual representation of your data that provides a concise view for monitoring. Q A dashboard is a collection of images that provide a cover page for your report. Q A dashboard is another name for a named Data Table. Previous Page m Page 28 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

Question 29 (1 point) Saved In the Pivot Table below, Accessory, Product A, Product B and Service are Product Types. The bold values, such as the one highlighted, in the Grand Total column represents: Sum of Revenue ($) Column Labels ~ Row Labels ~ Calgary Montreal Toronto Vancouver Grand Total = Accessory 1517.08 2160.19 2671.38 1385.16 7733.81 Qtrl 362.78 379.27 775.03 560.66 2077.74 Qtr2 280.33 560.66 1022.38 197.88 2061.25 Qtr3 791.52 906.95 709.07 461.72 2865.26 Qtra 82.45 313.31 164.9 164.9 725.56 =ProductA 412555 6347 577577 780681 2405513 Qtrl 1205.93 952.05 1650.22 3681.26 7485.46 Qtr2 1967.57 2094.51 2792.68 698.17 7552.93 Qtr3 317.35 241186 761.64 2538.8 6029.65 Qtrd 634.7 888.58 571.23 888.58 2983.09 = Product B 7652.04 10531.84 7981.16 10038.16 36203.2 Qtrl 12342 4278.56 1974.72 3291.2 10778.68 Qtr2 2632.96 2632.96 3538.04 1892.44 10656.4 Qtr3 3784.88 189244 2468.4 2468.4 10614.12 Qtr4 1727.88 2386.12 4114 = Service 12093 14595 12371 13344 52403 Qtrl 5004 3336 556 5004 13900 Qtr2 1807 5838 6116 3475 17236 Qtr3 3197 4031 5699 3058 15985 Qtrd 2085 1390 1807 5282 Grand Total 25387.67 33634.03 28799.31 32574.13 120395.14 The sum of the revenue values for all orders of a single product type at a single location in a single quarter The sum of the revenue values for all orders of a single product type at all locations in a single quarter. The sum of the revenue values for all orders of a single product type at all locations across all quarters. The sum of the revenue values for all orders of a single product type at a single location across all quarters

Question 30 (1 point) Saved In the Pivot Table below, Accessory, Product A, Product B and Service are Product Types. The non-bold values, such as the one highlighted, in the locations columns represent: Sum of Revenue ($) Column Labels ~ Row Labels ~ Calgary Montreal Toronto Vancouver Grand Total = Accessory 1517.08 2160.19 2671.38 1385.16 7733.81 Qtrl 362.78 379.27 775.03 560.66 2077.74 Qtr2 280.33 560.66 1022.38 197.88 2061.25 Qtr3 791.52 906.95 705.07 461.72 2869.26 Qtrd 82.45 313.31 164.9 164.9 725.56 = Product A 4125.55 6347 5775.77 7806.81 24055.13 Qtrl 1205.93 952.05 1650.22 3681.26 7489.46 Qtr2 1967.57 2094.51 2792.68 698.17 7552.93 Qtr3 317.35 2411.86 761.64 2538.8 6029.65 Qtrd 634.7 888.58 571.23 888.58 2983.09 = Product B 7652.04 10531.84 7981.16 10038.16 36203.2 Qtrl 1234.2 4278.56 1974.72 3291.2 10778.68 Qtr2 2632.96 263296 3538.04 1892.44 10696.4 Qtr3 3784.88 189244 24684 2468.4 10614.12 Qtrd 1727.88 2386.12 4114 = Service 12093 14595 12371 13344 52403 Qtrl 5004 3336 556 5004 13500 Qtr2 1807 5838 6116 3475 17236 Qtr3 3197 4031 5699 3058 15985 Qtrd 2085 1390 1807 5282 Grand Total 25387.67 33634.03 28799.31 32574.13 120395.14 The sum of the revenue values for all orders of a single product type at all locations in a single quarter. The sum of the revenue values for all orders of a single product type at a single location across all quarters @ The sum of the revenue values for all orders of a single product type at a single location in a single quarter The sum of the revenue values for all orders of a single product type at all locations across all quarters.

Question 31 (1 point) Saved Tammi is helping her Manager to create a dashboard for the weekly project team meetings. She wants to use MS Excel, and create a clean view for a professional look. What is the best method for her? O Use as many Charts as she can to completely fill the view area. O Use a different program to create a cover page and link it to her Excel workbook. O Make the cell borders white using the Cell Formatting option. @ Disable the gridlines by unchecking the box from the View menu. Previous Page m Page 31 of 32 Previous Page Next Page Page 32 of 32 Question 32 (1 point) Saved Tammi is helping her Manager to create a dashboard for the weekly project team meetings. She wants to use MS Excel, and link her charts to the data so that her Manager can click in to see the data details. What is the best method for her? Q She will not be able to do this in her Worksheet. Q Make a copy of her data and embed it into the Chart. @ Select the Chart first and then insert a Link from the Insert menu. Q Add a new Link item and place it in her Chart as a hidden object. Q Paste an image overtop of her data using Paste Linked picture. Previous Page Next Page Page 32 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

DataAnalyticsFinalExamAnswers

Related Documents