Excel Assignment

excel_tutorial_1_mini1_directions.docx

Home >Information Systems homework help >Excel Assignment

Excel Tutorial 1 Mini-Case1 Directions

Excel Tutorial 1: Mini-Case 1

Scenario: Dexter Lampe is excited. His new boss in the accounting department, Mr. Chaise, has asked him to spruce up a spreadsheet that he wants to present to the board of directors in the next board meeting. The spreadsheet contains financial information about the company's current balance sheet. In addition, it contains a section for forecasting sales for the next 3 years and analyzing how the forecast changes impact the balance sheet. It's the first opportunity that Dexter has had to show what he can do. He's sure that this will be the first of many successful assignments that will allow him to move up the corporate ladder at UltraCorp, Inc. Mr. Chaise attached the spreadsheet to an e-mail along with his instructions to Dexter. When Dexter opened it, he smiled and thought to himself, “Piece of cake!” All he would need to do is add a few formulas and do some formatting to make the spreadsheet presentable. The hard part would be in holding back and not getting too wild with the colors. He decided to get right to work.

Starter File: Tutorial 1: Mini-Case Balance Sheet

Your Task: Download the Excel file EXC_1_MC_Balance_Sheet.xlsx. Use this spreadsheet to help Dexter by completing the missing formulas in the spreadsheet and adjusting cell formats and font styles to make the balance sheet presentable for your boss. At a minimum, you should do the following:

·	Complete the missing formulas. Comments are provided on each cell (indicated by little red triangles in the cell) that describe the formula that you should enter. Simply place the cursor on the cell to read the comment.

·	Adjust all numeric values to display as currency format.

·	Use font styles (bold, italics, etc.) to highlight the various headings in the balance sheet.

·	Center the heading information at the top of the spreadsheet above the balance sheet and adjust the font and font style.

·	Use cell borders to separate the various sections of the balance sheet.

·	Fill the blank cells between the balance sheet columns with color to separate the columns visually.

·	Don't forget to save the file when you complete your work.

If you are not sure how to do some of these tasks, be sure to use Excel Help to find out how.