Enter Title

A

100

How is a cell in excel identified?

Letter Number example D3

200

What is excel?

Collection of rows and columns

300

How is a row identified?

Number

400

How is a column identified?

Letter

501

Sum

To sum the values of multiple cells

B

100

Count

To count the cells even if they are empty.

200

CountA

count cells which are not empty

300

Autofit

AutoFit in Excel is a feature that automatically adjusts the width of columns or height of rows so that all the content fits neatly within the cells—no text cut off, no unnecessary extra space.

400

=Sum(E4:11)

sum values from e4 to e11

501

Insert Sheet

Insert New Worksheet

C

100

=Count(A11:A29)

count the values from A11 to A29

200

Save a workbook

File-Save As-this PC-

300

Undo

Reverse the last action

400

Now()

Function that displays the date and time.

501

Column

Right click-Insert column

D

100

Clear contents

Clear contents but leave formatting

200

Clear Formats

Clear formatting but not deleting the contents

300

Layout

File -Orientation-Layout

400

Name a sheet

Right click-Rename

501

Flash fill

you type two examples then you drag the samples.

F

100

Copy Template

Right-Move& copy

200

Column Width

Format-Column Width

300

Row Height

Format-Row Height

400

Hide&Unhide

Format-Hide and Unhide

501

Rename Sheet

Format-Rename Sheet