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
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
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
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
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
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
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
Copying Files Across Workbooks
Lab 5, Step 1
A. Save all of the wk5_Chap7_cap iLab files to one folder. You should have the
following files:
B. Open the Summary workbook in Excel.
C. Open one of the files you wish to consolidate into this workbook. From t
Week 4 Transcript
I have info in a text file that I want to get into my worksheet, but I sure dont want to
retype it.
Theres a tool in Excel that can help me: The Text Import wizard.
Ill open my text file in Notepad, and I see that the values in each row
Creating 3D Cell References and Using Worksheet Grouping
Lab 5, Step 2
Make sure that the Lab 5 Summary file is open in Excel.
A. Fill in the first formula required using 3D cell reference to refer to data on multiple
worksheets.
Select Cell B3 on the Sum
Image Description
This is a custom column chart titled Major Sales Increase in Delivery Service with
vertical bars representing Dine-In, Pick-up, and Delivery amounts.
Over time, Dine-in sales decreased, Pick-Up sales stayed steady, and Delivery
sales gra
Image Description
This screen displays an income statement for the company, Day Care Wonders.
The spreadsheet includes data fields for the following categories: Assumptions,
Annual Revenue, Annual Variable Expenses, Annual Fixed Expenses, and a
Summary fo
Creating a One-Variable Data Table
Lab 6, Step 2
A. Set up your One-Variable Data Table
Create headings that describe the data table. Your columns will be labeled Initial Values
and then 6 through 15 (number of children) and your rows will be labeled Expe