Excel Ch 2 Review Pt 2: Question Preview (ID: 23517)


Below is a preview of the questions contained within the game titled EXCEL CH 2 REVIEW PT 2: Part 2 .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.

Which of the following is NOT a function we used this chapter?
a) SUBSTITUTE b) RIGHT c) CONCATENATE d) SUMIFS
which function returns the current date and time?
a) NOW b) TIME c) DATE d) SUMTIME
When naming a group of cells, you may include spaces in the name
a) false b) true c) honey badger d) freckled lizard
to create an excel table you must use the table tab
a) false b) true c) parmesan chicken d) buffalo wings
you can sort and filter a table using these (located on the table):
a) arrows b) total row c) sheet tabs d) oven mitts
which of these returns a value based on whether an argument is true or false?
a) IF b) SUM c) NOW d) MAX
which of the following functions uses a criteria to count the number of items in a range?
a) COUNTIF b) SUMIF c) VALUE d) REPLACECOUNT
If someone wanted to return the first 5 characters in a cell to a different cell, they would use
a) LEFT b) SUM c) CHAR d) RIGHT
FREEZE and SPLIT are both located under which tab?
a) view b) page layout c) data d) review
highlight cells rules, data bars, and icon sets are all examples of
a) conditional formatting b) table styles c) cell styles d) number styles
which of the following tabs contain many of the same options as the print screen?
a) page layout b) view c) insert d) home
to group sheet tabs together, use this key
a) control b) enter c) tab d) alt
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: 23517 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