Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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 F