Excel Chapter 3

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

Pharm Ch 38 Controlling Blood Glucose

View Set

Macroeconomics Chapter 12: Short-Run Fluctuations

View Set

Hospitality Management Test Review #1

View Set