Excel

This is the default column width setting in a blank Worksheet template.

8.43

What is a function?

A predefined computational formula

The cell reference, $A$10 is a(n) (know absolute and relative references)

Absolute reference

This type of format aligns numbers at the decimal place and places the dollar sign in a column at the left edge of the cell space.

Accounting

In Excel, this is created by the intersection of a row and a column.

Cell

This is a visual representation of data that is used to convey information in an easy-to-understand and attractive manner.

Chart

The default column sub-type in the Chart Sub-type section of the Chart Type list box is a

Clustered column

This is the default chart type in the Chart Type list box.

Column

In Excel, this controls how much information can be displayed in a cell.

Column size

To select nonadjacent cells or cell ranges, hold down this key after selecting the first cell or range while selecting each additional range.

Ctrl

Each sheet in a workbook should be assigned one of these to help identify the contents of the sheet.

Descriptive name

Separating a slice of a pie chart slightly from the other slices is referred to as

Exploding

A cell reference can be changed to absolute or mixed by using this key.

F4

In a worksheet, the black box in the lower-right corner of a selection can be used to copy cells. It is called the

Fill handle

In Excel, these entries perform calculations using number or data contained in other cells.

Formula

This bar displays entries as they are made and edited in the Excel workbook window.

Formula

As you type in a worksheet window, the entry is displayed in both the active cell and the

Formula Bar

To add a blank new sheet to the left of the active sheet, you can right click on an existing worksheet and select

Insert/worksheet

When this is displayed in the status bar of the workbook window, you can move around the workbook, enter data, use the function keys, or choose a command.

Ready

The cell reference, B4 is a(n) (know absolute and relative references)

Relative reference

A spreadsheet is made up of

Rows and Columns

In Excel, the cell selector does not move when you use this to move through the worksheet.

Scrollbar

When duplicating cell contents in a worksheet, this range is highlighted and identified by a dark border surrounding the selected cells.

Source

What are the arithmetic operators used to specify the type of numeric operation to perform in a formula?

Symbols are: * / + - ^

In Excel, this is a file that stores the information that is entered using the program.

Workbook