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.
C
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 fo
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
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
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 fun
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 Acce
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 s
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 ma
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, ty
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
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
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
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 an
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 SU
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
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 creat
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
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
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
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 su
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 paymen
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
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
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 autom
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,
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 informa
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 r