Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Ch 2 Review
Test Description: Functions, tables, etc...
Instructions: Answer all questions to get your test result.
1) Worksheet that are selected as a unit; any action performed on this unit will affect all the worksheets in the group.
A
grouping
B
scaling
C
arrangement
D
calling a range
2) a feature that speeds up the manual entry of functions. Be sure to double click instead of pressing enter!
A
insert function
B
formula autocomplete
C
fill handle
D
flash fill
3) a built-in formula for performing calculations, such as addition, in a table. examples include sum, min, and max
A
expression
B
calculator
C
functions
D
name box
4) to display only certain records.
A
filet
B
filter
C
range
D
sort
5) a row you can display below a table to calculate data in the columns above using a function you choose
A
filter arrows
B
total row
C
sumcalc
D
formula bar
6) the name given to a set of adjacent cells. you might name a range in order to make it more convenient to reference that range in a formula or a function, such as VLOOKUP
A
name box
B
name tag
C
fx button
D
range name
7) a type of equation (such as B625) that returns a value, such as TRUE or FALSE. Excel uses expressions to identify cells to include in certain formulas as IF and SUMIF
A
formula
B
argument
C
expression
D
autosum
8) if(sum b4:b8 is greater than 50) this is an example of
A
calling
B
nesting
C
cohabiting
D
integrating
9) to set a field so that it always remains on-screen, in the left-most position, as you scroll left to right
A
strike
B
freeze
C
short
D
split
10) variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.
A
conditional formatting
B
sort and filter
C
format painter
D
variations
11) The values and other inputs that a function uses to calculate the result. You specify the cell or range that holds the value(s) for each argument or input a particular value.
A
expression
B
result
C
argument
D
conclusion
12) a view that allows you to move and delete page breaks and redefine the print area.
A
custom
B
normal
C
page break preview
D
print layout
*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?