Excel 2007 practice exercises

By | 12.02.2019

Using IF to calculate different voucher rates. Calculate commission using conditional formulae. Creating Scatter charts with regression trendlines. Use the charting tools in Microsoft Excel to give a graphical representation of some Population statistics.

Uploader: Tacage
Date Added: 7 November 2006
File Size: 22.92 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 24576
Price: Free* [*Free Regsitration Required]





Creating scenarios for different input changes for an investment model.

Exerciees stacked pictures to a chart series. Using If to Calculate different parking charges. Use range names instead of absolute references in Microsoft Excel to make creating formulae easier. Creating a pie chart comparing survey data, and formatting this pie chart to look presentable.

Use Exercisess Excel to generate useful statistics from Pivot Tables. Price orders using absolute cell references. Use a Vlookup function in Microsoft Excel to categorise a list of values - Teletubbies. Using Advanced Filters in Tables with multiple criteria and extract ranges.

Excel download exercises and sample project

Use conditional formatting in Microsoft Excel to highlight successful salespeople. Use the charting tools in Microsoft Excel to give a graphical representation of some Population statistics.

Use Microsoft Exerciess to specify your print settings for a small amount of data, ensuring that it is suitably aligned and sized practide the page. You can use the menu to show just exercises for a specific topic. Create a variety of number series automatically, using AutoFill. Use IF functions in Microsoft Excel to rate movies as a flop or success based on their profit.

Use the Custom Sort Tool in a Microsoft Excel Table to rearrange a large table of data into a more user-friendly view. Set a print exeecises, print titles and a header and footer for an Excel sheet.

Creating frequency pivot tables and using the show values as options.

Use functions in Microsoft Excel to calculate basic statistics about the tallest buildings in the practicce. Add an input field to an Excel model saying what sort of celebrity you are, and use this to calculate income using a lookup formula.

Use grouping to create a whole new group in a pivot table. Creating sparklines in cells to report on accidents involving animals. Using various text functions in Excel to parse film names. Calculate rxcel counts and sums of data using Excel functions.

Free Excel exercises

Use an If function in Microsoft Excel to calculate different order totals based on the quantity of items ordered. Apply data validation and protection to an Excel model for the London Olympics. Using a lookup table to calculate different discounts. Use validation and protection settings in Microsoft Excel to create a robust spreadsheet model. Use Vlookup functions in Microsoft Excel to quickly calculate car tax bands for a list of vehicles.

Calculate commission using conditional formulae.

Calculate part time pay rates using range names in Excel. Use range names instead of cell references in your Microsoft Excel formulae to make your spreadsheets much easier to understand. Excel Business Modelling Excel Intermediate. Uses absolute cell references to calculate store bonuses.

Using the IF function to calculate different interest rates and messages. Using lookup formulae to calculate staff bonuses. Uses absolute cell references to refer to the ticket prices in the formulae.

2 thoughts on “Excel 2007 practice exercises

Leave a Reply

Your email address will not be published. Required fields are marked *