Excel Study Guide

studied byStudied by 14 people
5.0(1)
learn
LearnA personalized and smart learning plan
exam
Practice TestTake a test on your terms and definitions
spaced repetition
Spaced RepetitionScientifically backed study method
heart puzzle
Matching GameHow quick can you match all your cards?
flashcards
FlashcardsStudy terms and definitions

1 / 32

flashcard set

Earn XP

Description and Tags

33 Terms

1
  1. Active Cell

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

New cards
2
  1. cell

the intersection of a column and a row

New cards
3
  1. cell reference

the cell’s column headings and row headings

New cards
4
  1. column

flow vertical on the page

New cards
5
  1. column heading

the letters on the worksheet

New cards
6
  1. Formula Bar

shows the contents of the active cell

New cards
7
  1. Name Box

shows the cell reference of the active cell

New cards
8
  1. range

a group of adjacent cells

New cards
9
  1. row

a row flows horizontal on the page

New cards
10
  1. row heading

the numbers on the worksheet

New cards
11
  1. sheet tab

the tab at the bottom of the screen

New cards
12
  1. workbook

a single excel file that contains 3 worksheets

New cards
13
  1. worksheet

the work area of a workbook

New cards
14
  1. merge

the joining of two or more cells

New cards
15
  1. text wrapping

to fit words into a cell vertically

New cards
16
  1. ascending order

to arrange in order from top to bottom

New cards
17
  1. descending order

to arrange in order from bottom to top

New cards
18
  1. sort

to arrange in an orderly manner

New cards
19
  1. list

rows of related data

New cards
20
  1. AutoFill

automatically fills in a range of cells

New cards
21
  1. Average

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

New cards
22
  1. Calculation Operator

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

New cards
23
  1. fill handle

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

New cards
24
  1. filter

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

New cards
25
  1. formula

an expression that calculates the contents of other cells

New cards
26
  1. function

predefined formulas

New cards
27
  1. function argument

the information inside the parenthesis of a function

New cards
28
  1. MAX

finds the largest value of a range of cells

New cards
29
  1. MIN

finds the smallest value of a range of cells

New cards
30
  1. NOW

inserts today’s date and time

New cards
31
  1. Subtotal

a temporary total

New cards
32
  1. SUM

total of a range of cells

New cards
33
  1. TODAY

inserts today’s date

New cards

Explore top notes

note Note
studied byStudied by 11 people
1117 days ago
5.0(1)
note Note
studied byStudied by 19 people
836 days ago
5.0(1)
note Note
studied byStudied by 469 people
761 days ago
5.0(1)
note Note
studied byStudied by 6 people
799 days ago
5.0(1)
note Note
studied byStudied by 27 people
720 days ago
4.0(2)
note Note
studied byStudied by 36 people
834 days ago
4.5(2)
note Note
studied byStudied by 8 people
540 days ago
5.0(1)
note Note
studied byStudied by 214 people
672 days ago
5.0(2)

Explore top flashcards

flashcards Flashcard (20)
studied byStudied by 9 people
756 days ago
5.0(1)
flashcards Flashcard (74)
studied byStudied by 52 people
737 days ago
4.8(8)
flashcards Flashcard (108)
studied byStudied by 9 people
25 days ago
5.0(2)
flashcards Flashcard (169)
studied byStudied by 20 people
64 days ago
5.0(3)
flashcards Flashcard (39)
studied byStudied by 45 people
811 days ago
5.0(1)
flashcards Flashcard (20)
studied byStudied by 3 people
679 days ago
5.0(1)
flashcards Flashcard (38)
studied byStudied by 92 people
394 days ago
5.0(1)
flashcards Flashcard (33)
studied byStudied by 6 people
756 days ago
5.0(1)
robot