Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Computers and Small Business > Spreadsheet Vocabulary > Flashcards

Spreadsheet Vocabulary Flashcards

1
Q

speadsheet

A

a program that helps you do math

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

column

A

WHAT: a vertical line of cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

row

A

a line of cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

cell

A

a single rectangle on a spreadsheet

write the letter (column) first, then the number (row)

This cell is in column B, row 3

We call the cell “B3”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

range

A

a block of cells

write the top left cell, then the bottom right cell (corner to corner)

This range is B3 to F5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

border

A

a line around the outside

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

resize column

A

WHAT: make the column wider

HOW: move the cursor to the edge between the column headers

(the cursor will change to RESIZE cursor)

then click and drag

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

sort

A

WHAT: put data in alphabetical order

HOW: highlight the data, then use the SORT tool on the ribbon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

undo

A

control-z

OR

back arrow above the ribbon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

custom sort

A

sort BY a certain column

(example: sort by age, sort by price)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

arrow key

A

use arrow keys to move in a spread sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is this?

:

A

colon

use for a range in a spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

how can we sort

A

alphabetically

OR

numerically

AND

in reverse order

smallest to largest

largest to smallest

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

what is

number crunching

A

doing math, doing calculations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

what are the four basic operations in math

A

addition, substraction

multiplication, division

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

what is this?

/

A

WHAT: slash

USE FOR: division

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

what is this?

*

A

WHAT: star or asterisk

USE FOR: multiplication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

what is this?

=

A

WHAT: equal sign

USE FOR: beginning of a formula or calculation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

what is the formula bar?

A

WHERE: under the ribbon on a spreadsheet

WHAT: tells you the formula for the selected cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

how do you make a number look like a dollar amount

A

highlight the cell (or range)

and click on the dollar sign on the ribbon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

what are there?

( )

A

parentheses

(open parenthesis, close parenthesis)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

circular reference

A

error (mistake or problem)

formula that repeats over and over

WHY: because you highlighted the result with the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

dynamic

A

changes automatically

when you change the numbers in a spreadsheet,
the formula results change

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

selection handle

A

WHAT THEY DO: resize the selection

HOW: click on the handle, drag

CURSOR: two diagonal arrows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

check your formulas

A

WHAT: make sure that the range of the formula is correct

HOW: double-click the cell with the answer,
look at the shaded range

26
Q

shaded

A

in shadow, darkened

27
Q

diagonal

slanted

A

corner to corner

NOT straight up and down (vertical)

NOT side to side (horizontal)

28
Q

toggle

A

the same button turns ON or OFF

examples: bold, italic, underline

29
Q

how to add numbers on excel

A

equal sign

sum

(

highlight

)

hit enter

=sum(E2:E4)

30
Q

add a row or column

A

click on the row header (or column header)

control-shift-+

31
Q

remove a row or column

A

click on the row header (or column header)

control minus

32
Q

What does a

GREATER THAN SIGN

look like?

How do we read it?

A

>

4>2 “four is greater than two”

33
Q

What is this?

<

How do we read “2<4”?

A

“less than sign”

2 < 4 –> two is less than four

34
Q

conditional sentence

conditional statement

A

If ….. then ……

If I had a million dollars, I would buy a million-dollar house.

If A1=$1,000,000 then B1=”spend $500,000 on a house”

35
Q

What is this?

>=

How do we read 4>=4

A

greater than or equal sign

4>=3 four is greater than or equal to three

36
Q

IF formula

A

=IF(A1>=1000000, B1=”buy a house”)

=IF(logical test, result if true, result if false)

37
Q

What are these:

” ….. “ <– use these

‘….’ <– not these

A

(double) quotation marks

single quotes

My teacher said “Please turn to page 67.”

My teacher said “Please read the section called ‘Using a spreadsheet’ and answer the questions.”

38
Q

What is a logical test?

A

a statement that is TRUE or FALSE

like a yes/no question in English

39
Q

pin a cell in a formula

A

highlight the cell and hit F4

OR type $ $

40
Q

Why are there dollar signs?

$A$1

A

$A$1

the dollar signs show that the cell is pinned
(it will not move)

(it is fixed)

(it is stuck)

41
Q

How can you change his formula
so that it ALWAYS refers to A1?

=IF(A1 > 18, “you can drive”)

A

=IF(A1 > 18, “you can drive”)

highlight A1 and hit F4

OR change A1 $A$1

42
Q

What is

FILL DOWN?

A

You can copy a cell or formula:

  1. highlight the cell
  2. pick up the handle and drag it down

You can also FILL ACROSS

43
Q

how do you find an

average?

2 methods!!!!

A

EASY WAY:
HIghlight data,
go to autosum drop down menu,
and choose average

(little bit) HARDER WAY

In the cell, type

=AVERAGE( highlight data ) hit enter

44
Q

formula

Which ones do you know?

A

=IF( …… )

=SUM( ……. )

=AVERAGE( ……… )

45
Q

3 ways to copy data

A

highlight the data, then

  1. click on copy on the ribbon (looks like 2 pages)
  2. right-click and hit copy
  3. control -C
46
Q

3 ways to paste data

A

click on the cell, then

  1. click on paste on the ribbon (looks like clipboard plus 1 page)
  2. right-click and hit paste
  3. control -V
47
Q

what is

2 decimal places??

A

2 numbers after the decimal place

Example: $12.99 (99 is 2 decimal places)

Example: $13 (0 decimal places)

48
Q

HOW do we get 2 decimal places?

A

go to the ribbon

49
Q

when do we use comma in English?

A

for a list:

Funmi, Nyounai, and Omima

Khaled and Nahlaa

50
Q

optional

A

it’s choice

you can do it OR you can skip it

NOT required, NOT mandatory

51
Q

What does “roll over” mean?

A

move the mouse over something
WITHOUT clicking

when you roll over a link

the cursur will (probably) change!!

52
Q

how do you get a

“tool tip”

A

roll over the tool on the ribbon

and it gives you a description

of what the tool does

53
Q

what is a “shortcut”

A

lets you do something faster

(or do it with with fewer steps)

54
Q
A
55
Q
A
56
Q

2>=3

A
57
Q
A
58
Q
A
59
Q
A
60
Q
A

Computers and Small Business (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions