Excel Final Test Preparation Material (Excellent)

Document Content and Description Below

Spreadsheet Modeling, Excel 2013: Advanced Section: Final Please download the file final.xlsx and refer to Worksheet A. The standard deviation (assume that the dataset represents a sample, not a pop... ulation) of the quantity sold per transaction is ________. Round your answer to the nearest whole number, and enter just the number; e.g., enter 71.5 as 72. 36 错了但不知道正确的是啥 无头绪 For the names listed below you would like to put each person's first name in Column F and each person's last name in column G. The easiest way to do this is use the _____________ feature. Flash fill Consider the cash flows seen here. The Internal Rate of return on the cash flows (rounded to the nearest 1%) is ____________. Enter just the number; e.g., 18%. 25% You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what would be the row input cell for a two-way data table? Note: If the answer is a formula, there is no need to begin that answer with =. Please do not put any unnecessary spaces or () in your response. E3Consider the cash flows seen here. If we discount cash flows at 10% per year, the Net Present Value (rounded to the nearest dollar) of these cash flows as of 4/10/2011 is _____. 392 An airline sells 120 tickets for a flight that seats 100. Each ticket is nonrefundable and costs $200. The unit cost of flying a passenger (fuel, food, etc.) is $80. If the flight is overbooked, each person who does not find a seat is given $300 in cash. Assume it is equally likely that any number of people between 91 and 120 show up for the flight. Rounded to the nearest thousand (e.g., 18500 rounds to 19000), on the average how much expected profit (ignoring fixed cost) will the flight generate? Enter just the number; e.g., 11000. 14000 You would like to show how the number of faculty at the end of year 10 depends on the quit rate and number of annual hires. We would like for example, to have cell L10 give the number of Year 10 faculty if we hire 1 faculty member a year and 10% quit each year. Using the information in the spreadsheets below, what would be the column input cell for the twoway data table?Please do not put any unnecessary spaces or () in your response. E4 Please download the file final.xlsx and refer to Worksheet A. Transaction 12 was the ___th largest transaction in terms of the Total. Enter just the cardinal number; e.g., 9. 64 The value in cell A1 of a spreadsheet is needed to compute the value in cell E3. The value in cell E3 is needed to compute the value in cell E10. The value in cell E10 is needed to compute the value in cell A1. This spreadsheet contains a _______ reference. circular In the spreadsheet shown below, we computed profit earned by selling houses by entering the formula =F8-E8 in cell G8 and copying it down to G9:G11. We used the word open to denote a house that is not yet sold. Unfortunately, when a house has not yet been sold our spreadsheet shows the #VALUE error, because you cannot subtract the buy price from the word open. We would like to "error trap" Column G so that when a house has been sold the correct profit has been computed and if the house has not yet been sold a _ will be entered in Column G. How many of the following formulas could be entered in cell G8 and copied down to G9:G11 to achieve this goal? [Show More]

Last updated: 2 years ago

Preview 1 out of 12 pages