homework help

Kapalı İlan edilme: 6 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

Design a workbook named sales_LastNameFirstName to help you track your weekly sales commission.

Your name should list in cell A1 in an enlarged font size with a different color than the default color merged and centered across all columns used.

Display in a labeled cell your weekly base pay as a salesperson.

Display in a labeled cell the amount of commission earned the previous week.

Your company pays commission based upon the number of sales made in the week. The commission rate is then multiplied by the weekly base pay to compute commission amount. An English description is given below of commission rates. Use that data to create a lookup table placed on the workbook. Add a box border around the lookup table.

Number of Sales Commission Rate

1-9 3.0%

10-19 3.5%

20 or more 3.8%

Include column headings for date, number of sales, commission rate, commission amount, and total pay.

Format the column headings row with some border in a different color than the default color and each entry boldfaced and center-aligned in its cell.

Include five rows of data for the five business days Monday - Friday. For the first row, enter a particular Monday date and for remaining rows, add 1 to the previous date to compute the new date.

Use the VLOOKUP function to compute the commission rate for each day based on the number of sales.

Compute the commission amount from the commission rate and the base weekly pay.

Compute the total pay as the sum of base pay and commission amount.

Under the rows add a labeled cell and display the sum of commission amounts.

Use the IF function that compares commission amount earned this week to the previous week's value and reports some congratulatory message if the current amount exceeds the previous amount, and some other message otherwise. Format the message in boldface in the same font color as your name.

Use Currency format with two decimals on all money amounts.

Use Percentage format with one decimal on all percentage values.

Insert a small money-related image to the right side of the row data to fit the size of the five rows.

Rename Sheet1 appropriately and delete unused sheets.

Add a header of your name in the left side, sheet name in the middle, and current date on the right side.

Your workbook must be unique and reflect your own data and design.

Excel

Proje NO: #16449734

Proje hakkında

30 teklif Uzak proje Aktif 5 yıl önce

Bu iş için 30 freelancer ortalamada $28 teklif veriyor

schoudhary1553

Hi there..... Warm Greetings We came along with your request for homework and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(272 Değerlendirme)
7.6
paris2785

Hi, there. My name's Paris and I'm an experienced Excel developer. I read your brief and the given instructions seem quite familiar to me. I've completed such assignments in the past. This is a very simple and straigh Daha Fazla

$19 USD in 0 gün içinde
(156 Değerlendirme)
6.8
zebracaro

I can do it for you quickly and exactly. Please contact me for get hight mark .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(104 Değerlendirme)
6.6
javed1705

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(82 Değerlendirme)
6.1
EngrShahidul

I am experience SPSS Excel presentation, power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You may go through Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)
4.4
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can d Daha Fazla

$30 USD in 2 gün içinde
(14 Değerlendirme)
3.5
nanda1208

I think I can help you on your project. Feel free to contact me to discuss any further details, my bid and deadlines. Best Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
3.3
RenPerera

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.3
ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in ex Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
3.0
wangbeizou

Hello. How are you today. I have read . I have strong knowledge in Data structures, Algorithms Design And I'm expert in VBA, Excel, Access etc. I'm interested in this project. Please send me a message so that we Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.4
rhodelta

Experienced Excel/Word user based in Brisbane, Australia, with office and technical background. Good with maths, spreadsheet functions, and macros. Native English speaker fluent in US and UK English. Your workbook w Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.7
zahidmohoboob

Dear Sir, I wish to submit my application for this job. I am a professional writer in Economics, Accounts, Marketing and Finance also I am a qualified tutor in these fields. I do not outsource my job nor am I a Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.0
mjagbemi

Hello, I have read your terms and description of the project and i understand it perfectly! I have just the perfect skills you to do your home work due to the fact that i have 5 years experience in Excel! Check my p Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
tridibnandi

A proposal has not yet been provided

$30 USD in 9 gün içinde
(0 Değerlendirme)
0.0
kocharaj

i have a good experience in this field. I am responsible and hardworking person. I want to spend my time, 40hrs per week working as a freelancer. My goal here is to serve and share my talents to others providing custom Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
klanu16

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
excel4free

Hi, I am an excel enthusiast and like taking up projects which interests me. Would you allow me to help with your requirement.

$15 USD in 3 gün içinde
(0 Değerlendirme)
0.0
CJavinal1

I'm proficient in creating workbooks and spreadsheet using Microsoft Excel. I will finish your homework by the letter exactly as you said in the description.

$10 USD in 2 gün içinde
(0 Değerlendirme)
0.0
SandeepChawla

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
upashani

A proposal has not yet been provided

$10 USD in 5 gün içinde
(0 Değerlendirme)
0.0