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
calling a range
B
grouping
C
arrangement
D
scaling
2) a feature that speeds up the manual entry of functions. Be sure to double click instead of pressing enter!
A
insert function
B
fill handle
C
flash fill
D
formula autocomplete
3) a built-in formula for performing calculations, such as addition, in a table. examples include sum, min, and max
A
calculator
B
expression
C
name box
D
functions
4) to display only certain records.
A
range
B
filter
C
sort
D
filet
5) a row you can display below a table to calculate data in the columns above using a function you choose
A
sumcalc
B
total row
C
formula bar
D
filter arrows
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 tag
B
name box
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
argument
B
formula
C
expression
D
autosum
8) if(sum b4:b8 is greater than 50) this is an example of
A
nesting
B
calling
C
integrating
D
cohabiting
9) to set a field so that it always remains on-screen, in the left-most position, as you scroll left to right
A
short
B
strike
C
freeze
D
split
10) variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.
A
format painter
B
conditional formatting
C
variations
D
sort and filter
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
conclusion
C
result
D
argument
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?