Computer Applications – Excel Midterm Exam | Questions & Answers (Rated A+)

Computer Applications – Excel Midterm Exam | Questions & Answers (Rated A+) Computer Applications – Excel Midterm Exam | Questions & Answers (Rated A+) ____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. - ANSWER - Goal _____ refers to cells not wide enough to display the entire entry. - ANSWER - ##### _____ text often provides a strong visual appeal. - ANSWER - Rotated _____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges. - ANSWER - Double-click A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. - ANSWER - sparkline A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. - ANSWER - nested Cell references in a formula are called ____. - ANSWER - assumptions Charts can either be embedded in a worksheet or placed in a separate ____. - ANSWER - chart sheet Error messages begin with the _____ symbol. - ANSWER - # 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. - ANSWER - #REF! If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell. - ANSWER - Orientation In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key. - ANSWER - ENTER The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. - ANSWER - Fill Formatting Only The ____ function is useful when you want to assign a value to a cell based on a logical test. - ANSWER - IF The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory. - ANSWER - Clipboard The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it. - ANSWER - two The path to the Format Painter button is ____. - ANSWER - (HOME tab | Clipboard group) To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____. - ANSWER - Dialog Box Launcher Using the mouse to move or copy cells is called ____. - ANSWER - drag and drop When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. - ANSWER - NOW When working with a large worksheet, you can split the window into ____ panes. - ANSWER - two or four When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values. - ANSWER - constant Which comparison operator means "not equal to"? - ANSWER -