# 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.

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

Log In | Sign Up / Register

Log In | Sign Up / Register