Excel C

Formatting

100

Centers cells contents over multiple cells

-Merge and center

200

Used to delete a conditional formatting rule

-Conditional formatting rules manager

300

this feature is used to resize a column to accommodate its widest entry

-Autofit

400

You can view the whole print out and still edit the header...

-PageLayout

500

Sets the width to a specific number of characters..

-Column Width

Cell Reference

100

Type of cell refernce that does not change when copied.

-Absolute Cell Reference

200

Type of cell reference that changes when copied

-Relative Cell Reference

300

Type of cell refernce in which either the column or row remains constant when copied while other changes.

-Mixed Cell Reference

400

What type of cell reference is $H$8?

-Absolute cell reference

Identify

100

Shows more precise values by showing more decimal places

Increase Decimal Button

200

Sets the width to a specific number of characters..

-Column Width

300

Hides or displays hidden columns..

-Hide & unhide

Formulas

100

Which part of the formula is solved first F8+F11(G2/G5)

(G2/G5)

200

What type of formula is =F4+F6/R4

-Complex Formula

300

What is one way that function can be put in?

-Insert function button

KeyBoard

100

What key do you press to copy while dragging-and-dropping selected cells?

[Ctrl]

200

What key do you press to cycle through different types of cell references?

-[F4]

300

What key can help you get to edit mode?

-[F2]

400

When [Ctrl][Home] is used where does it take you in the sheet?

-Cell A1

500

What keys can be used to cut out a cell range or a worksheet?

-[Crtl][X]