Exam 2: Analytics on Spreadsheets

What is the Insert function in Excel?

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 before the column label B4 ($B4), how will the formula at B10 be represented in C11 using absolute addressing?

In a MATCH function, if the match_type = 0, then ________.

The process of developing good, useful, and correct spreadsheet models is known as spreadsheet engineering.

Explain the different Lookup functions in Excel.

Trace the process of copying and pasting a cell, which has a formula in it, such that the formula is not retained in the pasted cell.

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 -Using a $ sign before both the row and column labels keeps the reference to that cell fixed no matter where the formula is copied.

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 largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12?

The easiest way to locate a particular function is to select a cell and click on the Insert function button represented by ________ on the Excel ribbon.

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 would be used to calculate the gross profit?

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 operating expenses?

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 data value?