Excel Matching 1. small green square which makes copies to adjacent cells more e
ID: 3909423 • Letter: E
Question
Excel Matching
1. small green square which makes copies to adjacent cells more efficient
2. starts a function statement in a cell
3. brings up a gallery of possible present formatting options
4. recognizes patterns in data and autocompletes ranges
5. displays common functions used in excel
6. MAX
7. automatically changes cell appearance based on values in the cell
8. is enacted using dollar signs
9. adjusts formulas when you copy to other cells
10. decision logic built in to excel spreadsheets
A. absolute cell addressing
B. the equal sign
C. fill handle
D. is an example of an aggregate statistical function
E. relative cell addressing
F. the IF function
G. cell styles icon
H. fx button
I. flash fill
J. conditional formatting
Explanation / Answer
1.small green square which makes copies to adjacent cells more efficient: fill handle
2.starts a function statement in a cell: the equal sign
3.brings up a gallery of possible present formatting options: cell styles icon
4.recognizes patterns in data and autocompletes ranges: flash fill
5.displays common functions used in excel: fx button
6. MAX: is an example of an aggregate statistical function
7. automatically changes cell appearance based on values in the cell: conditional formatting
8. is enacted using dollar signs: absolute cell addressing
9. adjusts formulas when you copy to other cells: relative cell addressing
10. decision logic built in to excel spreadsheets: the IF function
Question Matche's 1 C 2 B 3 G 4 I 5 H 6 D 7 J 8 A 9 E 10 FRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.