Excel Ch.1 Creating and Editing Workbooks

The thin black plus sign pointer is used to: a. copy cell contents or complete a series b. select c. resize d. highlight duplicate cells e. move a group of cells

a. copy cell contents or complete a series

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

a. on the clipboard

By default, Excel 2016 files are saved with this extension. a. .xls b. .xlsx c. .cvs d. xbk e. .ods

b. .xlsx

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

b. ctrl+ plus sign

When you want column and row headings displayed whether you are at the top, bottom, left, or right or the spreadsheet, select: a. a filter b. freeze pains c. split window d. zoom to select e. splitter bar

b. freeze pains

A new Excel workbook uses the default theme named: a. Excel default b. office c. business d. home e. school

b. office

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

b. the name box

Text in a worksheet that displays a name, a main title, row or column titles, and similar descriptive information is called: a. a caption b. a tag c. a label d. a title e. an annotation

c. a label

The default view in excel is: a. page layout b. full screen c. normal d. default e. worksheet view

c. normal

To quickly select all the cells in a worksheet: a. double-click b. right-click c. press ctrl+a d. press enter e. click on the first column heading

c. press ctrl+a

In an excel worksheet dates and times are: a. labels b. decimals c. values d. formats e. series

c. values

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

d. a workbook

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

d. backspace

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

d. merge and center

A rectangular group of cells in excel is called a(n): a. column b. display c. selection d. object e. range

e. range