Microsoft ExcelUnit A

Computer & CareersMr. Lewis

Definitions:Spreadsheet Is an application you use to

perform numeric calculations and to analyze and present numeric data

Worksheet The electronic spreadsheet you work in.

Workbook The file that the worksheet is contained in (file extension .xlsx)

Formulas Are equations in a worksheet. You use a formulas to make calculations as simple as adding a column of numbers, or as complex as profit and loss projections.

File Extension Before 2007 = .xls2007 and after = .xlsx

When you open a spreadsheet the default name is

Book 1

Touring The Excel WindowName Box Formula Bar Cell

Cell Address

Active Cell

(Sheet Tabs) (3 tabs are the default)

(Sheet Tab Scrolling Buttons)(ModeIndicator)

AutoSum

Columns, designated withLETTERS, columns areVERTICAL (run up and down).

Rows, designated withNUMBERS, rows areHORIZONTAL (run side to side)

In Creating Calculations in Excel, It Is Important to:

• Know where the formulas should be.

• Know exactly what cells and arithmetic operations are needed.

• Create formulas with care

• Use Cell references rather than values.

• Determine what calculations will be needed.

Excel Arithmetic Operators

Operator Purpose Example

+ Addition =a5+a7

- Subtraction =a5-a10

* Multiplication =a5*a11

/ Division =a5/a3

% Percent =35%

^(caret) Exponent =6^4

Definitions:

Labels

Examples:“Travel Expenses”“Total Expenses”“Average Cost”

“2009 Sales”

Are entries that contain text and numerical information not used in calculations, such as “2009 Sales” or “Travel Expenses”. Labels help you identify data in a worksheet rows and columns, making your worksheet easier to understand.

Values

Examples:=a5 * a7

=sum(d1:d9)+ 10

Are numbers, formulas, and functions that can be used in calculations. To enter a calculations you type an equal sign (=) plus the formula for the calculation.

Definitions Cont.

Function Is a built in formula (like a shortcut)

Arguments They are the part of the function enclosed in round brackets (parentheses) following the function’s name. Arguments supply the data for the function to use in its calculations.

=sum(b9:b12)

Function Argument

FormulasInsert Function button, If you press this, then thescreen below appears

Formula Bar

FunctionArgumentMenu

Functions

Common Pointers In Excel

Normal Pointer (Indicates Ready Mode)

Fill Handle Pointer (Create a Alpha, Numeric Series in a Range)

I-Beam Pointer (Appears in Formula Bar)

Move Pointer (Changes Location on Spreadsheet)

Quick Keys

[CTRL] [HOME] Jumps to the first cell in a spreadsheet

[CTRL] [END] Jumps to the last cell (wherethe last number is located)

Switching Worksheet Views

• Normal View: This is the default setting view when you open

Excel.

• Page Layout View: This provides a more accurate view of

how a worksheet will look when printed. The margins of the page are displayed, along with the text box for the header and the ruler. Part of the page to the right is shown in this view.

• Page Break View: displays a reduced view of each page of your

worksheet, along with page break indicators.

• Full Screen View: displays the worksheet on the entire screen.

Functions VS Simple FormulasExamples of Functions:

=sum(a1:a5)

=max(a1:a5)

=min(a1:a5)

=average(a1:a5)

=count(a1:a5)

** The function is the WORD that is at the beginning of the formula.

Examples of Simple Formulas:

=a6 - a7

=d3 + d4 + d5

=c5 - c6 - c7

Simple formulas only use one arithmetic operator.

** Simple formulas do not use words, they just use simple arithmetic.

**** Important: Both formulas use cell referencing

Setting Your Page Up To Print

Page Layout Tab

Print Titles (Gridlines, Row & Column Headings, Header/Footer, Scaling)

Orientation (Landscape, Portrait)

Margins (Top, Bottom, Left, Right)

Page Setup Group

Spreadsheet Notes1. “Cells” are _INDIVIDUAL_ rectangles that can contain _LETTERS_ or

_NUMBERS_ .

2. “Rows” run _SIDE_ to __SIDE__, and are designated with ___NUMBERS__ .

3. “Columns” – run __UP_ and __DOWN_, and are designated with ___LETTERS___ .

4. A Simple Formula (adding, subtracting, multiplying, dividing) performs calculations for specific _INDIVIDUAL _ cells.

5. Subtracting is the same as __ADDING__ _A_ __NEGATIVE __ ___NUMBER__ .

6. Simple FUNCTION is used for calculating a __RANGE_ of cells.

7. “Sum” means to _____ADD____ numbers.

8. “Product” means to _____MULTIPLY___ numbers.

9. “Quotient” means to ____DIVIDE___ numbers.

10. “Min” is the abbreviation for _minimum , and means __The smallest number in a group of numbers_

11. “Max” is the abbreviation for _MAXIMUM_, and means _ The LARGEST number in a group of numbers

12. “Average” means __The sum of a group of numbers, divided by the number of numbers in the group__