Copyright 2014 Pearson Education Inc Publishing as Prentice Hall 1 by Mary Anne Poatsy Keith Mulbery Cyndi Krebs Eric Cameron Jason Davidson Lynn Hogan Amy Rutledge Chapter 1 ID: 762894
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.
Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. 1 by Mary Anne Poatsy, Keith Mulbery, Cyndi Krebs, Eric Cameron, Jason Davidson, Lynn Hogan, Amy RutledgeChapter 1Introduction to Excel exploring Microsoft Office 2013 Plus
ObjectivesExplore the Excel windowEnter and edit cell dataCreate formulas Use Auto FillDisplay cell formulasManage worksheets 2Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
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.
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.
Exploring the Excel Window6 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Exploring the Excel Window7 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Exploring the Excel Window8 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
Navigating Worksheets10 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
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.
Planning Structure of Worksheets13 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Entering Text14 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Entering Values 15 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
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.
Editing Cell Content 18 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Select CellDouble-click CellSelect Cell1. 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.
Mathematical Symbols 19 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. OperationCommon SymbolSymbol in ExcelAddition ++Subtraction- -MultiplicationX*Division÷/ Exponentiation ^ ^
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.
Cell References in Formulas21 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
Order of Precedence23 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Order of Precedence24 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
Using Auto Fill26 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
Displaying Cell Formulas28 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Managing Worksheets29 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall. Creating a multiple-worksheet workbook requires planning and maintenance
Organizing WorksheetsThe Format Menu presents sheet commands 30 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
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.
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.
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.
Adjusting Column WidthColumn width is the horizontal measurement of a column 35 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
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.
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.
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.
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.
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.
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.
Numeric Formats 43 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Numeric Formats (continued) 44 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Numeric Formats (continued)45 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
Using Page SetupPage Setup contains many common print-related options 46 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
Headers and Footers48 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall.
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.
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.
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.