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
TIME
B
DATE
C
SUMTIME
D
NOW
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
true
C
false
D
honey badger
4) to create an excel table you must use the table tab
A
buffalo wings
B
true
C
parmesan chicken
D
false
5) you can sort and filter a table using these (located on the table):
A
arrows
B
total row
C
oven mitts
D
sheet tabs
6) which of these returns a value based on whether an argument is true or false?
A
MAX
B
IF
C
SUM
D
NOW
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
LEFT
B
RIGHT
C
CHAR
D
SUM
9) FREEZE and SPLIT are both located under which tab?
A
review
B
data
C
page layout
D
view
10) highlight cells rules, data bars, and icon sets are all examples of
A
conditional formatting
B
number styles
C
cell styles
D
table styles
11) which of the following tabs contain many of the same options as the print screen?
A
insert
B
view
C
page layout
D
home
12) to group sheet tabs together, use this key
A
tab
B
alt
C
enter
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?