scenario for the last six months your personal budget is going haywire you are unable to identify the cause your friend suggests that you use the microsoft excel spreadsheet package to streamline your budget therefore you have now started learning th

Part A

Getting Started with Excel

Scenario

For the last six months, your personal budget is going haywire. You are unable to identify the cause. Your friend suggests that you use the Microsoft Excel spreadsheet package to streamline your budget. Therefore, you have now started learning the Microsoft Excel tool. Having completed a week’s learning, you are now ready to look back and refresh your learning.

Complete the following discussions in relation to Microsoft Excel:

  • What kind of data is Microsoft Excel best used for? What challenges, if any, did you face while creating a workbook?
  • Based on the types of data best used in Microsoft Excel, why do you think learning this application is going to be important toward the development and progress of your short- and long-term educational and professional goals?
  • Based on the types of data best used in Microsoft Excel, what are some types of formulas and functions that could be used to analyze data; for example, to streamline your budget according to the given scenario?
  • Certain ribbons are active when Microsoft Excel is started. Debate the usefulness of each ribbon. If you were creating a workbook, which ribbons and tools do you think would be required? Please specify if you use Microsoft Excel with a Windows or Mac computer as the ribbons may differ.
  • Discuss the different methods of opening, saving, and printing a workbook. Which method do you find to be the most useful in terms of time and efficiency? Why?

Part B

Computer Sales

Scenario

For the year 2012, the computer sales of All in One were very good; however, you want to evaluate and assess the sales for each salesman to track the following:

Item # 1234: SU 20-Inch Optional Touch Screen Generation 3: $999.00
Item # 2778: SU 23-Inch Optional Touch Screen Generation 3: $1,765.00
Item # 4996: SU 27-Inch Optional Touch Screen Generation 3: $2,500.00

There are a total of five salesmen with IDs 001, 002, 003, 004, and 005; and you have asked your administrative assistance to create a worksheet for documenting computer sales for 2012 that includes the following fields:

  • Salesman ID
  • First Name
  • Last Name
  • Item #
  • Item Description
  • Units Sold
  • Unit Price
  • Total Sales

Click here to view a draft design that you can consider when developing this worksheet.

The worksheet should adhere to the following specifications:

  • Include at least ten records.
  • For these records, assume that at least 100 computers were sold in 2012 in any combination for item numbers 1234, 2778, and 4996. Also, allocate the sales of 100 computers among the five salesmen.
  • Use font size 14 to fill in the information. You are free to create your own data for the columns.
  • Increase the row width and height to fit the data neatly in the rows.
  • Center-align the information in each column heading cell (Row 2) and also merge and center-align the worksheet title All in One Computer Sales – 2012 (Row 1) and fill the merged cell with a color of your choice.
  • Use a formula, which includes cell references, to calculate Total Sales.
  • Use the spell check feature to ensure that there are no spelling mistakes in the worksheet.
  • Improve the appearance of the information displayed in the worksheet by using the features available on the Formatting toolbar. For example, consider using some color-based formatting and currency-based formatting for values that represent money.
  • Rename the worksheet tab to Computer Sales.