A guide to help you study for the Microsoft Excel Lab Exam.

Below is a list of each chapter in the "Exploring: Microsoft Excel 2013, Comprehensive" book in which you worked on exercises in lab class. Listed with the chapter are the exercises you completed and the major topics covered in those exercises.

The first step to study for the Microsoft Excel Lab Exam is to read through the Excel Exam Layout Presentation.

The second step to study for the Microsoft Excel Lab Exam is completing
the Practice Excel Exam
1

to the best of your abilities before you read through the Excel Exam Review
Presentation.

The third step to study for the Microsoft Excel Lab Exam and to get an
idea of the format

of the Microsoft Excel Lab Exam is completing the
remaining **Practice Excel Exams**:

Practice Excel Exam 2.

Practice Excel Exam 3.

Practice Excel Exam 4.

Practice Excel Exam 5.

**Important**: Remember, the actual exam you will take is **NOT**
any of the Practice Excel Exams!!

The fourth step to study for the Microsoft Excel Lab Exam is answering
all of the multiple choice questions and completing all of the practice
exercises, mid-level exercises, and the capstone exercise at the end of
each chapter listed below.

But, do not do:

- Chapter 1 - Mid-level exercise 4.
- Chapter 2 - Mid-level exercise 4.
- Chapter 3 - Mid-level exercise 3.
- Chapter 4 - Mid-level exercise 3.
- Chapter 5 - Mid-level exercise 3.
- Chapter 6 - Mid-level exercise 3.

Click, Files for the Exploring Excel End of Chapter Exercises, to go to the instructions to download the files needed to do the practice exercises, mid-level exercises, and the capstone exercise at the end of each chapter listed below.

Chapter 1 - All 6 exercises.

- Enter text, values, and dates in cells.
- Clear cell contents.
- Create formulas using cell references.
- Use the Fill Handle to copy formulas to nearby cells.
- Rename a worksheet tab.
- Create a new worksheet.
- Move a worksheet.
- Delete a worksheet.
- Make a copy of a worksheet.
- Insert a row.
- Delete a row.
- Insert a column.
- Delete a column.
- Adjust row height.
- Adjust column width.
- Move a row.
- Select a range of cells.
- Copy and paste a range of cells.
- "Merge and center" a set of cells.
- Change text alignment attributes and wrap text.
- Apply different number formats: currency, percentage, etc.
- Change the number of decimal places for numeric values.
- Apply font attributes, borders and fill color.
- Indent cell contents.
- Set page orientation.
- Set margin options.
- Create a header.

Chapter 2 - All 4 exercises.

- Absolute, relative, and mixed cell addressing.
- Sum function.
- Average function.
- Median function.
- Min function.
- Max function.
- Count function.
- Today function.
- Year function.
- If function.
- Vlookup function.
- PMT function.
- Create a range name.
- Edit and delete range names.
- Use a range name in a formula.
- Insert a list of range names.

Chapter 3 - All 3 exercises.

- Creating a chart.
- Selecting the cells containing the data to use in creating a chart.
- Select the chart type: clustered column, bar, pie, etc.
- Move and/or resize a chart.
- Change the chart type.
- Changing the cells containing the data to use in creating a chart.
- Add a chart title.
- Add a title to the chart's x-axis.
- Add a title to the chart's y-axis.
- Add or remove the chart's data labels.
- Format the chart's data labels.
- Apply a fill color to a chart.
- Apply a chart style.
- Apply chart filters.
- Insert and customize sparklines.

Chapter 4 - All 5 exercises.

- Freeze rows and columns.
- Manage page breaks.
- Set and clear a print area.
- Print titles.
- Create a table.
- Add and delete fields.
- Add records.
- Remove duplicate rows.
- Apply a table style.
- Sort one field.
- Sort multiple fields.
- Apply text filters.
- Apply a number filter.
- Apply a date filter.
- Create structured references in formulas.
- Add a total row.
- Convert a table to a range.
- Highlight cell rules.
- Specify top/bottom rules.
- Display data bars.
- Use a formula in conditional formatting.

Chapter 5 - All 4 exercises.

- Sort data.
- Subtotal data.
- Create a PivotTable.
- Modify the source data and refresh the PivotTable.
- Apply a PivotTable style.
- Create a PivotChart.

Chapter 6 - All 3 exercises.

- Enter sustitution values for a one-variable data table.
- Enter formulas and complete the data table.
- Format the one-variable data table.
- Set up the structure for a two-variable datat table.
- Complete the two-variable data table.
- Use the Goal Seek tool.
- Use the Solver tool.

Chapter 8 - Hand-on Exercise 1 (step 1 & 2).

Chapter 10 - Hand-on Exercise 1, 2, Practice Exercise 2.