CIS 102 (Excel Q 1-3)

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

equal sign (=)

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

exploded

The range automatically selected by Excel is always correct.

false

A ____ is text and graphics that print at the top of each page.

header

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

nested

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

paste

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

When working with a large worksheet, you can split the window into ____ panes.

two or four

Press ____ to select the entire worksheet.

CTRL+A

To copy cell contents, you can select the cell and then press the ____ keys.

CTRL+C

To paste copied cell contents, you can press the ____ keys.

CTRL+V

Clicking the ____ box completes an entry.

Enter

In designing a worksheet, visual aesthetics should come first.

False

The Accounting number format assigns a floating dollar sign.

False

The arithmetic operator, ^, directs Excel to perform the division operation. True

False

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).

False

To use Range Finder to verify that a formula contains the intended cell references, click or tap the cell with the formula you want to check.

False

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

Clicking the ____ opens the Insert Function dialog box.

Insert Function box in the formula bar

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Print Selection

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Trace Error

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

True

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

True

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

True

Cooler colors tend to pull away from the reader.

True

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

True

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

True

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

True

Moving from left to right, the first calculation in the order of operations is negation (-).

True

Panes created using the vertical split bar scroll together horizontally.

True

The AVERAGE function requires that the argument be included within parentheses following the function name.

True

The Insert Options button lists formatting options.

True

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

True

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

True

Combining two or more selected cells into one cell is called ____ cells.

merging

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

0

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

26

Which of the following patterns extends the fill series to 575, 550, 525?

625, 600

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

8.43

Which comparison operator means "not equal to"?

<>

Which of the following formulas contains an absolute cell reference?

=$B$4

Error messages begin with the ____ symbol.

#

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

#REF!

1. Selects the cell at the beginning of the row that contains the active cell. 2. Displays the Find dialog box. 3. Selects the cell one worksheet window to the right. 4. Selects the adjacent cell in the direction of the arrow on the key. 5. Highlights one or more adjacent characters to the right. 6. Should not be used to clear a cell. 7. Deletes characters to the left of the insertion point. 8. Selects cell A1. 9. Toggles between Insert and Overtype mode. 10. Moves the insertion point to the end of data in a cell.

1. The correct answer is:HOME 2. The correct answer is:CTRL+F 3. The correct answer is:ALT+PAGE DOWN 4. The correct answer is:ARROW 5. The correct answer is:SHIFT+RIGHT ARROW 6. The correct answer is:SPACEBAR 7. The correct answer is:BACKSPACE 8. The correct answer is:CTRL+HOME 9. The correct answer is:INSERT 10. The correct answer is:END

1. A function that displays the highest value in a range. 2. Copies a formula. 3. A prewritten formula built into Excel. 4. Wraps text in a cell. 5. Spell-checking a worksheet. 6. A formula in a cell that contains a reference back to itself. 7. Pastes a formula. 8. Opens the Format Cells dialog box. 9. Negation comes first in this. 10. Displays the worksheet with formulas.

1. The correct answer is:MAX 2. The correct answer is:CTRL+C 3. The correct answer is:function 4. The correct answer is:ALT+ENTER 5.The correct answer is:F7 6.The correct answer is:circular reference 7.The correct answer is:CTRL+V 8.The correct answer is:CTRL+1 9.The correct answer is:order of operations 10.The correct answer is:CTRL+ACCENT MARK (`)

1. Fills a destination area using the format of the source area; no content is copied. 2. Pastes the contents, format, and styles of the source area. 3. The default option to fill an area. 4. Returns a number that corresponds to the system date and time beginning with December 31, 1899. 5. Keeps a cell reference constant when copying a formula or function. 6. Assigns a value to a cell based on a logical test. 7. Indicates a cell is using a name Excel does not recognize. 8. Indicates a cell that uses a number incorrectly. 9. Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell. 10. Determines the value of a cell on which the formula depends.

1.The correct answer is:Fill Formatting Only 2.The correct answer is:Keep Source Formatting 3.The correct answer is:Fill Series 4.The correct answer is:NOW function 5.The correct answer is:absolute cell referencing 6.The correct answer is:IF function 7.The correct answer is:#NAME? 8.The correct answer is:NUM! 9.The correct answer is:what-if analysis 10.The correct answer is:goal seeking

Excel remembers the last ____ actions you have completed.

100

All of the following are valid Excel arithmetic operators EXCEPT ____.

>

To start a new line in a cell, press the ____ keys.

ALT+ENTER

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

AVERAGE

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accounting number format

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

AutoCalculate

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

AutoCorrect

You should use a ____ chart to compare values side by side, broken down by category.

Clustered Column

What effect does the Accounting Number Format have on the selected cells?

Displays cell contents with two decimal places that align vertically

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

False

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

False

A thin red border indicates the active cell.

False

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

False

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

False

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

False

Clicking the Create Function box opens the Function Arguments dialog box.

False

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

False

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

False

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

False

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

False

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

The ____ function displays the highest value in a range.

MAX

The ____ function determines the lowest number in a range.

MIN

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

The default view in Excel is called ____ view.

Normal

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Qtr2

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

True

The default font for the Basis theme is different than the default font for the Office theme.

True

The equal sign (=) precedes a formula.

True

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range.

True

The most common error when entering a formula is to reference the wrong cell in the formula. Selected: True

True

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

True

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

True

The ____ button allows you to erase recent cell entries.

Undo

Using the Excel spell checker, you can ____.

a. check the spelling of words in a selected rangeThis answer is correct. b. add words to the dictionary

In Excel, a number can contain the characters ____.

all of the above

Cell references in a formula are called ____.

assumptions

The date you change a file is an example of a(n) ____ property.

automatically updated

To enter data in a cell, you must first select the ____.

cell

Charts can either be embedded in a worksheet or placed in a separate ____.

chart sheet

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

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

destination area

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

fill handle

A ____ is text and graphics that print at the bottom of every page.

footer

A ____ is a prewritten formula that is built into Excel.

function

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

indirect

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

insertion point

A ____ reference is an adjusted cell reference in a copied and pasted formula.

relative

The adjusted cell references in a copied and pasted formula are called ____ cell references.

relative

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. a. section

sparkline

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

theme

The first step in creating an effective worksheet is to make sure you ____.

understand what is required

A sensitivity analysis is another name for a(n) _ analysis.

what-if

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

worksheet

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

x

Which of the following actions are provided by the Paste Options button?

x