Question: Open a new workbook save the file as Excel 8. 2. Delete Sheet2 and Sheet3. 3. Enter the labels and values in the exact cells

Open a new workbook save the file as Excel 8. 2. Delete Sheet2 and Sheet3. 3. Enter the labels and values in the exact cells locations as desired. 4. Use AutoFill to insert the Customer IDs. 5. Set labels alignment appropriately. 6. Use Warp Text, Text Orientation and Merge Cells as desired. 7. Apply borders, gridlines and shading to the table as desired. 8. Format Colum E & D to Currency with dollar sign and two decimal places. 9. Find the Total Annual Purchases for each City. 10. Find the Average Annual Purchases for each Education. 11.Find the total number of each gender. 12. Find the total annual salary for each gender in each city. 13. Create the following Chart: Please make it in excel sheet and send it to me on my g m a i l : m o h a m m m a d 1 2 3 4 5 6 @ g m a i l . C o m

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The mechanism shown is used to lower disabled persons into a whirlpool tub for therapeutic treatment. In the unloaded configuration, the weight of the boom and hanging chair induces a compressive...

Hello, Please assist. Drawing Tools Project 5 Workbook - Excel Toni Sandridge X File Home Insert Page Layout Formulas Data Review View Help Acrobat Format Tell me what you want to do Share Cut...

Please assist. I am having trouble. Drawing Tools Project 5 Workbook - Excel X File Home Insert Page Layout Formulas Data Review View Help Acrobat Format Tell me what you want to do Share Cut Copy...

please help with solution Objectives: Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows. - Formatting Worksheets. - AutoFill, Numeric formats, previewing worksheets. 1. Open a...

G Payroll Net Pay 1 2 Date: 1/1/2011 EMPL EMPL Name 3 Number 4 E00001 Ford 5 E00002 Mino 6? Bell 7 ? Davis 8? Turro Hourly Rate 7.5 8 6.5 9 10 Hours Gross Payl S.S Tax Worked 35 ? ? 30 ? ? 25/? ?...

kindly help with the excel questions give the excel spreadsheet formulas to get the answers MS Excel Practical Questions: QNo. 1. Objectives: - Introduction to MS Excel files, Workbooks, Worksheets,...

help with the screen shot questions by helping with the formulas to the excel spreadsheet and the answers MS Excel Practical Questions: QNo. 1. Objectives: - Introduction to MS Excel files,...

help with the above question MS Excel Practical Questions: QNo. 1. Objectives: - Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows. - Formatting Worksheets. - AutoFill, Numeric...

Exercise 2 ITEM NO. OF ITEM NO. ITEMS PRICE TAX TOTAL TOTAL PRICE PRICE BEFORE AFTER TAX TAX RATE 2 100 101 5 115 256 49 23 840 200 294 4 30 12 56 150 5 56 300 90 7 0 ? ? 1 Count of items 2 Average...

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

Your corporation's 2021 balance sheet has current assets of $5,120 and current liabilities of $4,491. Your 2022 corporation's balance sheet has current assets of $5,320 and current liabilities of...

Calculate the missing amounts. Net sales Cost of goods sold Gross profit from sales Operating expenses Profit (loss) b $ 212,700 $ 167,700 S 77,700 42,900 a 110,800 92,900 93,900 (30,100) 4 C (4,600)...

course is Health Services Management Define decision making and describe who makes decisions and by what methods in HCOs. reference cite needed

Let a, b and c be three quantities in a calculation. Assuming that values are rounded to 4 decimal places, calculate the upper bound on the absolute error when calculating (a + b + c) [ calculate...

2. (a) Using the above diagram, assume that the seller of X increases the price from $1.50 to $2.00, and this results in an increase in total revenue, Which of the graphs represents the demand curve...

A is nxn matrix and v 1 ,v 2 ,...,v n be linearly independent in R n . What must be true about A for Av 1 , Av 2 ,..., Av 3 to be linearly independent?

1. Let W be the space spanned by f = sin x and g = cos x. a. Show that for any value of θ, f1 = sin(x+θ) and g1 =cos(x+θ) are vectors in W b. Show that f1 and g1 form a basis for W.

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

7.27 An express mail service charges a special rate for any package that weighs less than 1 pound. Let x denote the weight of a randomly selected parcel that qualifies for this special rate. The...

7.30 Referring to Exercise 7.29, use the result of Part (a) along with the fact that a carton contains 12 eggs to determine the mean value of z the number of unbroken eggs. (Hint: z can be written...

7.29 Exercise 7.9 introduced the following probability distribution for y 5 the number of broken eggs in a carton: a. Calculate and interpret my. b. In the long run, for what percentage of cartons is...