Excel Intro:
Summary

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007/2010  or españolIcon: Change web



The Excel interface is quite similar in many ways to the interface of other programs, such as Word, but there are some important differences. The toolbars have some different buttons. Some buttons that look the same have a different action than in Word. 

In a spreadsheet you enter data into cells. Data can be text, numbers, formulas, or logical tests. You can select adjacent and non-adjacent cells, ranges, rows, columns, or sheets. Special key combinations can help you move around the worksheet. In addition to the expected views (Normal, Print Preview, Full Screen), there is a new Page Break Preview, which lets you adjust page breaks. Also new are Split view, where you can view either 2 or 4 parts of a sheet at once, and Frozen Panes, where part of the sheet stays in view while you scroll to other areas.

AutoSum intelligently adds rows or columns for you. You can sort data alphabetically, but formulas may break if sorted. The Chart Wizard guides you in developing a chart for your data. Excel has several pre-defined formats for numbers with their own buttons. The Print button will cause all pages of the active sheet(s) to print.


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel Intro
    InterfaceTo subtopics
    Select & Navigate To subtopics
    Common Tasks To subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Excel BasicsTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Search
Glossary
Appendix


What you printed for Excel Project 1: Excel Intro

File & Sheet

What is it?

# of Pages

budget.xls Inflows chart

chart you created

1 page
 


Important Terms

absolute reference

active

adjacent

AutoCalculate

AutoFormat

AutoSum

cell

cell reference

Chart Wizard

column

column heading

column label

column width

Comma

Currency

data block or region

Decrease Decimal

edit data

Edit mode

End mode

enter data

formula

Formula bar

Freeze panes

Full screen

gridlines

Increase Decimal

Merge and Center

merge cells

Message area

mode

mode indicators

name

Name Box

non-adjacent

Normal View

Page Break Preview

Percentage

Print

Print Area

Print Preview

range

relative reference

row

row heading

row label

row height

Scroll Lock mode

selection

sheet

sheet tab

Sort Ascending

Sort Descending

split cell

Split view

spreadsheet

Unfreeze panes

workbook

workbook window

worksheet

xls