|
1 | | In Microsoft Excel, the file you create and edit is called: |
| | A) | A form. |
| | B) | A ledger. |
| | C) | A table. |
| | D) | A workbook. |
| | E) | A record. |
|
|
|
2 | | By default, Excel 2013 files are saved with this extension. |
| | A) | .xls |
| | B) | .xlsx |
| | C) | .csv |
| | D) | .xbk |
| | E) | .ods |
|
|
|
3 | | Text in a worksheet that identifies a title and subtitle, row and column headings, and other descriptive information is called: |
| | A) | A caption. |
| | B) | A tag. |
| | C) | A label. |
| | D) | A title. |
| | E) | An annotation. |
|
|
|
4 | | When you click on a cell to activate it, the cell address appears in: |
| | A) | The formula window. |
| | B) | The name box. |
| | C) | The task bar. |
| | D) | The dropdown menu. |
| | E) | The comment bubble. |
|
|
|
5 | | When you want to delete characters in a cell to the left of the insertion point press: |
| | A) | Delete. |
| | B) | Enter. |
| | C) | Edit. |
| | D) | Backspace. |
| | E) | End. |
|
|
|
6 | | To increase the distance between the cell contents and the left boundary of the cell, use this button. |
| | A) | Decrease indent |
| | B) | Increase indent |
| | C) | Merge & Center |
| | D) | Format border |
| | E) | Paragraph |
|
|
|
7 | | A group of cells in Excel is called a(n): |
| | A) | Column. |
| | B) | Display. |
| | C) | Selection. |
| | D) | Object. |
| | E) | Range. |
|
|
|
8 | | The thin black cross-shaped pointer is used to: |
| | A) | Complete lists and fill patterns. |
| | B) | Select. |
| | C) | Resize. |
| | D) | Highlight duplicate cells. |
| | E) | Move a group of cells. |
|
|
|
9 | | To quickly select the contents of an entire worksheet: |
| | A) | Double-click. |
| | B) | Right-click. |
| | C) | Press Ctrl+A. |
| | D) | Press Enter. |
| | E) | Click on the first column heading. |
|
|
|
10 | | After you select and cut cells, the cells are temporarily placed: |
| | A) | On the Clipboard. |
| | B) | In the address window. |
| | C) | In the context menu. |
| | D) | In the Formula bar. |
| | E) | On the Home tab window. |
|
|
|
11 | | When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series. |
| | A) | AutoSum |
| | B) | Custom Fill |
| | C) | Fill Handle |
| | D) | Ctrl+C |
| | E) | Series Style |
|
|
|
12 | | When you want column and row headings display whether you are at the top, bottom, left, or right of the spreadsheet, select: |
| | A) | A filter. |
| | B) | The Freeze Pane. |
| | C) | The Split Window. |
| | D) | Zoom to selection. |
| | E) | The Splitter bar. |
|
|
|
13 | | Use this button to combine two or more cells into one cell and center the text over a group of columns. |
| | A) | Combine Elements |
| | B) | Format Title Cells |
| | C) | Group and Merge |
| | D) | Merge and Center |
| | E) | Increase Indent |
|
|
|
14 | | A quick way to insert a new column or row in an existing worksheet is to select a column or row and press: |
| | A) | F4. |
| | B) | Ctrl+plus sign (+). |
| | C) | Ctrl+^. |
| | D) | Insert. |
| | E) | Alt+Tab. |
|
|
|
15 | | The default view in Excel is: |
| | A) | Page Layout. |
| | B) | Full Screen. |
| | C) | Normal. |
| | D) | Default. |
| | E) | Worksheet view. |
|
|