ms excel 2007 assignments for practice 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

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

• Get started with computers
• Learn Microsoft Office
• Apply for a job
• Improve my work skills
• Design nice-looking docs
• Getting Started
• Smartphones & Tablets
• Typing Tutorial
• Online Learning
• Basic Internet Skills
• Online Safety
• Social Media
• Zoom Basics
• Google Docs
• Google Sheets
• Career Planning
• Resume Writing
• Cover Letters
• Job Search and Networking
• Business Communication
• Entrepreneurship 101
• Careers without College
• Job Hunt for Today
• 3D Printing
• Freelancing 101
• Personal Finance
• Sharing Economy
• Decision-Making
• Graphic Design
• Photography
• Image Editing
• Learning WordPress
• Language Learning
• Critical Thinking
• For Educators
• Translations
• Staff Picks
• English expand_more expand_less

In this free Excel 2007 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.

Introduction to Excel

• 1 Setting Up Your Excel Environment arrow_forward_ios ✓ Familiarize yourself with the Excel 2007 environment.
• 2 Starting a Workbook arrow_forward_ios ✓ Learn how to create a new workbook, insert and delete text, navigate a worksheet, and save.
• 3 Modifying Columns, Rows, and Cells arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel.
• 4 Formatting Text arrow_forward_ios ✓ Learn all about formatting text in Excel.
• 5 Creating Simple Formulas arrow_forward_ios ✓ Learn how to create a simple formula in Excel.
• 6 Working with Cells arrow_forward_ios ✓ Learn how to cut, copy, and paste, as well as how to drag and drop data in Excel.
• 7 Printing Workbooks arrow_forward_ios ✓ Learn how to preview your spreadsheet, modify margins, change page orientation, and print.

Excel Basics

• 8 Creating Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel.
• 9 Working with Basic Functions arrow_forward_ios ✓ Learn how to use functions to find values for a range of cells.
• 10 Sorting, Grouping, and Filtering Cells arrow_forward_ios ✓ Learn how to sort, group, and filter cells in Excel.
• 11 Formatting Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel.
• 12 Aligning Text arrow_forward_ios ✓ Learn how to align text, merge and center cells, and apply different types of text control.
• 13 Working with Worksheets arrow_forward_ios ✓ Learn how to name, add, delete, group and ungroup, and freeze worksheets.

Doing More with Excel

• 14 Using Templates arrow_forward_ios ✓ Learn how to create a new workbook using an Excel template.
• 15 Using What-If Analysis arrow_forward_ios ✓ Learn how to use a what-if analysis tool called Goal Seek.
• 16 Working with Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to communicate information.
• 17 Using Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel.
• 18 Creating PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis.
• 19 What's New in Excel 2007? arrow_forward_ios ✓ Learn about the features available in Excel 2007.
• 20 What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel.
• 21 More Resources arrow_forward_ios ✓ Use these free resources to better work with and manipulate data in Excel.

• school Campus Bookshelves
• menu_book Bookshelves
• perm_media Learning Objects
• login Login
• how_to_reg Request Instructor Account
• hub Instructor Commons
• Download Page (PDF)
• Download Full Book (PDF)
• Periodic Table
• Physics Constants
• Scientific Calculator
• Reference & Cite
• Tools expand_more
• Readability

selected template will load here

This action is not available.

12.2: Assignment- Practice with Excel

• Last updated
• Save as PDF
• Page ID 18689

Assignment Objective

This assignment gives you practice using what you have learned about Excel without step-by-step directions.

Open the Excel Practice Application (.doc) document and use Excel to create a worksheet that meets the criteria listed. Try to complete the spreadsheet using what you remember. If you cannot remember a procedure, refer to the trainings provided previously.

• Introduction to Computer Applications and Concepts Excel Practice. Authored by : Jim Shannon. Provided by : Extended Learning Institute of Northern Virginia Community College. Located at : http://www.nvcc.edu/eli/index.html . License : CC BY: Attribution

50 Tricky MS Excel Objective Questions and Answers PDF

In this article, you will find 50 MS Excel objective questions and answers in PDF format. Most of the questions are very basic. As a result, anyone with a basic understanding of Excel will be able to answer the questions. These questions will be helpful for job examinations. Moreover, you should know the following: introduction to Excel VBA , enable the Developer tab , the basics of an Excel spreadsheet , use of the INDEX-MATCH formula , application of the AGGREGATE , AVERAGE , AVERAGEIF , CEILING.MATH , COUNT , COUNTBLANK , IF , IFS , COUNTIF , COUNTA , COUNTIFS , DATEDIF , DAY , FIND , IFERROR , LEN , MROUND , RAND , RANDBETWEEN , ROW , ROWS , SUM , SUMIF , TODAY , VLOOKUP , and XLOOKUP functions to solve them. You should use at least Excel 2019 to solve the problems without any issues.

Download Practice Workbook

Problem overview.

The Excel and PDF files each contain fifty MS Excel objective questions and answers in PDF format. The questions are provided in the “Problem” sheet. Additionally, the answers are highlighted in the “Solution” sheet. We can see a snapshot of the sample dataset for this article below. This dataset represents the sales achieved by twenty employees for a particular 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 will 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 –
• Combination of IFERROR, INDEX, 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
• Both a,b & c
• Q8. Which function can be used to determine the number of empty cells in the dataset?
• Q9. Using which function from the list you 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 will –
• 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. Shortcut to find the total of some numbers is –
• Q16. To insert chart from a data selection, you will need to press –
• Q17. To open the Spelling dialog box, you need to press –
• Q18. To bring up the custom cell Formatting press –
• Q19. To repeat the previous action, you will need to press on –
• Q20. The latest version of Microsoft Office is called –
• Microsoft 365
• Q21. The following shortcut key 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
• Combination of VLOOKUP and IF Functions
• HLOOKUP Function
• ZLOOKUP Function
• Q23. Which formula is correct for returning the name of the salesperson for the $25,010 sales?
•  =VLOOKUP(F5,IF({1,0},F5:F24,B5:B24),2,0)
• =ZLOOKUP(F5,F5:F24,B5:B24)
• =XLOOKUP(F6,F5:F24,B5:B24)
• Both a&c
• 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 x number of functions inside the AGGREGATE Function, here 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 is released in –
• Q30. Which of the following functions will 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 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. The following function is not available in the VBA WorksheetFunction method
• Q35. If there is a Red triangle in the top right corner of the cell, then 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, then it signifies –
• The cell is formatted as a number.
• Q37. You will press the following shortcut to bring up the VBA window –
• Q38. Which of the formulas will you use to round 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 is Cells (x, y), which 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 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 –
• AutoFill Tool
• Fill Handle
• Drag Handle
• Q48. If you select a range of cells and type something, then pressing a specific shortcut will copy the value to the selected range. Now, that shortcut key is –
• Shift+Enter
• Q49. If there is a VBA code in your Excel file, then you should save the file as ____ 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. So, this concludes the article on the topic MS Excel objective questions and answers PDF”.

Thank you for reading this article. By completing this article, we hope that you have gained knowledge about MS Excel objective questions and answers in PDF format. 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

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

404 Not found