Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Ch 2 Review Pt 2
Test Description: Part 2
Instructions: Answer all questions to get your test result.
1) which function returns the current date and time?
A
SUMTIME
B
NOW
C
TIME
D
DATE
2) Which of the following is NOT a function we used this chapter?
A
RIGHT
B
SUMIFS
C
CONCATENATE
D
SUBSTITUTE
3) When naming a group of cells, you may include spaces in the name
A
true
B
honey badger
C
false
D
freckled lizard
4) to create an excel table you must use the table tab
A
parmesan chicken
B
true
C
false
D
buffalo wings
5) you can sort and filter a table using these (located on the table):
A
sheet tabs
B
oven mitts
C
arrows
D
total row
6) which of these returns a value based on whether an argument is true or false?
A
SUM
B
IF
C
NOW
D
MAX
7) which of the following functions uses a criteria to count the number of items in a range?
A
COUNTIF
B
SUMIF
C
REPLACECOUNT
D
VALUE
8) If someone wanted to return the first 5 characters in a cell to a different cell, they would use
A
RIGHT
B
LEFT
C
CHAR
D
SUM
9) FREEZE and SPLIT are both located under which tab?
A
data
B
view
C
review
D
page layout
10) highlight cells rules, data bars, and icon sets are all examples of
A
conditional formatting
B
cell styles
C
number styles
D
table styles
11) which of the following tabs contain many of the same options as the print screen?
A
view
B
insert
C
page layout
D
home
12) to group sheet tabs together, use this key
A
alt
B
enter
C
tab
D
control
*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?