Latest NMIMS solutions June 2022 - Use the filter option to display the different designs of rides. Mention the count fo

Rs. 1,000

Description

For Nmims answersheets contact
[email protected]
+91 95030-94040

Essentials of IT

1. The annual summary for the sales representatives of ABC. Co. is presented in the table below, which indicates the sales rep's name, the target sales assigned to him, the sales achieved by him, and the percentage of sales. Explain any four different conditional formatting styles (4 marks) and apply the following conditional formatting rules to the table presented below:

a. Show in green the percentage for any sales rep achieving more than 100% of their target (1 mark)
b. Show arrows icons for the achieved column (1 mark)
c. Highlight the sales rep with the name Carla in pink with a red font (2 marks)
d. Use the yellow colour to show a sales rep who has a target of less than Rs. 75000 sales (2 marks)
You can choose to show the final table in the colour formatted manner.
Sales Reps - Annual Summary
Name Target
(in
Rs.) Achieved Percentage
Jenifer Murthy 85000 94,500 111.18%
Ivan Martha 120000 1,18,000 98.33%
Carla Parth 100000 1,07,000 107.00%
Randy Cunningham 65000 29,000 44.62%
Arthur Shore 50000 67,000 134.00%
Hugh Rego 150000 1,98,000 132.00%
Wendy Hussain 95000 1,24,750 131.32%
Carla Suzan 95000 94750 99.74%
Christmas Dias 75000 75,000 100.00%

Note: Q 1 is of 10 marks. The mark bifurcation is mentioned with each sub-question.
2. Use the table mentioned below to convert this data into a pivot table and find the overall average speed of all rides that satisfy the following criteria:

• The Type is Steel (3 marks)
• The Design is Sit Down (3 marks)
• The Amusement Park has the word adventure somewhere in the title ( 2 marks)
• Use the filter option to display the different designs of rides. Mention the count for each of these ( 2 marks)
Roller
Coaster Amusement Park Type Design Status Opened Speed ( mph
)
Air Alton Towers Steel Flying Operating 2002 46.6
Boomerang Pleasure Island Family Theme
Park Steel Sit Down Operating 1993 47
Cobra Paultons Park Steel Sit Down Operating 2006 31.1
Colossus Thorpe Park Steel Sit Down Operating 2002 45
Corkscrew Alton Towers Steel Sit Down Operating 1980 40
Corkscrew Flamingo Land Theme Park &
Zoo Steel Sit Down Operating 1983 40
Crazy Mouse South Pier Steel Sit Down Operating 1998 29.1
Crazy Mouse Brighton Pier Steel Sit Down Operating 2000 29.1
Enigma Pleasurewood Hills Steel Sit Down Operating 1995 34
Express M&Ds Scotland's Theme Park Steel Sit Down Operating 2006 28
Fantasy
Mouse Fantasy Island Steel Sit Down Operating 2000 29.1
G Force Drayton Manor Park Steel Sit Down Operating 2005 43.5
Grand
National Pleasure Beach, Blackpool Wood Sit Down Operating 1935 40
Infusion Pleasure Beach, Blackpool Steel Inverted Operating 2007 49.7
Irn-Bru
Revolution Pleasure Beach, Blackpool Steel Sit Down Operating 1979 45
Jubilee
Odyssey Fantasy Island Steel Inverted Operating 2002 63
Jungle
Coaster Legoland Windsor Steel Sit Down Operating 2004 35
Knightmare Camelot Theme Park Steel Sit Down Operating 2007 43.5
Kumali Flamingo Land Theme Park &
Zoo Steel Inverted Operating 2006 54.9
Magic Mouse Brean Leisure Park Steel Sit Down Operating 2007 29.1
Megafobia Oakwood Theme Park Wood Sit Down Operating 1996 48
Millennium
Roller
Coaster Fantasy Island Steel Sit Down Operating 1999 55.9
Nemesis Alton Towers Steel Inverted Operating 1994 50
Nemesis
Inferno Thorpe Park Steel Inverted Operating 2003 47.8
New Roller
Coaster New MetroLand Steel Sit Down Operating 1988 26.8
Oblivion Alton Towers Steel Sit Down Operating 1998 68
Pepsi Max
Big One Pleasure Beach, Blackpool Steel Sit Down Operating 1994 74
Rage Adventure Island Steel Sit Down Operating 2007 43.5
Rat Loudoun Castle Steel Sit Down Operating 2005 28
Rattlesnake Chessington World of
Adventures Steel Sit Down Operating 1998 28
Rhino
Coaster West Midlands Safari Park Steel Sit Down Operating 1992 28.5
Rita - Queen
of Speed Alton Towers Steel Sit Down Operating 2005 61.1
Roller
Coaster Great Yarmouth Pleasure
Beach Wood Sit Down Operating 1932 45
Roller
Coas

Seller OR Author Profile

Chat With Seller

Locality

Bangalore, Bengaluru South, Karnataka
List On: 06 May, 2022
Views: 14
AD ID: 12487

SAFETY TIPS

Be aware of fraud

Check the item before you buy

Pay after collect the item

Related Classified Ads

Art and Craft

Narsee Monjee Assignments June 2022 - Consider improving the experience of pregnant women at a government hospital in yo

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Design Thinking 1. Consider improving the experience of pregnant wo...

Bengaluru South , Karnataka

06 May, 2022
36
Art and Craft

Narsee Monjee Assignments June 2022 - Concept of “self-governance” is invariably present in the present Company Law regi

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Corporate & Information Technology Law 1. Concept of “self-go...

Bengaluru South , Karnataka

06 May, 2022
18
Art and Craft

Narsee Monjee Assignments June 2022 - Concept of “indemnification” is undergoing a major overhaul in the current regime

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Business and Allied Law 1. Concept of “indemnification” is unde...

Bengaluru South , Karnataka

06 May, 2022
16
Art and Craft

Narsee Monjee Assignments June 2022 - Compute the income from salary for A.Y 2022-23, and give reasons and explanations

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Fundamentals of Taxation 1. GST is called as consumption based tax....

Bengaluru South , Karnataka

06 May, 2022
18
Art and Craft

NARSEE June 2022 assignment help - You are working with a freight forwarding company. You have exported one

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Export Import Procedures and Documentation 1. You have joined one e...

Bengaluru South , Karnataka

06 May, 2022
18
Art and Craft

NARSEE June 2022 assignment help - You are the Team Leader with Amazon. A new group of interns has joined the company. Y

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Business Communication 1. You are the Team Leader with Amazon. A ne...

Bengaluru South , Karnataka

06 May, 2022
38
Art and Craft

NARSEE June 2022 assignment help - As a consultant explain four steps to develop strong brand for Worthy Pens

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Brand Management 1. Mr. Nimish plans to set up his business that de...

Bengaluru South , Karnataka

06 May, 2022
30
Art and Craft

NARSEE June 2022 assignment help - Arvind Enterprise sold goods worth Rs 10000 @ 10 % T.D to Mr Ram and 2% C.D is allowe

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Essentials of Financial Accounting 1. Zeno Pharma is operating in M...

Bengaluru South , Karnataka

06 May, 2022
18
Art and Craft

NARSEE June 2022 assignment help - Arvind Enterprise deposited cash in to Bank Rs 100000. Identify the type of account a

Rs. 1000
For Nmims answersheets contact [email protected] +91 95030-94040 Essentials of Financial Accounting 1. Zeno Pharma is operating in M...

Bengaluru South , Karnataka

06 May, 2022
17

Do You Want To Post Free Classifieds Ad?

Post your classifieds ads and grow up your business

Submit Your Ad Now!

X
Find Your Location

Please Wait....
We are processing your request.

Login

New here? Create an Account.


OR

Select Category
Jobs
Real Estate
Mobiles & Tablets
Electronics
Furniture
Fashion
Travels
Entertainment
Health & Fitness
Pets
Art and Craft
Services
Jobs
Data entry & Back office
Sales & Marketing
BPO & Telecaller
Driver
Office Assistant
Delivery & Collection
Teacher
Cook
Receptionist & Front office
Operator & Technician
IT Engineer & Developer
Hotel & Travel Executive
Accountant
Designer
Others
Real Estate
For Sale: Houses & Apartments
For Rent: Houses & Apartments
Lands & Plots
For Rent: Shops & Offices
For Sale: Shops & Offices
PG & Guest Houses
Mobiles & Tablets
Mobile Phones
Tablets
Accessories
Electronics
Computers & Laptops
Hard Disks, Printers & Monitors
Air Conditioner
Washing Machines
Fridges
Computer Accessories
Cameras & Lenses
Kitchen & Other Appliances
Games & Entertainment
TVs, Video - Audio
Furniture
Sofa & Dining
Beds & Wardrobes
Home Decor & Garden
Kids Furniture
Other Household Items
Fashion
Men
Women
Kids
Traditional
Designer Dress
Handloom
Travels
Hotels & resorts
Vehicles on Rent
Tour & Travel Agents
Entertainment
Restaurants
Fun & Food
Events
Health & Fitness
Gym & Fitness
Fitness Accessories
Beauty
Pets
Fishes & Aquarium
Dogs
Pet Food & Accessories
Other Pets
Art and Craft
Art
Craft
Services
Drivers & Taxi
Catering services
Electronics & Appliances - Repair
Health & Beauty
Computer & webdesign
Event services
Housing services
CCTV & Camera
Search
Suggestion Messages
Report This Item

Please select the reason why you want to report