Simple Excel spreadsheets#M4

Instructions

Spreadsheet Functions Part 1

:

A.

Create a new spreadsheet that contains three separate data sets. Place each

data set onto

its own worksheet. An example list of data sets are the

following:

·

Temperature

(F)

of your city

(Orlando, Florida)

for the past 5

-

10 days

·

Scored points per game of your favorite sports team

(Liverpool Football Club)

for their past 5

-

10 games

·

Amount you paid for gas for the past few months

·

Miles flown/dri

ven per day/trip etc. for the past month

·

Most anything else you can tabulate or can track

B.

Use at least four different functions (e.g. SUM, MAX, AVERAGE, MIN,

COUNT, etc.) to summarize each data set. You choose which to use, but be

sure each worksheet has at least four.

It is acceptable if the functions are

common between the three sheets.

Sprea

dsheet Functions Part 2

:

A.

On another sheet of the same file, create a worksheet that contains data

and a calculation determining monthly payments for a proposed purchase.

Include the following:

·

Identify your dream vehicle (plane, automobile, boat, etc.) and

estimate

its cost and the interest rate if you financed its purchase.

·

Enter data (loan amount, interest rate, term, etc.) onto spreadsheet

and use the PMT function and cell references to determine the monthly

payments.

B.

Important!

The spreadsheets must be

original (student created) for this

assignment; recycled files and templates are not permitted. Start with a

new worksheet and create from scratch.

Instructions

Spreadsheet Functions Part 1:

A. Create a new spreadsheet that contains three separate data sets. Place each

data set onto its own worksheet. An example list of data sets are the

following:

 Temperature(F) of your city (Orlando, Florida) for the past 5-10 days

 Scored points per game of your favorite sports team (Liverpool Football Club)

for their past 5-10 games

 Amount you paid for gas for the past few months

 Miles flown/driven per day/trip etc. for the past month

 Most anything else you can tabulate or can track

B. Use at least four different functions (e.g. SUM, MAX, AVERAGE, MIN,

COUNT, etc.) to summarize each data set. You choose which to use, but be

sure each worksheet has at least four. It is acceptable if the functions are

common between the three sheets.

Spreadsheet Functions Part 2:

A. On another sheet of the same file, create a worksheet that contains data

and a calculation determining monthly payments for a proposed purchase.

Include the following:

 Identify your dream vehicle (plane, automobile, boat, etc.) and estimate

its cost and the interest rate if you financed its purchase.

 Enter data (loan amount, interest rate, term, etc.) onto spreadsheet

and use the PMT function and cell references to determine the monthly

payments.

B. Important! The spreadsheets must be original (student created) for this

assignment; recycled files and templates are not permitted. Start with a

new worksheet and create from scratch.