Investigating Microsoft Exceed expectations.


75 views
Uploaded on:
Description
Investigating Microsoft Exceed expectations Section 1 Prologue to Microsoft Exceed expectations: What is a Spreadsheet? By Robert T. Grauer Maryann Stylist Targets (1 of 2) Portray what a spreadsheet is and potential applications
Transcripts
Slide 1

Investigating Microsoft Excel Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer Maryann Barber Exploring Microsoft Excel 2002 Chapter 1

Slide 2

Objectives (1 of 2) Describe what a spreadsheet is and potential applications Explain how the lines and sections of a spreadsheet are recognized, and how its phones are named. Recognize an equation and a consistent Open, spare, print an exercise manual; embed and erase lines and sections Exploring Microsoft Excel 2002 Chapter 1

Slide 3

Objectives (2 of 2) Describe the three-dimensional nature of an exercise manual; recognize an exercise manual and a worksheet Print worksheet with qualities or recipes Copy and/or move cells inside of a worksheet Differentiate between relative, supreme, and blended references Use Page Setup to print worksheet and sneak peak before printing Format a worksheet to incorporate changing the text style or appearance, outskirts, and arrangement Exploring Microsoft Excel 2002 Chapter 1

Slide 4

Overview Introduction to spreadsheets and Excel Show wide differences of spreadsheet applications Fundamentals of spreadsheets utilizing Excel Worksheet recalculates naturally after changes Exploring Microsoft Excel 2002 Chapter 1

Slide 5

Introduction to Spreadsheets Spreadsheet is an electronic record Divided into lines and segments Columns related to alphabetic headings Rows related to numeric headings Cell references Constants- - passages that don\'t change Formulas- - mix of constants and capacities Exploring Microsoft Excel 2002 Chapter 1

Slide 6

Introduction to Excel Common client interface on all Office applications Menus and toolbars are like Word and Power Point Worksheet is an Excel spreadsheet Workbook contains one or more worksheets Toolbars- - Standard and Formatting File menu- - Save, Save As, Open and Print summons Exploring Microsoft Excel 2002 Chapter 1

Slide 7

Excel XP Exploring Microsoft Excel 2002 Chapter 1

Slide 8

Excel XP Worksheet Exploring Microsoft Excel 2002 Chapter 1

Slide 9

Hands-On Exercise 1 Objective: To begin Microsoft Excel, to open, adjust, and spare a current exercise manual Welcome to Windows Obtain the practice documents Start Microsoft Excel Open the exercise manual The Save As charge The Active Cell, Formula Bar and Worksheet tabs Experiment (What If?) The Office Assistant Exploring Microsoft Excel 2002 Chapter 1

Slide 10

Modifying the Worksheet Insert order can be utilized to include individual lines, segments, or cells Exploring Microsoft Excel 2002 Chapter 1

Slide 11

Modifying the Worksheet Delete summon can be utilized to erase individual lines, segments, or cells Exploring Microsoft Excel 2002 Chapter 1

Slide 12

Modifying the Worksheet Page Setup charge and dialog box A dialog box gives you a chance to offer data to Excel Exploring Microsoft Excel 2002 Chapter 1

Slide 13

Hands-On Exercise 2 Objective: To open a current exercise manual; to embed and erase lines and columns;to alter the presence of a printed exercise manual. Open the exercise manual Delete a line Insert a line Use the AutoComplete highlight Insert a section Display the phone equations The Page Setup summon The Print Preview order Insert and Delete a worksheet Exploring Microsoft Excel 2002 Chapter 1

Slide 14

Excel Features and Commands (1 of 2) Active cell is encompassed by a substantial dark fringe passages are made into the dynamic cell Formula bar shows the dynamic\'s substance cell situated close to the highest point of the worksheet Status bar keeps you educated of what is going on as you work situated at the worksheet\'s base Exploring Microsoft Excel 2002 Chapter 1

Slide 15

Excel Features and Commands (2 of 2) Toolbars contain symbols that perform normal orders ScreenTips give accommodating clues show up when you hold the mouse over a symbol or a remarked cell File Type perfect with Excel 2000 and Excel 97 Save as Command recovery as an alternate document name save as an alternate record sort (Excel 95 or another spreadsheet system) Exploring Microsoft Excel 2002 Chapter 1

Slide 16

Getting around the Worksheet A rectangular gathering of cells is an extent Copy copies substance of a phone from a source reach to a destination reach Move exchange substance of a phone starting with one area then onto the next Exploring Microsoft Excel 2002 Chapter 1

Slide 17

Cell Referencing Absolute reference: stays steady all through a duplicate operation Specified with a dollar sign before the segment and column, i.e. $B$4 Relative reference: alters amid a duplicate operation Specified without dollar signs, i.e. B4 Mixed reference: either the line or the section is outright; the other is relative Specified with a dollar sign before the supreme piece of the reference, i.e. B$4 Exploring Microsoft Excel 2002 Chapter 1

Slide 18

Hands-On Exercise 3 Objective: to make another worksheet; to duplicate recipes containing relative and supreme references Start Excel Save the exercise manual Enter understudy information and strict data Compute the understudy semester normal Copy the semester normal Compute class midpoints What If? Change exam weights Exploring Microsoft Excel 2002 Chapter 1

Slide 19

Excel XP Formatting Column widths Row Heights Numeric Format Alignment Fonts Borders, Patterns, and Shading Exploring Microsoft Excel 2002 Chapter 1

Slide 20

General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Types of Numeric Formats Exploring Microsoft Excel 2002 Chapter 1

Slide 21

Format Cells Command Exploring Microsoft Excel 2002 Chapter 1

Slide 22

Hands-On Exercise 4 Objective: to configuration a worksheet utilizing boldface, italics, shading, and fringes; to change the textual style and/or arrangement of a section. Focus the title crosswise over determination Format the exam weights Format the class midpoints Borders and shading Print the exercise manual Use the Page Setup summon to adjust the presence of the printed exercise manual Print the phone recipes Exploring Microsoft Excel 2002 Chapter 1

Slide 23

Summary (1 of 2) Spreadsheet is mechanized accountant’s record Spreadsheet is bland term; worksheet is an Excel expression Cells contain equations or constants A recipe dependably starts with an equivalent sign Formulas can be duplicated or moved anyplace inside of the worksheet. Verify you comprehend supreme, relative, and blended cell referencing and when to utilize each!! Investigating Microsoft Excel 2002 Chapter 1

Slide 24

Summary (2 or 2) Page Setup gives you control over the presence of the printed worksheet Selecting so as to format is finished the cell(s) you need to configuration, then applying the arrangement you need Use the Ctrl key to choose non-adjoining cells or scopes of cells Print worksheets with showed qualities and recipes Exploring Microsoft Excel 2002 Chapter 1

Slide 25

.:tslidese

Recommended
View more...