1 1 excel part i. 2 definition of electronic spreadsheets ncomposed of rows and columns or primarily...
TRANSCRIPT
![Page 1: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/1.jpg)
11ExcelPart I
![Page 2: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/2.jpg)
2
Definition of Electronic Definition of Electronic SpreadsheetsSpreadsheets
Composed of rows and columns or primarily numeric data
Formulae based on cell references, so easy to update results
Easy to store, retrieve and print results
![Page 3: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/3.jpg)
3
Advantages of Using an Electronic Advantages of Using an Electronic SpreadsheetSpreadsheet
Support good design and accurate results
Program can quicklyEdit and format dataPerform calculationsCreate graphs
![Page 4: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/4.jpg)
4
Advantages to Using an Electronic Advantages to Using an Electronic SpreadsheetSpreadsheet
Perform “what-if” analyses by changing independent values in the spreadsheet.
![Page 5: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/5.jpg)
5
Electronic Spreadsheet TerminologyElectronic Spreadsheet Terminology
Alignment
Cell
Columns
data’s position to the left, centered or right of a cell
space created by intersection of horizontal row and vertical column
vertical blocks of cells identified by letter
![Page 6: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/6.jpg)
6
Electronic Spreadsheet TerminologyElectronic Spreadsheet Terminology
Copy
File linking
duplicates contents of cell or cell to another location
creates a connection between two files to share data
![Page 7: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/7.jpg)
7
Electronic Spreadsheet TerminologyElectronic Spreadsheet Terminology
Format
Formula
Function Graph
cell styles that control the appearance of the data there
entry performing a calculation
built-in formula visual
representation of data ranges in a worksheet
![Page 8: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/8.jpg)
8
Electronic Spreadsheet TerminologyElectronic Spreadsheet Terminology
Label
Move
Rows
entry consisting of text and numeric characters
relocates cell contents to another worksheet location
horizontal blocks of cells identified by number
![Page 9: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/9.jpg)
9
Electronic Spreadsheet TerminologyElectronic Spreadsheet Terminology
Value
What-if Analysis
numerical entry, or one resulting from a formula or function
process of evaluating effects of changing one or more values in formulas to help in decision making and planning
![Page 10: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/10.jpg)
10
Electronic Spreadsheet TerminologyElectronic Spreadsheet Terminology
WYSIWYG the “what you see is what you get” feature lets you see worksheet as it will be printed
![Page 11: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/11.jpg)
11
Load Excel for WindowsLoad Excel for Windows
Start buttons Programs Microsoft Excel
![Page 12: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/12.jpg)
12
Using Office AssistantUsing Office Assistant
Office Assistant
![Page 13: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/13.jpg)
13
Office Assistant
![Page 14: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/14.jpg)
14
Moving Around the WorksheetMoving Around the Worksheet
Arrow keys
Alt + Pg Dn
Alt + Pg Up
Moves cell selector one cell in direction of arrow
Moves cell selector right one full window
Moves cell selector left one full window
![Page 15: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/15.jpg)
15
Moving Around the WorksheetMoving Around the Worksheet
Pg Dn
Pg Up
Ctrl + Home
Moves cell selector down one full window
Moves cell selector up one full window
Moves cell selector to cell in upper-left corner of worksheet
![Page 16: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/16.jpg)
16
Moving Around the WorksheetMoving Around the Worksheet
Home
Pg Up
Ctrl + Home
Moves cell selector to beginning of row
Moves cell selector to last used cell in row
Moves cell selector to last used cell in column
![Page 17: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/17.jpg)
17
Design a WorksheetDesign a Worksheet
Specify purpose - ID the input data required, and the desired output
Design and build - either on paper or in Excel, should include title, row label and column headings, and some sample data
![Page 18: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/18.jpg)
18
Design a WorksheetDesign a Worksheet
Test - input some real data, and check the output
Document - usually within the spreadsheet itself, aid to others who may use the spreadsheet
![Page 19: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/19.jpg)
19
Enter DataEnter Data
Types of data entries Enter data
![Page 20: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/20.jpg)
20
Types of Data EntriesTypes of Data Entries
Text - any combination of letters, numbers, spaces, etc
Number - the digits 0 thru 9, plus any of the special characters such as +, _, /, $, %, etc.
Formula - perform calculations on data contained in other cells
![Page 21: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/21.jpg)
21
Entering DataEntering Data
Move the cell pointer to the desired location in spreadsheet work area
Press the appropriate keys Press the Enter key
![Page 22: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/22.jpg)
22
Cancel button
formula bar displays entry
Enter button
active cell displays entry and insertion point
![Page 23: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/23.jpg)
23
text entries are left-aligned in cell space
cell selector moves down to next cell after Enter is pressed
![Page 24: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/24.jpg)
24
Delete and Edit Cell EntriesDelete and Edit Cell Entries
While still typing and before pressing enterEscape, or Backspace
To delete an entry, press the Delete key
To edit a cell entry, press the F2 key, or double click
![Page 25: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/25.jpg)
25
Key Strokes in Edit ModeKey Strokes in Edit Mode
Home
End
->
<-
Moves insertion point to beginning of entry
Moves insertion point to end of entry
Moves insertion point one character right
Moves insertion point one character left
![Page 26: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/26.jpg)
26
Open and Close WorkbooksOpen and Close Workbooks
Open WorkbookFile, OpenFile Name
Close WorkbookFile, Close
![Page 27: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/27.jpg)
27
Delete and edit cell entriesDelete and edit cell entries
Highlight cellDelete keyEdit, Cut
Highlight cellF2 keyDouble mouse click
![Page 28: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/28.jpg)
28
Cutting, Copying and Pasting DataCutting, Copying and Pasting Data
Cut - cell contents deleted from the cell location, but stored in the Clipboard
Copy - copy of cell contents stored in the Clipboard
Paste - contents of the Clipboard transferred to the destination cell location
![Page 29: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/29.jpg)
29
Cut from source cell
![Page 30: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/30.jpg)
30
Paste in destination cell
![Page 31: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/31.jpg)
31
Copy from source cell
![Page 32: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/32.jpg)
32
Paste in destination cell
![Page 33: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/33.jpg)
33
Enter FormulaeEnter Formulae
Entries that perform calculations
Result of the calculation is displayed in the cell containing the formula
Always begins with an = sign, which tells Excel that a numeric operation follows
![Page 34: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/34.jpg)
34
With multi operator formulae the order of precedence isExponentsMultiplicationDivisionAdditionSubtraction
Enter FormulasEnter Formulas
![Page 35: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/35.jpg)
35
Operands - the values or cell references that the numeric operators operate on
Enter FormulaeEnter Formulae
![Page 36: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/36.jpg)
36
Numeric OperatorsNumeric Operators
+ - / * ^
for addition for subtraction for division for multiplication for
exponentiation
![Page 37: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/37.jpg)
37
Recalculate a WorksheetRecalculate a Worksheet
Automatic recalculation - when a number in a referenced cell changes, the formula is recalculated
Minimal recalculation - only those formulae directly affected by change are recalculated, great time saver with larger worksheets
![Page 38: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/38.jpg)
38
Change Cell AlignmentChange Cell Alignment
Horizontal and vertical placement and orientation of a cell entry
Horizontal - left, right, center Vertical - top, centered or bottom Centered across columns Repeated entry within a cell Click on Format then cell
![Page 39: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/39.jpg)
39
cell alignment
![Page 40: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/40.jpg)
40
Document, Save and PrintDocument, Save and Print
Document the file with File, Properties
Save a file with File, Save As (best choice when first saving, to ensure you see the file is actually saved)
Print a file with File, Print Preview (for seeing what is actually going to be printed), Print
![Page 41: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/41.jpg)
41
SS of File PropertiesSS of File Properties
File properties
![Page 42: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/42.jpg)
42
SS of Print PreviewSS of Print Preview
Print preview
![Page 43: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/43.jpg)
43
Print preview
![Page 44: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/44.jpg)
44
Exit the Excel programExit the Excel program
File, Save or Save As File, Close File, Exit
![Page 45: 1 1 Excel Part I. 2 Definition of Electronic Spreadsheets nComposed of rows and columns or primarily numeric data nFormulae based on cell references,](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e035503460f94aee47c/html5/thumbnails/45.jpg)