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
arrangement
B
scaling
C
calling a range
D
grouping
2) a feature that speeds up the manual entry of functions. Be sure to double click instead of pressing enter!
A
formula autocomplete
B
flash fill
C
fill handle
D
insert function
3) a built-in formula for performing calculations, such as addition, in a table. examples include sum, min, and max
A
functions
B
calculator
C
name box
D
expression
4) to display only certain records.
A
filet
B
range
C
filter
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
formula bar
C
sumcalc
D
total row
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
range name
B
name box
C
name tag
D
fx button
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
autosum
B
formula
C
expression
D
argument
8) if(sum b4:b8 is greater than 50) this is an example of
A
nesting
B
cohabiting
C
calling
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
freeze
B
split
C
strike
D
short
10) variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.
A
variations
B
format painter
C
sort and filter
D
conditional formatting
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
result
B
argument
C
expression
D
conclusion
12) a view that allows you to move and delete page breaks and redefine the print area.
A
page break preview
B
normal
C
custom
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?