# Excel Ch 2: Question Preview (ID: 17433)

### Below is a preview of the questions contained within the game titled EXCEL CH 2: Review .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

**Play games to reveal the correct answers. Click here to play a game and get the answers.**

**there is more than one way to insert a function**

a) true

b) false

c) chicken shwarma

d) beef kabobs

**which of the following will insert the date and time?**

a) NOW

b) TODAY

c) DATE AND TIME

d) GRAPH

**when you name a range of cells, you can just type in the __________**

a) name box

b) formula bar

c) home tab

d) autosum button

**when naming a group of cells, you cannot use spaces between words**

a) true

b) false

c) stuffed crust jalapeno and pepperoni pizza

d) texas potatoes

**which of the following is not a way to insert a function?**

a) insert tab

b) formulas tab

c) formula autocomplete

d) fx button

**the fx button does what?**

a) inserts function

b) zooms to selection

c) fixes your problem in Excel

d) sends a fax

**which of the following is not listed under autosum?**

a) if

b) max

c) min

d) average

**when using formula autocomplete, you need to double click the blue function name that appears**

a) true

b) false

c) brisket sandwich

d) chicken habanero sandwich

**this function counts the number of cells that contain numbers**

a) count

b) counta

c) countif

d) countblank

**this function counts the number of cells that are not blank**

a) counta

b) count

c) countif

d) countblank

**pre-programmed shortcuts for calculating complex equations**

a) functions

b) formulas

c) ctrl f

d) junctions

**you can access information from sheet 1 and put it on sheet 2.**

a) true

b) false

c)

d)

**in the if function, what is the argument listed at the top?**

a) logical test

b) value if true

c) value if false

d)

**when calculating loan payments, which argument represents the amount you are borrowing?**

a) pv

b) fv

c) pmt

d) rate

**in the pmt function, what do you need to do the rate to get it to be a monthly rate?**

a) divide by 12

b) multiply by 12

c) keep it the same

d)

**in the pmt function, should nper be in months or years?**

a) months

b) years

c) bi annual

d)

**which function includes table array, column index number, lookup value, and range lookup**

a) vlookup

b) if

c) pmt

d) max

**which of the following arguments in vlookup tells you which value you are looking for**

a) lookup value

b) range lookup

c) column index number

d) table array

**which of the following arguments in vlookup represents the group of cells that contain the info you are looking for?**

a) table array

b) column index number

c) table array

d) lookup value

Play Games with the Questions above at ReviewGameZone.com

To play games using the questions from the data set above, visit ReviewGameZone.com and enter game ID number: 17433 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

To play games using the questions from the data set above, visit ReviewGameZone.com and enter game ID number: 17433 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS

Log In | Sign Up / Register

Log In | Sign Up / Register