30 terms

Excel Chapter 1

STUDY
PLAY

Terms in this set (...)

A spreadsheet that contains formulas, functions, values, text, and visual aids.
Worksheet
A file containing related worksheets.
Workbook
A range of cells containing values for variables used in formulas.
Input Area
A range of cells containing results based on manipulating the variables.
Output Area
Identifies the address of the current cell.
Name Box
Displays the content (text, value, date, or formula) in the active cell.
Formula Bar
Displays the name of a worksheet within a workbook.
Sheet Tab
The intersection of a column and row.
Cell
Includes letters, numbers, symbols, and spaces.
Text
A number that represents a quantity or an amount.
Value
Rules that control the sequence in which Excel performs arithmetic operations.
Order of Precedence
Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.
Autofill
A small green square at the bottom-right corner of a cell.
Fill Handle
The horizontal measurement of a column.
Column Width
The vertical measurement of a row.
Row Height
A rectangular group of cells.
Range
The position of data between the cell margins.
Alignment
Formatting that enables a label to appear on multiple lines within the current cell.
Wrap Text
The background color appearing behind data in a cell.
Fill Color
A combination of cell references, operators, values, and/or functions used to perform a calculation.
Formula
What is the first step in planning an effective worksheet?

Identify the input and output areas.

State the purpose of the worksheet.

Decide how to format the worksheet data.

Enter labels, values, and formulas.
State the purpose of the worksheet.
What Excel interface item displays the address of the current cell?

Status bar

Formula Bar

Quick Access Toolbar

Name Box
Name Box
Given the formula =B1*B2+B3/B4^2 where B1 contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result?

121

14

76

9216
14
Why would you press Ctrl+` in Excel?

To display the print options

To enable the AutoComplete feature

To undo a mistake you made

To display cell formulas
To display cell formulas
Which of the following is a nonadjacent range?

A1:A10, D1:D10

L15:L65

A1:Z99

C15:D30
A1:A10, D1:D10
If you want to balance a title over several columns, what do you do?

Click Center to center the title horizontally over several columns.

Enter the data in the cell that is about midway across the spreadsheet.

Use the Increase Indent command until the title looks balanced.

Merge and center the data over all columns.
Merge and center the data over all columns.
Which of the following characteristics is not applicable to the Accounting Number Format?

Zero values displayed as hyphens

Dollar sign immediately on the left side of the value

Commas to separate thousands

Two decimal places
Dollar sign immediately on the left side of the value
You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?

Display the Paste Special dialog box and select Formulas and number formats.

Click the Paste arrow in the Clipboard group and select Formulas.

Click the Paste arrow in the Clipboard group and select Values & Source Formatting.

Click Paste in the Clipboard group on the Home tab.
Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?

Increase the left and right margins.

Decrease column widths if possible.

Decrease the Scale value.

Select a smaller range as the print area.
Increase the left and right margins.
What should you do if you see a column of pound signs (###) instead of values or results of formulas?

Delete the column.

Adjust the row height.

Increase the zoom percentage.

Increase the column width.
Increase the column width.