# Do some Excel Work

Name the Workbook “Excel Project_Your Name” and the Worksheet “Excel Project”

Color the worksheet tabs (any color)

Create the items as shown on the sample spreadsheet

Use the title style for the titles

Format the background cells for all areas similar to what is used - Cell Styles

Create the Car Loan Area

Enter the data as given in the sample

Use formulas to determine the monthly payment, total interest, total cost and loan amount –< /i> formulas given in the PowerPoint lesson

Insert the current date (use function for exact date to update automatically)

Input a data validation for the number of years to between 4 and 6. Use this as the error message – “ Loan must be between 4 and 6 years”< /font>

“Name” the cells for all cells (this is more than simply typing the names in the cells—“ Naming a cell” is specifically discussed in the PPT lesson posted)

Create an Interest Rate Schedule table as shown in the sample and discussed in the PPT

Use formulas to copy the data for monthly payment, total interest and total cost to the Interest Rate Schedule table

Use “ What-If” Analysis to determine an Interest Rate table

Enter the percentages for everything above 5.25% by using the fill handle

Use conditional formatting to change the formatting of all cells containing the monthly payment – make their formatting appear differently as shown in the example

Create the Grade table as shown in the sample

Format accordingly using Cell Styles and add filters so it can be sorted

Create the Criteria table

Use the DAverage and CountIF formulas to answer the questions given. Formulas must be used to calculate this data.

Average Female Age

Average male Age

B Students

Name each range (I.E. Car Loan, Interest Rate Schedule, Grades, etc.)

Insert a header with “ITEC 3000: Microsoft Excel Project” as the title – Bold, 12 point font – in the center; your name at the right

Insert a footer with the Date -use the formula in the custom footer to do this

Set print area to print only certain sections (I.E. Car Loan, Interest Rate Schedule, Grades)

Evner: Dataindførsel, Databehandling, Excel

Om arbejdsgiveren:
( 5 bedømmelser ) Norfolk, United States

Projekt ID: #6051932

## Tildelt til:

diptiranjan123

I have gone through this project and I can do [login to view URL] send the format in which you need the job to be done. Waiting for your reply. Regards, Diptiranjan

\$30 USD in 3 dage
(4 bedømmelser)
1.6

## 4 freelancere byder i gennemsnit \$113 på dette job

altafsyed

A proposal has not yet been provided

\$155 USD in 3 dage
(3 bedømmelser)
1.5
wsnavarathne

Hi I am a data entry operator. I am good at data entry. I have skills to do this job. My skills are Ms word ,Ms Excel Ms Power Point and Ms Access i will do this job on time and accurately

\$155 USD in 3 dage
(0 bedømmelser)
0.0
mohamedsuhail669

A proposal has not yet been provided

\$111 USD in 7 dage
(0 bedømmelser)
0.0