Need help?
Brief problem description:

Current queue

Elizabeth ... 4,092.69 minutes ago TNRB 290: in the room IS 201
Jessica K ... 2,410.21 minutes ago TNRB 204: just outside the room IS 201
pinlxexsy... 2,064.94 minutes ago MBA 520 location (see calendar) IS 303
WilliamHuc... 2,002.95 minutes ago TNRB 204: just outside the room Other IS class
Jameslem... 1,553.59 minutes ago TNRB 290: just outside the room IS 415
pollyox18... 1,385.76 minutes ago TNRB: in the atrium between 290 and 204 IS 402
WilliamKix... 1,160.70 minutes ago TNRB 290: just outside the room IS 115
ceceliaal6... 1,079.44 minutes ago TNRB: in the atrium between 290 and 204 IS 520
Devin Rock... 1,011.11 minutes ago TNRB 204: in the room IS 201
Sheldonpru... 806.80 minutes ago MBA 520 location (see calendar) IS 515
EdwardDom... 682.03 minutes ago TNRB: in the atrium between 290 and 204 IS 120
WayneVulse... 521.67 minutes ago TNRB 290: just outside the room IS 415
Keithpiemy... 378.54 minutes ago TNRB: in the atrium between 290 and 204 Other IS class

IS 110 Tips and Frequently Asked Questions

Be sure not to change the names of your worksheets - do not even add an extra space at the end of the names. If you do, then the grading script will not be able to find your sheets.

To complete this assignment, you must do a Multi-level Sort. It is not sufficient to merely do one sort followed by another.

If you are attempting to complete this assignment on a Mac, you will have a hard time. For example:

  • Task 10 requires that you format a date to be a Short Date, which is a built-in option in the Windows Excel 2010 version, but does not exist in the Mac version.
  • Tasks 11-20 require that you resize a column to a set width, but the Mac resizing functionality is not the same as the Windows version.
  • Task 22 asks that you place a Thick Bottom Border under some data labels. This border-style is a specific width that is labeled Thick Bottom Border in the Windows Excel version, but is not labeled in the Mac version.

Your charts can be located anywhere in your workbook - it does not matter if they are on their own sheet, or just inserted on top of another worksheet - it is up to you.

Question: The Grader says that it cannot find my Decision Sets for the scenario manager. I know they are there.

Answer: Your scenarios must be named exactly like this, including spacing and capitalization:

Question: What should I keep in mind as I add series to a chart?

Answer: When you are entering a Series Name for your new series, be sure to reference a cell containing the series name you want instead of just typing it in. Below is a picture of how the series that is already included in the chart was entered. Follow its pattern:

Tip: The Budget Task

Follow the instructions in the text-box on the Budget sheet - first make up a budget for yourself. After you’ve done that, a common mistake that students make is to make named ranges titled Total_Income and Total_Expenses, which sum up a range of cells called Income and Expenses, respectively. Do not do that! Do not create Total_[category] named ranges for this assignment. Instead, have your Income and Expenses named ranges each refer to a single cell, which should be a cell that sums up individual income and expense items.

Tip: Tax Rate Reference

Notice that this cell exists! (See image below)

Tip: Total Messages Over

Cellular Task 20 has the following language: This is the number of total messages over the messages included in the plan... When you see this, do not do division. Another way of wording this task description would be to say, This is the total message usage overage. It is over in the sense of, I went over my minutes, referring to a cell phone plan.

Tip: as you work on them, focus explicitly on the sentences from the task description that are highlighted below.

* The second half of the first sentence could also be read more simply as: ... minus the loan balance from two months prior.

** The phrase The minimum cash balance for any month must be zero implies that you need to ensure that your function never returns less than 0. You will need to write logic to detect whether the calculation would be less than 0, and then handle it appropriately. There is more than one way to handle this requirement.

As you work on your formulas, a good debugging strategy is to to temporarily change the inputs to your functions, to see if the output is what you expect it to be.

Be sure not to switch up your Lower and Upper Bounds.

Just type either 1990 or 2010 into the cells - do not use a formula.

Remember that functions like COUNT() and AVERAGE() automatically exclude text values in their calculations.