## 116940 | Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem | Lesson 11 – Evaluating the accuracy of a spreadsheet

Lesson 11 – Evaluating the accuracy of a spreadsheet The gold standard for professional data entry is to enter data not once, but twice. The two data sets are then compared, differences are examined and corrections are made. This is a “good practice” technique that...

## 116940 | Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem | Lesson 10 – Working with Cells

Lesson 10 – Working with Cells It is important to know how to move information from one cell to another in Excel. Learning the various ways will save you time and make working with Excel easier. Certain methods are more appropriate depending on how much...

## 116940 | Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem | Lesson 9 – Aligning Text and cell

Lesson 9 – Aligning Text and cell Worksheets that have not been formatted are often very difficult to read. Fortunately, Excel gives you many tools that allow you to format text and tables in various ways. One of the ways you can format your worksheet so that it...

## 116940 | Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem | Lesson 8 – Using Templates

Lesson 7 – Working with Basic Functions In Excel 2010, you have many templates that can save you a lot of time. A template is a pre-designed spreadsheet that you can use to create new spreadsheets with the same formatting and predefined formulas. With templates,...

## 116940 | Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem | Lesson 7 – Working with Basic Functions

Lesson 7 – Working with Basic Functions A function is a predefined formula that performs calculations using specific values in a particular order. While you may think of formulas as being short mathematical equations, like 2 + 2 or F2 * C2, they can actually be...