# COMPLETED THE EXCEL

 Project 1 Sales 2019 Sheet Overview You track the invoices of food sales for your company. You need to format and calculate sale totals. Tasks ☐ 1 Open the Practice Exam 1 workbook. ☐ 2 Rename the Sales sheet to 2019 Sales. ☐ 3 Without deleting the text, remove the hyperlink from A3 on the 2019 Sales sheet. ☐ 4 Apply the Title Style to cell A3. ☐ 5 Wrap the text in row 6, then center it. ☐ 6 Merge without centering A3:G3. Then make it 24pt. and bold. ☐ 7 Create formulas to complete each of the invoice totals in the Total column. ☐ 8 Create Named Ranges:  Name: SaleAmount       Cell range: D7:D24 Name: TaxAmount          Cell range: E7:E24 Name: ShipAmount        Cell range: F7:F24 ☐ 9 In cell K7, use the correct named range (SaleAmount) in a function to calculate the total sales of the items. In cell K8, use the correct named range in a function to calculate the total tax. In cell K9, use the correct named range in a function to calculate the total shipping. ☐ 10 Format K7:K9 as Currency with 2 decimals. ☐ 11 Set the print orientation to Landscape. ☐ 12 Type your full name in C25. ☐ 13 Without deleting the column or any of the data, modify the Name column so it doesn’t show.

 Project 4 Ledger Sheet Overview You need to analyze customer’s bank transactions for certain expenses. Tasks ☐ 1 On the Ledger sheet, create a table from the data in A3:E66. Apply the style Orange, Table Style Medium 3. Sort the data by Name (A to Z) and Date (oldest to newest). It is only one sort. ☐ 2 In cell H4 use a formula to find the number of expenses for rent. In cell H5 use a formula to find the number of expenses on or before 2/15/2019. Hint: COUNTIF. ☐ 3 In cell H7 use a formula to find out the total amount of transactions for rent. In cell H8 use a formula to find out the total amount of transactions on or after 2/16/19.  Hint: SUMIF. ☐ 4 Display the Total of all expenses by using the Total Row. ☐ 5 Give the table a name with your firstIntitialLastName, e.g. JSmith. Hint: On the Table Tools, Design Tab, Properties group.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.