Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Advanced Functions Pt 1
Test Description: Advanced Functions
Instructions: Answer all questions to get your test result.
1) What are conditional operators?
A
Lookup Functions
B
Date Functions
C
List
D
IF Statements
2) 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
Lookup Functions
C
List
D
Date Functions
3) What is used to assist in organizing spreadsheet information?
A
If Statements
B
LIst
C
Date Functions
D
Lookup Functions
4) What is used to calculate a period of time?
A
Lookup Function
B
List
C
Date Functions
D
IF Statement
5) What would this function do? =NOW
A
Calculate difference in days between two dates
B
The answer is Chuck Norris.
C
Tell me what's for lunch
D
Return the current date
6) What would this do? =Days360
A
Calculates difference in days between two dates
B
Return the Current Date
C
Tell me what's for lunch
D
The answer is Chuck Norris.
7) What symbol does every formula and function start with?
A
-
B
=
C
+
D
Chuck Norris
8) If I'm trying to calculate how many days until my birthday, which function would I use?
A
IF
B
Days360
C
NOW
D
LIST
9) If I needed to know the date, what function would I use?
A
=IF
B
=ChuckNorris
C
=NOW
D
=Days360
10) What would be the best use for an IF Statement?
A
Calculate the number of days until school is over
B
Determine which products need to be re-ordered by displaying YES or NO
C
Drop down list of Chuck Norris Jokes
D
Display the current date
11) Would would =CountA do?
A
calculate a period of time
B
Karate, the answer is Karate
C
count the number of cells in a range that contain values or letters
D
cell that meet a condition set forth in the formula
12) What does CountIF do?
A
cell that meet a condition set forth in the formula
B
count the number of cells in a range that contain values or letters
C
calculate a period of time
D
Karate, the answer it karate
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?