Excel Review List

Most concepts are discussed here and there in the book throughout all tutorials. Please read book thoroughly and need to pay attention to the bolded words in the book, which usually are important concepts. Please also consult the index part at the end of the book, whenever you are not familiar with a term. A subject is defined by its terms so terms are important to know.

Go over slides

1. Concept and Terminology

what is Excel?

Please find out the explanation to the following concepts on pages mainly on pages

By default, the file extension for a workbook is .xls

column range

row range

cell

worksheet

workbook

worksheet name, rename, copy

text

number

formula

formula bar

function

how many functions

if function nested if function

reference

absolute reference

relative reference

mixed reference

title bar

menu bar

full menu

short menu

dimmed button

standard toolbar

formatting toolbar

floating and docking

status bar

auto calculation area

keyboard indicators

name box

insert function box

formula bar

active cell

mouse pointer

valid characters in numbers

valid operators

range

fill handle

auto recalculate and manually recalculate

how many functions more than 250 different functions covering different application.

blank cell

2. Editing operation

Select all button

alter-enter

select

drag

fill handle

Different shapes of mouse pointers

copy optional

error messages

customization

optional settings

goal seek

3. Formatting operations

various numeric formatting techniques cell format (negative, precision, dollar sign etc.)

various text formatting techniques font type, style, size, color etc

autoformatting foreground and pattern.

conditional formatting

hiding columns

4. Chart

pie chart, bar chart and so on

legend

series

title

3D view

explode

5. save Excel worksheet as dynamic and static webpages.