student ms excel practical assignment

Excel Practice Exercises PDF with Answers

To solve the following exercises, you will need to know about the SUM , AVERAGE , IF , VLOOKUP , INDEX , MATCH , ROUNDUP , UNIQUE , COUNTIF , LEFT , SEARCH , MID , RIGHT , LEN , FIND , SUBSTITUTE , AND , and SUMIF functions and the Data Bars feature of Excel. You can use Excel 2010 or later, except for the UNIQUE function, which is only available in Excel 2021 .

Download the Practice Files

You can download the PDF and Excel files by filling out this form:

Eleven Practice Exercises with Solutions.pdf [/wpsm_box] [wpsm_box type="download" float="none" textalign="left"] Eleven Practice Exercises.xlsx [/wpsm_box] -->

Problem Overview

Here is a snapshot of the first two problems. The solutions to all problems are given in a separate sheet.

Exercise 01 – Class Performance Evaluation . You will find these values –
The total number for each student,
Their average on those subjects,
Based on the average score, you will return a GPA. For GPA calculation, less than 60 is B and higher is A .
You need to find the employee salary in the lookup table on the right side.
Exercise 03 – Lookup Values (Any Direction) .
Here your task is the same as the second task. However, this time the lookup range is on the right side. Therefore, you cannot use the VLOOKUP function here.
You will need to round the sales generated values in this exercise.
You will need to add the first name and last name.
Your task is to create a Data Bar for the salary values and hide the salary values.
Firstly, you need to find the unique values in a list of names.
Then, you will find how many times that value occurred in that lis
You need to separate the three parts of a name from a given list.
You will need to find the total sales for a particular country.
Your objective is to ensure that users cannot type less than 0 in a column.
Your target is to determine whether a date is between two dates or not.

Here is a screenshot of the solutions to the first two problems.

Excel Practice Exercises PDF with Answers

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

You really help me alot thanks

Hello, Aleem!

Thanks for your appreciation. stay in touch with ExcelDemy .

Regards ExcelDemy

Thanks a lot

Dear Rashmi ,

You are most welcome.

This is very helpful. You are God send

Thanks for your appreciation.

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.

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

Subject Explorer

School Subjects

Math & Science

Business & Technology

Electives & Health

Board & Administration

Teaching & Learning

Audio/Video Lectures

Books & Documents

Classifieds

Jobs & Resources

Discussions

Language & Literature

Practice Projects for Excel

Excel Project C9: Grades and Averages Practice Document

Instructions for students to “create a spreadsheet that shows all of your classes and automatically averages all of your test grades for each subject and then shows an overall average of your test …

Excel Project C8: Attendance Record Practice Document

In this practice project for Excel and similar spreadsheets, students create a spreadsheet that automatically adds up all of the Sunday School classes each Sunday, gives an average attendance for …

Excel Project C7: Loan Payment Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a record of loan payments. They format columns to make each payment automatically subtract from the balance …

Excel Project C6: Treasurer’s Report Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a treasurer’s report at an imaginary church. They also format a column to find the total at the bottom. …

Excel Project C5: Parent Directory Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a parent directory with empty spaces for parent contact information. …

Excel Project C4: School Directory Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a school directory with title and four columns of information. …

Excel Project C3: Sign Up Sheet Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a weekly sign up sheet with a title and two columns. …

Excel Project C2: Chapel Schedule Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a weekly chapel schedule including date, speaker, topic, and song leader. …

Excel Project C10: Invoice Practice Document

In this practice project for Excel and similar spreadsheets, students create an invoice template like the sample shown, entering the formulas for all of the cells so that the numbers total correctly …

Excel Project C1: Bible Memory Chart Practice Document

In this practice project for Excel and similar spreadsheet programs, students replicate a Bible memory chart. …

Categories:

Resource Type:

Pass it on:

Learning Center

Excel tutorials and practice tests.

Welcome to Automate Excel! Here you will find the best free Excel & VBA resources anywhere on the web. This page will direct you to all of our best content.

Scroll down the page to find detailed descriptions of our 100% FREE interactive tutorials, but you can use this top section to easily jump to our cornerstone resources.

Our VBA Tutorial and our VBA Code Generator as well as over 100 free VBA Code Examples .

Our VBA Formulas Tutorial and Excel Boot Camp as well as Formulas and Functions lists.

Our Excel ShortCut Training App , our popular ShortCut Coach Excel add-in and over 200 free Shortcuts .

Automate Excel and Steve Rynearson

Hi I’m Steve, The Chief Excel Officer at AutomateExcel. I'm here to help you "Excel" at Excel.

Courses and Examples

Get started with excel.

To start, we recommend going through our one-of-a-kind, completely free interactive Excel Tutorials. These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.

The tutorials cover at least 80% of what most Excel users would ever need to know. Beginners love our tutorials because they’re the fastest (and easiest) way to learn Excel or VBA. We also receive many emails from experienced Excel users who report learning new tricks and brushing up on knowledge.

Our tutorials are completely free, but you will need to create an account to save your progress.

Our interactive tutorials also contain practice tests that allow you to test what you've learned. The practice tests also let you define a custom set of questions in which to test yourself.

Testimonials

100% free and interactive, excel practice tests and tutorials, formulas and functions.

Learn 30 of Excel's most powerful functions with 60 interactive exercises and many more examples:

Intro to Formulas
Logical & Comparison
Statistical

Also learn about other formula essentials including:

Formula Shortcuts
Comparisons and Boolean Values
How to use Text in Excel

Keyboard Shortcuts

Learn 77 of Excel's most powerful shortcuts.

Selecting Cells
Rows & Columns
Data & Other Tools

'Learn' section teaches you shortcuts. Then you can develop shortcut "muscle memory" with the Practice section and test your knowledge with the Test section

VBA for Excel

100 interactive exercises and many more examples, covering everything you need to become a VBA expert:

Conditional Logic
Adv Cell References
Msg & Input Boxes
Adv Procedures

Learn VBA Tutorial

Excel automation examples.

Have a specific need? We have hundreds of pages with specific tutorials, walk-throughs, and examples. All of our examples are listed in easy to search lists:

Get Excel Help!

Do you have a problem you can’t solve? Do you need an Excel Automation expert? Learn more about our Excel / VBA consulting services:

Excel and VBA Consulting

More free help, free spreadsheets, tutorials and add-ins, premium excel & vba tools and tutorials.

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

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:

	January	February	March
Housing	1200	1200	1200
Groceries	200	250	275
Utilities	85	80	90
Misc Expenses	20	50	30

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.

Share This Book

Free Excel Training

Finally, a free Excel course that adapts to your skill level.

Trusted by 100,000+ students.

Three 10-minute lessons

Free exercises

Easily apply what you learn

Fits any skill-level

For beginners and experts

What you learn

New to Excel?

3 lessons on formulas and functions (the basics of Excel).

Learn what a formula is and how to write one

Make your spreadsheets look professional

How to use SUM, COUNT, and AVERAGE (and all other simple functions)

Not your first time?

INTERMEDIATE

3 lessons on data cleaning and advanced functions

IF and SUMIF

Making decisions with functions

Cleaning data

How to effectively clean and organize data

The world’s most popular Excel functions (for a reason!)

Experienced Excel-user?

3 lessons on automating your workflows using macros

Record and edit a macro to make Excel imitate your actions

This is where the magic happens

Your first macro

Let’s automate your first task!

Excel-nerd?

3 lessons on unlocking Excel’s full potential with VBA code

Objects, Properties, and Methods

The basics of (VBA) programming

Using and declaring variables

Implementing logic with If statements

Meet…

Your instructor

Spreadsheeto co-founder

KASPER LANGMANN

Certified microsoft office specialist.

Get advice you can trust

+100,000 students

Among the world’s most-popular instructors

Excel consultant

Applying Excel to real-world situations every day

The most ambitious students and organizations have already joined

Join +100,000 students

I am so happy I decided to learn more in Excel with Spreadsheeto. The lessons are taught in segments which is so great because you can go back and repeat what you needed to view again. You get assignments to complete and the practice helps you retain what you learned. All lessons are clear and easy to understand. There is no way you can’t improve your Excel skill level if you take the lessons and do the assignments.

The curriculum flows very well through all of the training. Kasper keeps the information moving which keeps you engaged. I would highly recommend this training!

I went from being a hesitant and clumsy user of Excel , to being able to do so many things that saved so much time and energy .

Spreadsheeto is saving me hours and hours! Kasper is clear in his directions, it is in short segments with practice in between each, and a review at the end where I find out what I need to practice more. So nice I can go back any time to review. This was an investment in myself and it is paying off beautifully and quickly. Also, I decide when I do the course; I love that flexibility. I highly recommend this course to anyone who uses Excel regularly.

Frequently asked questions

Got other questions? Get in touch!

Why is this training free?

By giving you this free training, you get a feeling for how we teach Excel. We hope you like our style and decide to continue your journey by enrolling in our more elaborate Excel-courses “ Zero to Hero ” or “ VBA Masterclass “.

When and how do I get the course?

The training is delivered straight to your inbox. Right after you’ve signed up, you’re going to receive the first lesson. From there, you receive the lessons 24 hours apart (or faster if you choose to).

Do I need Microsoft Excel for Windows?

Using the latest version of Excel 2021 for Windows is what I recommend. With a Microsoft 365 subscription, it’s very affordable as well. But, if you have Excel 2007 – or later – you can follow along.

How long does it take to complete?

You get three 10-minute lessons, so a total of 30 minutes.

Who's the instructor?

That’s Kasper Langmann. Co-founder and certified Microsoft Office Specialist. With +7 years’ experience teaching Excel to 1000s of students! Read more about Kasper and Spreadsheeto here.

What are the prerequisites?

None! This training fits all skill-levels. All you need is Excel!

Try it now!

Real Excel Exercises with Solutions

Description

Additional information, reviews (0), excel exercises for practice, description.

A real Excel project focused on data validation and data manipulation in Finance. It includes 15 Excel exercises for practice based on the daily routines that banking analysts and finance consultants have to carry out in order to prepare worksheets before doing their analysis. This Excel assignment is split into three main parts: 1) Clean, edit and prepare the worksheet to execute the validation. Easy. 2) Analysis and validation/reconciliation of data. You will have to compare columns to find differences or retrieve data from one sheet to another: Advanced 3) Modification and data manipulation: Intermediate. It consists of the classic reconciliation and validation tasks every finance professional has to carry out on a daily basis. All Excel practice questions included in the project are real, very common while working with spreadsheets. The advantage of working with real Excel projects like this one, is that you learn how to use Excel to solve specific problems and what formulas or functions are the most suitable in each scenario. That is the main difference with regular exercises. It is a simulation of what you will confront in the real world.

WHAT YOU WILL LEARN

1) Data querying formulas, in particular Vlookup . You will learn about the business applications of Vlookup as well as the different situations where you may execute it. The second part of the project is all about vlookup. 2) Commonly used functions: IF statements, nested formulas, concatenate(), exact(), etc. 3) Cell editing and formatting features. 4) Navigation on the spreadsheet, keyboard shortcuts, filters, etc. 5) Page set up: Insert/delete rows/columns, copy, paste options, etc. 6) Print out spreadsheets.

REQUIREMENTS

These Excel exercises for practice are aimed at beginners, but it requires a minimum knowledge of Excel. Students must have attended an introduction course of Excel . All spreadsheets included in the project have been done in Excel 2013. It is compatible with Excel 2007, Excel 2010 and Excel 2016.

DIGITAL DOWNLOAD / CONTENT

You will receive a Zip folder in the confirmation email sent after purchase. It is also available on your Practity account. The file includes 2 PDFs and 5 Excel files: 1) PDF with the instructions. 2) PDF (20 pages) with the project solutions. You will receive detailed explanations about the formulas required to complete each exercise. You will also see images showing where the requested features and tools are located in the Excel layout. 3) Three Excel files with data. 120 rows and 19 fields. 4) Two spreadsheets with the Excel exercises solved.

Email Address *

Specification: Real Excel Exercises with Solutions

Difficulty
Time Estimate	12 Hours

User Reviews

There are no reviews yet.

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

Related Products

Excel Exercises for Job Interview

Excel Data for Practice

Excel Projects for Practice

Real Excel Exercises for Beginners

Excel Dashboard Challenge

20 Real LookUp Exercises

Terms of Use

Shopping cart

Get the Reddit app

A vibrant community of Excel enthusiasts. Get expert tips, ask questions, and share your love for all things Excel. Elevate your spreadsheet skills with us!

Where can I find projects/assignments to practice excel?

I'm new to excel and a, learning it with the personal goal of having the qualifications to get an entry-level clerical job . I've followed some lessons from excelexposure.com and am making progress but I learn a lot faster and am more motivated when I actually apply the skill I'm learning. Where can I find prompts to build a personal project off of so I can diagnose gaps in my knowledge and actually be creating something as a reflection of what I've learnt? Sorry if this isn't the sub for this.

By continuing, you agree to our User Agreement and acknowledge that you understand the Privacy Policy .

Enter the 6-digit code from your authenticator app

You’ve set up two-factor authentication for this account.

Enter a 6-digit backup code

Create your username and password.

Reddit is anonymous, so your username is what you’ll go by here. Choose wisely—because once you get a name, you can’t change it.

Reset your password

Enter your email address or username and we’ll send you a link to reset your password

Check your inbox

An email with a link to reset your password was sent to the email address associated with your account

Choose a Reddit account to continue

IMAGES

50 Ms Excel Assignments Pdf For Practical Practices
SOLUTION: 50 ms excel assignments pdf for practice free download
ms excel practical assignment questions
MS Excel Practical Questions for Learners
Excel Practice Sheet For Students
[PDF] 50+ MS Excel Assignments Practice Exercises PDF

COMMENTS

50+ MS Excel Assignments Practice Exercises PDF
Intermediate Microsoft Excel Worksheet: Practice 1. Objectives: The Learner will be able to: Enter data into a Spreadsheet. Use AutoFill with labels, data, and formulas. Format Cell Borders and Contents. Calculate the total across the rows. Calculate the total for each column. Use Conditional Formatting.
50 Ms Excel Assignments Pdf For Practice Free Download
Q How Many Student "A" and "B" Grade Use of Countif. Q Student Ashok and Manoj Total Number and Average Use of Sumif. Q Count how many Students Use of Counta. Q How Many Student Hindi & English Subject Number Grater Then > 20 and < Use of Countif ##### Assignment - Use of Formulas - Product, If, Counta, Countif, Sumif
Excel Practice Exercises PDF with Answers
Exercise 04 - Rounding Values. You will need to round the sales generated values in this exercise. Exercise 05 - Joining Two Strings . You will need to add the first name and last name. Exercise 06 - Conditional Formatting . Your task is to create a Data Bar for the salary values and hide the salary values. Exercise 07 - Counting Unique ...
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. Download.
Excel Practice Online
Practice And Learn Excel Online For Free. Welcome to Excel Practice Online! On this website, you will learn and practice Excel functions and tools! 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 ...
Free Excel exercises
Free Excel exercises. You are welcome to try any of the 113 Excel exercises listed below, but please do not distribute them in any form without asking for our written permission first. Adding new data, editing and copying and changing column widths for customer services data. Use Excel to to calculate basic statiscs about the richest people in ...
50 Ms Excel Assignments PDF For Practice
1) This document provides 50 Excel assignments to practice using formulas like SUM, AVERAGE, IF, COUNT, COUNTA, COUNTIF and SUMIF. 2) The assignments cover topics like calculating totals, averages, counts, grades and more across multiple sample datasets including student results, sales data, and employee salary sheets. 3) Solving the assignments requires using Excel formulas to summarize and ...
Excel Exercises
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.
Excel Exercises
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.
Practice Projects for Excel
Excel Project C6: Treasurer's Report Practice Document. Kendall Myers November 15, 2017. In this practice project for Excel and similar spreadsheet programs, students replicate a treasurer's report at an imaginary church. They also format a column to find the total at the bottom. ….
Intermediate Excel Exercises. Excel Practice. Practity
Practity's Intermediate Excel exercises offer the perfect opportunity for Excel students to master the most important functions and formulas of spreadsheets. With a focus on essential concepts such as conditional statements, counts, duplicates, SUMIF, VLOOKUP, and more. This type of Excel challenges provide a hands-on approach to learn how to ...
Learn Excel
Get Started with Excel. To start, we recommend going through our one-of-a-kind, completely free interactive Excel Tutorials. These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.
Excel Exercises
Start Excel Exercises. Good luck! If you don't know Excel, we suggest that you read our Excel Tutorial from scratch. Track your progress - it's free! Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML.
Excel Beginner Exercises
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.
PDF Excel Practical -1
EXCEL PRACTICAL - 2 Q1 . A worksheet contains Roll Number , Marks in 2 subjects for 50 students in a class. Calculate Result and Grade using the following: A student is declared as PASS if he gets 40 or more in both the subjects , Otherwise FAIL. All FAILED students will be given Grade IV For PASSED students Grade will be obtained as follows :
Microsoft Excel: Practical Exercises
Download Microsoft Excel: Practical Exercises and more MS Microsoft Excel skills Exercises in PDF only on Docsity! MICROSOFT EXCEL PRACTICAL EXERCISE 1.1 Using the data given, get the sum of all the figures within the range. ... Excel Workbook-MS Excel-Assignment. COMP284 Practical 7 JavaScript (2) Introduction Exercises. Show others. Reviews ...
Excel Practice 1
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. Take a moment to locate the following components of the Excel workbook window. Notice how Columns are lettered and Rows are numbered.
Free Excel Training: 30-Minute Course (100,000+ Students)
Try it now! Click to learn Excel for free. Free online Excel training for beginners and experts (all skill levels). 3 lessons (30 minutes total), free assignments & much more.
Ms-excel-exercises
MS Excel Exercises Exercise 1. Objectives: Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows. Formatting Worksheets. AutoFill, Numeric formats, previewing worksheets. Open a new workbook and save the file with the name "Payroll". Enter the labels and values in the exact cells locations as desired.
Ms Excel Exercises Microsoft Excel Practical Works
Ms Excel Exercises Microsoft Excel Practical Works - Free download as PDF File (.pdf), Text File (.txt) or read online for free. This document contains instructions for 6 exercises to practice various skills in Microsoft Excel: 1. The first exercise involves formatting worksheets, using AutoFill, formatting cells, and creating formulas to calculate payroll information like gross pay, taxes ...
Excel Exercises for Practice. Excel Beginners. Practity
It includes 15 Excel exercises for practice based on the daily routines that banking analysts and finance consultants have to carry out in order to prepare worksheets before doing their analysis. This Excel assignment is split into three main parts: 1) Clean, edit and prepare the worksheet to execute the validation. Easy.
Where can I find projects/assignments to practice excel? : r/excel
Excel on youtube has hundreds of videos that show practical examples of excel. I always advise beginners to watch 1-10 to get started with Excel. But for practice, pick any of the hundreds and watch the video until you can set up the problem, and then solve it just the way he does. Reply reply. Cr4nkY4nk3r.