control-z OR back arrow above the ribbon

Spreadsheet Vocabulary Flashcards by Karen Nelson

speadsheet

a program that helps you do math

How well did you know this?

Not at all

Perfectly

column

WHAT: a vertical line of cells

How well did you know this?

Not at all

Perfectly

row

a line of cells

How well did you know this?

Not at all

Perfectly

cell

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?

Not at all

Perfectly

range

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?

Not at all

Perfectly

border

a line around the outside

How well did you know this?

Not at all

Perfectly

resize column

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?

Not at all

Perfectly

sort

WHAT: put data in alphabetical order

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

How well did you know this?

Not at all

Perfectly

undo

control-z

back arrow above the ribbon

How well did you know this?

Not at all

Perfectly

custom sort

sort BY a certain column

(example: sort by age, sort by price)

How well did you know this?

Not at all

Perfectly

arrow key

use arrow keys to move in a spread sheet

How well did you know this?

Not at all

Perfectly

What is this?

colon

use for a range in a spreadsheet

How well did you know this?

Not at all

Perfectly

how can we sort

alphabetically

numerically

AND

in reverse order

smallest to largest

largest to smallest

How well did you know this?

Not at all

Perfectly

what is

number crunching

doing math, doing calculations

How well did you know this?

Not at all

Perfectly

what are the four basic operations in math

addition, substraction

multiplication, division

How well did you know this?

Not at all

Perfectly

what is this?

WHAT: slash

USE FOR: division

How well did you know this?

Not at all

Perfectly

what is this?

WHAT: star or asterisk

USE FOR: multiplication

How well did you know this?

Not at all

Perfectly

what is this?

WHAT: equal sign

USE FOR: beginning of a formula or calculation

How well did you know this?

Not at all

Perfectly

what is the formula bar?

WHERE: under the ribbon on a spreadsheet

WHAT: tells you the formula for the selected cell

How well did you know this?

Not at all

Perfectly

how do you make a number look like a dollar amount

highlight the cell (or range)

and click on the dollar sign on the ribbon

How well did you know this?

Not at all

Perfectly

what are there?

( )

parentheses

(open parenthesis, close parenthesis)

How well did you know this?

Not at all

Perfectly

circular reference

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?

Not at all

Perfectly

dynamic

changes automatically

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

How well did you know this?

Not at all

Perfectly

selection handle

WHAT THEY DO: resize the selection

HOW: click on the handle, drag

CURSOR: two diagonal arrows

How well did you know this?

Not at all

Perfectly

check your formulas

WHAT: make sure that the range of the formula is correct HOW: double-click the cell with the answer, look at the shaded range

shaded

in shadow, darkened

diagonal slanted

corner to corner NOT straight up and down (vertical) NOT side to side (horizontal)

toggle

the same button turns ON or OFF examples: bold, italic, underline

how to add numbers on excel

equal sign sum ( highlight ) hit enter **=sum(E2:E4)**

add a row or column

click on the row header (or column header) control-shift-+

remove a row or column

click on the row header (or column header) control minus

What does a GREATER THAN SIGN look like? How do we read it?

**\>** **4\>2 "four is greater than two"**

What is this? **\<** How do we read "2\<4"?

"less than sign" 2 \< 4 --\> two is less than four

conditional sentence conditional statement

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"

What is this? **\>=** How do we read 4\>=4

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

IF formula

=IF(A1\>=1000000, B1="buy a house") =IF(logical test, result if true, result if false)

What are these: **" ..... "** \<-- use these **'....'** \<-- not these

(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."

What is a logical test?

a statement that is TRUE or FALSE like a yes/no question in English

pin a cell in a formula

highlight the cell and hit F4 OR type $ $

Why are there dollar signs? $A$1

$A$1 the dollar signs show that the cell is pinned (it will not move) (it is fixed) (it is stuck)

How can you change his formula so that it ALWAYS refers to A1? =IF(A1 \> 18, "you can drive")

=IF(A1 \> 18, "you can drive") highlight A1 and hit F4 OR change A1 $A$1

What is FILL DOWN?

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

how do you find an average? 2 methods!!!!

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

formula Which ones do you know?

=IF( ...... ) =SUM( ....... ) =AVERAGE( ......... )

3 ways to copy data

highlight the data, then 1. click on copy on the ribbon (looks like 2 pages) 2. right-click and hit copy 3. control -C

3 ways to paste data

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

what is 2 decimal places??

2 numbers after the decimal place Example: $12.99 (99 is 2 decimal places) Example: $13 (0 decimal places)

HOW do we get 2 decimal places?

go to the ribbon

when do we use comma in English?

for a list: Funmi, Nyounai, and Omima Khaled and Nahlaa

optional

it's choice you can do it OR you can skip it NOT required, NOT mandatory

What does "roll over" mean?

move the mouse over something WITHOUT clicking when you roll over a link the cursur will (probably) change!!

how do you get a "tool tip"

roll over the tool on the ribbon and it gives you a description of what the tool does

what is a "shortcut"

lets you do something faster | (or do it with with fewer steps)

2\>=3