Random shit I should know

Question 1

N/A!

Answer 1

Cannot find the referenced data

Question 2

NAME?

Answer 2

Unrecognized text in formula

Question 3

NULL!

Answer 3

A space was used

Question 4

NUM!

Answer 4

Formula has invalid numeric data

Question 5

REF!

Answer 5

A reference is invalid

Question 6

VALUE!

Answer 6

The wrong type of operand or function was used

Question 7

Insert current time

Answer 7

CTRL SHIFT COLON

Question 8

Insert current date

Answer 8

CTRL SEMICOLON

Question 9

Apply General Format

Answer 9

CTRL SHIFT TILDE

Question 10

Switch worksheet to the right

Answer 10

CTRL Pg Dn

Question 11

Move on Screen to the right

Answer 11

ALT Pg Dn

Question 12

Close current workbook

Answer 12

CTRL F4 and CTRL W

Question 13

Switch between open workbooks

Answer 13

CTRL TAB

Question 14

Toggle between displaying values and formulas

Answer 14

CTRL LEFT QUOTE

Question 15

Delete Cells

Answer 15

CTRL -

Question 16

Show Format Cells Dialog window

Answer 16

CTRL 1

Question 17

Apply Number Format

Answer 17

CTRL SHIFT !

Question 18

Apply percent format

Answer 18

CTRL SHIFT %

Question 19

Apply Currency Format

Answer 19

CTRL SHIFT $

Question 20

Apply a Border

Answer 20

CTRL SHIFT &

Question 21

Remove a border

Answer 21

CTRL SHIFT _

Question 22

Insert Cells

Answer 22

CTRL SHIFT +

Question 23

Paste Special

Answer 23

CTRL ALT V

Question 24

Copy formula down

Answer 24

CTRL D

Question 25

Copy Formula across

Answer 25

CTRL R

Question 26

A _____ cell uses the value in the active cell in its formula

Answer 26

Dependent

Question 27

Locking cells or hiding formulas has no effect unless the worksheet is protected

Answer 27

TRUE

Question 28

Should you save formulas in CSV format?

Answer 28

NO

Question 29

How do you protect a sheet from being deleted?

Answer 29

PROTECT WORKBOOK

Question 30

To display tracer arrows that indicate which formulas use the value in the active cell, use

Answer 30

TRACE DEPENDENTS

Question 31

Can you input text directly into a relational operator?

Answer 31

NO, must use quotes

Question 32

If using an exact match VLOOKUP, values must be sorted in ascending order

Answer 32

FALSE

Question 33

The ____ is the time it will take to earn sufficient profits that the loan can be repaid

Answer 33

Payback Period

Question 34

For financial functions, 0 means END of the period

Answer 34

TRUE

Question 35

For financial functions, 1 means beginning of the period

Answer 35

TRUE

Question 36

To compare two text strings to see if they're identical (case sensitive), use ____

Answer 36

EXACT

Question 37

Once a scenario is created, the changing cells and comments cannot be edited

Answer 37

FALSE

Question 38

A pivot table is _____ allowing you to change the view of the data

Answer 38

Interactive

Question 39

Decision variables are the _____ cells

Answer 39

Changing

Question 40

Changing Variable Cells must only be values

Answer 40

TRUE

Question 41

Error Alert Stop

Answer 41

Cannot enter invalid data, must either RETRY or CANCEL

Question 42

Error Alert Warning

Answer 42

Warns about invalid data. must either ACCEPT, DECLINE OR CANCEL

Question 43

Error Alert Information

Answer 43

warns about invalid data. must either ACCEPT or CANCEL