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


Part 2. TEACHERS: click here for quick copy question ID numbers.

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 above, visit ReviewGameZone.com and enter game ID number: 23517 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register