Exam 3: Excel: Creating a Worksheet and an Embedded Chart

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

While creating an Excel worksheet, several decisions will determine the appearance and characteristics of the finished worksheet.List and explain the general guidelines you should follow as you create a worksheet.

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

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

In Excel, a number can contain the characters ____.

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

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

When selecting worksheet titles and subtitles, follow the more is less guideline.

To clear the entire worksheet, click the Clear All button on the worksheet.

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

The opposite of merging cells is splitting a merged cell.

Which of the following keys moves the insertion point to the end of data in a cell?

The characters that Excel displays on the screen are a specific _____.

Which of the following keys can be pressed to highlight one or more adjacent characters?

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

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

Worksheet titles and subtitles should be as wordy as possible.