1 by Mary Anne Poatsy Keith Mulbery Lynn Hogan Amy Rutledge Cyndi Krebs Eric Cameron Rebecca Lawson Chapter 1 Introduction to Excel exploring Microsoft Office 2013 Volume 1 Objectives ID: 625184
Download Presentation The PPT/PDF document "Copyright © 2014 Pearson Education, Inc..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
1
by Mary Anne Poatsy, Keith Mulbery, Lynn Hogan, Amy Rutledge, Cyndi Krebs, Eric Cameron, Rebecca LawsonChapter 1Introduction to Excel
exploring Microsoft Office 2013 Volume 1Slide2
ObjectivesExplore the Excel windowEnter and edit cell dataCreate formulas
Use Auto FillDisplay cell formulasManage worksheets
2Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide3
Objectives (continued)Manage columns and rowsSelect, move, copy, and paste dataApply alignment and font options
Apply number formatsSelect page setup optionsPreview and print a worksheet
3Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide4
Introduction to Spreadsheets
A spreadsheet
is an electronic file used to organize related data and perform calculationsIf data is altered, formulas automatically recalculate results4 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide5
Exploring the Excel Window
A worksheet is a single spreadsheet that contains formulas, values, text, and visual aids
A workbook is a file containing related worksheets5 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide6
Exploring the Excel Window6
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide7
Exploring the Excel Window7
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Slide8
Exploring the Excel Window8
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide9
Exploring the Excel WindowWorksheet rows lie horizontallyWorksheet
columns lie verticallyA cell is the intersection of a row and column
A cell address or cell reference names a cell9 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide10
Navigating Worksheets10
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Slide11
Planning Structure of WorksheetsState the purpose of the worksheetDecide what input values
are neededAn input area is a range of cells containing values
Decide what outputs are neededAn output area is a range of cells containing resultsAssign the worksheet inputs and resultsUse rows and columns11Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide12
Planning Structure of WorksheetsEnter the labels, values, and formulasFormat the numerical values
Format the descriptive titles and labelsDocument the workbook Save and share the completed workbook
12Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide13
Planning Structure of Worksheets13
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide14
Entering Text14
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide15
Entering Values
15
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide16
Entering FormulasFormulas are combinations of cell addresses, math operations, values and/or functions
A formula begins with the equal sign (=)Examples: =A1+A2 =C2*5
16 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide17
Entering FormulasCell D4 contains the formula =B4*C4Cell C8 contains the formula =C4+C5+C6+C7
17
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide18
Editing Cell Content
18
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Select CellDouble-click CellSelect Cell
1. Click in the Formula Bar.1. Make edits directly in the cell.1. Press F2.
2. Make changes in the Formula Bar.2. Press Enter.2. Make changes in the cell.3. Click Enter on the left side of the Formula Bar.
3. Press Enter.Slide19
Mathematical Symbols
19
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. OperationCommon Symbol
Symbol in ExcelAddition++
Subtraction--Multiplication
X*Division÷/
Exponentiation
^
^Slide20
Cell References in FormulasIt is best to use cell addresses in formulas versus actual dataIf cell A1 contains the value 5 and you need to add B1 to this value, use =A1+B1 versus =5+B1
If the data changes, Excel will recalculate the result
20 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide21
Cell References in Formulas21
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Slide22
Order of PrecedenceOrder of precedence (operations) controls the sequence in which math operations are computed
ParenthesesExponentiationMultiplication and DivisionAddition and Subtraction
22 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide23
Order of Precedence23
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide24
Order of Precedence24
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide25
Using Auto FillAuto Fill enables you to copy the contents of a cell or cell range or to continue a series using the fill handle
Example: Month names Jan, Feb, Mar form a series The fill handle is the small green square in the bottom right corner of an active cell
25 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide26
Using Auto Fill26
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Slide27
Displaying Cell FormulasThe result of a formula appears in a cell and the formula itself appears in the Formula barPress the
Ctrl+` key combination to display formulas in the worksheetThis key combination acts as a toggle so can be used again to turn off the effect
27 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide28
Displaying Cell Formulas28
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide29
Managing Worksheets29
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Creating a multiple-worksheet workbook requires planning and maintenanceSlide30
Organizing WorksheetsThe Format Menu presents sheet commands
30
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide31
Insert and Delete a WorksheetInsert a worksheet to add a new worksheet to the workbookDelete
a worksheet when the data is no longer needed
31 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide32
Moving or Copying WorksheetsMoving a worksheet changes its order among sheet tabsCopying
a worksheet makes a duplicate sheet at the new location
32 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide33
Inserting Rows and ColumnsThe Insert command offers several techniques to insert rows, columns, and cells
33 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide34
Deleting Rows and ColumnsThe Delete command offers several techniques to remove rows, columns, and cells
34 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide35
Adjusting Column WidthColumn width is the horizontal measurement of a column
35
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide36
Adjusting Row HeightRow height is the vertical measurement of a rowThe row height is automatically adjusted with a font size increase
Using Alt+Enter to create multiple lines may require a row height adjustment
Select Row Height from the Format menu36 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide37
Hiding Columns and RowsHiding a column or row prevents it from displaying and printing
Unhiding a column or row returns it to view
37 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide38
Selecting a Cell RangeA range
is a group of adjacent or contiguous cellsA nonadjacent range contains a group of ranges that are not next to each other
38 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide39
Moving/Copying a RangeMoving/copying a range preserves text and values, but cell addresses in formulas will be altered in the pasted location
Move a range by cutting it and pasting to the upper left corner of the destinationCopy a range can by copying it and pasting to the upper left corner of the destination
39 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide40
Using Paste SpecialThe Paste Special command is used to paste data from the clipboard using a different format
40 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide41
FormattingFormatting accentuates and draws attention to meaningful portions of a worksheet
Alignment refers to how data are positioned in cells
41 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide42
Merge and center labelsA range of cells can be merged together to become one cellData in merged cells are centered
42 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide43
Numeric Formats
43
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide44
Numeric Formats (continued)
44
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide45
Numeric Formats (continued)45
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide46
Using Page SetupPage Setup contains many common print-related options
46
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide47
Headers and FootersA header is content appearing at the top of each printed page
A footer is content appearing at the bottom of each printed page
47 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide48
Headers and Footers48
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Slide49
SummaryIn this chapter, you have learned how to enter and edit cell data.You have created simple formulas with math operators as well as copied and displayed those formulas.
You can now manage a worksheet by manipulating rows, columns, and cells.
49 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide50
SummaryYou have learned basic formatting techniques to add visual appeal to text and numbers.You can modify the page layout and create headers and footers.
You are able to print preview and finally print a worksheet.
50 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Slide51
Copyright 51
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. Printed in the United States of America.