Fe_ICA_10_23_Start

Problem ICA 10-23 Energy Cost 0.106 Brand Model Black & Decker BCE27 Danby Millennium DAR194BL Danby Millennium DAR194W General Electric SFR03BAPBB General Electric SFR03BAPWW Haier ESRB03B MicroFridge MHR-2.7E Silhouette DAR195BL Silhouette DAR259BL Silhouette DAR340BL Sunbeam SBCR039WE U-Line 2015R U-Line 15R Whirlpool WAR349BSL Part a - S Brand Model General Electric SFR03BAPBB General Electric SFR03BAPWW Many college students have compact refrigerator-freezers in less than 3.6 cubic feet [cft], according to the American Cou analysis. We would like to compute the cost to run each model for a y “Energy Cost [$/year],” that calculates the annual energy co Complete the steps below using cell references to given d To copy/paste a formula across a row or down a column Excel function is to be used, the directions will specify th Instead, make a reference to the cell in which the data is cases, unless otherwise directed, use the earliest appeara (a) Sort the first table by energy usage, with the model with

Silhouette DAR340BL Whirlpool WAR349BSL U-Line 15R Silhouette DAR259BL U-Line 2015R Danby Millennium DAR194BL Danby Millennium DAR194W Silhouette DAR195BL Black & Decker BCE27 Haier ESRB03B MicroFridge MHR-2.7E Sunbeam SBCR039WE Which model appears first? Which model appears first? Instructions 1Start Excel. 2 3 (b) Sort by the volume in ascending order and the annual en Do this part on the ICA 10-23 (b) worksheet. (c) Assume we want to restrict our selection to refrigerators the models that follow this criterion. Do this part on the ICA 10-23 (c) worksheet. (d) Assume we want to restrict our selection to refrigerators kilowatt-hours per year. Use Filter setting in order to display Do this part on the ICA 10-23 (d) worksheet. On the ICA 10-23 worksheet, in cell I10 , by usi refrigerator. Copy the formula from cell I10 dow On the ICA 10-23 worksheet, in cells D29-H42 , Select the cells D29-H42 . Select the Sort & Filte to sort by Energy Use, sort on Values, and set th

[$ / kWh] Initial Worksheet Defrost Type Energy Use [kWh/yr] Energy Cost [$ / yr] Manual 2.7 261 $27.67 Automatic 1.8 302 $32.01 Automatic 1.8 302 $32.01 Automatic 3.2 316 $33.50 Automatic 3.2 316 $33.50 Manual 2.7 261 $27.67 Manual 2.7 260 $27.56 Automatic 1.8 302 $32.01 Automatic 2.5 309 $32.75 Automatic 3.3 316 $33.50 Manual 1.7 252 $26.71 Automatic 3.1 307 $32.54 Automatic 3.5 312 $33.07 Automatic 3.3 316 $33.50 Sorting by Energy Usage Defrost Type Energy Use [kWh/yr] Automatic 3.2 316 Automatic 3.2 316 n their dorm rooms. The data set provided is a partial list of energy-efficient models uncil for an Energy Efficient Economy (www.aceee.org). Complete the following year. Assume that it costs $0.106 per kilowatt-hour [kWh]. Create a new column, ost for each refrigerator. data or previous calculations. In some cases, a simple cell reference is all you need. n, an absolute cell reference or a mixed cell reference may be preferred. If a specific he use of that function. Do not type in numerical data into a cell or function. s found. Make your computations only in the cells specified in Instructions. In all ance of the data in your formulas. Volume [ft 3 ] h the highest kilowatt-hour rating listed first. Volume [ft 3 ]

Automatic 3.3 316 Automatic 3.3 316 Automatic 3.5 312 Automatic 2.5 309 Automatic 3.1 307 Automatic 1.8 302 Automatic 1.8 302 Automatic 1.8 302 Manual 2.7 261 Manual 2.7 261 Manual 2.7 260 Manual 1.7 252 SFR03BAPBB SBCR039WE nergy cost in ascending order. s that can contain more than 2.0 cubic feet. Use Filter setting in order to display a list of s that can contain more than 2.0 cubic feet and only require between 0 and 300 y a list of the models that follow these criteria. ing relative and absolute addressing, calculate the annual energy cost for each wn the column to cell I23 . (1 point) , sort data in descending order of energy usage specified in the column H . er on the Home tab of the Ribbon, in the drop down list select the Custom Sort. Select he order Largest to Smallest. (1 point)

art b - Sorting by Volume then Energy Cost Defrost Type Energy Use [kWh/yr] Energy Cost [$ / yr] Manual 1.7 252 $27.67 Automatic 1.8 302 $27.56 Automatic 1.8 302 $27.67 Automatic 1.8 302 $33.50 Automatic 2.5 309 $32.75 Manual 2.7 260 $32.01 Manual 2.7 261 $32.01 Manual 2.7 261 $33.50 Automatic 3.1 307 $32.01 Automatic 3.2 316 $26.71 Automatic 3.2 316 $32.54 Automatic 3.3 316 $33.07 Automatic 3.3 316 $33.50 Automatic 3.5 312 $33.50 nergy cost in ascending order. Which model appears first? Volume [ft 3 ]

Defrost Type Energy Use [kWh/yr] Manual 2.7 261 Automatic 3.2 316 Automatic 3.2 316 Manual 2.7 261 Manual 2.7 260 Automatic 2.5 309 Automatic 3.3 316 Automatic 3.1 307 Automatic 3.5 312 Automatic 3.3 316 s that can contain more than 2.0 cubic feet. Use Filter setting in order to display a list of c - Volume > 2.0 ft 3 Volume [ft 3 ]

Defrost Type Energy Use [kWh/yr] Manual 2.7 261 Manual 2.7 261 Manual 2.7 260 s that can contain more than 2.0 cubic feet and only require between 0 and 300 y a list of the models that follow these criteria. 0 ft 3 and Energy Use ≤ 300 kWh/yr Volume [ft 3 ]