Excel Editting Category, 10 points

How do you clear an entry in a cell?
Excel Editting Category, 20 points

What happens when you insert a row?
Excel Editting Category, 30 points

Identify three ways that you can edit (change) the contents of a cell.
Excel Editting Category, 40 points

After you've selected cell(s) and did a Ctrl + C (Edit, Copy), what happens when you hit the Escape key?
Excel Editting Category, 50 points

The black box in the lower right corner of the selected cell(s) is called the fill handle. What happens when you drag and drop the fill handle?
Excel Formatting Category, 10 points

When you enter a number into a cell, how is the number aligned?
Excel Formatting Category, 20 points

True or False?
Alignment settings include Horizontal, Vertical and Orientation. Horizontal placement includes left, center, right and indent. Vertical placement includes top, center and bottom. Orientation refers to the angle of text in the cell.
Excel Formatting Category, 30 points

Identify two ways that you can change a column width.








Excel Formatting Category, 40 points

What does the Number tab in the Format Cells dialog box do?
Excel Formatting Category, 50 points

Identify three buttons on the formatting toolbar that allow you to format a number to a predefined style.
Excel Formulas Category, 10 points

True or False?
A formula always begins with an equal sign.
Excel Formulas Category, 20 points

What are the five arithmetic operators used in a formula?
Excel Formulas Category, 30 points

Describe how you enter a formula using Point Mode.
Excel Formulas Category, 40 points

What happens when you copy the following formula from B2 to B3?

=A1+B1+C1








Excel Formulas Category, 50 points

What happens when you copy the following formula from B2 to C2?

=A1+B1+C1








Excel Features Category, 10 points

What does automatic recalculation mean?
Excel Features Category, 20 points

True or False?
Rows are identified by letters and columns are identified by numbers.
Excel Features Category, 30 points

True or False?
Excel has a zoom drop-down on the formatting toolbar.
Excel Features Category, 40 points

What does the AutoSum button on the standard toolbar do?
Excel Features Category, 50 points

What does the Paste Function button on the standard toolbar do?
Excel Miscellaneous Category, 10 points

Changing the font and font size, making the text bold, italics, or underlining the text can be done using which toolbar?
Excel Miscellaneous Category, 20 points

What is the difference between a worksheet and a workbook?
Excel Miscellaneous Category, 30 points

What do the keystrokes End + --> (right arrow) do?
Excel Miscellaneous Category, 40 points

How do you add a predefined header to a worksheet?
Excel Miscellaneous Category, 50 points

How is the Merge and Center button on the formatting toolbar used?