Basics of Excel

An Excel file is called a workbook?

• True

• False

What keystrokes would you press to bring up the “Excel Help” window?

• F4

• F3

• F1

• F9

If you press the “Tab” key it moves one cell to the left.

• True

• False

You can format text in a cell in Excel.

• True

• False

Excel automatically adjusts row height to accommodate the size of data in a row.

• True

• False

To add color to a row or column you click the ___.

• Click the font color button.

• Fill color button (paint pail)

• Set a colored border

You can create mixed references by placing a dollar sign in front of only the column letter or only the row number

• True

• False

You can insert a row by right clicking a column heading

• True

• False

You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press __________.

• CTRL+X and CTRL+V

• CTRL+C and CTRL+V

• CTRL+A and CTRL+V

• CTRL+V and CTRL+X

Which function can you use to capture the contents of an open window?

• Icon Set

• Clip Art

• SmartArt

• Screenshot