Interactive Loan Calculator
Lab 2, Step 4
A. Design the application.
Begin by creating the basic design for this application. Create a title section and labels as
follows:
B. Enter the calculations.
Create the Down Payment calculations. Multiply the price
LAB 1, STEP 2a
Calculate Profit per Item
A. Click in Cell C5 to enter the formula.
B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated
value.
C. The profit margin for this sale is 50%. Click cell B5, enter the multiplica
Using the PMT function
Lab 2, Step 2d
Select Cell G4 and use the Insert Function icon to open the PMT function wizard:
Search for the PMT function and then click OK to open the wizard:
Now we need to provide the arguments:
Rate-This is the interest rate p
LAB 1, STEP 2b
Calculate Sales per Item
A. Click in Cell N5 to enter the formula.
B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated
value.
C. Total sales per item is the sum of all daily sales for this period. Use the
Using the VLOOKUP function
Lab 2, Step 2a
In this step, you will use the VLOOKUP function to determine the interest rate of a loan
based on the number of years of the loan.
We will use the VLOOKUP function wizard to help create the formula.
Click on Cell
Create a Database Table
Lab 7, Step 1
A. Open Access and create a new database named Lab7_yourlastname.accdb.
Access the iLabs and open the Office 2010 application folder. Select Access 2010:
The Access 2010 screen will open in the New tab of the File men
LAB 1, STEP 2e
Calculate Percent Profit for Each Item
A. Click in Cell P5.
B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated
value:
C. Select O5, type a division symbol (/), and then select D15:
D. Type a dollar sign (
Using the VLOOKUP function
Lab 2, Step 2b
A. Create the VLOOKUP function.
In this step, we can begin by using the same VLOOKUP function as we created in Step
A. Think about the change(s) we need to make.
Lookup_value This will remain the same
Table_array
LAB 1, STEP 2c
Calculate Profit per Item
A. Click in Cell O5 to enter the formula.
B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated
value.
C. Click on Cell C5, type a multiplication sign (*), and then click on cell N5
Step-by-Step Instructions
Step 4
Layout Worksheet
A. Change the color of the first tab to Brown. Right click on the sheet tab and select
Tab Color:
B. Rename and change the second tab. Right click on the second tab and select
Rename. Type the name Fundrai
Trendline Chart
Steps 5b
A. You should have a data set that includes daily profit per item and total profit:
B. Select the data you wish to chart, the dates and the Totals. Select noncontiguous
cells by holding down the CTRL key:
C. From the Insert Tab, g
BIS155 Final Exam Study Guide
The Final Exam has a total of five essay questions. The focus of the exam is to evaluate your ability to select and apply appropriate
tools/concepts based on descriptions of common business situations.
Topic
TCO 1 through 9:
Step-by-Step Instructions
Step 3b
Format Spreadsheet
A. Separate the Header information and the summary information from the data.
Insert a row between Rows 3 and 4 (between the row containing GOAL and the
row with column headings Item, Sales Price, and s
LAB 1, STEP 2d
Calculate Total Profit to Date and Remaining Profit Needed
A. Click in Cell D15.
B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated value.
C. Type SUM and an open parenthesis to enter the total of a range
Week 8 : Final Exam - Final Exam
Time Remaining:
Page 1
1. (TCOs 2, 3, 7, 9) You currently work for an automotive parts supply store. Your company is growing
and is considering expansion. The company currently has three locations (North, South, and Centra
Step-by-Step Instructions
Step 5a
Create a Pie Chart
Begin by extracting the data you will need for your chart. It is much simpler to work
with the specific data you need. The pie chart you will create includes the Items and the
percentage of profits. Sel
Sort Sales Data
Lab 3, Step 3
A. Make a copy of the Sales Data in order to ensure that you have a backup copy of the
original data.
Right click on the Sales Data tab and select Move or Copy:
Make sure that you click the Create a Copy checkbox and select M
Step-by-Step Instructions
Step 3a
Insert a Comment
Comments are generally used to explain the formula behind the data in a cell or to
explain what type of data is appropriate in a column.
A. To insert a comment, select the cell in which you wish to place
Transcript
Hello and welcome. Do you need to do some work in Excel, but youre not quite sure
how to get started? The first time I used Excel, my manager asked me to type a list of
names in it, and for a long time, I thought thats all you used it for. But
Filter Sales Data
Lab 3, Step 4
A. Make a copy of the Sales Data in order to ensure that you have a backup copy of the original data.
Right click on the Sales Data Tab and select Move or Copy:
Make sure that you click the Create a Copy checkbox and select
Week 2 Transcript
Worksheet functions greatly expand what you can do in a formula.
Yes, you can add or multiply numbers by using math operators, like this.
But what if you want to calculate the payment for a car loan? Or quickly find the
largest number in
Transcript
Welcome to the course. One of the great things about Excel is that you can use it to
calculate all sorts of things from doing basic math, finding the cost of monthly
payments. You can even use a formula to tidy up a list of incorrectly capitali
Week 1 Transcript
I can turn that series into pie chart that visually shows each value as a percentage of
the whole pie.
Let me show you how easy it is to create such a chart.
I like the 3-D look, so Ill click this chart type.
For a new look, Ill choose a
Transcript
In the last movie, I did math by typing numbers into formulas. Now, Ill show you how to
create formulas by using cell references. Then when I change a value in a cell, youll
see Excel automatically update the formula result. You may already be
Week 3 Transcript
So whats a table in Excel? Its a way to store related information.
Here Ive got rows of data with descriptive headings at the top of each column.
Country, Salesperson, Order Amounts, Order Dates and Order IDs.
But wait this isnt a table.
Week 3 Transcript
Converting a range of data into a table is simple to do and helps make your data
easier to work with.
On this worksheet, I have a list of product sales by quarter.
All of the information is here, but its not very easy to read or work wit
Transcript
What you see here is a list of names. These are salespeople, and these are the amounts
that they sold during Week 1 and Week 2, and Id like to get the total of their sales for
Week 1. Its really easy to get that total by using a prewritten form