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 89 people
890 days ago
4.5(4)
note Note
studied byStudied by 11 people
879 days ago
5.0(1)
note Note
studied byStudied by 1 person
19 hours ago
4.0(1)
note Note
studied byStudied by 19 people
979 days ago
5.0(1)
note Note
studied byStudied by 22 people
799 days ago
5.0(1)
note Note
studied byStudied by 15 people
816 days ago
5.0(1)
note Note
studied byStudied by 11 people
965 days ago
5.0(1)
note Note
studied byStudied by 127 people
616 days ago
5.0(1)

Explore top flashcards

flashcards Flashcard (21)
studied byStudied by 5 people
635 days ago
5.0(1)
flashcards Flashcard (23)
studied byStudied by 2 people
148 days ago
5.0(1)
flashcards Flashcard (32)
studied byStudied by 26 people
391 days ago
5.0(1)
flashcards Flashcard (173)
studied byStudied by 1 person
13 days ago
5.0(1)
flashcards Flashcard (55)
studied byStudied by 14 people
760 days ago
5.0(3)
flashcards Flashcard (30)
studied byStudied by 18 people
445 days ago
5.0(1)
flashcards Flashcard (20)
studied byStudied by 7 people
361 days ago
4.0(1)
flashcards Flashcard (84)
studied byStudied by 74 people
352 days ago
5.0(1)
robot