# Advanced Functions Pt 1: Question Preview (ID: 32566)

### Below is a preview of the questions contained within the game titled ADVANCED FUNCTIONS PT 1: Advanced Functions .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.

If I'm trying to calculate how many days until my birthday, which function would I use?
a) IF
b) NOW
c) LIST
d) Days360

If I needed to know the date, what function would I use?
a) =NOW
b) =Days360
c) =IF
d) =ChuckNorris

What symbol does every formula and function start with?
a) =
b) -
c) +
d) Chuck Norris

What would this do? =Days360
a) Return the Current Date
b) Calculates difference in days between two dates
c) Tell me what's for lunch
d) The answer is Chuck Norris.

What would this function do? =NOW
a) Return the current date
b) Calculate difference in days between two dates
c) Tell me what's for lunch
d) The answer is Chuck Norris.

What is used to calculate a period of time?
a) IF Statement
b) Date Functions
c) Lookup Function
d) List

What is used to assist in organizing spreadsheet information?
a) If Statements
b) Date Functions
c) Lookup Functions
d) LIst

What are conditional operators?
a) IF Statements
b) Date Functions
c) Lookup Functions
d) List

What are used to compare a cell value to an array to cells and return a value that matches the location of the value in the array
a) IF Statements
b) Date Functions
c) Lookup Functions
d) List

What would be the best use for an IF Statement?
a) Calculate the number of days until school is over
b) Display the current date
c) Determine which products need to be re-ordered by displaying YES or NO
d) Drop down list of Chuck Norris Jokes

Would would =CountA do?
a) count the number of cells in a range that contain values or letters
b) cell that meet a condition set forth in the formula
c) Karate, the answer is Karate
d) calculate a period of time

What does CountIF do?
a) Karate, the answer it karate
b) calculate a period of time
c) cell that meet a condition set forth in the formula
d) count the number of cells in a range that contain values or letters

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: 32566 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS