excel 50 assignment

Excel Practice Worksheets

Excel practice exercises.

Download our 100% fre e Excel Practice Workbook.

The workbook contains 50+ automatically graded exercises . Each exercise is preceeded by corresponding lessons and examples.

Excel Boot Camp

Excel Boot Camp: Learn Excel inside Excel

The ultimate Excel tutorial - learn efficiently with the "boot camp" approach.

Practice Online

Instead of practicing inside Excel, you can practice online with our interactive Formulas & Functions Tutorial !

Practice Shortcuts or VBA

You can also practice online with our interactive Shortcuts and VBA tutorials:

Practice And Learn Excel Online For Free

Here you can practice dozens of Excel exercises with full solutions and explanations. If you are new to excel, please check out our  Excel Basics Tutorial!

The explanations can be found in the Answer tab in each of the exercises. Have fun 🙂

New! Excel Self Assessment – Test your Excel skills and understand what to learn next to be even better!

• Basic Math and Percentages Exercise

SUM Function

• SUM Tutorial and Practice
• SUM Function – Exercise 1
• SUM Function – Exercise 2
• SUM Function – Exercise 3

COUNT, COUNTA & COUNTBLANK Functions

• COUNT Tutorial and Practice
• COUNTA Tutorial and Practice
• COUNT & COUNTA Functions – Exercise 1
• COUNT & COUNTA Functions – Exercise 2
• COUNT, COUNTA & COUNTBLANK Functions – Exercise 3

AVERAGE Function

• AVERAGE Tutorial and Practice
• Average Function – Exercise 1
• Average Function – Exercise 2
• Average Function – Exercise 3

MIN/MAX Function

• MIN Tutorial and Practice
• MAX Tutorial and Practice
• MIN/MAX Function (combined with AVERAGE)
• MIN/MAX Function (combined with IF)

IF Function

• IF Tutorial and Practice
• IF Function – Exercise 1
• IF Function – Exercise 2
• IF Function – Exercise 3
• IF Function – Exercise 4

Nested IF Function

• Nested IF Tutorial and Practice
• Nested IF – Exercise 1

VLOOKUP Function

• VLOOKUP Tutorial and Practice
• VLOOKUP Function – Exercise 1
• VLOOKUP Function – Exercise 2
• VLOOKUP with Approximate Match – Exercise 3

HLOOKUP Function

• HLOOKUP Function – Exercise 1

SUMIF Function

• SUMIF Tutorial and Practice
• SUMIF Function – Exercise 1
• SUMIF Function – Exercise 2

COUNTIF Function

• COUNTIF Tutorial and Practice
• COUNTIF Function – Exercise 1
• COUNTIF Function – Exercise 2

SUMIFS Function

• SUMIFS Tutorial and Practice
• SUMIFS Function – Exercise 1
• SUMIFS Function – Exercise 2

COUNTIFS Function

• COUNTIFS Tutorial and Practice
• COUNTIFS Function – Exercise 1
• COUNTIFS Function – Exercise 2

Pivot Table

• Pivot tables Tutorial and Practice
• Pivot Table basics – Exercise 1

Practice Excel Exams and Tests

Want to test yourself? check out our Excel Practice Tests Page

Terms and Conditions - Privacy Policy

Excel Exercises helps regular people learn Excel as quickly as possible.

Our bite-sized, interactive lessons make excel skills easy to learn and remember..

"I finished up all the lessons, they really helped me understand Excel logic better. Can't wait for more!"

"i stumbled across your website with excel exercises, and it's seriously an amazing resource [...] i seriously believe your platform proves to be one of the most efficient ways to learn excel", "when i first started the practice exercises at your site i just found it really acclerated my comprehension of excel. i started to understand it so much better than any other prior learning platform that i had visited.", a better way to learn excel skills.

Welcome to the fun, hands-on way to learn Excel! My name is Jake and I'm known as a spreadsheet wizard around my office, but it wasn't a fast or easy process to get here. I watched several hours worth of Excel training videos, but found I didn't really master a formula until I actually got my hands dirty and used the formula at work. It took me a few years of working in finance and consulting- using Excel nearly every day- to internalize all the keyboard shortcuts and functions. I started wondering why there wasn't an easier and faster way to master Excel.

Like I mentioned before, I spent hours watching Excel training videos, but they were honestly kind of boring. I'd find myself zoning out and would need to rewind and re-watch each video two or three times. And without immediately putting the techniques from the videos into practice, I'd forget the techniques right after watching the video.

Excel Practice For Real People

Practice Excel the right way - in small, bite-sized, engaging lessons, rather than falling asleep reading a lengthy article or daydreaming through a long video. This is Excel practice for those who learn by doing, not by watching. There's a reason thousands of people are choosing to get their Excel practice from Excel Exercises: because it works. Each lesson is designed to keep you engaged and entertained while walking you through new concepts, so that you can't advance if you're not absorbing the information. That's just one of the ways Excel Exercises helps you learn more efficiently and maximize your practice time.

Excel Exercises Solves the "Boring Video" Problem

We walk you through all the Excel functions that you need to know, forcing you to type through practice exercises to get hands-on and commit them to memory. You'll also practice keyboard shortcuts on your own keyboard to build muscle memory and get faster at manipulating spreadsheets. Through hands-on repetition and smart skills targeting, I've distilled all the skills I've learned from years of working with Excel to a program that can be completed in a matter of days.

Have Fun While You Learn With Excel Exercises

These practice exercises aren't just engaging; they are actually fun. Score points by answering questions correctly and advance through the levels as you learn, rather than relying on boring memorization. You'll start by practicing some easy skills and work your way up to practicing more advanced techniques. By gradually introducing new concepts for you to practice, we make it easy to learn all the techniques you need to become an Excel master. Whether you're searching for easy Excel practice exercises or more advanced formula practice, Excel Exercises offers a fun learning experience for all skill levels - it doesn't even feel like learning!

Thousands of people have already used Excel Exercises to practice Excel skills and advance their careers. Solid Excel skills are critical for most finance, accounting, consulting, and other data-oriented jobs. And let's be honest - if your shortcut game is on point you'll impress anyone watching over your shoulder. Learn Excel the fun way today and get your career moving in the right direction.

Use Excel Exercises to Excel-erate Your Career

Almost any job in Finance, Accounting, Data Science, Consulting, or any other quantitative industry will require you to use spreadsheets. By mastering Excel you can give yourself an edge by completing your work faster and better than your peers. Many jobs today also require an Excel test as part of the application and interview process. Whether you're applying for an internship or you're already an executive, Excel mastery is a tangible and noticeable skill that can help you get the offer, earn more money, and make yourself indispensable.

Today's job market demands strong spreadsheet skills like never before. Everything from simple data entry to advanced data analysis will require proficiency with Excel in order to pass the interview process and perform with the speed and quality necessary to thrive in your new job. Luckily, there are now more resources than ever available to help you learn Excel online. Excel Exercises is the first web-based Excel practice resource that simulates real Excel practice exercises right in your browser. Let Excel Exercises be your new secret weapon to master Excel and get a new job or move up in your current role.

No sign up necessary. If you love it, you can create an account and join thousands of others who are already using their new Excel skills to stand out and get ahead in their careers.

Hands-on Exercises

Most people can't learn new skills simply by watching. There's a reason you hear that the best way to learn Excel is just to use it at work for a few years. But when you don't have years to learn Excel, your best option is the curated simulations offered by Excel Exercises. We walk you through new skills and let you write the actual formulas and tap out the keyboard shortcuts to build muscle memory and learn by doing. By focusing on one skill at a time, you'll get enough reps to commit the skill to memory before moving on.

Excel Exercises for Beginners and Experts

Whether you already have some Excel experience or you've never written a "sum" function in your life, this site will teach you the tools to stand out at work as the Excel Master. It starts easy with simple functions to build a solid foundation. Then it becomes more challenging as the lessons incorporate new concepts, shortcuts, and advanced functions to build your skills, boost your efficiency, and expand on what you thought was possible with Excel. Whether you're a beginner or advanced, there is always a new Excel skill you can learn.

50 Tricky MS Excel Objective Questions and Answers PDF

Download the Practice Workbook

You can download the  PDF  and Excel  files by submitting your valid email address:

Problem Overview

The Excel and PDF files each contain 50 MS Excel objective questions and answers in PDF format. The questions are provided in the “Problem” sheet. The answers are highlighted in the “Solution” sheet. Here’s a snapshot of the sample dataset for this article. The dataset represents the sales achieved by 20 employees for a company.

Let’s go through the objective questions.

• Q1. Which Function can be used to Find the Number of Females?
• Both a & b
• Q2. The function to find the highest sales value is –
• Both a & c
• Q3. The total value of sales for the male employees can be calculated by using –
• INDEX-MATCH
• Q4. To find the employee who generated the most sales, you can use the following formula –
• =INDEX(B5:B24,MATCH(MAX(F5:F24),F5:F24,0))
• =INDEX(B5:B24,MATCH(MAX(F5:F24),F5:F24,1))
• =INDEX(B5:B24,MAX(F5:F24),0)
• =INDEX(B5:B24,MATCH(MAX(F5:F24),F5:F24,-1))
• Q5. To find the distinct job position names, you can use –
• IFERROR, INDEX, and MATCH
• Both b & c
• Q6. To determine the total number of characters in the employee names, you can use the function named –
• STRINGLENGTH
• Q7. To extract the day value from the Date Joined column, which of the following features can be used?
• DAY Function
• Insert an adjacent helper column and use Flash Fill
• LEFT Function
• a, b & c
• Q8. Which function can be used to determine the number of empty cells in the dataset?
• Q9. Which function from the list can return a random name?
• =INDEX(B5:B24,MATCH(RANDBETWEEN(1,20),B5:B24,0))
• =INDEX(B5:B24,RANDBETWEEN(1,20))
• =INDEX(B6:B25,RAND())
• =INDEX(B6:B25,RAND(20))
• Q10. To create a Pie Chart using the Position column, you can –
• Select the cell range D5:D24 and select Pie Chart from the Insert tab.
• Select the cell range D5:D24 and select Recommended Chart from the Insert tab, and then select the Pie Chart.
• Find the unique values and their instances and then create a Pie Chart.
• None of these.
• Q11. To determine the number of sales greater than $100,000 AND dates joined after 30th April, the following formula needs to be used –
• =COUNTIFS(F5:F24,”>100000″,E5:E24,”>44681″)
• =COUNTIF(F5:F24,”>100000″)+COUNTIF(E5:E24,”>44681″)
• None of these
• Q12. To determine the number of sales greater than $100,000 OR dates joined after 30th April, the following formula needs to be used –
• Q13. To calculate the average sales by the male employees, the following formula need to be used –
• =AVERAGEIF(C5:C24,”Male”,F5:F24)
• =AVERAGEIFS(C5:C24,”Male”,F5:F24)
• =IF(C5:C24=”Male”,AVERAGE(F5:F24),””)
• =MEANIF(C5:C24,”Male”,F5:F24)
• Q14. To find the arithmetic mean, you can use the following function –
• Q15. The shortcut to find the total of some numbers is –
• Ctrl + Alt + =
• Q16. To insert a chart from a data selection, you can press –
• Q17. To open the Spelling dialog box, you need to press –
• Q18. To bring up Custom Cell Formatting, press –
• Q19. To repeat the previous action, you will need to press –
• Q20. The latest version of Microsoft Office is called –
• Microsoft 365
• Q21. Which of the following shortcuts will open the Find and Replace dialog box and activate the Replace tab?
• Q22. To return value from the left side of the matched value, we can use –
• VLOOKUP Function
• VLOOKUP and IF Functions
• HLOOKUP Function
• ZLOOKUP Function
• Q23. Which formula is correct for returning the name of the salesperson with $25,010 in sales?
•  =VLOOKUP(F5,IF({1,0},F5:F24,B5:B24),2,0)
• =ZLOOKUP(F5,F5:F24,B5:B24)
• =XLOOKUP(F6,F5:F24,B5:B24)
• Q24. The cell C15 is empty and F15 is $135,430. So, the output of =C15*F15 is –
• Q25. Different types of Font Formatting are available in the –
• Q26. There is a total of x functions inside the AGGREGATE Function. The value of x is –
• Q27. The maximum number of rows and columns in Excel are –
• 1,048,576 columns and 16,384 rows
• 1,048,576 rows and 16,384 columns
• 256 columns and 65,536 rows
• Q28. The last column in Excel is –
• Q29. The first version of Excel was released in –
• Q30. Which of the following functions can you use to determine the number of values in the Sales column?
• Q31. Microsoft Excel is the most popular spreadsheet program in the world. Which of the following is the first spreadsheet program?
• Microsoft Excel
• Lotus 1-2-3
• Q32. If you want to show the current date with time, you can use –
• Q33. The difference between the SEARCH and FIND function is –
• The FIND function is case sensitive and the SEARCH function is not.
• The SEARCH function is case sensitive and the FIND function is not.
• There is no difference between them, only for compatibility, both are listed.
• Q34. Which of the following functions is not available in the VBA WorksheetFunction method?
• Q35. If there is a red triangle in the top-right corner of the cell, it signifies –
• There is a note in that cell.
• The cell is formatted as text.
• There is an error on that cell.
• There is a circular reference.
• Q36. If there is a green triangle in the top-left corner of the cell, it signifies –
• The cell is formatted as a number.
• Q37. Which of the following shortcuts brings up the VBA window?
• Q38. Which of the formulas rounds up the sales figure from cell F17 to the nearest thousand?
• =MROUND(F17,1000)
• =FLOOR.MATH(F17,1000)
• =CEILING.MATH(F17,1000)
• =ROUNDUP(F17,1000)
• Q39. You can assign sequential serial number (1,2,3, etc.) to the rows by using the formula and AutoFill –
• =ROWS($B$5:B5)
• Q40. Which of the following are not valid Excel functions?
• Both a&b
• Q41. In the VBA Cells function, the argument Cells (x, y) means –
• x = row number, y = column number
• x = column number, y = row number
• x = row index y = column index
• x = column index, y = row index
• Q42. The maximum height of a row is –
• 409.5 Units
• 403.5 Units
• Q43. You can copy a cell by using the shortcut –
• Q44. Which of the following functions is available but not shown in the Excel Tooltip?
• Q45. Which of the following is an absolute cell reference?
• Q46. Which of the following is a mixed cell reference?
• Q47. When you move your cursor to the bottom right corner of a cell, it turns into a plus (+) sign. This icon is known as the –
• AutoFill Tool
• Fill Handle
• Drag Handle
• Q48. If you select a range of cells and type something, pressing a specific shortcut will copy the value to the selected range. That shortcut key is –
• Shift + Enter
• Ctrl + Enter
• Alt + Enter
• Q49. If there is a VBA code in your Excel file, then you should save the file in ____ format –
• Q50. Google has developed their own spreadsheet program, which is known as –
• Spreadsheet

The image below depicts the first five solutions to the objective questions.

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

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

Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.

Excel Practice 1

Since Microsoft Excel is widely used in industry, and we are using Microsoft Windows, we will focus on Excel going forward. There are many similarities across spreadsheet software, so the skills we are learning can be translated to other software and apps. The following ‘Practice It’ assignments are designed to be completed using Microsoft Excel in Office 365 on a PC with Windows 10 or higher.

We will use Excel to perform complex calculations, analyze data so that we can make intelligent decisions, and create visually interesting charts and graphs that help us understand the data. Since Excel is used for Data Analysis, it is best to use a keyboard and mouse or touchpad rather than the touchscreen.

In Excel, data is stored in a cell . Cell content is anything that is stored in the cell and can be either a constant value or a formula. The most commonly used values are text values and number values . Values can also be a date or time. A text value is also referred to as a label.

Here is a video demonstrating the skills in this practice. Please note it does not exactly match the instructions: 

Complete the following Practice Activity and submit your completed project.

For our first assignment in Excel, we will create a spreadsheet with monthly expenses. This spreadsheet will provide us with an overall picture of our financial health by helping us understand where we are spending our hard-earned money. We will start with a new blank Excel Spreadsheet.

• Start Excel. Click Blank Workbook.
• Select File, Save As, Browse, and then navigate to your Excel folder on your flash drive or other location where you save your files. Name the workbook as Yourlastname_Yourfirstname_Excel_Practice_1.

• Notice the vertical and horizontal scroll bars. Use the arrows to practice scrolling on the page.
• In cell A1, type My Budget By Month and press Enter.
• In cell A2 Type For the First Quarter and press Enter.
• In the Name Box, change A3 to A4 and then press Enter. Notice how the active cell changed to A4.
• Misc Expenses
• Monthly Total
• In cell B3, type January and press Enter.
• Select cell B3 and use the fill handle to drag to cell D3. Notice how the names of the months automatically generate. The fill handle enables auto fill , which generates and extends a series of values into adjacent cells based on the value of other cells.

• Adjust the column width for column A to 136 pixels by dragging the right boundary (between columns A and B) to the right.
• Select the range B3:D3 and center the text.
• In cell B4, type 1200 and enter the remaining numbers as shown:

• In cell B8, type =b4 + b5 + b6 + b7 and press Tab.
• In cell C8, type =c4 + c5 + c6 + c7 and press Tab.
• A quicker way to enter in a formula is with a function . We will use the SUM function next. In cell D8, click AutoSum on the Home Tab, Editing Group and press Enter.
• In cell E3, type Total and then press Enter.
• Click in cell E4, Press Alt + =. This is a keyboard shortcut that enters the Sum function. If the keyboard shortcut does not work (this is common due to variations in keyboards), use the AutoSum technique from step 16.
• Click the Enter button on the Formula Bar which is the green or blue check mark.
• With Cell E4 selected, drag the fill handle in cell E4 down through cell E8.
• Click in cell F3, type Trend and press Enter.
• Click in cell A1, and drag your cursor to the right to select the range A1:F1. On the Home tab, in the Alignment Group, choose Merge and Center . The title should be Merged and centered in the range A1:F1.
• Using the same technique, Merge and Center the title in the range A2:F2.
• Apply the Title style to cell A1 and the Heading 1 style to cell A2. Cell styles are on the Home Tab, Styles Group, then choose the arrow next to cell styles .
• Apply the Heading 4 style to the ranges B3:F3 and A4:A8. You can select the first range, hold down the CTRL key, and select the second range, then apply the cell style. Or apply, one at a time.
• Apply the Accounting number format to the ranges B4:E4 and B8:E8. The number format is located on the Home Tab, Number Group. Select the arrow to view a drop down list of all number formats.
• Apply the Comma number style to the range B5:E7. This is located on the Home Tab, Number Group, and select the comma.
• Apply the Total number style to the range B8:E8. Cell styles are on the Home Tab, Styles Group, then choose the arrow next to cell styles.
• AutoFit column D. Select column D by clicking on the D Column Header. Then, double click the line between the D and E. Or, with Column D selected, on the Home Tab, Cells Group, click the arrow next to Format and choose auto fit for the Column.
• Apply the Slice theme to the Workbook. On the Page Layout Tab, in the Themes Group, choose Slice. If necessary, adjust the total cells, or any other cells to ensure you can see all of the cell content.
• Select the range A3:D7.
• On the Insert tab, in the charts group, click Recommended Charts, click All Charts, select Clustered Column chart and then click OK.
• With the chart selected, under the Chart Design Tab, in the Chart Layouts Group, Choose the Add Chart Element and ensure the Chart Title is ‘Above Chart’. Change the Chart Title to My Budget.
• Drag the chart by clicking and holding any of the chart outer lines using the four-sided arrow mouse pointer. Move the chart so that the upper left corner is inside cell A10.
• Ensure the chart is still selected, and apply Chart styles, Style 6. Chart styles are located on the Chart Design Tab, under Chart Styles. Click the down arrow (“more” button, which is the upside-down triangle with the line above it) to see all of the Chart Styles.
• Using Change Colors select Colorful Palette 4. The Change Colors button is located on the Chart Tools, Design Tab, under Chart Styles
• Select the range B4:D4 and insert a Line sparkline in cell F4. Be sure to not include the totals in the sparkline range. Sparklines are located on the Insert Tab, Sparklines group, then choose Line. The sparkline will display in cell F4. For the location range, click in cell F4.
• With cell F4 selects, on the Sparklines, Design Toolbar, in the Show group choose the checkbox next to Markers.
• Apply the Dark Green, Sparkline Style Colorful #4 style (or similar). Styles are located on the Sparkline Design toolbar in the Style group. Choose the down arrow to view more styles.
• With cell F4 selected, use the fill handle to fill the sparkline to cells F5:F7.
• On the Page Layout Tab, Sheet Options Group, click the arrow to launch the Page Setup Dialog Box. Notice how it opens to the Sheet tab. Go to the Margins tab and click the checkbox to center the data and chart horizontally on the page.
• With the Page Setup Dialog Box still open, go to the Header/Footer tab. Choose Custom Footer and insert the File Name in the left section of the footer. The file name will show in the Print Preview and also when the spreadsheet is printed. This is a field , so if the file name is changed, it will automatically update the footer with the new file name.
• Title: Excel Budget
• Subject: OFTEC 108 and Section #
• Author: Your First and Last Name
• Keywords: Sums, Charts, Budget, Excel
• Click the back arrow to exit backstage view. Click the Save shortcut button and ensure your file is saved in a safe location.
• Select the range A2:F5 and then press Ctrl + F2. This is the keyboard shortcut that displays Print Preview . If you do not have the shortcut key, click File to enter Backstage View, Print and view the Print Preview.
• Change the print settings option to Print Selection and notice how the Print Preview changes. Printing of this assignment is not required, but if you needed to print a copy, you would click Print.
• Exit Backstage view and Save your file.
• On the Formulas tab, in the Formulas Auditing group, Show the Formulas. This is a toggle button, so press it once to show the formulas. Press it again to remove show formulas. Notice how row 8 and column D display the formulas rather than the result when the show formulas is turned on. Turn show formulas off.
• On the Page Layout tab, in the Page Setup group, Change to Landscape orientation and Scale the data to fit on one page. This is on the Page Tab of the Page Layout Dialog Box.
• Run spelling and grammar check from the Review tab using the Spelling button in the Proofing group, making any spelling corrections as necessary. Compare your file to the image below and make all necessary corrections.

Intro to Microsoft Office Copyright © 2021 by Abby Rusu & Maricopa Millions is licensed under a Creative Commons Attribution 4.0 International License , except where otherwise noted.

Share This Book

Microsoft Excel Tutorials : Including Free Practice Exercises!

Right below you find +100 excel-tutorials. all tutorials are super practical and include free exercises. simply download the included sample file and start practicing your excel skills today.

More results...

Excel Line Spacing: How to Adjust Line Spacing (2024)

Excel Line Spacing: How to Adjust Line Spacing (2024) Sometimes, you may need to input a long text into your Excel spreadsheet. When you do, you need to make sure that it's organized and presentable, not only for your sake but for others as well😊 One of the many ways to do that [...]

How to Calculate MEDIAN IF in Excel (“MEDIANIFS” Formula)

How to Calculate MEDIAN IF in Excel ("MEDIANIFS" Formula) Excel is a powerful tool that can help you easily analyze and manipulate data. One of the most useful functions in Excel is the median function, which helps find the middle value in a set of data. However, what if you only want to [...]

How to SUM by color in Excel: Step-by-Step Guide (2024)

How to SUM by color in Excel: Step-by-Step Guide (2024) Most of you know how to get the Excel SUM. It's one of the most basic Excel functions. What most people don't know is that you can get the Excel SUM by color, too 🤩 There is no built-in function for this but [...]

How to do RANK IF in Excel to Rank With Condition (2024)

How to do RANK IF in Excel to Rank With Condition (2024) Ranking values in Excel is something very common. And with the RANK function, that’s not even a problem. However, if you want to perform a conditional (or criteria-based) ranking in Excel, this might be a little problem at first 😣 That’s [...]

Excel Not Responding – Here is How to Fix it (2024)

Excel Not Responding - Here is How to Fix it (2024) Excel is a powerful tool used by millions of people around the world to handle data 💪🏻 However, it is common for Excel users to get issues with Excel files such as the Excel not responding error. This is such a frustrating [...]

“Reference isn’t Valid” Excel Error: How to Fix (2024)

"Reference isn't Valid" Excel Error: How to Fix (2024) When you're working in Excel to organize and analyze your data, you may encounter different types of Excel errors ⚠️ Getting Excel errors is so frustrating because it hinders you from getting work done 😩 The "Reference isn't Valid" error is one of the [...]

Excel Ran Out of Resources – How to Fix it Step-by-Step (2024)

Excel Ran Out of Resources - How to Fix it Step-by-Step (2024) Microsoft Excel is an amazing tool that we can use to do our calculations. But, sometimes you get a headache with Excel when there are errors 😞 Most of the time you have to sort out these issues by yourself because [...]

How to use the Excel functions TRUE & FALSE (Boolean)

How to use the Excel functions TRUE & FALSE (Boolean) There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. For example, you might manage a sales team. You may need to calculate whether each salesperson qualifies [...]

How to Switch X and Y Axis in Excel (Flip Chart Axes)

How to Switch X and Y Axis in Excel (Flip Chart Axes) Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble.  Microsoft Excel is powerful spreadsheet software that will let you store data and make calculations on it. You can then visualize the data using [...]

How to Print Labels From Excel: Step-by-Step (2024)

How to Print Labels From Excel: Step-by-Step (2024) Mail Merge is one awesome feature that will help you create mass letters and email messages. But you can also use it to create and print mailing labels for your mailing list 😀 All you need to do is to prepare your label data in [...]

The 9 Best Project Management Templates for Excel (Free)

The 9 Best Project Management Templates for Excel (Free) Project managers are known for their decisiveness and time management. A project's success depends on how a project manager identifies, plans, and employs the resources available for any given project (especially the timespan). If you, too, have a complicated project ahead of you that [...]

Free Excel Dashboard Templates (My Top-6)

Free Excel Dashboard Templates (My Top-6) Excel dashboards are the difference between good and great data presentation. A well-built dashboard can breathe life into the most boring and mundane subjects. Simple Excel dashboards are easy enough to build if you follow a proper tutorial like ours here. But to truly wow your [...]

How to Create Macros in Excel: Step-by-Step Tutorial (2024)

How to Create Macros in Excel: Step-by-Step Tutorial (2024) Get ready to have your mind blown! 🤯 Because in this tutorial, you learn how to create your own macros in Excel! That’s right! And you don't need to know VBA (Visual Basic for Applications)! Instead, you will use the Excel macro recording feature [...]

How to Recover an Unsaved Excel File (5 Free Solutions)

How to Recover an Unsaved Excel File (5 Free Solutions) Losing an unsaved Excel file is a real pain🤕 Whether you lose an entire Excel spreadsheet or just the latest round of edits, it can take a lot of time to fix the problem. But don’t worry! In this guide, I’ve compiled the [...]

How to Insert a Checkbox in Excel (4 Uncomplicated Steps)

How to Insert a Checkbox in Excel (4 Uncomplicated Steps) If you want to collect user input in your spreadsheet there's no better way than the checkbox. User-friendly, slick-looking, and easy for you to work with. Well... After you learn it at least. If you're having a hard time understanding the ins [...]

How to Remove Blank Rows in Excel (3 Easy Methods)

How to Remove Blank Rows in Excel (3 Easy Methods) Choosing the right method to remove blank rows in Excel is crucial - a wrong move can lead to lost data. Method 1: Remove all rows that contain only blank cells Method 2: Remove all rows that contain one or more blank cells Method [...]

How to Use VLOOKUP in Excel: 4 Easy Steps (For Beginners)

VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.

How to Add Axis Labels in Excel Charts (X and Y Titles)

How to Add Axis Labels in Excel Charts (X and Y Titles) An axis label briefly explains the meaning of the chart axis. It's basically a title for the axis. Like most things in Excel, it's super easy to add axis labels, when you know how. So, let me show you 💡 If [...]

How to Use INDEX MATCH With Multiple Criteria in Excel

In this tutorial, you'll learn to use the MATCH INDEX functions with multiple criteria by following 5 easy steps. In the end, you'll have built a tool to search through your spreadsheet for information that you define. Don't miss this one!

How to Create a Drop-down List in Excel (in 60 Seconds)

The drop-down list is a great way to look like a superuser and impress your co-workers and boss. At the same time, it’s a very user-friendly asset in almost all custom-made Excel sheets. In this tutorial, we're going to show you the 5 steps to create a drop-down in 1 minute or less. We call it the “1 Minute Drop-Down”.

How to Track Changes in Excel & View Them (Easy Method)

How to Track Changes in Excel Tracking changes in Excel is a critical feature you need for managing and reviewing edits when working with a team 💻 You can use this functionality to keep a track record of all the changes made and who made what changes in the workbook. You can highlight [...]

Does dragging an Excel formula not work? Here’s why!

Does dragging an Excel formula not work? Here's why! If I wake up tomorrow learning that the dragging formulas feature of Excel will no longer work – I’d prefer sleeping back assuming it was only a nightmare. Half of the power of Excel is derived from its dynamics to drag the formula around [...]

How to Make a Flow Chart in Excel (Step-by-Step)

How to Make a Flow Chart in Excel (Step-by-Step) Flow charts are an excellent way to visually represent workflows, processes, and complex walkthroughs to reach a decision. You can design flow charts in Excel using its wide array of tools and shapes. It allows detailing and customizing options to create professional-looking flow [...]

How to Calculate and do an Anova Test in Excel

How to Calculate and do an ANOVA Test in Excel The ANOVA test of Microsoft Excel is a great statistical tool that helps you find significant differences between two or more data groups. Never mind if you’re hearing the word ANOVA for the first time – the word might be alien but the [...]

How to do Sensitivity Analysis in Excel (Easily)

How to do Sensitivity Analysis in Excel (Easily) Excel is a great analytical tool and if you haven’t yet used it for sensitivity analysis, you’re missing out on a great feature of Microsoft Excel. The sensitivity analysis tool of Excel allows you to see how variation in one or more input variables may [...]

How to Tab Down in Excel (Must-Know Method)

How to Tab Down in Excel (Must-Know Method) In today's data-driven world, proficiency in Excel is an indispensable skill for nearly everybody. You can enhance your Excel efficiency many folds by understanding the art of navigation within Excel. This will enable you to work smarter, and not harder. Especially if you want to [...]

How to Separate All Sorts of Data Using Excel Formulas

How to Separate All Sorts of Data Using Excel Formulas When it comes to data management and organization, splitting text is the one task that’s inevitable. It can range from splitting numbers from text to parsing out data based on specific delimiters. Luckily, Excel offers a variety of methods you can use to [...]

How to Fix Problems With Excel Formula References

How to Fix Problems With Excel Formula References Excel formulas are powerful tools that allow you to analyze data, automate large calculations and perform a variety of different tasks. However, sometimes a small mistake in the formula can lead to errors like formula references that can lead to incorrect results or unexpected behaviour [...]

How to Create a Fillable Form in Excel (Data Entry)

How to Create a Fillable Form in Excel (Data Entry) Thinking of fillable forms, the first thing that comes to mind is probably an editable PDF or a Google Form. Gotcha! You can also create fillable forms in Microsoft Excel and believe me, it is a very effective way to collect and manage [...]

How to Center Text in Excel (Works Every Time)

How to Center Text in Excel (Works Every Time) As you store data in Excel (some of which might be text), the alignment of the data within the cells is a core aspect. Centering (or aligning) text in Excel is a fundamental feature. It not only adds to the visual appeal of your [...]

• 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 Tutorial

Excel formatting, excel data analysis, table pivot, excel functions, excel how to, excel examples, excel references, excel exercises.

You can test your Excel skills with W3Schools' Exercises.

We have gathered a variety of Excel exercises (with answers) for each Excel Chapter.

Try to solve an exercise by editing some code, or show the answer to see what you've done wrong.

Count Your Score

You will get 1 point for each correct answer. Your score and total score will always be displayed.

Start Excel Exercises

Start Excel Exercises ❯

If you don't know Excel, we suggest that you read our Excel Tutorial from scratch.

COLOR PICKER

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail: [email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail: [email protected]

Top Tutorials

Top references, top examples, get certified.

Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.

Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.

Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.

• Homework Q&A
• Become a Tutor

All Subjects

Mathematics

Programming

Health & Medical

Engineering

Computer Science

Foreign Languages

Access over 35 million academic & study documents

50 ms excel assignments pdf for practice free download.

Sign up to view the full document!

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic  math  to advanced rocket science !

Similar Documents

working on a study question?

Studypool is powered by Microtutoring TM

Copyright © 2024. Studypool Inc.

Studypool is not sponsored or endorsed by any college or university.

Ongoing Conversations

Access over 35 million study documents through the notebank

Get on-demand Q&A study help from verified tutors

Read 1000s of rich book guides covering popular titles

Sign up with Google

Sign up with Facebook

Already have an account? Login

Login with Google

Login with Facebook

Don't have an account? Sign Up

#1 Excel tutorial on the net

• Assignment Problem

Formulate the Model | Trial and Error | Solve the Model

Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost.

Formulate the Model

The model we are going to solve looks as follows in Excel.

1. To formulate this assignment problem , answer the following three questions.

a. What are the decisions to be made? For this problem, we need Excel to find out which person to assign to which task (Yes=1, No=0). For example, if we assign Person 1 to Task 1, cell C10 equals 1. If not, cell C10 equals 0.

b. What are the constraints on these decisions? Each person can only do one task (Supply=1). Each task only needs one person (Demand=1).

c. What is the overall measure of performance for these decisions? The overall measure of performance is the total cost of the assignment, so the objective is to minimize this quantity.

2. To make the model easier to understand, create the following named ranges .

3. Insert the following functions.

Explanation: The SUM functions calculate the number of tasks assigned to a person and the number of persons assigned to a task. Total Cost equals the sumproduct of Cost and Assignment.

Trial and Error

With this formulation, it becomes easy to analyze any trial solution.

For example, if we assign Person 1 to Task 1, Person 2 to task 2 and Person 3 to Task 3, Tasks Assigned equals Supply and Persons Assigned equals Demand. This solution has a total cost of 147.

It is not necessary to use trial and error. We shall describe next how the Excel Solver can be used to quickly find the optimal solution.

Solve the Model

To find the optimal solution, execute the following steps.

1. On the Data tab, in the Analyze group, click Solver.

Note: can't find the Solver button? Click here to load the Solver add-in .

Enter the solver parameters (read on). The result should be consistent with the picture below.

You have the choice of typing the range names or clicking on the cells in the spreadsheet.

2. Enter TotalCost for the Objective.

3. Click Min.

4. Enter Assignment for the Changing Variable Cells.

5. Click Add to enter the following constraint.

Note: binary variables are either 0 or 1.

6. Click Add to enter the following constraint.

7. Click Add to enter the following constraint.

8. Check 'Make Unconstrained Variables Non-Negative' and select 'Simplex LP'.

9. Finally, click Solve.

The optimal solution:

Conclusion: it is optimal to assign Person 1 to task 2, Person 2 to Task 3 and Person 3 to Task 1. This solution gives the minimum cost of 129. All constraints are satisfied.

Learn more, it's easy

• Transportation Problem
• Shortest Path Problem
• Maximum Flow Problem
• Capital Investment
• Sensitivity Analysis
• System of Linear Equations

Download Excel File

• assignment-problem.xlsx

Next Chapter

• Analysis ToolPak

Follow Excel Easy

Become an Excel Pro

• 300 Examples

Assignment Problem • © 2010-2024 Excel is Awesome, we'll show you: Introduction • Basics • Functions • Data Analysis • VBA