Advanced Functions Pt 1 Question Preview (ID: 32566)


Advanced Functions. TEACHERS: click here for quick copy question ID numbers.

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 above, visit ReviewGameZone.com and enter game ID number: 32566 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register