LEARNING PLAN 7: SPREADSHEET APPLICATION COMPETENCIES DEVELOP SPREADSHEETS USING A SPREADSHEET APPLICATION This learning plan addresses the following learning objectives to help you master the competency: a) b) c) d) e) f) g) h) i) j) k) Start a spreadsheet application. Change displays between normal, page layout and print preview. Distinguish between text, value, and formulas as cell contents. Use the AutoSum button to sum a range of cells. Copy a cell contents to a range of cells using various methods. Apply formatting to a worksheet. Modify cell contents. Enter cell references into formulas. Analyze a range of cells with basic statistical functions. Create a chart using the Chart Wizard. Apply basic operations open, save, print, and close a worksheet file.

OVERVIEW Microsoft Excel 2010 is an excellent tool for performing many financial, mathematical, and data analysis tasks in a spreadsheet format. It is the most widely used spreadsheet application currently on the market. Therefore, it’s important to become familiar with the various facets of this software, because it allows for compatibility across multiple computers as well as collaborative features. This series of activities gives you clear instructions and practice so that you will become comfortable using this important computer application. This learning plan covers the basics of Microsoft Excel 2010. It was created primarily for a novice user, and prior experience is helpful, but not required, to cover this section.

National American University

Page 215

START A SPREADSHEET APPLICATION. Starting Microsoft Excel 2010 presents the main screen and opens one Workbook. A Workbook has a filename just as a Word document or PowerPoint presentation. Each Workbook has three Worksheets. You can add more Worksheets if you like. The Worksheet is composed of little boxes called Cells. When you start Microsoft Excel