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