Transcript Microsoft Excel - Bishop Ireton High School

Microsoft Excel
A Spreadsheet Program
1
A Spreadsheet Program
• Allows the user to organize data into
columns and rows, format the data,
perform calculations on the data, and
create charts and graphs using the data
• Killer App
2
Excel Window
3
Excel Interface
• The way you interact with the Excel
program is very similar to the way you
interact with other Microsoft Office
programs given the locations of the
Office Button, Quick Access Toolbar,
Title bar, Close button, Ribbons, Zoom
Slider, View Buttons, and Status Bar.
• Undo and Redo work as well!
4
Excel Workbook
• An Excel file with one or more
worksheets
5
Excel Worksheet
• The work area for entering and
calculating data made up of columns
and rows separated by gridlines (light
gray lines). Also called a spreadsheet.
• 16,384 Columns
• 1,048,576 Rows
6
Cell
• The Intersection of a column and a
row on a worksheet. You enter data
into cells to create a worksheet.
7
Active Cell
• The active cell contains the cell pointer.
There is a dark outline around the active
cell.
8
Formula Bar
• As you enter data into a cell, it
simultaneously appears in the Formula
bar, which is located above the
worksheet.
9
Name Box
• The box to the left of the Formula bar above
a worksheet that indicates the location of the
active cell
• Type a cell’s name in the name box and press
Enter to go to that cell.
10
Cell Reference
• The location of a cell in a worksheet is
identified by its column letter and row
number. Also known as the cell’s address.
The active cell reference or name is in the
name box to the left of the Formula bar.
• The Column header (a letter) and Row
header (a number) are highlighted as well
11
Scroll
• Use the scroll bar to view locations on a
worksheet without changing the active
cell.
12
Sheet Tabs or Worksheet Tabs
• Tabs that appear at the bottom of the
workbook window that display the name of
each worksheet.
• You can change these names by right clicking
on them and typing new names.
13
Tab Scrolling Buttons
• These appear to the left of the
worksheet tabs and allow you to scroll
hidden tabs into view. Useful in
workbooks containing more than 5 or 6
sheets.
14
Label
• Text in the first row or column of a
worksheet to identify the type of
data contained in that column or
row
• Can be Alphabetical, numeric, or a
symbol
• Automatically aligns to the LEFT
15
Spreadsheet Defaults
• The standard settings Excel uses in its
software, such as column width
16
Entering Data
• Text – aligns left
• Numbers – align right
• You can set different alignment for a
cell, a row, a column, the worksheet
17
Delete or Clear Cell Contents
• You can press the Escape key or click the
Cancel button on the formula bar to cancel
an entry before you press the tab key or the
Enter key
• Use the Clear Contents Command or the
Delete key to erase data from a cell after it
has been finalized
18
Excel File Names
• Save as an Excel workbook
• File extension (.xlsx for 2013) is added
to file name
• Up to 255 characters – but keep short
• File names can contain letters, numbers,
and spaces, but not / \ : * > “ <>
19
AutoComplete
• A feature used to complete an entry
based on previous entries made in
column containing the active cell
20
AutoCorrect
• A feature used to automate the
correction of common typing errors
• Spell Check is also available in Excel and
should be used with every file that
contains text
– Spell Check does not put red wavy lines under
misspelled words. You must run Spell Check.
21
Value
• A number entered in a worksheet
• A cell contains a value when its first
character is a number, or one of these
symbols: + - = $
22
Numeric Label
• A number entered in a worksheet as a
label, not a value – such as the year
2005 used as a column label
23
Series
• A list of sequential numbers, dates,
times or text that can be entered in a
range of cells
24
Standard Column Width
• The default number of characters that
display in a column based on the default
font
25
Entering Dates
• Can enter dates using several different
formats
• Use Number Group on Home Ribbon to
specify date and other number or text
formats
26
Formula
• An instruction Excel uses to calculate a
number
• Example: =sumA1+A2 means make
the contents of the active cell equal to
the total of the contents of cells A1 and
A2 OR add up the numbers in cells A1
and A2 put the answer in this active cell
where the formula is being typed
27
Cell Range
• A1:C3 is the way you would write or
indicate all the cells starting with A1 and
going through C3
• You could use a cell range in a formula
such as =sum(A1:C3)
28
Mathematical Operators
o Symbols used in mathematical
operations
o
o
o
o
+
*
/
is Addition
is Subtraction
is Multiplication
is Division
29
Order of Mathematical Operations
• The order in which Excel performs the
calculations specified in a formula
– Operations enclosed in parentheses are
first if any parentheses are present
– Left to right within the formula,
multiplication and division are performed
before addition and subtraction
30
Charts
• Select cells on a worksheet to create a chart
• Use Chart Options on Insert Ribbon to select
chart type such as: column, line, pie, bar
• Add colors, titles, data labels and other
elements to make charts easy to read and
understand the data
31