Exam 1: Creating a Worksheet and a Chart

While typing in a cell,you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

An Excel ____ allows data to be summarized and charted easily.

The date you change a file is an example of a(n)____ property.

Clicking the ____ box completes an entry.

____________________ involves reducing the electricity consumed and environmental waste generated when using computers,mobile devices,and related technologies.

Which of the following keys toggles between Insert mode and Overtype mode?

Pressing the ____ keyboard shortcut key(s)selects cell A1.

Excel recognizes the following as text: 401AX21,921-231,619 321,883XTY.

Live preview is available on a touch screen.

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Worksheet titles and subtitles should be as wordy as possible.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

The group of adjacent cells beginning with B4 and ending with B8,written as B4:B8,is called a(n)range._________________________

In a worksheet,columns typically contain information that is similar to a list._________________________

Like an area chart,a(n)____________________ chart often is used to illustrate changes in data over time.

The automatically adjusted cell reference in a pasted formula is called a(n)____________________.

____________________ cells involves creating a single cell by combining two or more selected cells.

A ____ reference is an adjusted cell reference in a copied and pasted formula.

To erase an entire entry in a cell and then reenter the data from the beginning,press the ____ key.