Spreed Sheet Assigment

Applying Fundamental Excel Skills and Tools in Problem Solving

Chapter 1

Chapter Introduction

• Fundamental skills and tools encountered when working with Excel to solve problems and support decision making

• Writing formulas in cells to perform calculations • Designing a workbook so that calculations can be

automatically updated if input values are changed • Formatting options that can be applied to cells and

ranges of cells • Ability to correct spreadsheet errors • Rules that affect how information is displayed and

calculations are performed in an Excel worksheet

Succeeding in Business with Microsoft Excel 2013: Chapter 1 2

Functions Covered in This Chapter

• AVERAGE • COUNT • COUNTA • MIN • MAX • SUM

Succeeding in Business with Microsoft Excel 2013: Chapter 1 3

Level 1 Objectives: Identifying and Correcting Common Errors in

Formatting and Formulas

• Define common Excel error messages • Correct basic formatting problems in a

worksheet • Correct errors in formulas • Understand precision vs. display of cell values

Succeeding in Business with Microsoft Excel 2013: Chapter 1 4

Examining a Basic Worksheet for Errors (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 5

Correcting Formatting Problems

• Modifying column width and row height – Double-click the column dividing line to make the

column as wide as the longest entry – Drag the column dividing line to the desired width – Click the Format button in the Cells group on the

HOME tab, click Column Width, and type the width in the Column width box

• Checking error messages (Error Alert button) • Formatting numbers • Inserting and aligning a title

Succeeding in Business with Microsoft Excel 2013: Chapter 1 6

Correcting Formatting Problems (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 7

Correcting Formatting Problems (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 8

Correcting Errors in Formulas

• Printing the worksheet in two different formats – Default format (displays values) – Format that displays formulas

• Checking simple formulas for accuracy • Using formulas and cell references instead of

values • Determining order of precedence • Understanding precision vs. display of cell values • Checking accuracy in formula updates

Succeeding in Business with Microsoft Excel 2013: Chapter 1 9

Correcting Errors in Formulas (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 10

Correcting Errors in Formulas (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 11

Correcting Errors in Formulas (continued)

• Excel can display values in several different formats without changing the precise value stored in the program

Succeeding in Business with Microsoft Excel 2013: Chapter 1 12

Correcting Errors in Formulas (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 13

Correcting Errors in Formulas (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 14

Level 1 Summary

• Locating and correcting common errors in formatting or formulas to make the worksheet readable and functional

Succeeding in Business with Microsoft Excel 2013: Chapter 1 15

What to do in Chapter # 1 - Level 1

1- Open Week # 2 - Chapter 1 - Assignment .pdf document, save it, and follow the directions.

2- Open Week # 2 - Chapter 1 – Exercises.pdf save it to do the exercises

3- Open Chapter # 1 - Lecture save it to use the information of the presentation

4- Open Chapter # 1 - Video - Level 1 to see the video of Levels 1 Chapter 1.

• Starting on 23 of your textbook. • You should read the learning material covered on pages 23-41 that is covered

in the video • Watch the video about the Learning Process of Chapter # 1 – Level 1 • Repeat step 4 until you understand the material

5- Using the Week # 2 - Chapter 1 – Exercises.pdf make the exercise requested for Level 1

Succeeding in Business with Microsoft Excel 2013: Chapter 1 16

Level 2 Objectives: Calculating and Comparing Data Using Simple Functions

• Work with multiple worksheets • Calculate total, average, minimum, and

maximum values with functions • Understand how functions work: syntax,

arguments, and algorithms • Calculate the number of values using both

COUNT and COUNTA

Succeeding in Business with Microsoft Excel 2013: Chapter 1 17

Calculating Totals Using the SUM Function

• Function – A predefined formula that performs calculations – Structure

• Function name and open parenthesis mark • Arguments (list of inputs in a specific order, separated by

commas) • Closing parenthesis mark

– Has its own syntax (specifies function name and order of arguments)

– Behaves according to its algorithm (rules programmed into the function)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 18Level 2 home

Calculating Totals Using the SUM Function (continued)

• SUM function – Adds a list of values and/or cell ranges

• Excel has an AutoSum feature for quick calculation

Succeeding in Business with Microsoft Excel 2013: Chapter 1 19Level 2 home

Calculating Totals Using the SUM Function (continued)

Succeeding in Business with Microsoft Excel 2013: Chapter 1 20Level 2 home

Calculating the Number of Values Using the COUNT and COUNTA Functions

Succeeding in Business with Microsoft Excel 2013: Chapter 1 21

The COUNT function ignores blank cells and cells with text; the COUNTA function does not ignore text cells.

Level 2 home

Level 2 Summary

• Simple functions (SUM, AVERAGE) and how to use them in formulas

• Syntax of functions and their underlying algorithms

Succeeding in Business with Microsoft Excel 2013: Chapter 1 22

What to do in Chapter # 1 - Level 2

1- Open Week # 2 - Chapter 1 - Assignment .pdf document, save it, and follow the directions.

2- Open Week # 2 - Chapter 1 – Exercises.pdf save it to do the exercises

3- Open Chapter # 1 - Lecture save it to use the information of the presentation

4- Open Chapter # 1 - Video - Level 2 to see the video of Levels 2 Chapter 1.

• Starting on 43 of your textbook. • You should read the learning material covered on pages 43-51 that is covered

in the video • Watch the video about the Learning Process of Chapter # 1 – Level 2 • Repeat step 4 until you understand the material

5- Using the Week # 2 - Chapter 1 – Exercises.pdf make the exercise requested for Level 2

Succeeding in Business with Microsoft Excel 2013: Chapter 1 23

Chapter Summary

• Identifying and correcting common errors in formatting and formulas

• Calculating and comparing data using simple functions

Succeeding in Business with Microsoft Excel 2013: Chapter 1 24