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
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
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
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
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
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
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
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 f
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
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
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 decreas
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 Var
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