Excel Chapter 3
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
Which of the following is a nonadjacent range? A1:A10, D1:D10 L15:L65 A1:Z99 C15:D30
A1:A10, D1:D10
The position of data between the cell margins.
Alignment
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
The intersection of a column and row.
Cell
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.
The horizontal measurement of a column.
Column Width
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
The background color appearing behind data in a cell.
Fill Color
A small green square at the bottom-right corner of a cell.
Fill Handle
A combination of cell references, operators, values, and/or functions used to perform a calculation.
Formula
Displays the content (text, value, date, or formula) in the active cell.
Formula Bar
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.
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.
A range of cells containing values for variables used in formulas.
Input Area
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.
Identifies the address of the current cell.
Name Box
What Excel interface item displays the address of the current cell? Status bar Formula Bar Quick Access Toolbar Name Box
Name Box
Rules that control the sequence in which Excel performs arithmetic operations.
Order of Precedence
A range of cells containing results based on manipulating the variables.
Output Area
A rectangular group of cells.
Range
The vertical measurement of a row.
Row Height
Displays the name of a worksheet within a workbook.
Sheet Tab
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.
Includes letters, numbers, symbols, and spaces.
Text
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
A number that represents a quantity or an amount.
Value
A file containing related worksheets.
Workbook
A spreadsheet that contains formulas, functions, values, text, and visual aids.
Worksheet
Formatting that enables a label to appear on multiple lines within the current cell.
Wrap Text