D Panda EST Monthly Sales Report - July Salary Sales Amount 1600 1800 1500 Comission 25007 3000 Total Salary 4 Emp. No. Name Ahmed Hassan Al Waleed Mohammed Samir SS101 6 S105 7 5112 8 5107 9 5110 2200 2000 1700 1600 4500 3500 2500 10 5103 11 12 17 Totals Average Highest Lowest 13 14 15 16 Count a) 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% of sales, COMMISSION = SALES * 2% Copy the formula to the remaining employees. d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY = SALARY + COMMISSION Copy the formula to the remaining employees. e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the formula to each column. f) Format numeric data to include commas and two decimal places. 8) 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 center section, and your ID number in the right section. i) Create footer with DATE in the left section and TIME in the right section. i) Save the file with name panda EST.
D Panda EST Monthly Sales Report - July Salary Sales Amount 1600 1800 1500 Comission 25007 3000 Total Salary 4 Emp. No. Name Ahmed Hassan Al Waleed Mohammed Samir SS101 6 S105 7 5112 8 5107 9 5110 2200 2000 1700 1600 4500 3500 2500 10 5103 11 12 17 Totals Average Highest Lowest 13 14 15 16 Count a) 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% of sales, COMMISSION = SALES * 2% Copy the formula to the remaining employees. d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY = SALARY + COMMISSION Copy the formula to the remaining employees. e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the formula to each column. f) Format numeric data to include commas and two decimal places. 8) 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 center section, and your ID number in the right section. i) Create footer with DATE in the left section and TIME in the right section. i) Save the file with name panda EST.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
pls answer this
Transcribed Image Text:Enter the formula to find COMM X
00 MS Excel Practical Questions-
x
b My Questions | bartleby
X +
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 Maps
Translate ¢ 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 O
3 /6 -
100%
|
A.
B.
D
Panda EST
1.
Monthly Sales Report - July
3.
Sales Amount
1600
1800
1500
Salary
Comission
Total Salary
4 Emp. No. Name
TAhmed
S S101
2500
3000
6 S105
7 5112
8 S107
9 S110
Hassan
Ali
Waleed
Mohammed
2200
2000
4500|
1700
3500
10 S103
Samir
1600
2500
11
3
12
Totals
Average
Highest
13
14
15
Lowest
16
Count
a) 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% of
sales, 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 =
4
SALARY + COMMISSION Copy the formula to the remaining employees.
e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the
formula 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 center
section, 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:02
O Type here to search
A O T 4) ENG
11-02-2022
Tools a
Transcribed Image Text:Enter the formula to find COMM X
00 MS Excel Practical Questions-
x
b My Questions | bartleby
X +
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 Maps
Translate ¢ 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 O
3 /6 -
100%
|
A.
B.
D
Panda EST
1.
Monthly Sales Report - July
3.
Sales Amount
1600
1800
1500
Salary
Comission
Total Salary
4 Emp. No. Name
TAhmed
S S101
2500
3000
6 S105
7 5112
8 S107
9 S110
Hassan
Ali
Waleed
Mohammed
2200
2000
4500|
1700
3500
10 S103
Samir
1600
2500
11
3
12
Totals
Average
Highest
13
14
15
Lowest
16
Count
a) 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% of
sales, 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 =
4
SALARY + COMMISSION Copy the formula to the remaining employees.
e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the
formula 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 center
section, 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:02
O Type here to search
A O T 4) ENG
11-02-2022
Tools a
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY