MICROSOFT EXCEL

You can use the horizontal and vertical scroll bars to:

• (A) Split a worksheet into two panes
• (B) View different rows and columns
• (C) Edit the contents of a cell
• (D) View different worksheets

What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer:

• (A) Spreadsheet program
• (B) Database program
• (C) Word processor program
• (D) Desktop publisher program

You can add an image to a template by clicking the Insert Picture From File button on the __________ Toolbar.

• (A) Standard
• (B) Formatting
• (C) Drawing
• (D) Picture

To drag a selected range of data to another worksheet in the same workbook, use the:

• (A) Tab key
• (B) Alt key
• (C) Shift key
• (D) Ctrl key

When creating a vertical page break:

• (A) The active cell must be A1
• (B) The active cell can be anywhere in the worksheet
• (C) The active cell must be in row 1v
• (D) The active cell must be in column A

To activate the previous cell in a pre-selected range, press:

• (A) The Alt key
• (B) The Tab key
• (C) The Enter key
• (D) None of the above

When the formula bar is activated, you can see:

• (A) The Edit Formula button
• (B) The Cancel button
• (C) The Enter button
• (D) All of above

In a worksheet you can select:

• (A) The entire worksheet
• (B) Rows
• (C) Columns
• (D) A, B, and C

When you print preview a worksheet:

• (A) the entire worksheet is displayed
• (B) the selected range is displayed
• (C) the active portion of the worksheet is displayed
• (D) A, B and C

You can group non-contiguous worksheets with:

• (A) The group button on the standard toolbar
• (B) The shift key and the mouse
• (C) The ctrl key and mouse
• (D) The alt+enter key