Answered You can hire a professional tutor to get the answer.

QUESTION

Open a new Excel file, and in Column A create a vertical list of numbers from 1 to 15,000, starting in row 1.

  1. Open a new Excel file, and in Column A create a vertical list of numbers from 1 to 15,000, starting in row 1.
  2. In Column B, create a second column that has the values 2 through 30,000, counting by 2s (2, 4, 6, 8, etc.), starting in row 1.
  3. In Column C, create a third list of number that starts with 7 in row 1 and continues until 105,000, counting by 7s (7, 14, 21, etc.)
  4. Convert the three columns of numbers from "General" cells to "Number" cells.
  5. Insert a new row above the top row, so that A1 and B1 are now blank.
  6. In A1 and B1, enter formulas that sum all the numbers in each column. For example, A1 contains the sum of all the numbers in the "A" column, starting from A2 and going down.
  7. Adjust the column widths so that all numbers are readable.
  8. In column D, create a list of numbers that represent the AVERAGE of each row's numbers from columns A, B, and C.
  9. Switch to Sheet2 and create a Weighted Scoring Model of some personal purchase decision you have recently made, or are about to make. You should be deciding amongst at least three similar things, and there should be between 7 and 10 decision criteria. The weights you use for the criteria should add up to 1.0 (100%). Indicate which item is chosen. Once you have completed this, do what you can to make this sheet attractive and presentable, as though you were going to use this to convince your CEO to view a decision the way you do, and to see you as a polished employee with executive potential.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question