Microsoft Excel Review

On an Excel sheet the active cell is indicated by:

• a dark border
• a dotted border
• a blinking border
• none of the above

To select a column, the easiest method is to:

• double-click any cell in the column
• drag from the top cell to the last cell
• click the column heading
• double-click the first 

If you press _____, the cell accepts your typing as its contents but the focus stays in the cell.

• Enter
• CTRL + ENTER
• Tab
• Insert

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.

• B1-G10
• B1,G10
• B1;G10
• B1:G10

To select several cells or ranges that are not touching each other, you would _____ while selecting

• a.  Hold down the CTRL key
• a.  Hold down the SHIFT key
• a.  Hold down the ALT key
• a.  Hold down the CTRL + SHIFT key

To arrange rows in alphabetical order based on column A, you need to use the command Sort & Filter found on the _____ tab.

• Insert
• Page Layout
• Home
• Formulas 

To change the number format in a cell to accounting, simply click the ____ button on the home tab. 

• ,
• %
• $
• None of these

If you select a cell with a date in it and drag the fill handle down across several cells, what happens?

• The date is copied to each cell
• The date is increased by 1 day into each cell
• The date is increased by 1 week into each cell
• None of these

The default orientation for the printed page is

• Landscape
• Portrait

Cell A4 =10 and A5 = 20. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are

• 10,10,10
• 10,20,10
• 30, 60, 120
• 30, 40, 50