Find the below given Table where you will find lots of issues, and all these you

have solve. find

Due to column size issues, we can't read and display all the informations, so arrange the column width as per the
In Column C "Product Code" where we have 15 digits code number of product starts with 00 but it's not working
In Column E "Price" are not displaying with Currency Symol with INR
In Column F Amount must display in Millions with 2 decimal Points
For the Column H, I and J apply a Formating so that values can match with it's Header row for each column

S. No. Product Name Product Code Quantity Price(INR)

1 Product 1 7695087310710 57335 INR 13,526.00
2 Product 2 9283794151173 95679 INR 7,829.00
3 Product 3 1420607484466 61907 INR 12,625.00
4 Product 4 3214020335286 95342 INR 10,298.00
5 Product 5 7998844981388 67948 INR 12,893.00
6 Product 6 1334672913976 55873 INR 12,843.00
7 Product 7 9205730274440 75513 INR 13,820.00
8 Product 8 9819614062973 65431 INR 11,894.00
9 Product 9 3998165608249 73710 INR 11,352.00
10 Product 10 8496282246859 55316 INR 2,314.00
11 Product 11 2389605689468 77103 INR 1,957.00
12 Product 12 3794531146167 99205 INR 6,676.00
13 Product 13 2929507298637 74231 INR 9,527.00
14 Product 14 5080581394323 72121 INR 10,327.00
15 Product 15 7190163166929 91596 INR 6,013.00
16 Product 16 6532171997790 98675 INR 8,944.00
17 Product 17 5496081428085 88404 INR 6,700.00
18 Product 18 2196469583565 91073 INR 6,657.00
19 Product 19 5806229967814 66522 INR 1,420.00
20 Product 20 9430191108002 64193 INR 8,536.00
 sues, and all these you have solve. find the details below like:
ations, so arrange the column width as per the content size
r of product starts with 00 but it's not working, so you have to implement something to get the solution for the same.
NR
s
ch with it's Header row for each column

Total Amount(In Mill) Delivery Date Transaction Year

775513210 1/4/2019 1/4/2019
749070891 1/5/2019 1/5/2019
781575875 1/15/2019 1/15/2019
981831916 2/18/2019 2/18/2019
876053564 3/11/2019 3/11/2019
717576939 4/16/2019 4/16/2019
1043589660 5/9/2019 5/9/2019
778236314 5/10/2019 5/10/2019
836755920 7/6/2019 7/6/2019
128001224 8/1/2019 8/1/2019
150890571 8/8/2019 8/8/2019
662292580 8/12/2019 8/12/2019
707198737 8/13/2019 8/13/2019
744793567 8/19/2019 8/19/2019
550766748 10/7/2019 10/7/2019
882549200 11/2/2019 11/2/2019
592306800 11/17/2019 11/17/2019
606272961 12/3/2019 12/3/2019
94461240 12/14/2019 12/14/2019
547951448 12/20/2019 12/20/2019
something to get the solution for the same.

Transcation Month Name Transaction Week Day Name

1/4/2019 1/4/2019
1/5/2019 1/5/2019
1/15/2019 1/15/2019
2/18/2019 2/18/2019
3/11/2019 3/11/2019
4/16/2019 4/16/2019
5/9/2019 5/9/2019
5/10/2019 5/10/2019
7/6/2019 7/6/2019
8/1/2019 8/1/2019
8/8/2019 8/8/2019
8/12/2019 8/12/2019
8/13/2019 8/13/2019
8/19/2019 8/19/2019
10/7/2019 10/7/2019
11/2/2019 11/2/2019
11/17/2019 11/17/2019
12/3/2019 12/3/2019
12/14/2019 12/14/2019
12/20/2019 12/20/2019
 You have to apply all the operation given below at sh

1 Enter the text into the cells indicated.

A1: ABC Balance Checkbook A3: Ck. # B3: Date C3: Item Description D3: Debit E3: Credit F3: X G3: Ba
2 Modify column widths for columns A through F. Instead of selecting the best fit option, indicate precisely the
Follow the steps below to complete requirments.
Step 1: Goto to the HOME Tab. Step 2: Select the FORMAT Command Arrow from CELLS Group. Step 3: Select
<OK>.

now try the following widths for each column

Column A: 5 Column B: 8 Column C: 30 Column D: 10 Column E: 10 Column F: 1 Column G: 12
3 Format the numbers to show Rupees for all entries in columns D, E, and G.
4 Format column B to enter the date of transactions. Date must be enter in the format as 01-January-2019
5 Enter the formulas below in the cells indicated
Cell G4: =-d4+e4
Cell G5:=g4-d5+e5

6 Enter the information below in the rows indicated.

Row Ck. # Date Item Description Debit
4 01/February/2020 February Paycheck
5 100 02/February/2020 Shell Oil Co. 5816.73
6 101 03/February/2020 Pink Palace Enter. 8287.603
7 04/February/2020 Cash (Auto Teller) 2872.297
8 102 05/February/2020 Dr. D. J. Houston 8806.207
9 103 06/February/2020 Rent 8510.807
10 07/February/2020 Drug Sales
11 104 08/February/2020 Bail (Drug Arrest) 1163.782
12 105 09/February/2020 Benny the Weasel 9315.48
13 10/February/2020 Rainy Day Quarter Fund
7 Copy the formula from cell G5 to cells G6 through G13.
8 Save your workbook now
eration given below at sheet "Q2 Solution Sheet":

ebit E3: Credit F3: X G3: Balance

t option, indicate precisely the column width desired.

om CELLS Group. Step 3: Select the COLUMN WIDTH option. Step 4: Type the Column Width 15. Step 5: Click on

Column G: 12

ormat as 01-January-2019

Credit
19210.71

90953.7

27878.78
Write all the steps for using Clipboard feature into below give table format

S.No Description
t

n
Apply a format so that all positive value can highlight with blue color and up arrow↑ symbol whe
display with red color and Down arraow ↓ symbol

30 3 19 13 -3 22 -4 36 10
-5 -5 27 -27 -48 -36 -44 37 25
12 2 48 50 -19 -48 40 -9 -17
5 18 -27 12 34 47 40 -26 0
34 -50 48 -23 25 38 21 8 31
24 -46 23 -1 -39 -41 -17 -36 -2
28 9 8 -44 -19 -27 39 -7 -8
41 47 17 14 9 15 18 -49 -8
-3 -44 46 -50 -45 5 42 36 -38
11 -7 20 23 18 -25 24 -1 43
33 10 -10 -25 -5 9 0 3 4
39 -11 -5 -18 24 42 -44 -48 45
2 10 43 49 -49 20 45 -5 44
-10 -39 -31 -39 -16 -33 -21 27 27
16 -22 8 19 -44 40 46 14 -27
up arrow↑ symbol whereas all other value must

-4 -24
44 -30
47 50
-8 -21
25 -25
-4 26
3 25
-50 26
1 1
-15 -7
41 35
-19 48
1 -25
-45 -39
-42 28
 Find the requirements in below given tables(Yellow Colors). Apply necessar

Sales Rep Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total Average

Andy ₹ 32,000.00 ₹ 38,564.00 ₹ 35,380.00 ₹ 41,635.00 ₹ 147,579.00 ₹ 36,894.75
Evan ₹ 47,500.00 ₹ 46,420.00 ₹ 49,066.00 ₹ 43,695.00 ₹ 186,681.00 ₹ 46,670.25
Sara ₹ 53,000.00 ₹ 45,112.00 ₹ 39,866.00 ₹ 42,561.00 ₹ 180,539.00 ₹ 45,134.75
Jose ₹ 28,750.00 ₹ 39,348.00 ₹ 47,634.00 ₹ 39,330.00 ₹ 155,062.00 ₹ 38,765.50
Chan ₹ 37,650.00 ₹ 41,317.00 ₹ 40,534.00 ₹ 42,400.00 ₹ 161,901.00 ₹ 40,475.25
Valerie ₹ 29,995.00 ₹ 42,620.00 ₹ 33,081.00 ₹ 38,432.00 ₹ 144,128.00 ₹ 36,032.00
Kavitha ₹ 43,275.00 ₹ 27,770.00 ₹ 42,903.00 ₹ 28,248.00 ₹ 142,196.00 ₹ 35,549.00
Raul ₹ 51,200.00 ₹ 45,647.00 ₹ 41,177.00 ₹ 45,098.00 ₹ 183,122.00 ₹ 45,780.50
Daphne ₹ 48,990.00 ₹ 28,317.00 ₹ 45,265.00 ₹ 27,515.00 ₹ 150,087.00 ₹ 37,521.75

Highest ₹ 186,681.00 Overall ₹ 1,451,295.00

Lowest ₹ 142,196.00 Sales
Difference ₹ 44,485.00
w Colors). Apply necessary function to get the solutions.
Find all the required Commented cells to get the solutions below

New Product Est. Sales

Desktop ₹ 55,350.00
Phone ₹ 109,600.00
Tablet ₹ 78,900.00
Smart TV ₹ 89,488.00
VR HMD ₹ 59,400.00

Sales Before Tax ₹ 392,738.00

Tax Rate 8%
Sales With Tax ₹ 424,157.00
Expenses ₹ 81,980.00
Profit ₹ 310,758.00
e solutions below
 Apply necessary function to get the solutions, and for Commission calculatio

Name Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total

Silva ₹ 115,500.00 ₹ 65,500.00 ₹ 84,000.00 ₹ 187,110.00 ₹ 452,110.00
Maddox ₹ 113,500.00 ₹ 120,550.00 ₹ 243,760.00 ₹ 197,830.00 ₹ 675,640.00
Koval ₹ 104,500.00 ₹ 113,000.00 ₹ 100,700.00 ₹ 110,925.00 ₹ 429,125.00
Lindgren ₹ 79,500.00 ₹ 113,500.00 ₹ 88,000.00 ₹ 61,670.00 ₹ 342,670.00
Sykes ₹ 125,000.00 ₹ 170,000.00 ₹ 105,000.00 ₹ 192,215.00 ₹ 592,215.00
Lee ₹ 120,550.00 ₹ 274,060.00 ₹ 76,000.00 ₹ 142,320.00 ₹ 612,930.00
Gilgamos ₹ 128,000.00 ₹ 243,760.00 ₹ 151,500.00 ₹ 92,215.00 ₹ 615,475.00
Matthews ₹ 113,000.00 ₹ 292,225.00 ₹ 84,000.00 ₹ 102,270.00 ₹ 591,495.00
Anderson ₹ 113,500.00 ₹ 243,240.00 ₹ 184,275.00 ₹ 147,150.00 ₹ 688,165.00
Pereira ₹ 116,500.00 ₹ 123,000.00 ₹ 106,900.00 ₹ 211,020.00 ₹ 557,420.00
Wagner ₹ 119,000.00 ₹ 138,500.00 ₹ 63,000.00 ₹ 88,950.00 ₹ 409,450.00
Roberts ₹ 274,130.00 ₹ 296,120.00 ₹ 120,500.00 ₹ 118,335.00 ₹ 809,085.00
Avellone ₹ 156,000.00 ₹ 115,500.00 ₹ 88,500.00 ₹ 171,050.00 ₹ 531,050.00
Clarke ₹ 251,120.00 ₹ 86,500.00 ₹ 76,000.00 ₹ 136,650.00 ₹ 550,270.00
Chen ₹ 77,500.00 ₹ 95,000.00 ₹ 151,500.00 ₹ 172,410.00 ₹ 496,410.00
Nguyen ₹ 154,500.00 ₹ 122,000.00 ₹ 84,000.00 ₹ 149,215.00 ₹ 509,715.00
Basara ₹ 74,075.00 ₹ 65,500.00 ₹ 57,900.00 ₹ 77,950.00 ₹ 275,425.00
Bryant ₹ 122,500.00 ₹ 128,000.00 ₹ 110,000.00 ₹ 194,215.00 ₹ 554,715.00
Antonov ₹ 104,500.00 ₹ 113,000.00 ₹ 100,700.00 ₹ 147,330.00 ₹ 465,530.00
King ₹ 79,500.00 ₹ 113,500.00 ₹ 88,000.00 ₹ 195,015.00 ₹ 476,015.00
Masterson ₹ 125,000.00 ₹ 170,000.00 ₹ 105,000.00 ₹ 137,215.00 ₹ 537,215.00
Bailey ₹ 120,550.00 ₹ 274,060.00 ₹ 76,000.00 ₹ 99,700.00 ₹ 570,310.00
Huxley ₹ 128,000.00 ₹ 243,760.00 ₹ 151,500.00 ₹ 147,325.00 ₹ 670,585.00
Washington ₹ 113,000.00 ₹ 292,225.00 ₹ 84,000.00 ₹ 171,650.00 ₹ 660,875.00
d for Commission calculation use the cell reference N5

Average Highest Lowest Commission

₹ 113,027.50 ₹ 187,110.00 ₹ 65,500.00 ₹ 18,084.40
₹ 168,910.00 ₹ 243,760.00 ₹ 113,500.00 ₹ 27,025.60
₹ 107,281.25 ₹ 113,000.00 ₹ 100,700.00 ₹ 17,165.00
₹ 85,667.50 ₹ 113,500.00 ₹ 61,670.00 ₹ 13,706.80
₹ 148,053.75 ₹ 192,215.00 ₹ 105,000.00 ₹ 23,688.60
₹ 153,232.50 ₹ 274,060.00 ₹ 76,000.00 ₹ 24,517.20
₹ 153,868.75 ₹ 243,760.00 ₹ 92,215.00 ₹ 24,619.00
₹ 147,873.75 ₹ 292,225.00 ₹ 84,000.00 ₹ 23,659.80
₹ 172,041.25 ₹ 243,240.00 ₹ 113,500.00 ₹ 27,526.60
₹ 139,355.00 ₹ 211,020.00 ₹ 106,900.00 ₹ 22,296.80
₹ 102,362.50 ₹ 138,500.00 ₹ 63,000.00 ₹ 16,378.00
₹ 202,271.25 ₹ 296,120.00 ₹ 118,335.00 ₹ 32,363.40
₹ 132,762.50 ₹ 171,050.00 ₹ 88,500.00 ₹ 21,242.00
₹ 137,567.50 ₹ 251,120.00 ₹ 76,000.00 ₹ 22,010.80
₹ 124,102.50 ₹ 172,410.00 ₹ 77,500.00 ₹ 19,856.40
₹ 127,428.75 ₹ 154,500.00 ₹ 84,000.00 ₹ 20,388.60
₹ 68,856.25 ₹ 77,950.00 ₹ 57,900.00 ₹ 11,017.00
₹ 138,678.75 ₹ 194,215.00 ₹ 110,000.00 ₹ 22,188.60
₹ 116,382.50 ₹ 147,330.00 ₹ 100,700.00 ₹ 18,621.20
₹ 119,003.75 ₹ 195,015.00 ₹ 79,500.00 ₹ 19,040.60
₹ 134,303.75 ₹ 170,000.00 ₹ 105,000.00 ₹ 21,488.60
₹ 142,577.50 ₹ 274,060.00 ₹ 76,000.00 ₹ 22,812.40
₹ 167,646.25 ₹ 243,760.00 ₹ 128,000.00 ₹ 26,823.40
₹ 165,218.75 ₹ 292,225.00 ₹ 84,000.00 ₹ 26,435.00
Commission % 4.00%
 Find the below given question from the range A16 to A
Country Year 2017 Year 2018
Australia ₹ 5,117,277,112,073.00 ₹ 3,025,518,340,264.00
Canada ₹ 835,661,382,632.00 ₹ 7,411,975,301,718.00
Germany ₹ 5,510,856,139,290.00 ₹ 5,010,161,883,607.00
France ₹ 6,628,395,806,023.00 ₹ 2,803,802,450,948.00
United Kingdom ₹ 9,938,632,170,408.00 ₹ 1,184,778,816,757.00
United States ₹ 9,174,128,724,948.00 ₹ 3,453,070,325,315.00
India ₹ 5,263,757,272,552.00 ₹ 5,820,151,476,746.00
Denmark ₹ 8,933,915,325,397.00 ₹ 3,750,763,140,673.00
China ₹ 1,384,548,166,381.00 ₹ 9,294,439,784,825.00
Japan ₹ 9,868,413,356,904.00 ₹ 7,947,967,658,301.00
Morocco ₹ 5,755,079,069,958.00 ₹ 9,532,867,795,740.00
Philippines ₹ 1,200,684,438,436.00 ₹ 4,396,564,605,778.00
Total Sales ₹ 69,611,348,965,002.00 ₹ 63,632,061,580,672.00
Highest Sales Amount ₹ 9,938,632,170,408.00 ₹ 9,532,867,795,740.00
Smallest Sales Amount ₹ 835,661,382,632.00 ₹ 1,184,778,816,757.00
Count of Records
Average Sales
% Share
Total Expenses
Total Tax Amount
Net Profit
Total Growth
Growth %
Running Total Sales
Running/Cum % Total
m the range A16 to A28, and find the solutions.
Year 2019 Year 2020 Year 2021
₹ 5,266,681,601,331.00 ₹ 1,307,337,983,150.00 ₹ 3,437,091,790,078.00
₹ 5,067,161,379,376.00 ₹ 4,993,751,282,699.00 ₹ 9,089,488,401,461.00
₹ 1,866,646,445,656.00 ₹ 2,823,914,421,304.00 ₹ 9,857,727,226,887.00
₹ 6,315,893,542,970.00 ₹ 9,334,848,119,468.00 ₹ 2,364,200,430,589.00
₹ 9,789,862,018,098.00 ₹ 4,179,280,354,306.00 ₹ 1,416,198,634,512.00
₹ 4,220,291,403,117.00 ₹ 6,630,903,606,907.00 ₹ 4,512,227,617,483.00
₹ 6,626,270,109,815.00 ₹ 1,497,657,468,235.00 ₹ 4,780,313,473,769.00
₹ 3,190,082,436,701.00 ₹ 5,993,029,811,206.00 ₹ 7,023,595,610,201.00
₹ 3,919,345,387,982.00 ₹ 9,308,124,405,813.00 ₹ 5,375,035,088,617.00
₹ 598,158,046,977.00 ₹ 2,374,999,180,306.00 ₹ 5,391,870,341,008.00
₹ 3,038,312,942,458.00 ₹ 1,724,552,405,139.00 ₹ 2,899,340,992,162.00
₹ 9,538,562,687,232.00 ₹ 5,200,524,337,558.00 ₹ 2,010,588,184,033.00
₹ 59,437,268,001,713.00 ₹ 55,368,923,376,091.00 ₹ 58,157,677,790,800.00
₹ 9,789,862,018,098.00 ₹ 9,334,848,119,468.00 ₹ 9,857,727,226,887.00
₹ 598,158,046,977.00 ₹ 1,307,337,983,150.00 ₹ 1,416,198,634,512.00
Expenses Tax %
8.95% 8.25%
 State Model Units Unit Price Total Amount
Delhi Desktop 366 ₹ 849.00 ₹ 310,734.00
Delhi Laptop 202 ₹ 929.00 ₹ 187,658.00
Delhi Tablet 317 ₹ 599.00 ₹ 189,883.00
U.P. Desktop 395 ₹ 849.00 ₹ 335,355.00
U.P. Laptop 348 ₹ 929.00 ₹ 323,292.00
U.P. Tablet 375 ₹ 599.00 ₹ 224,625.00
Maharastra Desktop 358 ₹ 849.00 ₹ 303,942.00
Maharastra Laptop 301 ₹ 929.00 ₹ 279,629.00
Maharastra Tablet 250 ₹ 599.00 ₹ 149,750.00
M.P. Desktop 244 ₹ 849.00 ₹ 207,156.00
M.P. Laptop 411 ₹ 929.00 ₹ 381,819.00
M.P. Tablet 389 ₹ 599.00 ₹ 233,011.00
 Required Function Details
Units Find the smallest Units Values
Unit Price Highest Unit Price value
 Apply required function in the all Colored cells (C

Commission Rate 3.50%

Bonus Rate 1%

Category Names
Sales Rep. Cameras Laptops Printers Desktops
Mullins ₹ 118,340.00 ₹ 114,071.00 ₹ 76,387.00 ₹ 59,777.00
Little ₹ 82,580.00 ₹ 123,394.00 ₹ 44,257.00 ₹ 30,770.00
Brooks ₹ 147,238.00 ₹ 27,118.00 ₹ 87,111.00 ₹ 109,726.00
Berry ₹ 81,590.00 ₹ 66,976.00 ₹ 49,798.00 ₹ 72,727.00
ction in the all Colored cells (Comments has been inserted for requirements)

Total Sales Goal Total Commission Goal Bonus

₹368,575 ₹ 325,000.00 ₹12,900 ₹43,575
₹281,001 ₹ 275,000.00 ₹9,835 ₹6,001
₹371,193 ₹ 400,000.00 ₹12,992 ₹0
₹271,091 ₹ 250,000.00 ₹9,488 ₹21,091
s)
 Apply required function with in row number 21 and row

2021 Monthly Budget

Expense Type January February March April May
Rent ₹ 19,890.00 ₹ 19,890.00 ₹ 19,890.00 ₹ 19,890.00 ₹ 19,890.00
Car Payment ₹ - ₹ - ₹ - ₹ - ₹ -
Cable ₹ 2,386.80 ₹ 2,386.80 ₹ 2,386.80 ₹ 2,386.80 ₹ 2,386.80
Power ₹ 3,341.52 ₹ 3,580.20 ₹ 3,580.20 ₹ 3,978.00 ₹ 4,375.80
Phone ₹ 2,386.80 ₹ 2,545.92 ₹ 2,784.60 ₹ 2,386.80 ₹ 3,341.52
Insurance ₹ 3,580.20 ₹ 3,580.20 ₹ 3,580.20 ₹ 3,580.20 ₹ 3,580.20
Credit Cards ₹ 7,956.00 ₹ 7,956.00 ₹ 7,956.00 ₹ 7,956.00 ₹ 7,956.00
Groceries ₹ 23,868.00 ₹ 23,868.00 ₹ 23,868.00 ₹ 23,868.00 ₹ 23,868.00
Gas ₹ 13,923.00 ₹ 13,923.00 ₹ 13,923.00 ₹ 13,923.00 ₹ 13,923.00

Total Monthly Expenses ₹77,332.32 ₹77,730.12 ₹77,968.80 ₹77,968.80 ₹79,321.32

Monthly Income ₹ 95,892.00 ₹ 95,892.00 ₹ 95,892.00 ₹ 95,892.00 ₹ 95,892.00
Total Savings ₹ 18,559.68 ₹ 18,161.88 ₹ 17,923.20 ₹ 17,923.20 ₹ 16,570.68
w number 21 and row number 23

June July
₹ 19,890.00 ₹ 19,890.00
₹ - ₹ -
₹ 2,386.80 ₹ 2,386.80
₹ 4,534.92 ₹ 5,569.20
₹ 2,545.92 ₹ 2,784.60
₹ 3,580.20 ₹ 3,580.20
₹ 7,956.00 ₹ 7,956.00
₹ 23,868.00 ₹ 23,868.00
₹ 13,923.00 ₹ 13,923.00

₹78,684.84 ₹79,957.80
₹ 95,892.00 ₹ 95,892.00
₹ 17,207.16 ₹ 15,934.20
 Apply required Formula/Function to ge

Student Name State Stream

Sem 1 Sem 2
Andrew Texas EC 64 71
John Chichago CS 68 70
Mervin New York IT 61 86
Jack Texas MECH. 63 51
Jane New York CIVIL 59 50
Michael Texas EC 78 45
George Chichago CS 75 60
Andy New York MECH. 71 75
Smith Texas CIVIL 70 64
Bob New York IT 86 68
Harry Chichago EC 51 61
Samuel Texas CS 50 63
Cindy Chichago MECH. 45 59
Veronica Texas CIVIL 60 78
Betty New York IT 75 75
ula/Function to get the solutions within column L and M

Percentage Marks
Sem 3 Sem 4 Sem 5 Sem 6 Sem 7 Sem 8
61 86 68 61 63 75
63 51 61 63 59 64
59 50 63 59 78 68
78 45 59 78 75 61
75 60 78 75 71 65
71 75 75 71 70 68
70 64 71 70 61 71
61 68 64 86 63 72
63 61 68 68 59 70
59 63 61 61 78 86
78 61 63 63 75 51
75 63 61 61 75 50
71 59 63 63 71 45
70 78 71 59 70 60
86 75 70 78 86 75
Total Averge
549 68.625
499 62.375
524 65.5
510 63.75
533 66.625
553 69.125
542 67.75
560 70
523 65.375
562 70.25
503 62.875
498 62.25
476 59.5
546 68.25
620 77.5
In below given table you will find the total sales value for multiple years now you have to appl

Year 2013 Year 2014 Year 2015

Toal Sales Value ₹ 11,070,612.00 ₹ 12,700,909.00 ₹ 12,279,555.00

Growth % 0 140606835586308.00% 155961510615495.00%

ple years now you have to apply a Formula/Function to calculate yearly growth in Presentage% with 2

Year 2016 Year 2017 Year 2018 Year 2019

₹ 45,566,547.00 ₹ 62,166,285.00 ₹ 62,248,346.00 ₹ 57,914,667.00

559536920046585.00% 2832702947267895.00% 3869748418214610.00% 3605092229890782.00%

Presentage% with 2 Decimal points value.

Year 2020 Year 2021 Year 2022

₹ 80,990,096.00 ₹ 123,028,502.00 ₹ 183,137,034.00

4690514440138032.00% 9964090187716190.00% 22531074953743100.00%

Apply required Formula/Function to get Presentage% discount without decimal po

Expenses Original Price Discount price Discount %

Expense 1 ₹ 86,822.00 ₹ 5,004.00 1-(E7/D7)
Expense 2 ₹ 63,678.00 ₹ 4,866.00
Expense 3 ₹ 32,713.00 ₹ 6,508.00
Expense 4 ₹ 15,719.00 ₹ 2,435.00
Expense 5 ₹ 46,953.00 ₹ 8,565.00
Expense 6 ₹ 27,134.00 ₹ 5,743.00
Expense 7 ₹ 77,104.00 ₹ 2,480.00
Expense 8 ₹ 59,684.00 ₹ 6,733.00
Expense 9 ₹ 48,549.00 ₹ 4,725.00
Expense 10 ₹ 32,013.00 ₹ 9,489.00
count without decimal points
 Apply required Formula/Function to get Presentage% change between last month

Get % Change between 2 values

Sales Person Last Month Sales This Month Sales % Change

Steven King ₹ 634,238.00 ₹ 366,372.00
Neena Kochhar ₹ 678,873.00 ₹ 727,738.00
Lex De Haan ₹ 184,909.00 ₹ 757,521.00
Alexander Hunold ₹ 860,455.00 ₹ 478,276.00
Bruce Ernst ₹ 607,508.00 ₹ 949,643.00
David Austin ₹ 788,060.00 ₹ 204,314.00
Valli Pataballa ₹ 987,190.00 ₹ 813,795.00
Diana Lorentz ₹ 837,864.00 ₹ 436,554.00
Nancy Greenberg ₹ 254,569.00 ₹ 981,259.00
Daniel Faviet ₹ 719,421.00 ₹ 832,979.00
John Chen ₹ 430,738.00 ₹ 519,049.00
Ismael Sciarra ₹ 451,618.00 ₹ 817,466.00
Jose Manuel Urman ₹ 819,328.00 ₹ 233,115.00
Luis Popp ₹ 919,147.00 ₹ 266,640.00
Den Raphaely ₹ 856,040.00 ₹ 791,710.00
Alexander Khoo ₹ 873,329.00 ₹ 238,702.00
Shelli Baida ₹ 504,120.00 ₹ 908,395.00
Sigal Tobias ₹ 533,018.00 ₹ 982,443.00
Guy Himuro ₹ 133,020.00 ₹ 515,853.00
Karen Colmenares ₹ 136,708.00 ₹ 874,535.00
Matthew Weiss ₹ 881,907.00 ₹ 120,867.00
etween last month and this month sales values

(D7-C7)/C7
Into below given table range you will find few colored cells where you have to find th
1 Within column G, find Total tax Amount on basis of Total Standard Cost Value
2 In Column H apply a function to find the Actual Cost value which will be the total of Standerd P
3 Find the total sales amount and the product of Unit Sold with Sales Price Amount
4 Apply a function by your own to find the total profit amount
5 Find cumulative total of Total Profit Amount
6 Calculate the % share of Total Profit amount

Product Standard Cost

S.No Product Name Unit Sold Total Tax %
Code (Per Unit)

1 P001 Product 1 78 ₹ 193.00 9.82%

2 P002 Product 2 51 ₹ 937.00 4.57%
3 P003 Product 3 82 ₹ 273.00 6.10%
4 P004 Product 4 41 ₹ 378.00 4.45%
5 P005 Product 5 49 ₹ 638.00 5.68%
6 P006 Product 6 37 ₹ 565.00 6.97%
7 P007 Product 7 99 ₹ 789.00 3.61%
8 P008 Product 8 98 ₹ 615.00 7.33%
9 P009 Product 9 81 ₹ 743.00 4.25%
10 P010 Product 10 95 ₹ 908.00 1.33%
11 P011 Product 11 80 ₹ 743.00 2.09%
12 P012 Product 12 13 ₹ 369.00 8.93%
13 P013 Product 13 92 ₹ 352.00 3.22%
14 P014 Product 14 49 ₹ 231.00 8.48%
15 P015 Product 15 51 ₹ 691.00 9.80%
16 P016 Product 16 12 ₹ 636.00 5.72%
17 P017 Product 17 55 ₹ 999.00 8.82%
18 P018 Product 18 57 ₹ 781.00 6.94%
19 P019 Product 19 55 ₹ 525.00 5.80%
20 P020 Product 20 61 ₹ 826.00 3.98%
s where you have to find the solutions as per the below given requirements
ard Cost Value
h will be the total of Standerd Price, Total Tax and Freight Outward
ales Price Amount

Total Tax Freight Outward Total Sales Amount

Actual Cost Amount Sales Price
Amount (Per Unit) (Unit * Sales price)

₹ 4.79 ₹ 311.51
₹ 1.34 ₹ 1,048.82
₹ 4.90 ₹ 486.82
₹ 1.06 ₹ 560.18
₹ 2.95 ₹ 716.47
₹ 5.75 ₹ 681.35
₹ 4.89 ₹ 995.45
₹ 1.78 ₹ 694.38
₹ 1.27 ₹ 921.99
₹ 5.47 ₹ 1,061.79
₹ 1.95 ₹ 905.67
₹ 4.47 ₹ 552.23
₹ 3.89 ₹ 440.97
₹ 1.76 ₹ 366.00
₹ 4.10 ₹ 855.74
₹ 2.63 ₹ 805.07
₹ 3.82 ₹ 1,150.78
₹ 3.34 ₹ 915.58
₹ 3.60 ₹ 638.60
₹ 1.88 ₹ 1,022.92
ements

Cumulative Profit
Total Profit % Share
Total
 Find the requirements in below given tables(Yellow Colors

Goal Actual Difference

Region Sales Sales (Goal - Actual) Region
North ₹ 40,000.00 ₹ 34,884.00 5116 North
East ₹ 60,000.00 ₹ 45,064.00 14936 East
South ₹ 40,000.00 ₹ 31,257.00 8743 South
West ₹ 45,000.00 ₹ 27,123.00 17877 West
Total ₹ 185,000.00 ₹ 138,328.00 46672 Total
Average ₹ 46,250.00 ₹ 34,582.00 Average
Highest Value ₹ 60,000.00 ₹ 45,064.00
Lowest Value ₹ 40,000.00 ₹ 27,123.00
tables(Yellow Colors). Apply necessary function to get the solutions.

Sales Call Actual # of Difference

Goal Calls (Goal - Actual)
45 37 8
60 50 10
45 35 10
45 30 15
195 152 43
49 38 11
Below given table provides, the details of Started Date & time jobs for each employee, and require
each job to get it finish. Now you have to apply a logic or formating for finding the job completion l
and every employee.

Employee Name Start Date & Time Days required to Complete Finish Date & Time
Shannon Carlson 07/02/2020 12:58 AM 14.41
Gurmeet Singh 08/02/2020 08:31 PM 23.37
Monique Cohen 15/02/2020 07:16 AM 16.71
Chinmay Singh 24/03/2020 10:41 AM 30.53
Sharvana Jain 30/03/2020 12:51 AM 26.35
Lauren Walker 02/04/2020 03:40 AM 11.89
Rajesh Kumar 26/05/2020 02:36 AM 12.22
Rajan Kishore 04/06/2020 12:42 PM 16.39
Janet Alvarez 13/06/2020 08:14 PM 10.59
Cary Nichols 18/06/2020 11:11 AM 12.91
Ian Jenkins 19/06/2020 12:25 PM 24.08
Paulette Diaz 19/07/2020 08:55 PM 28.70
Christy Zhu 22/07/2020 07:06 PM 19.39
Ernestine French 29/07/2020 05:26 AM 13.51
Marco Mehta 01/08/2020 08:34 PM 28.16
Sydney Bennett 09/08/2020 04:34 AM 14.49
Krishna Dev 13/08/2020 06:35 AM 28.47
Sonu Baweja 21/09/2020 01:28 AM 12.50
Becky Woods 21/10/2020 07:01 PM 20.81
Gwen Patrick 03/12/2020 10:23 PM 27.34
Mohan Singh 23/12/2020 06:28 AM 22.07
Shadow Elizabeth 30/12/2020 03:33 AM 27.07
Km. Ranjita 11/01/2021 03:25 PM 29.68
Claire Watson 17/01/2021 12:02 AM 28.03
Agnes Fernandez 26/01/2021 01:05 AM 10.30
Mohit Dhinghra 06/02/2021 06:46 AM 27.81
Ted Riley 06/02/2021 04:15 PM 15.02
Muriel Thomas 09/02/2021 12:01 PM 10.89
Ignacio Hunter 23/02/2021 08:42 PM 18.15
Julio Ruiz 25/02/2021 04:47 AM 10.07
Eugene Huang 05/03/2021 05:30 AM 27.68
Rajkishor Gupta 12/03/2021 10:19 AM 26.29
Jenny Washington 12/03/2021 09:58 PM 21.94
Cora Neal 18/04/2021 12:34 AM 16.27
Jacquelyn Suarez 20/04/2021 02:04 AM 14.18
Rob Verhoff 08/05/2021 03:19 PM 18.71
Smith Jane 23/05/2021 06:49 AM 21.24
Rosie Newton 29/06/2021 08:16 PM 23.65
Rajiv Kalra 18/07/2021 09:13 PM 19.76
Winston Vargas 23/07/2021 03:33 PM 18.86
Kay Tate 21/08/2021 02:17 PM 25.89
Kishore Kumar Lalit 28/08/2021 03:59 AM 20.18
Rajkumar Verma 05/09/2021 02:51 PM 12.50
Mercedes Hale 04/10/2021 12:30 PM 14.72
Elizabeth Johnson 31/10/2021 10:27 AM 26.95
Maurice Morrison 23/11/2021 12:45 AM 13.06
Vinod Adwani 25/11/2021 02:43 AM 23.56
Cecelia Nash 15/12/2021 01:57 AM 16.21
Bernice Gray 04/01/2022 04:40 AM 16.24
Potter Betty 18/01/2022 12:58 PM 10.85
Doe John 26/01/2022 04:55 PM 15.55
Ruben Torres 30/01/2022 01:15 AM 12.74
Shila Rani 20/03/2022 06:23 PM 15.49
Curtis Lu 26/03/2022 06:58 AM 10.70
Ravinder Pawar 03/04/2022 05:28 AM 30.19
Tom Brown 10/04/2022 12:54 AM 24.54
Christina Day 01/05/2022 01:56 AM 27.89
Noah Green 18/05/2022 02:34 PM 11.45
Suzanne Maxwell 23/05/2022 01:09 PM 22.46
Jon Yang 26/05/2022 03:01 AM 13.31
Chloe Young 30/05/2022 12:44 AM 21.63
Terrance Reyes 15/06/2022 08:32 PM 11.76
Sonja Adkins 21/06/2022 06:19 PM 24.47
Randal Chandler 25/06/2022 11:08 PM 24.45
Jermaine Blake 02/07/2022 04:45 PM 11.83
Roman Carr 10/07/2022 10:58 AM 18.83
Adrian Barnes 17/07/2022 01:18 PM 23.37
Vibhore Sharma 17/07/2022 07:36 PM 15.75
Md. Naveed Ahmed 25/07/2022 07:22 PM 26.43
Glenn Meyer 02/08/2022 01:50 AM 19.90
mployee, and required completed days for
the job completion last date & time for each
Apply required Formatting from Column(colored) F to H

Emp_Code Name Department Date Hired Location Date

A001 Rajesh Kumar Marketing 19-May-08 Delhi 39587
A002 Mohan Singh Sales 20-May-08 Delhi 39588
A003 Rajkumar Verma Production 21-May-08 Calcutta 39589
A004 Vibhore Sharma Operation 22-May-08 Delhi 39590
A005 Rajan Kishore Management 23-May-08 Mumbai 39591
A006 Mohit Dhinghra Marketing 24-May-08 Delhi 39592
A007 Rajiv Kalra Sales 25-May-08 Delhi 39593
A008 Vinod Adwani Production 26-May-08 Calcutta 39594
A009 Md. Naveed AhmOperation 27-May-08 Calcutta 39595
A010 Tom Brown Management 28-May-08 Calcutta 39596
A011 Gurmeet Singh Marketing 28-Aug-13 Delhi 41514
A012 Shila Rani Sales 12-Apr-05 Calcutta 38454
A013 Km. Ranjita Production 16-Feb-02 Mumbai 37303
A014 Krishna Dev Operation 9-Sep-03 Calcutta 37873
A015 Sharvana Jain Management 14-Nov-09 Mumbai 40131
A016 Ravinder Pawar Marketing 13-Mar-01 Mumbai 36963
A017 Chinmay Singh Sales 9-Aug-11 Delhi 40764
A018 Kishore Kumar LalProduction 12-May-06 Delhi 38849
A019 Sonu Baweja Operation 15-Mar-13 Delhi 41348
A020 Rajkishor Gupta Management 25-Feb-12 Calcutta 40964
A021 Smith Jane Sales 6-May-10 Mumbai 40304
A022 Potter Betty Production 21-Sep-06 Calcutta 38981
A023 Doe John Operation 9-Jul-13 Mumbai 41464
A024 Shadow ElizabethManagement 26-Sep-09 Delhi 40082
Month Number Day Name Months Name Year Office Type Basic Salary
39587 39587 39587 39587 Zonal ₹ 11,047.00
39588 39588 39588 39588 Head Office ₹ 37,552.00
39589 39589 39589 39589 Nodal Branch ₹ 26,664.00
39590 39590 39590 39590 Zonal ₹ 15,086.00
39591 39591 39591 39591 Head Office ₹ 35,054.00
39592 39592 39592 39592 Nodal Branch ₹ 24,567.00
39593 39593 39593 39593 Zonal ₹ 23,646.00
39594 39594 39594 39594 Head Office ₹ 15,722.00
39595 39595 39595 39595 Nodal Branch ₹ 12,077.00
39596 39596 39596 39596 Zonal ₹ 47,379.00
41514 41514 41514 41514 Head Office ₹ 13,063.00
38454 38454 38454 38454 Nodal Branch ₹ 19,095.00
37303 37303 37303 37303 Zonal ₹ 25,222.00
37873 37873 37873 37873 Head Office ₹ 12,678.00
40131 40131 40131 40131 Nodal Branch ₹ 46,903.00
36963 36963 36963 36963 Zonal ₹ 16,097.00
40764 40764 40764 40764 Head Office ₹ 28,368.00
38849 38849 38849 38849 Nodal Branch ₹ 29,029.00
41348 41348 41348 41348 Zonal ₹ 11,163.00
40964 40964 40964 40964 Head Office ₹ 24,420.00
40304 40304 40304 40304 Nodal Branch ₹ 17,346.00
38981 38981 38981 38981 Zonal ₹ 33,686.00
41464 41464 41464 41464 Head Office ₹ 12,312.00
40082 40082 40082 40082 Nodal Branch ₹ 25,639.00
Total Salary Annual Salary
₹ 16,272.00 ₹ 195,264.00
₹ 43,362.00 ₹ 520,344.00
₹ 32,126.00 ₹ 385,512.00
₹ 21,013.00 ₹ 252,156.00
₹ 40,249.00 ₹ 482,988.00
₹ 30,508.00 ₹ 366,096.00
₹ 29,015.00 ₹ 348,180.00
₹ 21,051.00 ₹ 252,612.00
₹ 17,761.00 ₹ 213,132.00
₹ 52,558.00 ₹ 630,696.00
₹ 18,109.00 ₹ 217,308.00
₹ 24,461.00 ₹ 293,532.00
₹ 30,795.00 ₹ 369,540.00
₹ 18,287.00 ₹ 219,444.00
₹ 51,656.00 ₹ 619,872.00
₹ 21,770.00 ₹ 261,240.00
₹ 33,720.00 ₹ 404,640.00
₹ 33,482.00 ₹ 401,784.00
₹ 16,185.00 ₹ 194,220.00
₹ 28,994.00 ₹ 347,928.00
₹ 22,594.00 ₹ 271,128.00
₹ 39,035.00 ₹ 468,420.00
₹ 18,103.00 ₹ 217,236.00
₹ 31,127.00 ₹ 373,524.00
Apply Required functions at below given coloured blank cells

Sales Person Code Sales Sales % Product name

Hindol Sinha W1 3200 2482.93% Dry Tissues
Dola Das H2 1250 969.89% Paper Towels
Deepak Sharma C4 1250 969.89% Wet Wipes
Uma Nag T1 150 116.39% Chicken Dinner
Sayak Pal C1 2999 2326.97% Clear Refresher
Srijan Das W1 3200 2482.93% Dried Grits
Srijita Agarwal H1 590 457.79% Extra Nougat
Rina Karmakar S2 99 76.82% Athletic Drink
Lily Roy T5 150 116.39%
Total Sales 12888
Quantity Price Sales Tax Amount Sales Tax 7.50%
20 3800 5700 76000
40 150 450 6000
25 50 93.75 1250
32 200 480 6400
30 200 450 6000
15 6580 7402.5 98700
30 6580 14805 197400
22 50 82.5 1100
 Year 2023
Sales Person wise Monthly T

Target % 2.23% 3.34% 2.67%

Sales Person Target January February March
Rob Verhoff ₹ 164,506.00 ₹ 3,668.48 ₹ 5,494.50 ₹ 4,392.31
Shadow Elizabeth ₹ 186,343.00 ₹ 4,155.45 ₹ 6,223.86 ₹ 4,975.36
Ian Jenkins ₹ 155,543.00 ₹ 3,468.61 ₹ 5,195.14 ₹ 4,153.00
Shila Rani ₹ 101,719.00 ₹ 2,268.33 ₹ 3,397.41 ₹ 2,715.90
Ruben Torres ₹ 192,612.00 ₹ 4,295.25 ₹ 6,433.24 ₹ 5,142.74
Marco Mehta ₹ 198,205.00 ₹ 4,419.97 ₹ 6,620.05 ₹ 5,292.07
Mohit Dhinghra ₹ 160,259.00 ₹ 3,573.78 ₹ 5,352.65 ₹ 4,278.92
Tom Brown ₹ 102,034.00 ₹ 2,275.36 ₹ 3,407.94 ₹ 2,724.31
Janet Alvarez ₹ 167,168.00 ₹ 3,727.85 ₹ 5,583.41 ₹ 4,463.39
 Year 2023
n wise Monthly Target

5.51% 6.00% 7.00% 8.00% 9.00%

April May June July August
₹ 9,064.28 ₹ 9,870.36 ₹ 11,515.42 ₹ 13,160.48 ₹ 14,805.54
₹ 10,267.50 ₹ 11,180.58 ₹ 13,044.01 ₹ 14,907.44 ₹ 16,770.87
₹ 8,570.42 ₹ 9,332.58 ₹ 10,888.01 ₹ 12,443.44 ₹ 13,998.87
₹ 5,604.72 ₹ 6,103.14 ₹ 7,120.33 ₹ 8,137.52 ₹ 9,154.71
₹ 10,612.92 ₹ 11,556.72 ₹ 13,482.84 ₹ 15,408.96 ₹ 17,335.08
₹ 10,921.10 ₹ 11,892.30 ₹ 13,874.35 ₹ 15,856.40 ₹ 17,838.45
₹ 8,830.27 ₹ 9,615.54 ₹ 11,218.13 ₹ 12,820.72 ₹ 14,423.31
₹ 5,622.07 ₹ 6,122.04 ₹ 7,142.38 ₹ 8,162.72 ₹ 9,183.06
₹ 9,210.96 ₹ 10,030.08 ₹ 11,701.76 ₹ 13,373.44 ₹ 15,045.12