Learning about Excel the past two weeks of this module have been interesting. There is more to learn about Excel than students could have anticipated. Week two of classes we were to complete an income statement, balance sheet, statement of cash flows, a common size income statement, and a common size balance sheet, from chapter two of Mayes & Shank (2012) problem number 3. The question that needs to be answered is what the value is in having the financial statements on a spreadsheet (Mayes & Shank, 2012). The answer is that all the information is formulated within the Excel; it is easy to read and even easier to navigate through and follow.

When doing an Excel spreadsheet especially dealing with financial statements, there are a lot of formulas and numbers to be tracked. In the problem we had missing numbers that needed to be calculated with the proper formulas in Excel. For the income statements the first number to be calculated was for the gross profit. This was accomplished by taking the sales of Winter Park Web Design and subtracting that by the cost of goods sold. Next was to find the depreciation expense. This was found by looking on the statement of cash flows spreadsheet of Winter Park Web Design under depreciation expense. The next missing calculation was for the net operating income. The net operating income was found by taking the gross profit and subtracting it from the depreciation expense and subtracting that from the selling and administrative expense to get the total for net operating income. Next was to calculate the earnings before taxes, by taking the net operating income and subtracting the interest expense from it. The next was to calculate the taxes. This was done by taking the earnings before taxes and multiplying the number by the tax rate. Last was to calculate the net income. This is calculated by taking the earnings before taxes and subtracting it by the taxes.

By doing the first step of the problem it was easy to realize...

...Week 6
Excel
PF008 A14
Introduction to Spreadsheets
A spreadsheet is an electronic file that contains a
grid of columns and rows used to organize related
data and perform calculations.
Excel is a spreadsheet program used to create and modify
electronic spreadsheets.
An electronic spreadsheet makes data-entry changes easy,
and if the formulas are correctly constructed, the results
recalculate automatically and accurately.
A worksheet is a single spreadsheet that typically contains
descriptive labels, numeric values, formulas, functions, and
graphical representations of data.
A workbook is a collection of one or more related
worksheets contained within a single file. Each worksheet
is identified by a sheet tab. By default, new workbooks
have three worksheets.
The whole file is a workbook
Worksheet
Planning Structure of Worksheets
1. State the purpose of the worksheet
2. Decide what input values are needed
An input area is a range of cells containing values
3. Decide what outputs are needed
An output area is a range of cells containing
results
4. Assign the worksheet inputs and results
Use rows and columns
5. Enter the labels, values, and formulas
6. Format the numerical values
7. Format the descriptive titles and labels
8. Document the worksheet
9. Save the completed workbook
Exploring the Excel Window
• Worksheet rows lie horizontally
• Worksheet columns lie vertically
• A cell is the intersection of a row and...

...to Create an Interactive Quiz in Excel
http://college.cengage.com/accounting/resources/instructors/air/fall_2006...
Creating Interactive Quizzes in Excel
J.A. (Jim) Connell University of Montevallo Michael E. Stephens College of Business Station 6551 Montevallo, AL 35115 Elizabeth Mulig USF St. Petersburg 140 Seventh Avenue South St. Petersburg Florida 33701-5016 727-553-4154 mulig@stpt.usf.edu
Introduction Have you ever received a spreadsheet file that asked you questions and then magically told you whether your answers were correct? They can be more than e-mail pastimes. Once you understand how those spreadsheet files list questions and check your answers, you can create spreadsheet files that ask your students accounting questions. All it takes is an understanding of a few simple functions within the spreadsheet, and we’re about to reveal those secrets. They’re a lot easier to create than most people think and it only takes one simple formula to produce a scoring system that makes your quiz interactive. This means that your answers will be included in the spreadsheet, but it’s easy to hide the answers and password protect the spreadsheet so your students have to work to find the correct answer. To illustrate how it works, we’ve created an interactive quiz based for a principles-level accounting class. Once you understand the function, you can adapt this to your own needs by changing the headings and questions. We used Microsoft...

...Student ID: 21709822
Exam: 038229RR - Microsoft Excel
When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you
hit Submit Exam. If you need to exit before completing the exam, click Cancel Exam.
Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page
break, so be sure that you have seen the entire question and all the answers before choosing an answer.
1. The order of precedence is very important when building formulas in Excel. Which of the following
formulas will produce 778 as the result?
A. =25*(27/9 + 5) + 309*2
B. =25*27/9 + 5 + 309*2
C. =25*((27/9 + 5) + 309*2)
D. =(25*(27/9) + 5 + 309)*2
2. Which of the following identifies the patterns used for each data series in a chart?
A. The horizontal and vertical axes
B. Data series
C. Legend
D. Data point
3. Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot
table?
A. When Helga created the pivot table, Excel automatically put the fields to the appropriate cells of the pivot table. There aren't
two ways to set up a pivot table.
B. Helga can check the field or type in the data in the pivot table.
C. Helga can drag the fields to the four boxes in the pivot table field list or right-click a field name and choose its location from
the shortcut menu.
D. Helga can slide cells to the four boxes or double-click...

...-------------------------------------------------
Excel Assignment #1
Exercise 1: Student Grade Book (expected time – less than 45 minutes)
Please download the spreadsheet Excel Assignment 1.xlsx from Blackboard. Click on worksheet E1 (you may be in Worksheet E1 by default). This spreadsheet keeps track of students’ grades. There are two exams – Exams 1 and Exam 2.
Please do the following:
(a) Find the total weighted score for the semester based on Exam 1 and Exam 2 and their respective weights. (i.e., Exam 1 * Weight 1 + Exam 2 * Weight 2) Exam 1 is weighted 45% of the total, and Exam 2 is weighted 55% of the total. These weights are in cells B4 & C4. (Hint: you might want to use absolute cell references when referring to these cells.) This formula belongs in the Weighted Total column. You MUST use absolute cell references to get credit for this question.
(b) Find the average (AVERAGE), standard deviation (STDEV), maximum (MAX), and minimum (MIN) for Exam 1, Exam 2 and Total Weighted Score. (Click on the “Formulas” tab and then select “Insert Function.” Select “Statistical” from the category drop down box.) Put these formulas in cells B40:D43, as appropriate.
(d) You have two more columns called Consistent A and Consistent C or D. Display “Yes” in the Consistent A if the student scored 90 or above on both exams. Otherwise, display “No.” Similarly, display “Yes” in the Consistent C or D column if the student received a score less...

...DISCUSSION:
After using both languages, Microsoft Excel and MATLAB (MATrix LABoratory), on the same module experiments from 1 to 4, I observed the following:
* For Microsoft excel,
* It uses spreadsheet application where each elements or data values are distributed in cells.
* Most statistical computations are easy to solve due to the manner of data organization where data are inserted on cells arranged in numbered rows and letter-named columns.
* It is easy to plot the selected values by just choosing the selected data then use the chart tools/design tab.
* The Disadvantage of this language are as follows:
* Difficulty in debugging the error
* Limited set of statistical tools
* In the case of excessively large results, Excel returns #NUM! instead of an answer
* Inability to handle large datasets
* For MATLAB,
* It uses matrix based algorithms hence each element or data values are treated in an m row by n column, such that a single integer is considered a matrix of one row and one column.
* Manipulation of vectors is easily done by one command.
* To plot, matlab needs to use certain algorithms which are compiled in an M-file.
* The Disadvantage of this language are as follows:
* Expensive wherein every single toolbox has to be paid due to its licensure
* It uses a huge amount of computer memory; hard...

...Microsoft Excel Exercise
IT/206
September 19, 2011
Patrica Byerly
Microsoft Excel Exercise
Situation 1: A business professional wants to use Microsoft Excel to organize data for the monthly expense report. He has never used Microsoft Excel and is inquiring about the functions that would support him with this task.
The approach that should be used to for this customer is to explain the functions that would help the customer to organize his spreadsheets for his monthly expense report. I would also explain to the customer that he may add formulas to the spreadsheet that will add up the totals for him, to help him get it done quicker. I would tell the customer that he could set it up to give him the total expenses by the day, week and also the month. I would also tell the customer that he could also set it up to calculate the totals spent on transportation, food, and motel expenses. Additionally, he could also calculate the fuel, entertainment, phone, and misc. expenses. I would also alert the customer that using filters will help narrow down data for an easy view without having to look all over the data to find what he is looking for, such as how much was spent on the motel stay. I would then tell the customer that he can add graphs and charts to show what was spent in each category, whether it was by the day, week, or month. I would let him know that if he decides to use graphs and charts it would be an easy...

...Microsoft Excel 2007: Create a macro by using Microsoft Visual Basic | Add to Favorites |
In Microsoft Excel 2007, macros can be created using Microsoft Visual Basic. The following will show you how to create a macro using Microsoft Visual Basic:
1. If the Developer tab is unavailable, complete the following to display it:
a. Click the Microsoft Office Button, and then click Excel Options.
b. In the Popular category, under Top options for working with Excel, choose the Show Developer tab in the Ribbon check box, and then click OK.
2. To set the security level temporarily to enable all macros, complete the following instructions:
a. On the Developer tab, in the Code group, click Macro Security.
b. Under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.
Note: To help prevent dangerous code from running, it is recommend that you return to any of the settings that disable all macros after you are finished working with macros.
3. On the Developer tab, in the Code group, click Visual Basic.
4. If needed, on the Insert menu, click Module.
Note: Modules are automatically created for all sheets in the workbook.
5. In the code window of the module, type or copy the macro code that you want to use.
6. To run the macro from the module window, press F5.
7. On the File menu, click...

...Spreadsheet Evaluation
To create an ICT solution to record and analyse costs for the Actors Associates business I chose Microsoft Excel because it presents the information in a clear way which is easy for the reader to understand. It also performs quick and easy calculations.
Use of Formulae.
In my excel spreadsheet, I used different formulae to perform calculations. Some of the formulae I used include addition and multiplication, which i believe are input correctly. I used replication to prevent inputting the same formula repetitively. This also saved time but the only problem that would have occurred, would be if the original formula was incorrect and it was replicated throughout the whole column. I also used if statements and absolute cell references in the worksheets. If statements check if a statement is true or false and inputs the data appropriate. An absolute cell reference is useful to refer to another and replicate the formula without changing that cell reference, e.g =($M$4*J4). Another useful formula I used was to linking worksheet within my spreadsheet. For example, =COST!E5. This allowed me to update data in a cell in one worksheet and have the changes applied to the appropriate cell in other worksheets.
Data Validation.
Data validation is a tool on excel which makes it possible to control the values input into a given cell. I used this tool to prevent negative numbers entering into the duration column of...