Spreadsheets - Lesson 1

You can automatically adjust a column width to "fit" the content by:

• clicking the column heading

• clicking the row heading

• double-clicking between the two column headings

• double-clicking between the two cells

Combining multiple cells in your spreadsheet is called:

• formatting

• aligning

• merging

• mixing

What special formatting can you use to set your information apart from the other cells on your spreadsheet?

• Currency formatting

• Date & time formatting

• Sorting & filtering

• Borders & color shading

Instead of resizing your column to accommodate your content, what can you use to fit your content to the size of the cell?

• Paint formatting

• Text wrapping

• Filtering

• Sorting

What can the Autofill handle do?

• Copy cell content and/or populate cells with series (pre-defined or sequential) of content

• Copy cell content

• Populate cells with series (pre-defined or sequential) of content

• Overwrite copied content

What commands will change the amount of numbers shown to the right of the decimal point?

• Increase/Decrease Decimal

• Increase/Decrease Indent

• Align Left and Right

• Format Percent

What formatting tool adds a dollar symbol, a comma separator and two default decimal places to a number?

• Percent

• Currency

• Comma

• Increase Decimal

What keyboard shortcut will select all the cells in a spreadsheet?

• Shift + A

• Ctrl + A

• Alt + A

• Tab + A

Using your mouse, you can click a single cell to select it or click and drag your pointer across a range of cells to select multiple cells. You can select random cells anywhere on the spreadsheet by holding down the ________ key and clicking each cell.

• Shift

• Ctrl

• Alt

• Enter

When entering text into a cell, your spreadsheet program automatically aligns your text to:

• the left side of the cell

• the top of the cell

• the right side of the cell

• the bottom of the cell