Vocabulary Practive: Functions, Formulas, Cell References

studied byStudied by 0 people
0.0(0)
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 / 14

encourage image

There's no tags or description

Looks like no one added any tags here yet for you.

15 Terms

1

Exponent

Meaning of E in the order

New cards
2

order of operations

This method tells Excel which operation to calculate first. PEMDAS

New cards
3

Excel Formula

An equation that calculates a new value from values currently in a worksheet

New cards
4

conditional formatting

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed

New cards
5

Syntax

The arrangement of words and phrases to create well-formed sentences in a language

New cards
6

Number format

A format that controls how n data is displayed, including the use of commas, dollar signs, and number of decimal places

New cards
7

Parentheses

Meaning of P in the order of operations

New cards
8

$ sign

An absolute reference is designates in a formula by the addition of —- sign. It can precede the column reference, the row reference, or both.

New cards
9

Relative cell reference

A cell reference that adjusts based on the position of the formula when copied to another cell.

New cards
10

Addition

Meaning of A in the order of operations

New cards
11

Excel Function

predefined formulas and are already available in Excel

New cards
12

Multiplication

Meaning of M in the order of operations

New cards
13

Absolute cell reference

The cell reference remain constant no matter where they are copied

New cards
14

Subtraction

Meaning of S in the order of operations

New cards
15

Division

Meaning of D in the order of operations

New cards
robot