Exploring: Microsoft Excel 2013, Introductory / Edition 1

Other Format (Print)
Rent
Rent from BN.com
$32.40
(Save 67%)
Est. Return Date: 06/17/2015
Buy New
Buy New from BN.com
$85.40
Buy Used
Buy Used from BN.com
$60.75
(Save 37%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $32.64
Usually ships in 1-2 business days
(Save 66%)
Other sellers (Other Format)
  • All (12) from $32.64   
  • New (7) from $37.30   
  • Used (5) from $32.64   

Overview

The book covers introductory Excel.

Move students beyond the point-and-click.

The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.

Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.

NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.

Used books, rentals, and purchases made outside of Pearson

If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

Read More Show Less

Product Details

  • ISBN-13: 9780133412178
  • Publisher: Prentice Hall
  • Publication date: 7/12/2013
  • Series: Exploring Series
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 352
  • Sales rank: 884,120
  • Product dimensions: 8.80 (w) x 10.70 (h) x 0.60 (d)

Table of Contents

Microsoft Office 2013

Chapter One Office Fundamentals and File Management: Taking the First Step 1

Objectives 1

Case Study: Spotted Begonia Art Gallery 1

Windows 8 Startup 2

Logging In with Your Microsoft Account 2

Identifying the Start Screen Components 3

Interacting with the Start Screen 4

Accessing the Desktop 4

Hands-On Exercise 1:

Windows 8 Startup 6

Files and Folders 10

Using File Explorer 10

Working with Folders and Files 13

Selecting, Copying, and Moving Multiple Files and Folders 15

Hands-On Exercise 2:

Files and Folders 17

Microsoft Office Software 22

Identifying Common Interface Components 22

Getting Office Help 28

Hands-On Exercise 3:

Microsoft Office Software 31

The Backstage View Tasks 36

Opening a File 36

Printing a File 38

Closing a File and Application 39

Hands-On Exercise 4:

The Backstage View Tasks 41

Home Tab Tasks 45

Selecting and Editing Text 45

Using the Clipboard Group Commands 49

Using the Editing Group Commands 52

Hands-On Exercise 5:

Home Tab Tasks 55

Insert Tab Tasks 60

Inserting Objects 60

Review Tab Tasks 62

Reviewing a File 62

Page Layout Tab Tasks 65

Using the Page Setup Dialog Box 66

Hands-On Exercise 6:

Insert Tab Tasks, Page Layout Tab Tasks, and

Review Tab Tasks 68

Chapter Objectives Review 72

Key Terms Matching 73

Multiple Choice 74

Practice Exercises 75

Mid-Level Exercises 79

Beyond the Classroom 81

Capstone Exercise 82

Microsoft Office Excel 2013

Chapter One Introduction to Excel: What Is a Spreadsheet? 83

Objectives 83

Case Study: ok Office Systems 83

Introduction to Spreadsheets 84

Exploring the Excel Window 84

Entering and Editing Cell Data 87

Hands-On Exercise 1:

Introduction to Spreadsheets 91

Mathematics and Formulas 94

Creating Formulas 94

Using Auto Fill 96

Displaying Cell Formulas 97

Hands-On Exercise 2:

Mathematics and Formulas 99

Workbook and Worksheet Management 104

Managing Worksheets 104

Managing Columns and Rows 107

Hands-On Exercise 3:

Workbook and Worksheet Management 111

Clipboard Tasks 116

Selecting, Moving, Copying, and Pasting Data 116

Hands-On Exercise 4:

Clipboard Tasks 121

Formatting 124

Applying Alignment and Font Options 124

Applying Number Formats 126

Hands-On Exercise 5:

Formatting 129

Page Setup and Printing 133

Selecting Page Setup Options 133

Previewing and Printing a Worksheet 137

Hands-On Exercise 6:

Page Setup and Printing 138

Chapter Objectives Review 142

Key Terms Matching 144

Multiple Choice 145

Practice Exercises 146

Mid-Level Exercises 151

Beyond the Classroom 154

Capstone Exercise 155

Chapter Two Formulas and Functions: Performing Quantitative Analysis 157

Objectives 157

Case Study: Townsend Mortgage Company 157

Formula Basics 158

Using Relative, Absolute, and Mixed Cell

References in Formulas 158

Correcting Circular References 160

Hands-On Exercise 1:

Formula Basics 162

Function Basics 166

Inserting a Function 166

Inserting Basic Math and Statistics Functions 168

Using Date Functions 173

Hands-On Exercise 2:

Function Basics 176

Logical, Lookup, and Financial Functions 181

Determining Results with the IF Function 181

Using Lookup Functions 184

Calculating Payments with the PMT Function 187

Hands-On Exercise 3:

Logical, Lookup, and Financial Functions 188

Range Names 192

Creating and Maintaining Range Names 192

Using Range Names in Formulas 194

Hands-On Exercise 4:

Range Names 195

Chapter Objectives Review 198

Key Terms Matching 199

Multiple Choice 200

Practice Exercises 201

Mid-Level Exercises 206

Beyond the Classroom 211

Capstone Exercise 213

Chapter Three Charts: Depicting Data Visually 215

Objectives 215

Case Study: Computer Job Outlook 215

Chart Creation Basics 216

Selecting the Data Source 216

Choosing a Chart Type 217

Moving, Sizing, and Printing a Chart 227

Hands-On Exercise 1:

Chart Creation Basics 230

Chart Elements 235

Adding Chart Elements 235

Formatting Chart Elements 238

Hands-On Exercise 2:

Chart Elements 243

Chart Design and Sparklines 247

Applying a Chart Style and Colors 247

Modifying the Data Source 248

Creating and Customizing Sparklines 249

Hands-On Exercise 3:

Chart Design and Sparklines 251

Chapter Objectives Review 254

Key Terms Matching 255

Multiple Choice 256

Practice Exercises 257

Mid-Level Exercises 260

Beyond the Classroom 263

Capstone Exercise 264

Chapter Four Datasets and Tables: Managing Large Volumes of Data 265

Objectives 265

Case Study: Reid Furniture Store 265

Large Datasets 266

Freezing Rows and Columns 267

Printing Large Datasets 267

Hands-On Exercise 1:

Large Datasets 271

Excel Tables 275

Designing and Creating Tables 275

Applying a Table Style 279

Hands-On Exercise 2:

Excel Tables 281

Table Manipulation 286

Sorting Data 286

Filtering Data 288

Hands-On Exercise 3:

Table Manipulation 292

Table Aggregation 297

Using Structured References and a Total Row 297

Hands-On Exercise 4:

Table Aggregation 300

Conditional Formatting 304

Applying Conditional Formatting 304

Creating a New Rule 308

Hands-On Exercise 5:

Conditional Formatting 311

Chapter Objectives Review 315

Key Terms Matching 316

Multiple Choice 317

Practice Exercises 318

Mid-Level Exercises 322

Beyond the Classroom 324

Capstone Exercise 326

Summarizing and Analyzing Data 327

Application Capstone Exercise

Excel 327

Glossary 329

Index 334

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)