Excel Sect 3.3

A _____ is a series of two or more adjacent cells in a column or row or group of cells.

• range
• split
• key
• merge 

The _____ function ads all of the numbers in a range of cells.

• autosum
• minimum
• maximum
• none of the above 

When entering numbers in a worksheet, you must put $ if the number is to be used as currency.

• True
• False

To alert Excel that you are entering a formula and not text, type a(n) _______.

• equal sign
• number sign
• asterisk
• apostrophe

The _________ function is used to determine the lowest number in a given range. 

• LOW
• NUM
• SMALL
• MIN

A(n) _________ is a prewritten formula that is built into EXCEL. 

• function
• problem
• equation
• equal sign

To allow you to evenly distribute a title over a table of numbers, use the

• Center button
• Merge and Center button
• Merge cells only button

By default, all cells are Relative Cell References within a formula and will update when  copied or use of Autofill.

• True
• False

The ____ function to display the highest value in a range.

• max
• min
• average
• range

How do you change column width to fit the contents?

• Single-click the boundary to the left of the column heading
• Double-click the boundary to the right of the column heading
• Press ALT and single-click anywhere in the column