excel assignment for practice pdf download

User Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related Products

Excel Projects for Practice

Excel Templates Practice

Solar System Calculator

Excel Dashboard Challenge

25 Real Pivot Table Exercises

Real Excel Exercises for Beginners

Shopping cart

Practice And Learn Excel Online For Free

Welcome to Excel Practice Online!

Now you can practice Excel everywhere! You can even practice on your mobile phone!

Every function and tool has an explanation followed by an online excel exercise which can be solved within the page itself, no need to download anything – All thanks to the amazing powers of Excel Online!

The tutorials are sorted from beginner level to advanced level. If you like this site please share it with your friends! 🙂

Tip for mobile phone users – tap twice on the cell you want to edit in order to edit it.

• Free Excel Courses and Resources
• Excel Self-Assessment Tool
• Free Excel Online Exercises
• Excel Basics – Zero to Hero
• Excel Tests
• Top 10 formulas and functions in Excel
• Vlookup – Tutorial with Example and Exercise Sheet
• Pivot Tables Tutorial
• Excel Shortcuts – Windows and Mac
• HOT! – Excel Mortgage Calculator – Calculate your mortgage payments and get the payment schedule for the entire period of the loan – Step-by-step tutorial on how to build a Mortgage Calculator in Excel.
• New! Excel Online Cheat Sheet – A Quick Guide To Excel’s Web Version
• Can’t find what you’re looking for? Suggest a tutorial here!
• Excel Basics – Start here if you are new to Excel! Learn how Excel works, how to perform basic calculations, and how to use cell references to save time and increase efficiency!
• Addition (Plus)
• Subtraction (Minus)
• Multiplication
• Excel Shortcuts for Windows – Master Excel Shortcuts to save time and increase efficiency!
• Excel Shortcuts for Mac – Learn how to make the most of Excel on your Mac!

Formulas/Functions

• SUM function – Sum multiple values in Excel
• MAX – find the maximum value in a range
• MIN – find the minimum value in a range
• COUNT – Count numeric values in a range
• COUNTA – Count numeric and textual values
• AVERAGE – Calculate average of a range
• Filtering in Excel – Learn how to filter your data using Excel’s Filter Tool
• Excel Sort – Learn how to sort your data in Excel.
• Flash Fill – Excel’s hidden gem for auto-completing data based on a pattern
• Remove Duplicates – Remove duplicate values in a single column or multiple columns!

Intermediate

Conditional.

• IF function – check if a condition is met
• NESTED IF – Multiple if conditions
• Conditional Formatting – Format Excel Cells based on criteria
• COUNTIF – Count cells in range which meet a certain criteria
• SUMIF – Sum range based on criteria
• AVERAGEIF – Calculate the average of a range based on criteria
• SUMIFS – Sum cells using multiple criteria
• COUNTIFS – Count cells using multiple criteria
• MAXIFS – Find maximum value in a range based on criteria
• MINIFS – Find minimum value in a range based on criteria
• AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)
• ISBLANK – Check if a cell is blank or not
• VLOOKUP – lookup value and return corresponding value from a table
• HLOOKUP – lookup value and return corresponding value from a table
• Hot!!! XLOOKUP – Excel’s next generation lookup function which combines the best features from VLOOKUP, INDEX MATCH, HLOOKUP and IFERROR/IFNA

Pivot tables

• Pivot Table – Quickly Analyze and Summarize your data using Excel’s most powerful tool!

Text Formulas

• LEFT, MID, RIGHT – Basic Text Functions
• HOT! – TEXTBEFORE & TEXTAFTER – Extract text before or after a delimiter using Excel’s brand new powerful functions!
• HOT! – TEXTSPLIT – Split your text into multiple cells using this super powerful new function!
• TEXTJOIN – Easily combine multiple cells using delimiter
• CONCAT – Combine range of cells without delimiter
• CONCATENATE – Combine two cells or more into one cell
• LEN – Find the length of a cell
• FIND – Find the position of a text within another text (Case-sensitive)
• SEARCH – Find the position of a text within another text (Case-insensitive)
• SUBSTITUTE – Replace text with another text in a cell/expression
• TRIM – Remove extra spaces from the text
• LOWER, UPPER, PROPER – Convert text to lowercase, uppercase and proper case
• VALUE – Convert data stored as text into values
• TEXT – Convert and format numbers into text
• Text to Columns – Quickly split a column into multiple columns using a delimiter. Bonus – Quickly change date formats or convert text to numbers!
• FORMULATEXT – display a formula in another cell as text

Date functions

• DAY, MONTH, YEAR – Extract day, month and year from a date in Excel
• DATE – Create a date from individual values
• WEEKDAY – Return the number of the day of the week
• EOMONTH – Return the date of the last day of the month based on a specific date

Index & Match lookup

• INDEX – Retrieve cell in nth position in a range
• MATCH – Find position of value in a range
• INDEX MATCH – Just like VLOOKUP, only better.

Other advanced tools

• SUMPRODUCT – Sum the products of Excel ranges
• Excel Wildcards – Advanced searching and matching in Excel
• Advanced Filter – Filter by multiple criteria in the same column, or even in different columns!

Power Query

• Combine data from multiple Excel workbooks using Power Query
• Column from Examples tool – Learn the secret to mastering Power Query without any prior knowledge!
• Unpivot columns easily using Power Query

Secret Excel Functions

This section covers Excel functions that are not available in most of Excel’s versions. These functions will unlock a new set of capabilities such as fining only unique values, sorting, and filtering – the tutorials below will help you with mastering Excel’s new functions!

• UNIQUE – Extract unique values from a range
• SORT Function – Sort range dynamically
• SORTBY – Sort range dynamically by using another range
• FILTER Function – Filter range by specific criteria
• RANDARRAY – Create an array of random numbers 
• SEQUENCE – Create a range of sequential values
• LET – Assign values and calculations to names to improve your formula’s ease of use, readability, and performance!
• HOT! – LAMBDA – The mother of all functions that will help you create amazing and powerful custom functions for your own need! 
• VSTACK – Vertically stack arrays/ranges in Excel
• HSTACK – Horizontally stack arrays/ranges in Excel
• CHOOSEROWS – Return specific rows from a range or array
• CHOOSECOLS – Return specific columns from a range or array
• TOROW – Convert a range/array into a single row
• TOCOL – Convert a range/array into a single column

Financial Functions

Learn how to use Excel to make financial calculations!

• Excel Financial Calculator – quickly calculate PV, FV, PMT, NPV, IRR
• PMT – Calculate the periodic payment amount of a loan, mortgage, or another financial instrument
• PPMT & IPMT – Find the Principal and Interest portion of a certain payment
• PV – Find the Present Value of a loan, mortgage, or any other financial instrument 

Excel Macros – VBA (Visual Basic for Applications)

• Start here – How to run your first VBA Macro in Excel without knowing VBA? 

Excel Data Sheets for Practice

Want to do some freestyle practice? Create your own Excel playground with our blank excel Worksheet!

• Excel-Online Blank Worksheet
• Excel Practice Data

How to Calculate in Excel – Excel-Online Calculators

• How to Calculate GPA in Excel
• How to Calculate BMI in Excel
• How to Calculate Density in Excel
• How to Calculate Weighted Average in Excel

Terms and Conditions - Privacy Policy

Excel Data for Practice Free Download

In this article, you can download an Excel file with data for practice for free. In this file, there are five questions for you to solve. The first four problems are easy to solve, however, the last problem needs a little more advanced Excel knowledge. Therefore, if you have advanced knowledge in Excel, you are good to deal with these problems. You need to know these functions: IFERROR , IFS , AND , COUNTIFS , SUM , COUNTIF , SUMIF , WEEKDAY , and SUMPRODUCT . Additionally, you should know about the Conditional Formatting and change the font color to get the solution to the problem. If you have at least Excel 2010 , you can use all of the applied features.

Download Practice Files

You can download the Excel file from the following link.

Excel Data for Practice.xlsx

Problem Overview

This is a dataset about a small electronics retail company. There are two sales employees, working on separate shifts. The payment is shiftwise. The night shift pays more. The cost price and selling price are the accumulation of all items sold on each shift per day. We have 5 tasks to solve. Additional data are provided in the “Reference Data” sheet. These are solved in the “Solution” sheet. Here is a snapshot of the “Problem” sheet, which is only showing the first 19 rows of the 88 rows from the dataset.

• Solution: You can use the formula “(selling price – cost price)/cost price” to find the profit. Then, you can divide the profit by the cost price to get the profit percentage.
• Solution: A certain profit percentage will reward the salesman with a commission. The exact amount is provided in the “Reference Data” sheet. You can integrate that data with a conditional formula. We have created ours by combining the AND , IFERROR , and IFS functions. Moreover, the following image shows the sheets of our Excel file.

• Solution: You can use the COUNTIFS function to calculate this. Alternatively, you can use multiple COUNTIF functions to do so.
• Solution: The payment is higher for the night shift. So, the employee who works more on the night shift will earn more.
• Solution: This can be a tricky question for some. You can either solve this by creating helper columns or using the SUMPRODUCT function. We have shown both ways in the Excel file. Here, Monday is 1 , Tuesday is 2 , and so on. Additionally, you can use the conditional formatting to highlight the maximum value.

Lastly, after solving the problems, it will look like this.

Thank you for reading this article. We hope that with this Excel data for practice, a free download file, you can test your Excel skills. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

Hi, Can you help me with few things..

1. Attendance Report for 365 days which should be able to get data from Teams and update status of employees when they update as Present in Microsoft Teams.

2. Same data should be added in preparing Dashboard with Masterfile, Downtime, Employee Production count as per day wise and Pivot Table at end. All pivot table data should be shared every month with Team members on regular basis.

All above tasks should be automated…. Thanks Support. Appreciate your time…

Dear Datla Srinivas ,

We are working on your requirements. We hope we will come back to you with your expected solutions.

Regards Shamima Sultana Project Manager | ExcelDemy

We have sent you an email. Please find the attached documents in it.

Best wishes Md. Abu Sina Ibne Albaruni Team ExcelDemy

We have sent you an email. Please see the attached document in it.

Regards Md. Abu Sina Ibne Albaruni Team ExcelDemy

Can i get a videos of solving this problem cause am lost solving them

Hello Exceldemy team, pls how can i get an off line course for beginners, planning on getting into data analysis. Will greatly appreciate your prompt response. Thanks Bolajoko Olufemi

Dear Bolajoko Olufemi ,

You will get all resources related to Data Analysis here All About Data Analysis . We are planning to launch courses as soon as possible.

Regards ExcelDemy

It looks Profit Calculation is wrong in practice file…

profit percentage = (selling price – cost price) / cost price. Our calculation is correct. Additionally, commission is not usually included in the profit calculation.

Could you please clarify the difference between profit margin and profit percentage?

Hiii I am not able to understand Jacob and ben How to calculate their Day and night shift for each. ???

Hi Farhan, Hope you are doing well. Here Jacob and Ben are sales representative working in both night and day shifts. In order to calculate their day and night shift from the list for each we used a simple formula using the COUNTIFS function. First, the COUNTIFS function counts the number of cells in the cell range ( $C$5:$C$92 ) matching the value in cell ( K23 ) which indicates sales representative Ben . Next, it also match the value in cell ( L22 ) within the cell range ( $D$5:$D$92 ). As a result, we will get the result counting total number of day shifts attended by Ben .

Similarly, we can calculate the total number of shifts attended by Jacob .

Hope you found the answers for your submitted queries. Regards Wasim Akram ExcelDemy

Dear Fardeen,

The profit margin is the percentage you get from the selling price. The formula for profit margin is: (Selling Price-Cost Price)/Selling Price or, Net Profit/Selling Price

Where is solution sheet?

Dear Nikhil Pandey ,

You will get the solution sheet in the Download Practice Files section. Download the workbook there in Solution sheet you will get all the solutions. You you can get the workbook from this link Solution Sheet

I wanted to know how had you find out weekday? Please write querry below.

You will get all the solutions in the workbook’s Solution sheet. Here I’m giving you the query answer for your understanding.

The Formula is : =WEEKDAY(B5,11)

Hardest formula commission i am not able to calculate the comission for both is there any other easy way ????????

Hello FARHAN,

Hope you are doing well. I can see the formula in this article to calculate commission is a bit tricky. However, you can use the below procedure to calculate commission. I believe this formula is easier than the previous one.

=IF(K5< 12%,0,IF(K5 <= 20%, I5 *0.005,I5 *0.015)) 

Here is the final output after applying the formula to calculate the commission.

Hello ExcelDemy Team , Your responses always appreciable in Formula WEEKDAY(B5,11) What is 11 here please clarify

Hello Akram Siddique , Here, in the formula : =WEEKDAY(B5,11) 11 means – Numbers 1 (Monday) through 7 (Sunday). Here the weeks starts from Monday. So it will count the days of week from Monday and the integer value will be 1, Tuesday (2) and so on.

Where can I find more practice sheets like this?

Hello Drishti ,

Here are some article you will find more exercises. Excel Practice Exercises PDF with Answers Sample Excel File with Employee Data for Practice Advanced Excel Exercises with Solutions PDF Regards ExcelDemy

Leave a reply Cancel reply

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.

Contact  |  Privacy Policy  |  TOS

• User Reviews
• List of Services
• Service Pricing

• Create Basic Excel Pivot Tables
• Excel Formulas and Functions
• Excel Charts and SmartArt Graphics
• Advanced Excel Training
• Data Analysis Excel for Beginners

Advanced Excel Exercises with Solutions PDF

• No category

50 Ms Excel Assignments Pdf For Practice Free Download

Study collections, add this document to collection(s).

You can add this document to your study collection(s)

Add this document to saved

You can add this document to your saved list

Suggest us how to improve StudyLib

(For complaints, use another form )

Input it if you want to receive answer

Excel Beginner Exercises

In this article, I’m going to walk you through a couple of Excel exercises that are perfect for beginners. We will slowly ramp up the difficulty from beginner to advanced so if things are too easy for you, just scroll down a bit.

Getting started with formulas

‘Formulas?!’ You may be thinking. ‘That’s way too advanced for a first Excel beginner exercise.’ It’s not really. Let me explain why: formulas and functions are the bread and butter of Excel. If you want to work with Excel, it is wise to at least know what a formula looks like and why a formula is handy. That’s why we’re starting with this. Don’t worry, they are really not as complicated as they sound.

So let’s jump into it. We will be calculating the result of 32+57. However, we won’t be doing that ourselves, we will be making Excel do the hard work for us.

To start with a formula in Excel, we have to fill in the equals sign = into a cell. After that, we add our formula, so 32+57 in this case. The resulting cell content becomes =32+57 .

Note: all of our exercises have a Show answer button in the top-right that you can click if you cannot figure out what the answer has to be. After clicking Show answer , you can click on the cell to see the formula that was used in the formula bar. You can also reset the editor back to its default contents using the Reset button.

I hope the number 89 is showing in cell A1 of the spreadsheet editor above. The cool thing about this is that you can substitute the + for a minus – and it will also work. Or you can use the asterisk * to multiply. Or the slash / to divide. You can try all of these different calculations in the editor above if you want.

And just like that, you have learned how Excel formulas work! You can now get rid of your calculator 😉

Using Excel beginner functions: SUM

Now that we’ve seen how to include formulas in Excel spreadsheets, we can get to the real deal: functions. Functions are basically formulas with names. It’s easiest to understand with an example:

The SUM function will sum the values that you give it. We can recreate the formula that we created in the exercise above ( =32+57 ), but using the SUM function. That would look like this:

=SUM(32,57)

If you write this in a cell, it will show 89 . Exactly as you may expect. But you can add more numbers (separated by commas) to the function: =SUM(32,57,1) will result in 90, for example.

In this next exercise, we will combine the SUM function with another interesting Excel feature: references. So what are references? Once again, an example will explain this very quickly. Look at the following formula:

=SUM(A1,A2)

What do you think the result will be? The answer is: it depends. That’s because the formula uses references to cells A1 and A2 .

We know the SUM function will sum the values that you give it, but in this case we give it references to cells. When you do that, it will instead sum the contents of the cells that you reference. So the result will be different depending on the values in cells A1 and A2 . If cell A1 contains 1 and cell A2 contains 2 , then the result will be 3 .

These references can be super handy because they update automatically if the contents of the cells change. Whenever you edit the value in cell A1 , the result of =SUM(A1, A2) will also automatically update! And that’s why references are so ridiculously useful.

Now, let’s get to the exercise. We will be using the SUM function to calculate our total monthly income after expenses.

Calculating income using SUM

I hope that wasn’t too difficult. Or if it was a little difficult, that when you looked at the answer, it made sense.

Note about the answer: if you looked at the answer to the above exercise, you saw a notation that you may not have seen before. =SUM(B2:B5) . The colon : is used to mean a cell range . In this case, that means cells B2 up to and including B5 . So it is equivalent to using =SUM(B2,B3,B4,B5) . In Excel, there are often multiple ways of solving the same problem. I’d encourage you to use the solution that is most intuitive to you.

A step up: Average

Calculating the average of a group of numbers is quite simple: you sum them all up and divide by how many number you have. For example, the average of the number 1, 2, 3, 4 and 5 is: 1 + 2 + 3 + 4 + 5 divided by 5, because there are 5 numbers.

You could do this in Excel by typing =SUM(1,2,3,4,5)/5 into a cell. But there is an easier way. You can simply use the AVERAGE function. Let’s do so in an Excel exercise.

Note: you may have noticed by now that both of these functions are written in all-caps. That’s just the way function names in Excel are. So it may look like I’m screaming SUM at you, but that’s just how it is written.

More practical: Concatenate

We’ve seen functions that use numbers, now let’s look at another type of function: text functions. They are functions that take text as input or that result in text output (or usually both).

Before we get to the exercise, you need to know something about text in Excel formulas. Texts in Excel formulas are almost always surrounded by double quotes “. That’s just the way to let Excel know that it is a text.

Concatenate first and last names exercise

For the fourth of our Excel beginner exercises, we will be combining the contents of two cells. The first cell will have a first name, the second cell will have a last name in it. We would like to fill the third cell with the first name, then a space and then the last name.

We can do this using the CONCATENATE function. The CONCATENATE function looks like this: =CONCATENATE("text1","text2","text3") . If we would run this function, it would result in text1text2text3 . So it just combines the texts that you give it.

More Excel Exercises

That was it for our Excel beginner exercises. I hope you’ve learned something new today. If you just can’t get enough of these types of exercises, we have an Excel exercises page filled to the brim with exercises to dig your teeth into.

5 thoughts on “Excel Beginner Exercises”

• Pingback: How to Learn Excel Fast: 3 Principles to Learn Excel Quickly

Helpful and clear for beginners.

Written with very clear instructions except with the CONCATENATE. Unfortunately I cannot figure this simple formula.

This is awesome

Leave a Comment Cancel reply

Save my name, email, and website in this browser for the next time I comment.

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to  upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

• We're Hiring!
• Help Center

Excel Assignments 1-14

Related Papers

Desireé McKie

Khan Sayyad

rosy sharma

Alasdair Edwards

Mahendra Kumar

 While highly recommended as preparation for the Word and Excel Assignment, this practice exercise is optional and will not be graded.  Solutions to this assignment have been posted.  Please note that this exercise is not exhaustive and does not cover all tasks required on the Word and Excel Assignment. Purpose The purpose of this practice exercise is to help prepare you to complete the Word and Excel Assignment. This exercise requires you to use the following:  Microsoft Excel for creating tables, scatter plots, and completing data analysis.  Microsoft Word for creating a summary document containing the results and discussion from two Excel exercise. Specifically, Word will be used to import tables/plots; create text, equations, captions, and drawings; and to use built-in tools for heading styles, automatic referencing and citations, and tables of contents. Relevant Resources The Microsoft Excel tutorials and Microsoft Office Learning Resources are available at http://engineering.queensu.ca/Current-Students/First-Year-Studies/Incoming-Students.html You should read this tutorial and refer to these resources while completing the exercise. If you have any additional questions about the exercise, you may contact [email protected] for assistance. Required Software This practice exercise can be completed on both PCs and Macs. You will need the following software and plug-ins: 1. Microsoft Excel-Ensure the "Analysis ToolPak" plug-in is installed in your version. 2. Microsoft Word-Ensure you have the option to use the IEEE reference style in the Word citation management tool. Detailed installation instructions are included in the Microsoft Excel and Word tutorials mentioned previously in 'Relevant Resources.'

Kiet Nguyen

Trần Mạnh Phú

Loading Preview

Sorry, preview is currently unavailable. You can download the paper by clicking the button above.

RELATED PAPERS

Engineering with the Spreadsheet

Krisna Teeveerabhan

Sheila Evellyn

Will Robertson

Abubakar Musa

j-paine.org

Jocelyn Ireson-Paine

Ardian Kusumah

Barbara Gage , Scott Sinex

Ariya Dikha Bayu

Andrea Pitasi

Journal of Investigative Medicine

Linda Hynan

Drago Pupavac , Marija Baburić

Alfredo Sánchez Alberca

Özlem Ekici

SOUMYA MONDAL

Science Park Research Organization & Counselling

Mohamad Asghari Jafarabadi

American Journal of Business Education (AJBE)

David Tufte

Proceeding of the eleventh international ACM SIGACCESS conference on Computers and accessibility - ASSETS '09

Iyad Abu Doush

International Journal of Information and Education Technology

Nchimunya Chaamwe

ISLLAC : Journal of Intensive Studies on Language, Literature, Art, and Culture

Gita Putri Aulia

International Journal for Research in Applied Science & Engineering Technology (IJRASET)

IJRASET Publication

Nathan Brown

•   We're Hiring!
•   Help Center
• Find new research papers in:
• Health Sciences
• Earth Sciences
• Cognitive Science
• Mathematics
• Computer Science
• Academia ©2024

You are now being redirected to mayfile.online....