Exam 9: Excel: Creating a Worksheet and a Chart

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

____ is/are used to place worksheet, column, and row titles on a worksheet.

Excel remembers the last ____ actions you have completed.

____________________ corrects two initial capital letters by changing the second letter to lowercase.

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

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

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

In Excel, a number can contain the characters ____.

Which of the following is the Ribbon path to the Cell Styles button?

Live preview is available on a touch screen.

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Discuss document properties.Include definitions of these terms: standard properties and automatically updated properties .Be sure to give at least two reasons why document properties are valuable.

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.

The ____ is a blinking vertical line that indicates where the next typed character will appear.

The default font for a new workbook is ____________________ 11-point regular black.

Modified Multiple Choice If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

The range of cells receiving the content of copied cells is called the ____.

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.