pls answer this Enter the formula to find COMM X00 MS Excel Practical Questions-xb My Questions | bartlebyX +A Not secure pmc.edu.np/department-of-statistics-and-computer-science/public/uploads/Pdffile/00%20MS%20Excel%20Practical%20Questions-11257. Le *....I Apps M GmailYouTube 9 MapsTranslate ¢ Settings - Passwords ! Downloads* Photos - Google Ph.45+ Birthday Wishe.How to Speed Up.E Reading list00 MS Excel Practical Questions-11257.pdf/6 |+ | 8 O3 /6 -100%|A.B.DPanda EST1.Monthly Sales Report - July3.Sales Amount160018001500SalaryComissionTotal Salary4 Emp. No. NameTAhmedS S101250030006 S1057 51128 S1079 S110HassanAliWaleedMohammed220020004500|1700350010 S103Samir1600250011312TotalsAverageHighest131415Lowest16Counta) Create the worksheet shown above.b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E& F: 14.c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% ofsales, COMMISSION = SALES * 2% Copy the formula to the remaining employees.let.d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY =4SALARY + COMMISSION Copy the formula to the remaining employees.e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy theformula to each column.f) Format numeric data to include commas and two decimal places.g) Align all column title labels horizontally and vertically at the center.h) Create a Header that includes your name in the left section, page number in the centersection, and your ID number in the right section.i) Create footer with DATE in the left section and TIME in the right section.j) Save the file with name panda EST.12:02O Type here to searchA O T 4) ENG11-02-2022Tools a Enter the formula to find COMM X00 MS Excel Practical Questions-xb My Questions | bartlebyX +A Not secure pmc.edu.np/department-of-statistics-and-computer-science/public/uploads/Pdffile/00%20MS%20Excel%20Practical%20Questions-11257. Le *....I Apps M GmailYouTube 9 MapsTranslate ¢ Settings - Passwords ! Downloads* Photos - Google Ph.45+ Birthday Wishe.How to Speed Up.E Reading list00 MS Excel Practical Questions-11257.pdf/6 |+ | 8 O3 /6 -100%|A.B.DPanda EST1.Monthly Sales Report - July3.Sales Amount160018001500SalaryComissionTotal Salary4 Emp. No. NameTAhmedS S101250030006 S1057 51128 S1079 S110HassanAliWaleedMohammed220020004500|1700350010 S103Samir1600250011312TotalsAverageHighest131415Lowest16Counta) Create the worksheet shown above.b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E& F: 14.c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% ofsales, COMMISSION = SALES * 2% Copy the formula to the remaining employees.let.d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY =4SALARY + COMMISSION Copy the formula to the remaining employees.e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy theformula to each column.f) Format numeric data to include commas and two decimal places.g) Align all column title labels horizontally and vertically at the center.h) Create a Header that includes your name in the left section, page number in the centersection, and your ID number in the right section.i) Create footer with DATE in the left section and TIME in the right section.j) Save the file with name panda EST.12:02O Type here to searchA O T 4) ENG11-02-2022Tools a

Question

pls answer this Enter the formula to find COMM X00 MS Excel Practical Questions-xb My Questions | bartlebyX +A Not secure pmc.edu.np/department-of-statistics-and-computer-science/public/uploads/Pdffile/00%20MS%20Excel%20Practical%20Questions-11257. Le *....I Apps M Gmail>YouTube 9 MapsTranslate ¢ Settings - Passwords ! Downloads* Photos - Google Ph.45+ Birthday Wishe.How to Speed Up.E Reading list>>00 MS Excel Practical Questions-11257.pdf/6 |+ | 8 O3 /6 -100%|A.B.DPanda EST1.Monthly Sales Report - July3.Sales Amount160018001500SalaryComissionTotal Salary4 Emp. No. NameTAhmedS S101250030006 S1057 51128 S1079 S110HassanAliWaleedMohammed220020004500|1700350010 S103Samir1600250011312TotalsAverageHighest131415Lowest16Counta) Create the worksheet shown above.b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E& F: 14.c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% ofsales, COMMISSION = SALES * 2% Copy the formula to the remaining employees.let.d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY =4SALARY + COMMISSION Copy the formula to the remaining employees.e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy theformula to each column.f) Format numeric data to include commas and two decimal places.g) Align all column title labels horizontally and vertically at the center.h) Create a Header that includes your name in the left section, page number in the centersection, and your ID number in the right section.i) Create footer with DATE in the left section and TIME in the right section.j) Save the file with name panda EST.12:02O Type here to searchA O T 4) ENG11-02-2022Tools a Enter the formula to find COMM X00 MS Excel Practical Questions-xb My Questions | bartlebyX +A Not secure pmc.edu.np/department-of-statistics-and-computer-science/public/uploads/Pdffile/00%20MS%20Excel%20Practical%20Questions-11257. Le *....I Apps M Gmail>YouTube 9 MapsTranslate ¢ Settings - Passwords ! Downloads* Photos - Google Ph.45+ Birthday Wishe.How to Speed Up.E Reading list>>00 MS Excel Practical Questions-11257.pdf/6 |+ | 8 O3 /6 -100%|A.B.DPanda EST1.Monthly Sales Report - July3.Sales Amount160018001500SalaryComissionTotal Salary4 Emp. No. NameTAhmedS S101250030006 S1057 51128 S1079 S110HassanAliWaleedMohammed220020004500|1700350010 S103Samir1600250011312TotalsAverageHighest131415Lowest16Counta) Create the worksheet shown above.b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E& F: 14.c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% ofsales, COMMISSION = SALES * 2% Copy the formula to the remaining employees.let.d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY =4SALARY + COMMISSION Copy the formula to the remaining employees.e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy theformula to each column.f) Format numeric data to include commas and two decimal places.g) Align all column title labels horizontally and vertically at the center.h) Create a Header that includes your name in the left section, page number in the centersection, and your ID number in the right section.i) Create footer with DATE in the left section and TIME in the right section.j) Save the file with name panda EST.12:02O Type here to searchA O T 4) ENG11-02-2022Tools a

Accepted Answer

Answer:
I have given answered in the handwritten format in brief explanation.