50.1K

Verified Solution

Link Copied!

Can you solve each sheet please. show how it was done step by step

Issessment SUMMARIZE DATA IN MULTIPLE WORKSHEETS USING RANGE NAMES SNAP Grade it 1. Open NADQI Fees.xlsx. 2. Save the workbook and name it EL2-C4-A1-NADQI Fees. 3. The workbook contains three worksheets showing dental fees earned in January, February, and March for three dentists at a dental clinic. Create a range name in cell F13 of each worksheet to reference the total fees earned by each dentist for the quarter as follows: a. Type Popovich Total as the name for cell F13 in the Popovich worksheet. b. Type VanketTotal as the name for cell F13 in the Vanket worksheet. c. Type JovanovicTotal as the name for cell F13 in the Jovanovic worksheet. 4. Make Fee Summary the active worksheet and then type the following label in cell A6: Quarter 1 fees for Popovich, Vanket, and Jovanovic, 5. Make cell F6 the active cell and create a Sum formula to add the total fees earned by each dentist using the range names created in Step 3. 6. Apply accounting formatting to cell F6 and then adjust the column width to AutoFit. 7. Print the Fee Summary worksheet. 8. Save and then close EL2-C4-A1-NADQI Fees.xlsx. NewAge Dental Services Fee Revenue Summary Conditional Formatting 1 2 3 General Examinations 4 Cleanings and Fillings 5 Teeth Whitening 6 Bonding 7 Porcelain Veneers 8 Crowns and Bridges 9 Full and Partial Dentures 10 Emergency Extractions 11 Root Canals 12 13 Total K. Popovich January February March $ 1,675.44 $ 1,075.44 $ 1,447.52 3,675.58 2,615.58 2,096.52 2,068.45 2,641.25 3,345.77 3,035.64 3,555.25 4,358.58 5,674.21 3,685.67 3,671.52 1,086.52 4,667.63 3,348.57 1,687.45 2,675.48 5,623.85 845.50 635.85 685.40 1,852.42 1,402.75 3,014.25 Total $ 4,198.40 8,387.68 8,055.47 10,949.47 13,031.40 9,102.72 986 78 Cell Styles 6,269.42 $ 21,601.21 $ 22,954.90 $ 27,591.98 $ 72,148.09 14 15 16 17 18 19 20 21 22 23 24 25 26 W. Vanket January February $ 1,075.46 $ 986.45 $ 2,613.65 2,075.42 675.45 3,352.44 954.23 1,358.00 March 999.48 1,885.42 1,085.42 985.41 Total $ 3,061.39 6,574.49 5,113.31 3,297.64 1,345.75 2,554.75 2,643.85 1,875.84 655.47 1,085.45 1,885.07 3,315.75 315.63 1,345.74 5,874.67 7,746.34 971.10 2,431.19 $ 9,219.29 $ 14,032.92 $ 11,817.92 $ 35,070.13 1 2 3 General Examinations 4 Cleanings and Fillings 5 Teeth Whitening 6 Bonding 7 Porcelain Veneers 8 Crowns and Bridges 9 Full and Partial Dentures 10 Emergency Extractions 11 Root Canals 12 13 Total 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 FeeSummary Format as Table Popovich Vanket Jovanovic + S. Jovanovic January February March 623.57 $ 1,324.52 $ 1,063.45 3,345.75 4,325.37 3,125.48 $ Total $ 3,011.54 10,796.60 1,845.74 2,348.75 2,076.34 6,270.83 3,324.85 4,375.32 2,545.00 3,365.85 455.74 1,304.78 1,885.43 2,946.53 514.66 1,674.22 7,755.28 10,687.70 970.40 2,979.00 $ 13,486.43 $ 15,698.81 $ 13,286.11 $ 42,471.35 1 2 3 General Examinations 4 Cleanings and Fillings 5 Teeth Whitening 6 Bonding 7 Porcelain Veneers 8 Crowns and Bridges 9 Full and Partial Dentures 10 Emergency Extractions 11 Root Canals 12 13 Total 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 FeeSummary Cell Styles Jovanovic + Popovich Vanket Issessment SUMMARIZE DATA IN MULTIPLE WORKSHEETS USING RANGE NAMES SNAP Grade it 1. Open NADQI Fees.xlsx. 2. Save the workbook and name it EL2-C4-A1-NADQI Fees. 3. The workbook contains three worksheets showing dental fees earned in January, February, and March for three dentists at a dental clinic. Create a range name in cell F13 of each worksheet to reference the total fees earned by each dentist for the quarter as follows: a. Type Popovich Total as the name for cell F13 in the Popovich worksheet. b. Type VanketTotal as the name for cell F13 in the Vanket worksheet. c. Type JovanovicTotal as the name for cell F13 in the Jovanovic worksheet. 4. Make Fee Summary the active worksheet and then type the following label in cell A6: Quarter 1 fees for Popovich, Vanket, and Jovanovic, 5. Make cell F6 the active cell and create a Sum formula to add the total fees earned by each dentist using the range names created in Step 3. 6. Apply accounting formatting to cell F6 and then adjust the column width to AutoFit. 7. Print the Fee Summary worksheet. 8. Save and then close EL2-C4-A1-NADQI Fees.xlsx. NewAge Dental Services Fee Revenue Summary Conditional Formatting 1 2 3 General Examinations 4 Cleanings and Fillings 5 Teeth Whitening 6 Bonding 7 Porcelain Veneers 8 Crowns and Bridges 9 Full and Partial Dentures 10 Emergency Extractions 11 Root Canals 12 13 Total K. Popovich January February March $ 1,675.44 $ 1,075.44 $ 1,447.52 3,675.58 2,615.58 2,096.52 2,068.45 2,641.25 3,345.77 3,035.64 3,555.25 4,358.58 5,674.21 3,685.67 3,671.52 1,086.52 4,667.63 3,348.57 1,687.45 2,675.48 5,623.85 845.50 635.85 685.40 1,852.42 1,402.75 3,014.25 Total $ 4,198.40 8,387.68 8,055.47 10,949.47 13,031.40 9,102.72 986 78 Cell Styles 6,269.42 $ 21,601.21 $ 22,954.90 $ 27,591.98 $ 72,148.09 14 15 16 17 18 19 20 21 22 23 24 25 26 W. Vanket January February $ 1,075.46 $ 986.45 $ 2,613.65 2,075.42 675.45 3,352.44 954.23 1,358.00 March 999.48 1,885.42 1,085.42 985.41 Total $ 3,061.39 6,574.49 5,113.31 3,297.64 1,345.75 2,554.75 2,643.85 1,875.84 655.47 1,085.45 1,885.07 3,315.75 315.63 1,345.74 5,874.67 7,746.34 971.10 2,431.19 $ 9,219.29 $ 14,032.92 $ 11,817.92 $ 35,070.13 1 2 3 General Examinations 4 Cleanings and Fillings 5 Teeth Whitening 6 Bonding 7 Porcelain Veneers 8 Crowns and Bridges 9 Full and Partial Dentures 10 Emergency Extractions 11 Root Canals 12 13 Total 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 FeeSummary Format as Table Popovich Vanket Jovanovic + S. Jovanovic January February March 623.57 $ 1,324.52 $ 1,063.45 3,345.75 4,325.37 3,125.48 $ Total $ 3,011.54 10,796.60 1,845.74 2,348.75 2,076.34 6,270.83 3,324.85 4,375.32 2,545.00 3,365.85 455.74 1,304.78 1,885.43 2,946.53 514.66 1,674.22 7,755.28 10,687.70 970.40 2,979.00 $ 13,486.43 $ 15,698.81 $ 13,286.11 $ 42,471.35 1 2 3 General Examinations 4 Cleanings and Fillings 5 Teeth Whitening 6 Bonding 7 Porcelain Veneers 8 Crowns and Bridges 9 Full and Partial Dentures 10 Emergency Extractions 11 Root Canals 12 13 Total 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 FeeSummary Cell Styles Jovanovic + Popovich Vanket

Answer & Explanation Solved by verified expert

See Answer