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