Flash Cards (current)
Games
Teachers

Advanced Functions Pt 1

Test Description: Advanced Functions

Instructions: Answer all questions to get your test result.

1) What are conditional operators?

ADate Functions BIF Statements CList DLookup Functions

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

ALookup Functions BIF Statements CList DDate Functions

3) What is used to assist in organizing spreadsheet information?

AIf Statements BLIst CDate Functions DLookup Functions

4) What is used to calculate a period of time?

ADate Functions BLookup Function CIF Statement DList

5) What would this function do? =NOW

ACalculate difference in days between two dates BTell me what's for lunch CThe answer is Chuck Norris. DReturn the current date

6) What would this do? =Days360

AReturn the Current Date BCalculates difference in days between two dates CTell me what's for lunch DThe answer is Chuck Norris.

7) What symbol does every formula and function start with?

A+ B= C- DChuck Norris

8) If I'm trying to calculate how many days until my birthday, which function would I use?

AIF BNOW CLIST DDays360

9) If I needed to know the date, what function would I use?

A=NOW B=ChuckNorris C=IF D=Days360

10) What would be the best use for an IF Statement?

ADisplay the current date BDrop down list of Chuck Norris Jokes CDetermine which products need to be re-ordered by displaying YES or NO DCalculate the number of days until school is over

11) Would would =CountA do?

AKarate, the answer is Karate Bcalculate a period of time Ccount the number of cells in a range that contain values or letters Dcell that meet a condition set forth in the formula

12) What does CountIF do?

Acount the number of cells in a range that contain values or letters Bcalculate a period of time Ccell that meet a condition set forth in the formula DKarate, the answer it karate

*select an answer for all questions

Play Games with the Questions Above

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?