Exam 2: Analytics on Spreadsheets

Using a $ sign before a column label ________.

Use the following scenario to answer the following question(s) The Blue Sunset Band is planning to record a new album.A major decision to be made is if the band can record the album on their own, or if they should hire a studio to record it with.The fixed cost for recording at the studio is $100,000 plus the manufacturing cost per CD, which is at $250.If they record the album in-house, the cost per CD is $350.They plan to produce 3000 copies of the album regardless of the place of recording.The band plans to record with the cheaper option.Below is the spreadsheet of the Recording Decision. A B The Blue Sunset Band Album Recording Decision 2 3 Data 4 5 Recording at Studio 6 Fixed Cost \ 100,000 7 Unit CD Cost \ 8 250 9 Recording In-house 10 Unit CD Cost \ 11 350 12 Production Volume 3000 13 14 Model 15 16 Total studio manufacturing cost \ 850,000 17 Total in-house 18 \ 200,000 19 Cost Difference 20 Recording Decision Studio -Which of the following formulas are used to calculate the In-house recording cost?

Give the logical function for the following: If cell B7 equals 12, check contents of cell B10.If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space.If cell B7 does not equal 12, then the value of the function is 7 no matter what cell H45 is.

To use the VLOOKUP(lookup_value, table_array, col_index_num), the table must be sorted in the descending order.

Which of the following functions is a logical function that returns TRUE if any condition is true and FALSE if not?

Using the spreadsheet below to answer the following question(s). The spreadsheet below shows the net income model for a company that sells shoes. 1 A B 2 3 Data 4 5 Sales \ 10,000,000 6 Cost of Goods Sold \ 6,400,000 7 Administrative Expenses \ 500,000 8 Selling Expenses \ 900,000 9 Depreciation Expenses \ 750,000 10 Interest Expenses \ 70,000 11 Taxes \ 620,000 12 13 Model 14 15 Gross Profit \ 3,600,000 16 Operating Expenses \ 2,150,000 17 Net Operating Income \ 1,450,000 18 Earnings Before Taxes \ 1,380,000 19 20 Net Income -Which of the following formulas would be used to calculate the net income value using only the information in the Model, and not in the Data section?

Use the data given below to answer the following question(s). Below is a spreadsheet of purchase orders for a computer hardware retailer. -If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size?

Using the spreadsheet below to answer the following question(s). The spreadsheet below shows the net income model for a company that sells shoes. 1 A B 2 3 Data 4 5 Sales \ 10,000,000 6 Cost of Goods Sold \ 6,400,000 7 Administrative Expenses \ 500,000 8 Selling Expenses \ 900,000 9 Depreciation Expenses \ 750,000 10 Interest Expenses \ 70,000 11 Taxes \ 620,000 12 13 Model 14 15 Gross Profit \ 3,600,000 16 Operating Expenses \ 2,150,000 17 Net Operating Income \ 1,450,000 18 Earnings Before Taxes \ 1,380,000 19 20 Net Income -Which of the following formulas would be used to calculate earnings before taxes?

Which of the following ways would $10^{2}$ × $5^{3}$ /100 - 73 be represented in an Excel spreadsheet?

If cell G7 contains the function ________, it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.

To copy a formula from a single cell or range of cells down a column or across a row, first ________, click and hold the mouse on the small square in the lower right-hand corner of the cell, and drag the formula to the "target" cells which you wish to copy.

Explain how the Data Validation feature in Excel helps in increasing spreadsheet quality.

Use the data given below to answer the following question(s). Below is a spreadsheet of purchase orders for a computer hardware retailer. -The ________ reflects the opportunity costs of spending funds now versus achieving a return through another investment, as well as the risks associated with not receiving returns until a later time.

Use the following scenario to answer the following question(s) The Blue Sunset Band is planning to record a new album.A major decision to be made is if the band can record the album on their own, or if they should hire a studio to record it with.The fixed cost for recording at the studio is $100,000 plus the manufacturing cost per CD, which is at $250.If they record the album in-house, the cost per CD is $350.They plan to produce 3000 copies of the album regardless of the place of recording.The band plans to record with the cheaper option.Below is the spreadsheet of the Recording Decision. A B The Blue Sunset Band Album Recording Decision 2 3 Data 4 5 Recording at Studio 6 Fixed Cost \ 100,000 7 Unit CD Cost \ 8 250 9 Recording In-house 10 Unit CD Cost \ 11 350 12 Production Volume 3000 13 14 Model 15 16 Total studio manufacturing cost \ 850,000 17 Total in-house 18 \ 200,000 19 Cost Difference 20 Recording Decision Studio -Which of the following formula is used to make the recording decision in B20?

Use the data given below to answer the following question(s). Below is a spreadsheet of purchase orders for a computer hardware retailer. -To find the total order cost, what Excel formula should be used in A12?

Use the data given below to answer the following question(s) Below is the spreadsheet for demand prediction of a company that sells chocolates. A B C 1 Demand Prediction Models 2 3 Linear Model 4 a 10,000 5 b 10 6 7 Price Demand 8 \ 50 9,500 9 \ 55 9,450 10 \ 45 9,550 11 -If a dollar sign is used after the column in B5 (B$5), how will the formula at B8 be represented in C9 using absolute addressing?

In a MATCH function, if match_type = 1, then the function finds the smallest value that is greater than or equal to lookup_value.

Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?

________ is a logical function that returns one value if the condition is true and another if the condition is false.

The Excel function of ________ is used to find the largest value in a range of cells.