Microsoft Office Flashcards

1
Q

Excel follows the ___ rule in performing mathematical computations

A

PEMDAS

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

P is for?

A

Parenthesis

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

E is for

A

Exponent

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

M is for

A

Multiplication

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

D is for

A

Division

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

A is for

A

Addition

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

S is for

A

Subtraction

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

there are a total of __ excel arithmetic operators

A

six/6

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

an icon, graphic, or text that links to another file, object,
page or web address.

A

hyperlink

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

4 Numerical functions in microsoft excel

A

-SUM
-AVERAGE
-MODULUS
-POWER

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

7 string functions is microsoft excel

A

-concatenate
-left
-right
-middle
-length
-replace
-substitute

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

excel arithmetic operators

A

grouping symbol
exponent
multiplication
division
addition
subtraction

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

( ) symbol

A

grouping symbol

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

^ symbol

A

exponent

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