Expert answer:Pls following the instruction to finish the work. Thank you.1. GeneratethefollowingprintingpatternusingHTMLandJavascript.
● Forn=5
Note: Use for loops and arrays for this question. Take number of rows from the user.
Intheaboveexample,numberofrows(n)=5.
Topic:ExcelSheets(VlookupTable)-2points
1. FindthesheetnamedExtraCredits.xlsuploadedwiththeassignment.Youhave
tocreatean“AdjustedRegion”columnusingVlookupTabletothetableonthe
sheet.
Forexample:
AdjustedRegioncolumnshouldshow1-NorthforthecorrespondingRegionN.
extracredits.xls
extracreditassignment.pdf
Unformatted Attachment Preview
Exercise 1
Create an “Adjusted Region”
column created from a vlookup to
the table on the sheet.
Group Name
Postcards Store
Randles Roadshack
Examineers Inc
Buttersworth Co
FASST Trax
Hula Hoopers
Hehehe
Marleyville Tea
Creepy Lada
Jokes R Us
Petie’s Palace
Ramone’s Castle
Group Segment
Big
Small
Medium
Small
Small
Big
Medium
Small
Medium
Big
Small
Big
Revenue
8249.32767
6557.872983
6180.035747
9915.454311
4047.669178
4797.087505
6537.800101
3151.422775
9504.781827
9378.14047
6772.133042
48922666.9867
Expenses
Net Income/Loss
594.878242
7654.449428
83.33938597
6474.533597
551.2667804
5628.768967
336.8576784
9578.596633
481.0083009
3566.660877
962.3550943
3834.73241
931.9697248
5605.830376
848.213517
2303.209258
827.5632244
8677.218603
566.7976536
8811.342816
436.8799836
6335.253059
41584266.94
7338400.048
Region
N
S
E
W
SE
NE
N
S
E
W
SE
NE
Region
N
S
E
W
NE
SE
Adjusted Region
1-North
2-South
3-East
4-West
1-North
2-South
EXTRA CREDIT ASSIGNMENT
Topic : Javascript (For loops and Arrays) - 2 points
1. Generate the following printing pattern using HTML and Javascript.
● For n = 5
Note: Use for loops and arrays for this question. Take number of rows from the user.
In the above example, number of rows (n) = 5.
Topic : Excel Sheets (Vlookup Table) - 2 points
1. Find the sheet named ExtraCredits.xls uploaded with the assignment. You have
to create an “Adjusted Region” column using Vlookup Table to the table on the
sheet.
For example:
Adjusted Region column should show 1-North for the corresponding Region N.
…
Purchase answer to see full
attachment
