# Exploring Microsoft Office 2016

Exploring Microsoft Office 2016 Series Editor Mary Anne Poatsy Mulbery|Krebs|Hogan|Cameron | Davidson|Lau|Lawson|Williams Series Created by Dr. Robert T. Grauer Copyright 2017 Pearson Education, Inc.

Exploring Excel 2016 Chapter 1 Introduction to Excel Creating and Formatting a Worksheet Copyright 2017 Pearson Education, Inc.

Objectives (1 of 2) Explore the Excel Window Enter and Edit Cell Data Create Formulas Display Cell Formulas Manage Columns and Rows Select, Move, Copy, and Paste Data Copyright 2017 Pearson Education, Inc.

Objectives (2 of 2) Apply Cell Styles, Alignment, and Font Options Apply Number Formats Manage Worksheets Select Page Setup Options Preview and Print a Worksheet Copyright 2017 Pearson Education, Inc.

Objective 1: Explore the Excel Window (1 of 5) Skills: Identify Excel Window Elements Identify Columns, Rows, and Cells Navigate In and Among Worksheets Copyright 2017 Pearson Education, Inc.

Explore the Excel Window (2 of 5) Spreadsheet electronic file that: Contains a grid of columns and rows Displays results of calculations Enables interpretation of quantitative data Copyright 2017 Pearson Education, Inc.

Explore the Excel Window (3 of 5) Worksheetsingle spreadsheet that contains: Descriptive labels Numeric values Formulas, functions Graphical representations of data Copyright 2017 Pearson Education, Inc.

Explore the Excel Window (4 of 5) Workbookcollection of one or more related worksheets Cellintersection of a column and a row Identification: Columns use lettersA Rows use numbers10 Cells use a combination of a letter and a numberA10 Copyright 2017 Pearson Education, Inc.

Explore the Excel Window (5 of 5) Cell A1 Workbook Book1 Row 11 Column S

Single worksheet Copyright 2017 Pearson Education, Inc. Objective 2: Enter and Edit Cell Data (1 of 3) Skills: Enter Text Use Auto Fill to Complete a Sequence

Enter Values Enter a Date Clear Cell Contents Copyright 2017 Pearson Education, Inc. Enter and Edit Cell Data (2 of 3) Data types: Text combination of letters, numbers, symbols, and spaces

Values numbers used as the basis of calculations Dates and times entered in a variety of formats Auto Fill feature that completes a sequence of words or values Copyright 2017 Pearson Education, Inc. Enter and Edit Cell Data (3 of 3) Clear

options Copyright 2017 Pearson Education, Inc. Objective 3: Create Formulas (1 of 3) Skills: Use Cell References in Formulas Apply the Order of Operations Use Semi-Selection to Create a Formula

Copy Formulas Copyright 2017 Pearson Education, Inc. Create Formulas (2 of 3) Formula used to perform calculation, such as =A1 + 3 Order of operations rules in which arithmetic operations are performed Some unfamiliar operators: * for multiplication

^ caret for exponentiation Semi-selection selects cell or range of cells as formula is built Copyright 2017 Pearson Education, Inc. Create Formulas (3 of 3) Copyright 2017 Pearson Education, Inc.

Objective 4: Display Cell Formulas (1 of 2) Skills: Display Cell Formulas Copyright 2017 Pearson Education, Inc. Display Cell Formulas (2 of 2) Cell formula

Cell value Cell formula Copyright 2017 Pearson Education, Inc. Objective 5: Manage Columns and Rows

(1 of 6) Skills: Insert Cells, Columns, and Rows Delete Cells, Columns, and Rows Hide a Column or Row Adjust Column Width Adjust Row Height Copyright 2017 Pearson Education, Inc.

Manage Columns and Rows (2 of 6) Copyright 2017 Pearson Education, Inc. Manage Columns and Rows (3 of 6) Copyright 2017 Pearson Education, Inc.

Manage Columns and Rows (4 of 6) Hide & Unhide Copyright 2017 Pearson Education, Inc. Manage Columns and Rows (5 of 6) Adjust

column width Copyright 2017 Pearson Education, Inc. Manage Columns and Rows (6 of 6) Column Width

Copyright 2017 Pearson Education, Inc. Objective 6: Select, Move, Copy, and Paste Data (1 of 4) Skills: Select a Range Move a Range Copy and Paste a Range

Use Paste Options and Paste Special Copyright 2017 Pearson Education, Inc. Select, Move, Copy, and Paste Data (2 of 4) Copyright 2017 Pearson Education, Inc. Select, Move, Copy, and Paste Data (3 of 4)

To move, copy, or paste data: 1. Select range 2. Select Cut or Copy 3. Move to new location 4. Select Paste and the paste option Copyright 2017 Pearson Education, Inc. Select, Move, Copy, and Paste Data (4 of 4)

Cut Paste Copy Paste Special

Copyright 2017 Pearson Education, Inc. Objective 7: Apply Cell Styles, Alignment, and Font Options (1 of 6) Skills: Apply a Cell Style Merge and Center Data Change Cell Alignment Wrap Text

Increase Indent Apply a Border Apply Fill Color Copyright 2017 Pearson Education, Inc. Apply Cell Styles, Alignment, and Font Options (2 of 6) Cell style collection of format settings that provide a consistent

appearance Cell styles control: Font Font color and size Borders and fill colors Alignment Number formatting Copyright 2017 Pearson Education, Inc.

Apply Cell Styles, Alignment, and Font Options (3 of 6) Copyright 2017 Pearson Education, Inc. Apply Cell Styles, Alignment, and Font Options (4 of 6) Alignmenthow data are positioned within boundaries of cell

Data type default alignments: Textaligns at left cell margin Dates and valuesalign at right cell margin Horizontal alignmentposition of data between left and right cell margins Vertical alignmentposition of data between top and bottom cell margins Copyright 2017 Pearson Education, Inc. Apply Cell Styles, Alignment, and Font

Options (5 of 6) Merge and centermerges selected cells together into one cell Wrap textdata appears on multiple lines in cell Indentoffset of data from current alignment Borderline that surrounds cell or range of cells Fill colorbackground color that displays behind data Copyright 2017 Pearson Education, Inc.

Apply Cell Styles, Alignment, and Font Options (6 of 6) Merged and centered Wrapped text Filled

color Border Indented text Copyright 2017 Pearson Education, Inc. Objective 8: Apply Number Formats (1 of 2) Skills:

Apply Number Formats Increase and Decrease Decimal Places Copyright 2017 Pearson Education, Inc. Apply Number Formats (2 of 2) Copyright 2017 Pearson Education, Inc.

Objective 9: Manage Worksheets (1 of 3) Skills: Insert a Worksheet Delete a Worksheet Copy or Move a Worksheet Rename a Worksheet Group Worksheets Copyright 2017 Pearson Education, Inc.

Manage Worksheets (2 of 3) Delete selected sheet Rename selected sheet Move or

copy selected sheet Selected worksheet tab New sheet

Copyright 2017 Pearson Education, Inc. Manage Worksheets (3 of 3) New location Move within workbook

Copy Copyright 2017 Pearson Education, Inc. Objective 10: Select Page Setup Options (1 of 4) Skills: Set Page Orientation Select Scaling Options

Set Margin Options Create a Header or Footer Select Sheet Options Copyright 2017 Pearson Education, Inc. Select Page Setup Options (2 of 4) Page Setup

group Scale to Fit group Copyright 2017 Pearson Education, Inc. Select Page Setup Options (3 of 4)

Copyright 2017 Pearson Education, Inc. Select Page Setup Options (4 of 4) Copyright 2017 Pearson Education, Inc. Objective 11: Preview and Print a Worksheet (1 of 2) Skills:

View in Print Preview Set Print Options Print a Worksheet Copyright 2017 Pearson Education, Inc. Preview and Print a Worksheet (2 of 2) Print

preview Number of pages Copyright 2017 Pearson Education, Inc. Summary (1 of 2) A workbook can consist of multiple worksheets, divided into columns, rows, and cells

Cells contain text, values, or formulas, with contents entered by typing, copying and pasting, and using Auto Fill Columns, rows, and cells can be added or deleted, copied, or moved Styles, alignment, and formatting can be applied to cells Formatting can be applied to numerical values Copyright 2017 Pearson Education, Inc. Summary (2 of 2)

Worksheets can be inserted, deleted, renamed, copied, and moved A worksheet can have orientation and margins changed, headers and footers added, and scaling adjusted Before printing, a worksheet can be previewed and final printing options selected Copyright 2017 Pearson Education, Inc. Questions

? Copyright 2017 Pearson Education, Inc. Copyright 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. Copyright 2017 Pearson Education, Inc.

## Recently Viewed Presentations

• Parmi les approches néo-industrialistes, la théorie élaborée par Jonathan Gershuny (1978) apparaît comme la plus aboutie. En annonçant et analysant l'émergence d'une société ou économie de « self-service », Gershuny abandonne lui aussi l'idée d'une croissance inexorable de la demande...
• Training will be provided by the InternationalBrotherhood of Electrical Workers (IBEW) Local 134 LaborUnion ... The Future Energy Jobs Act (FEJA) provides fundingfor three training programs that will enable Illinois to meet the growing demand for trained renewable energy workers....
• AMR - as a priority for MOH AMR, is a cross cutting issue relevant for all National Health programs Child Health Disease Control (TB/HIV/STI/NTDs) Family Health Addressing AMR benefits all National Health Programs Recently we launched National Antibiotic Treatment Guidelines...
• The Megger test is the most important electrical test of an ESP system. It is an IR (Insulation Resistance) test. A high DC Voltage (-5KVDC typical) is applied to the downhole cable, motor, and gauge to verify High Voltage insulation...
• Statistics Canada Research Data Centre Program* Facilities across Canada housing detailed confidential microdata and documentation files from Statistics Canada. Statistics Canada released data that would otherwise not be available into "secure" sites.
• [email protected] requesting access. If you are a designate for a Principal Investigator (PI), you must forward written permission from you PI. You will receive an email in return with the requisite WROAMS form and your eSirius login information. Fill out...
• Strong acids and bases are those that ionize completely in aqueous solution. They are also typically strong electrolytes. Weak. acids. and . bases. are those that . do not . ionize completely. in aqueous solution. They are also typically ....
• Synergize. Habit 6 "Alone we can do so little, together we can do so much." ~Helen Keller. ASCA Standards. A:A2.4 Apply knowledge and learning styles to positively influence school performance. C:A1.4 Learn how to interact and work cooperatively in teams.