Uses of spreadsheet

Advantage and disadvantage of spreadsheet

Basic features of spreadsheet

Terminology of spreadsheet

Absolute Cell Reference

Active Cell

Cell

Cell Name

Cell Reference

Columns

Data

Filter

Formula

Formula Bar

Function

Range

Relative Reference

Rows

Values

Workbook

Worksheet

Types of spreadsheet,describe each one.

Introuction to Excel

Advantage and disadvantage of Excel

Common Functions in Excel, describe them:

SUM

SUMIF

SUMIFS

COUNT

COUNTA

COUNTIF

IF

VLOOKUP

MIN

MAX

AVERAGE

CONCATENATE

ROUND

PROPER, UPPER, and LOWER

NOW

TODAY