Good Evening

 I'm looking for help on the following homework.  I uploaded the following file to help the process.

Thank you very much.

Jefferson Community College
Watertown, New York Instructor Andy Smith
CIS 110-3 Introduction to Computing and Applications Excel Topic 5 - Lab
Context
You have decided to create a purchase requisition for your local college. Therefore, you will create a blank requisition
form with the following guidelines. Instructions
1.) Put your name in the Left Header. 2.) Place a centered title in the first row with the college name. 3.) Place cells to allow the user to enter their name and address (including city, state, and zip code). Place labels
next to the cells that the user data will be placed in. Unlock the cells that the name and address will be placed
in. Add bottom borders in the cells that the name and address will be placed in. 4.) Place cells to allow the user to enter the name and address of the company from whom we are purchasing
materials (including city, state, and zip code). Place labels next to the cells that the user data will be placed in.
Unlock the cells that the name and address will be placed in. Add bottom borders in the cells tha the name
and address will be placed in. 5.) Place a cell under the company name and address to hold a shipping-cost value. Place an appropriate label
next to this cell. Unlock this cell. Style this cell as currency. Add a bottom border in the cells that contains the
shipping value. 6.) Below these two areas, we will have a multi-column block of data that lists the items we want to order:
a. Include a column for Item Description. Enable wrap-text for these data cells. Unlock these cells.
b. Include a column for Quantity Ordered. Unlock these cells.
c. Include a column for Price. Unlock these cells and format them as currency format.
d. Include a column for Extended Price. Use a function to display the result of quantity ordered * price,
ONLY when the quantity ordered and item price cells have numeric information in them. Otherwise,
the cell should be empty. Unlock these cells and format them as currency format.
e. Place borders around the entire outside of this area as well as between the column headings and the
data. Shade every other row with a light grey. 7.) Under the column for extended price, place a cell that will hold a formula for a total price. The formula for
this cell should be the SUM of the extended prices along with the shipping value. Place a border around the
outside of this cell. Style this cell as currency and style the text as bold. 8.) Place a formula near the bottom right corner of the spreadsheet (according to the page layout view) to
display “An additional quote is required for this order” when the total price exceeds $400. Style this cell as
bold and italic. Jefferson Community College
Watertown, New York 9.) Instructor Andy Smith
CIS 110-3 Introduction to Computing and Applications Place a formula below the previous formula to display “A third quote is also required for this order” when the
total price exceeds $1000. Style this cell as bold and italic. 10.) Resize the columns in the spreadsheet so that the spreadsheet will be readable when the user enters
reasonable data.
11.) Set cell alignment appropriately. Column-heading rules are that you left-align above data that is left aligned,
and right-align above data that is right-aligned.
12.) Make sure you have appropriate, clear, and typo-free labels throughout your spreadsheet.
13.) Turn on worksheet protection. The only allowed feature should be selecting unlocked cells. Submission
1.) Make 3 Sample sheets based off of this Blank sheet. Sample data includes both address areas, the shipping value,
and several ordered items as described below. 2.) Sample 1 is an order that contains 4 items and the total price is lower than $400. 3.) Sample 2 is an order that contains 5 items and the total price is between $400 and $1000. 4.) Sample 3 is an order that contains 6 items and the total price is greater than $1000. 5.) Upload your spreadsheet file to Blackboard in the appropriate assignment area.

• 1493443372-Excel Topic 5 Lab Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 29 Apr 2017 05:04 AM My Price 8.00

-----------

Attachments

file 1493443374-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer