Advanced Functions Pt 1 Question Preview (ID: 32566)
Advanced Functions.
TEACHERS: click here for quick copy question ID numbers.
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 is used to assist in organizing spreadsheet information?
a) If Statements
b) Date Functions
c) Lookup Functions
d) LIst
What is used to calculate a period of time?
a) IF Statement
b) Date Functions
c) Lookup Function
d) List
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 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 symbol does every formula and function start with?
a) =
b) -
c) +
d) Chuck Norris
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 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.
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
Log In | Sign Up / Register