Microsoft Excel Project 1 Presentation

1. Microsoft ExcelMicrosoft Excel
Project 1Project 1
Computer Applications I
Creating a Worksheet and Embedded Chart
Mrs. Martin

2. Spreadsheet TerminologySpreadsheet Terminology
WorkbooksWorkbooks are like
notebooks containing a
collection of worksheets.
WorksheetsWorksheets individual
sheets organized into a
rectangular grid of vertical
columns and horizontal
rows within a workbook .
SheetSheet TabsTabs display the
sheet name at the bottom
of a workbook.
CellCell the intersection of a
row and column, is a
basic unit of a worksheet
in which you enter data.
RangeRange is a series of 2
or more adjacent cells.
GridlinesGridlines the horizontal
and vertical lines on a
worksheet.
Slide 2

3. What is Microsoft Excel? What is Microsoft Excel?
A powerful spreadsheet program that allows
users to organize data, complete calculations,
make decision, graph data, and develop
professional-looking reports.
Slide 3

4. Four Major Parts of ExcelFour Major Parts of Excel
WorksheetsWorksheets allow users to enter, calculate,
manipulate and analyze data.
ChartsCharts pictorially represent data. Excel can
draw two or three-dimensional charts.
Tables Tables helps organize and manage data
within a worksheet.
WebWeb SupportSupport allows users to save the
worksheets in HTML format.
Slide 4

5. Excel WindowExcel Window
Quick Access
Toolbar
Title Bar
Ribbon
Name Box
w/active cell
reference
Scroll
Bars
Mode
Indicator
Office
Button
heavy border
surrounds
active cell
highlighted row &
column headings
indicate cell A1 is
active
Sheet
Tabs
Formula Bar
Status Bar
Select All
Button
AutoCalculate
Area

6. Excel Window ElementsExcel Window Elements
Ribbon Ribbon control center in
Excel.
OfficeOffice ButtonButton central
location for managing and
sharing documents.
QuickQuick AccessAccess ToolbarToolbar
provides easy access to
frequently used
commands.
NameName BoxBox displays the
active cell reference.
CellCell ReferenceReference unique
address identifying cell
coordinates.
FormulaFormula BarBar displays an
entry as you type.
StatusStatus BarBar presents
information about the
worksheet.
Slide 6

7. Microsoft Excel FeaturesMicrosoft Excel Features
EnteringEntering DataData
Text & Numbers
ActiveActive Cell Cell
FunctionsFunctions
Prewritten Formulas
Arguments
CalculatingCalculating a Suma Sum
Sum Function
AutoSum Button
FillFill HandleHandle
MergingMerging CellsCells
AutoCalculate AreaAutoCalculate Area
ChartsCharts
Embedded Charts
Legend
ChartChart DepictionDepiction
Y- & X-Axis
Slide 7

8. TextText is used to place titles and consists of any set
of characters containing a letter, hyphen or
space. Text is left aligned by default.
NumbersNumbers are used to represent amounts and
can contain only the following characters:
0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
*If a cell entry contains any other keyboard character
(including spaces), Excel interprets the entry as text.
Numbers are right aligned by default.
Entering DataEntering Data
Back to Excel Features Slide 8

9. Active CellActive Cell
The ActiveActive CellCell is the one which you can enter
data.
 Ways to identify the active cell:
Surrounded by a heavy border
Name box displays the active cell reference
The column heading and row heading are
bolded
Back to Excel Features Slide 9

10. Functions-Prewritten FormulasFunctions-Prewritten Formulas
A FunctionFunction takes a value or values,
computes a statistic, and returns a result to a
cell.
All functions start with an equal sign, and
include ArgumentsArguments in parentheses after the
function name.
=Sum(D3:D10)
Equal
Sign
Function
Name
Arguments in
Parentheses
Back to Excel Features Slide 10

11. Calculating a SumCalculating a Sum
SumSum FunctionFunction computes the sum or total of a
range of cells.
 AutoSumAutoSum ButtonButton when selected, Excel
selects a range of cells to sum. If the range is
wrong you must select the correct range before
clicking the button a second time.
AutoSumAutoSum ButtonButton ArrowArrow provides access to other
often used buttons.
Back to Excel Features Slide 11

12. Fill HandleFill Handle
The FillFill HandleHandle is the small black square in the
lower right corner of the active cell used to fill or
copy a series.
Use the fill handle to copy a cell to adjacent cells.
CopyCopy AreaArea is the cell being copied or source.
PastePaste AreaArea is the range of cells receiving the copy
or the destination.
RelativeRelative ReferenceReference when you copy, excel
adjusts the cell references for each new position.
Slide 12Back to Excel Features

13. Merging CellsMerging Cells
MergingMerging CellsCells involves creating a single cell by
combining two or more selected cells. Use the
MergeMerge & Center button& Center button to merge cells and center
the contents of the cells across columns.
Merge &
Center button
cells A1 through
G1 merged to
create new cell A1
& centered entry
across columns
heavy border
indicates new
dimensions of
cell A1
Back to Excel Features Slide 13

14. AutoCalculate AreaAutoCalculate Area
AutoCalculateAutoCalculate AreaArea is used in place of a
calculator to view range totals. Use the
AutoCalcuateAutoCalcuate AreaArea on the status bar to check
your work by selecting the range of cells
containing the numbers you want to check.
AutoCalculate
Area
Back to Excel Features Slide 14

15. Embedded ChartsEmbedded Charts
Charts Charts drawn to graphically represent data
based on the values in a worksheet.
BTW-when you change a cell value on which a chart
is dependent, Excel redraws the chart
instantaneously.
EmbeddedEmbedded ChartsCharts are drawn on the same
worksheet as the data.
LegendLegend identifies each bar in a chart as titles
from the leftmost column.
Back to Excel Features Slide 15

16. Chart DepictionChart Depiction
Y-Axis (Value Axis)
scale is derived on
the basis of the
values in the
worksheet.
X-Axis
(Category Axis)
titles are the entries
in the topmost row of
the range.
Back to Excel Features
Columns
developed from
values in worksheet
each color
represents a row in
the worksheetdash ( $- )
represents zero
3-D Clustered
Column Chart
Slide 16