Expert answer:Excel accounting assignment
Solved by verified expert:all info you need is in the file.
excel_lab_one___create_an_excel_workbook_and_bar_chart_1_.docx
Unformatted Attachment Preview
Excel Lab One –Create an Excel Workbook and Bar Chart Microsoft Excel 2013
PURPOSE: Excel is a software package and a part of the Microsoft Office Suite used
worldwide to organize and analyze data. Before doing this assignment, you should go
familiarize yourself with Excel. You will need to know this material to do this
assignment as well as other Excel lab assignments. Excel is a powerful software package
capable of doing a multitude of formula driven applications such as budgets, sales
analysis, etc. It is especially useful for working with lists on a one-of-a-kind basis. It
SHOULD NOT be confused with the capabilities and functionality of a database.
With Excel, you can make changes and see the results of your work immediately in all
of your calculations, charts, and any other work such as Word, Power Point, etc., that are
linked to your workbook(s). You can also import data from other software such as
Access, etc., and/or export data to other software such as Word, Power, Point, Access,
etc. Each workbook currently can handle up to 16,384 columns and 1,048,576 rows.
When working with Excel, you should plan what you expect the worksheet(s) to look
like and what information will go into the columns and rows before you begin! This is
called “planning” and is a critical factor in problem solving. Typical processes would
have rows listing data elements horizontally (record like items in a file or database table)
and columns that vertically group like in a row (a field that contains like data items in a
file or database table).
ASSIGNMENT: You are to create a new blank Excel workbook saving the workbook with the
file name as lastname_firstinitial_statement. Organize and enter the information below
into a Microsoft 2013 Excel worksheet. Calculate the Total Monthly Budget, Actual, and
Variance both horizontally and vertically. You are to then create a Bar Chart for this
workbook.
a) Make sure the worksheet view is set to 100%.
b) Verify the “active cell´ is selected in the upper left hand corner of the worksheet. This should
be cell A1. If not, make this the active cell by positing the cursor in cell A1 and then left
clicking the cell.
c) In this cell, A1, type the company name The Latest Fashion Trends, Inc. – Your Name.
Press the Enter key to store this information.
d) In cell A2, type Financial Budget/Income Statement. Press the Enter key to store this
information.
(1) Press the Enter key again to skip to cell A4.
e.) In cell A4, type Month. Press the Tab key to move the active cell to B4.
COSC – 111 Excel Lab One – Create an Excel Workbook – Page 1
Copyright © June, 2015, Dominic M. Mezzanotte, Sr.
(1) Beginning in cell B4, list the 12 months of the year beginning with January and
ending with December pressing the Tab key after each month is entered. The active
cell should now be N4:
(2) In active cell N4, type Total and press the Enter key.
a. Save your workbook.
b. Make sure the active cell is A5. If not, make cell A5 the active cell.
f.)
NOTE: When entering number values, the numbers should be formatted to
show only the number values. In this case, no decimals or dollar signs are to be
shown. Commas are to separate hundreds, thousands of dollars, etc. Negative
number should be bracketed with right and left parans. For this assignment,
us the tool bar for Number is located under the Home tab. You can apply the
numbering scheme desired either before or after entering the numeric data
detailed below by simply highlighting all of the cells to be formatted and
applying the desired editing at one time.
g.) In cell A5, type Budget and press the Tab key.
(1) Beginning in cell B5, type 1000, 12000, 9000, 11000, 15000, 15500, 20000, 21500,
24500, 25650, 29550, 35500 pressing the Tab key after each entry. The active cell
should be in cell N5.
(2) In cell N5, sum cells B5 through M5. Press the Enter key.
(3) Save your workbook after completing this operation.
(4) Make A6 the active cell.
h.) In cell A6, type Actual. Press the Tab key to make the active cell B6.
(1) Beginning with cell B6, type 1475, 9590, 11175, 16850, 14900, 16750, 23750,
22480, 24350, 26975, 28400, 37500 pressing the Tab key after each entry. The active
cell should be at cell N6.
(2) In cell N6, sum cells B6 through M6. Press the Enter key.
(3) Save your workbook after completing this operation.
(4) Make A7 the active cell.
i.) In cell A7, type Variance and press the Tab key.
(1)
(2)
(3)
(4)
Beginning in cell B7, calculate the Variance for each month.
Variance equals Actual minus Budget.
Negative numbers should be bracketed with right and left parenthesis symbols.
In cell N7, sum cells B7 through M7. Press the Enter key.
COSC – 111 Excel Lab One – Create an Excel Workbook – Page 2
Copyright © June, 2015, Dominic M. Mezzanotte, Sr.
(5) Save your workbook after this operation.
j.) Merge & Center the information you entered in cell A1 changing the font to 16.
k.) Merge & Center the information you entered in cell A2 changing the font to 14.
l.) Highlight cells B4 through N4 changing the text to Bold and centering the names of the
month.
m.) Highlight cells A4, A5, A6, and A7 changing the text to Bold.
(1) Save your workbook after completing these operations.
(2) Your workbook should look like Figure 1 below.
Figure 1. Completed Financial Statement without Chart.
n.) Create a chart by:
(1)
(2)
(3)
(4)
(5)
Selecting the “INSERT” tab
Highlighting cells B5 through M7
Selecting the “INSERT COLUMNS CHART” from the Charts tool bar
Selecting the “3-D Chart” from the available charts
Save your workbook after completely this operation
o.) Upload your completed workbook for this assignment in Blackboard.
COSC – 111 Excel Lab One – Create an Excel Workbook – Page 3
Copyright © June, 2015, Dominic M. Mezzanotte, Sr.
Grading Matrix:
•
•
•
•
•
•
Organization – 7 points (includes all forms of punctuation such as dollar signs, decimal
values if applicable, and periods, positive and/or negative values identified, etc.)
Format – 5 points (includes cell width, Bar Chart appearance, professionalism, etc.).
Column Headings – 2 points (cells properly labeled, etc.).
Calculations – 5 points (includes formulas, column totals, crossfoot totals, etc.).
Workbook, Spreadsheet, and Bar Chart Headings and Footers, Bar Chart Captions, etc.
– 5 points.
Spelling – 1 point.
COSC – 111 Excel Lab One – Create an Excel Workbook – Page 4
Copyright © June, 2015, Dominic M. Mezzanotte, Sr.
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades