Skip to Content
Excel® 2010 Workbook for Dummies®
book

Excel® 2010 Workbook for Dummies®

by Greg Harvey
September 2010
Beginner
408 pages
10h 23m
English
For Dummies
Content preview from Excel® 2010 Workbook for Dummies®

Appendix C. Table of Exercises

Table C-1 is a handy reference table that lists every exercise in the book, complete with the page number where you can find it.

Table C-1. Table of Exercises

Exercise Name

Page Number

Chapter 1: Creating Spreadsheets

Exercise 1-1: Opening the Backstage View and Selecting Its Menu Commands

11

Exercise 1-2: Selecting Commands from the Ribbon

13

Exercise 1-3: Adding a Custom Tab to the Excel Ribbon

14

Exercise 1-4: Adding Commands to a Custom Tab

16

Exercise 1-5: Quickly Customizing the Quick Access Toolbar

17

Exercise 1-6: Adding Commands from the Excel Options Dialog Box to the Quick Access Toolbar

17

Chapter 2: Using Formulas and Functions

Exercise 2-1: Adding Excel 2010 Shortcuts to the Windows Desktop and Quick Launch Toolbar

22

Exercise 2-2: Opening a New Workbook from the Blank Workbook Template

24

Exercise 2-3: Opening a New Workbook File from an Installed Template File

25

Exercise 2-4: Moving the Cell Cursor in a Displayed Area of the Worksheet

26

Exercise 2-5: Moving the Cell Cursor to Unseen Parts of a Worksheet

27

Exercise 2-6: Moving the Cell Cursor Using the Ctrl and Arrow Keys

27

Exercise 2-7: Practice Moving the Cell Cursor to Different Sheets of the Same Workbook

29

Exercise 2-8: Practice Assigning Fill Colors to Selected Cell Ranges

30

Exercise 2-9: Practice Entering Data in a Simple Table

32

Exercise 2-10: Creating a Series of Entries with the Fill Handle

34

Exercise 2-11: Copying Formulas with the Fill Handle

35

Exercise 2-12: Saving a Workbook File

36

Chapter 3: Working ...

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,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Using Microsoft® Excel® 2010

Using Microsoft® Excel® 2010

Tracy Syrstad, Bill Jelen
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780470489604Purchase book