Basic Excel
Introduction
This core Microsoft® Excel® text provides students with the skills needed to exec...
Module 1 – Fundamental Skills
1.1 Overview of Microsoft Excel
Learning Objectives Examine the value of using Excel to make decisions. Learn how to ...
1.2 Entering, Editing, and Managing Data
Learning Objectives Understand how to enter data into a worksheet. Examine how ...
1.3 Formatting and Data Analysis
Learning Objectives Use formatting techniques as introduced in the Excel Spreadsheet G...
1.4 Printing
Learning Objectives Use the Page Layout tab to prepare a worksheet for printing. Add he...
1.5 Chapter Practice
To assess your understanding of the material covered in the chapter, complete the following a...
1.6 Scored Assessment
Sales And Inventory Items Download Data File: SC1 Data A key activity for marketing profe...
Questions
What is Microsoft Excel?a) A word processorb) A presentation softwarec) A spreadsheet application...
Module 2 – Mathematical Computations
2.1 Formulas
Learning Objectives Learn how to create basic formulas. Understand relative referen...
2.2 Introductory Statistical Functions
Learning Objectives Use the SUM function to calculate totals. Use the COUNT functio...
2.3 Functions for Personal Finance
Learning Objectives Understand the fundamentals of loans. Use the PMT function to calcu...
2.4 Preparing to Print
Learning Objectives Review and learn new cell formatting techniques. Understand how t...
2.5 Chapter Practice
Financial Plan For A Lawn Care Business Download Data File: PR2-Data Running your own law...
2.6 Chapter Scored
Hotel Occupancy And Expenses Download Data File: SC2-Data The hotel management industry p...
Questions
What is the shortcut key to create a new workbook in Excel?A) Ctrl + NB) Ctrl + OC) Ctrl + WD) Ct...
Module 3 – Formulas, Functions, Logical and Lookup Functions
3.1 More on Formulas and Functions
Learning Objectives Review the use of the =MAX function. Examine the Quick Analysis...
3.2 Logical and Lookup Functions
Learning Objectives Use an IF Function to make logical comparisons between a value a...
3.3 Conditional Formatting
Learning Objectives Use Conditional Formatting techniques to provide flexible highli...
3.4 Preparing to Print
Learning Objectives Locate and fix formatting consistency errors. Apply new formatt...
3.5 Chapter Practice
Household Budget Download Data File: PR3 Data Etta and Lucian Redding are a recently marrie...
3.6 Chapter Scored
Midascoffee Company Download Data File: SC3 data MidasCoffee: Ruth Kobran owns a coffee su...
Module 4 – Presenting Data with Charts
4.1 Choosing a Chart Type
Learning Objectives Construct a line chart to show timeline and comparison trends. Le...
4.2 Formatting Charts
Learning Objectives Apply formatting commands to the X and Y axes. Assign titles to the...
4.3 Using Charts with Microsoft® Word® and Microsoft® PowerPoint®
Learning Objectives Learn how to paste an image of an Excel chart into a Word document. L...
4.4 Preparing to Print
Learning Objectives Review each worksheet in a workbook in Print Preview. Modify worksh...
4.5 Chapter Practice
To assess your understanding of the material covered in the chapter, please complete the foll...
4.6 Scored Assessment
Charting Sales Data Download Data File: SC4 Data An effective way to communicate finding...
Questions
1.Which type of chart is best suited for comparing data that is divided into categories? a. Line...
Module 5 – Tables
5.1 Table Basics
Learning Objectives Understand table properties and structure. Format data as a tab...
5.2 Intermediate Table Skills
Learning Objectives Sort table data. Custom Sort table data. Apply Custom List sor...
5.3 Preparing to Print
Learning Objectives Adjust page settings for printing. Add footer information for u...
5.4 Chapter Practice
Tables For A Tourism Company Download Data File: PR5 Data Travel and tour companies need ...
5.5 Scored Assessment
Tables For A Retail Company Download Data File: SC5 Data Retail companies with today’s on...
Introduction
Excel is the leading application for storing, managing and analyzing data. In Chapter 5, you will...
Questions
1.What is a table in Excel? a. A database management system b. A tool for sorting and filterin...
Module 6 – Multiple Sheet Files
6.1 Multiple Sheet Basics
Learning Objectives Navigating through a multiple sheet file. Adding, deleting, cop...
6.2 Formulas with 3-D References
Learning Objectives Entering formulas that reference another sheet. Using the SUM f...
6.3 Templates
Learning Objectives Use existing Microsoft Excel templates to create new spreadsheets. ...
6.4 Preparing to Print
Learning Objectives Printing all of the worksheets in a workbook at one time. Pre...
6.5 Chapter Practice
Creating A Multiple Sheet Workbook For A Sports Team Data file: PR6 Data You have just been...
6.6 Scored Assessment
A Multiple Sheet Workbook For National Parks Data Data file: none You are working at th...
Questions
1.What is a multiple sheet file in Excel? a. A file with multiple worksheets b. A file with mul...