Excel Study Guide

5.0(1)
studied byStudied by 15 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/32

flashcard set

Earn XP

Description and Tags

Other Subject

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

33 Terms

1
New cards
1. Active Cell
the cell you enter text and numbers, has a dark border around it
2
New cards

2. cell
the intersection of a column and a row
3
New cards

3. cell reference
the cell’s column headings and row headings
4
New cards

4. column
flow vertical on the page
5
New cards

5. column heading
the letters on the worksheet
6
New cards

6. Formula Bar
shows the contents of the active cell
7
New cards

7. Name Box
shows the cell reference of the active cell
8
New cards

8. range
a group of adjacent cells
9
New cards

9. row
a row flows horizontal on the page
10
New cards

10. row heading
the numbers on the worksheet
11
New cards

11. sheet tab
the tab at the bottom of the screen
12
New cards

12. workbook
a single excel file that contains 3 worksheets
13
New cards

13. worksheet
the work area of a workbook
14
New cards

14. merge
the joining of two or more cells
15
New cards

15. text wrapping
to fit words into a cell vertically
16
New cards

16. ascending order
to arrange in order from top to bottom
17
New cards

17. descending order
to arrange in order from bottom to top
18
New cards

18. sort
to arrange in an orderly manner
19
New cards

19. list
rows of related data
20
New cards

20. AutoFill
automatically fills in a range of cells
21
New cards

21. Average
calculates the total of a range of cells and divides by the number of cells
22
New cards

22. Calculation Operator
+, —, / (slash), * (astericks)
23
New cards

23. fill handle
small black square in the bottom right corner of the active cell
24
New cards

24. filter
sets criteria so that you only see a portion of the data
25
New cards

25. formula
an expression that calculates the contents of other cells
26
New cards

26. function
predefined formulas
27
New cards

27. function argument
the information inside the parenthesis of a function
28
New cards

28. MAX
finds the largest value of a range of cells
29
New cards

29. MIN
finds the smallest value of a range of cells
30
New cards

30. NOW
inserts today’s date and time
31
New cards

31. Subtotal
a temporary total
32
New cards

32. SUM
total of a range of cells
33
New cards

33. TODAY
inserts today’s date

Explore top notes

Explore top flashcards