January 2015
Beginner
768 pages
21h 38m
English
Content preview from Computing Fundamentals: Introduction to Computers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 10
Creating Spreadsheets with Microsoft Excel
Learning objectives
- Explain the features of the Excel interface
- Demonstrate how to navigate in a workbook and enter text
- Show how to change the structure of a worksheet
- Explain how to use formatting to improve a worksheet
- Demonstrate the use of formulas and functions
- Show how to summarize and illustrate data with charts
- Understand how Excel uses tables to organized structured data
Understanding the Excel Interface
Moving Around in a Worksheet
Changing the Structure of a Worksheet
Formatting Cells
Entering Formulas and Functions
Creating Charts
Working with Data Tables
Spreadsheets help us to organize, calculate, and make sense of numeric data. Like the orderly row-and-column format of ...