true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Microsoft Excel

Upendra Lele

12/08/2019 0 0

For the following data, determine the discount rate for which the total payable amount will be Rs. 45000

Particulars	Qty	Rate	Amount
LG Washing machine	2	23800	47600
Discount (%)		10%	4760
Net amount payable			42840
GST		12%	47981
Transport			500
Total payable amount			48481

0 Like 0 Dislike

Follow 1

Other Lessons for You

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data

Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Ankur Sharma

3 1

Formula to Populate Weekdays of a Given Month

If you want to populate weekdays (Monday to Friday) in a range, follow below steps. Step1: In Cell A1 write any month 1st date. Let’s say 02/01/2017 (Feb 1st 2017) Step2: In Cell C1 write this...

Karthik Dale

0 0

Excel Conditional Formatting

In this video, learn about Conditional Formatting, Creating Conditional Formatting Rules, Use Conditional Formatting Presets, Managing & Removing Conditional Formatting.

Mukesh Chopra

0 0

Presentation Perfect Reports

Presentation Perfect Reports. Why Presentable, neatly crafted Reports makes a job more perfect and easy for Business Analyst who is going make decisions out of the information structured in reports. Many...

Kaustubh Chavan

0 0

What Are Olap, Molap, Rolap, Dolap, Holap?

1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal...

ITech Analytic Solutions

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

How to write macros in excel?

11 Answers

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything...

11 Answers

How can I learn MS Excel from the beginning to the advanced level, online?

5 Answers

What is use of VBA? Can you explain it?

5 Answers

My name is Kartik, I have 6 years of experience in Data analysis. I have experience on BI, Trackwise,...

5 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.