Excel Study Guide

1. Active Cell

the cell you enter text and numbers, has a dark border around it

2. cell

the intersection of a column and a row

3. cell reference

the cell’s column headings and row headings

4. column

flow vertical on the page

5. column heading

the letters on the worksheet

6. Formula Bar

shows the contents of the active cell

7. Name Box

shows the cell reference of the active cell

8. range

a group of adjacent cells

9. row

a row flows horizontal on the page

10. row heading

the numbers on the worksheet

11. sheet tab

the tab at the bottom of the screen

12. workbook

a single excel file that contains 3 worksheets

13. worksheet

the work area of a workbook

14. merge

the joining of two or more cells

15. text wrapping

to fit words into a cell vertically

16. ascending order

to arrange in order from top to bottom

17. descending order

to arrange in order from bottom to top

18. sort

to arrange in an orderly manner

19. list

rows of related data

20. AutoFill

automatically fills in a range of cells

21. Average

calculates the total of a range of cells and divides by the number of cells

22. Calculation Operator

+, —, / (slash), * (astericks)

23. fill handle

small black square in the bottom right corner of the active cell

24. filter

sets criteria so that you only see a portion of the data

25. formula

an expression that calculates the contents of other cells

26. function

predefined formulas

27. function argument

the information inside the parenthesis of a function

28. MAX

finds the largest value of a range of cells

29. MIN

finds the smallest value of a range of cells

30. NOW

inserts today’s date and time

31. Subtotal

a temporary total

32. SUM

total of a range of cells

33. TODAY

inserts today’s date