![Computer Networking: A Top-Down Approach (7th Edition)](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
pls answer this
![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](https://content.bartleby.com/qna-images/question/07fbf2b7-d144-4172-ace8-8dcda4d841c1/c48c4d8e-9c58-4e4f-b154-81a8a8a2c606/7z3dat_thumbnail.jpeg)
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
![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](https://content.bartleby.com/qna-images/question/07fbf2b7-d144-4172-ace8-8dcda4d841c1/c48c4d8e-9c58-4e4f-b154-81a8a8a2c606/7biuqmf_thumbnail.jpeg)
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
![Check Mark](/static/check-mark.png)
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 nowThis is a popular solution!
Step by stepSolved in 3 steps with 1 images
![Blurred answer](/static/blurred-answer.jpg)
Knowledge Booster
Similar questions
- Which of the following is done last in the order of operations? Squaring Addition Multiplication Summation (S)arrow_forward(p ↔ q) ⊕ (p ↔ ¬q)arrow_forwardQUESTION 5 Which of the following would have orthonormal eigenvectors? 100 10 0 0 1 A = A = 1 2 3 245 356 All of the above 1 20 2 3 4 1 4 1 A =arrow_forward
- What is the value in al in a,b,c, and d? mov al,6Bhshr al,1 a. shl al,3 b. mov al,8Ch sar al,1 c. sar al,3 d.arrow_forwardDiscrete math truth tables. Pklease make a table and show me how to do this I do not understand this.arrow_forwardAND TRUTH TABLE TRUE FALSE NULL TRUE (a) (d) (g) FALSE (b) (e) (h) NULL (c) (f) (i) Use the space provided to answer for each letter. Note: Blank #1 corresponds to (a), Blank #2 corresponds to (b), and so forth. Blank # 1 Blank # 2 Blank # 3 Blank # 4 Blank # 5 Blank # 6 Blank # 7 Blank # 8 Blank # 9 N N N 1 A A A/arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY