Computer Applications - Excel Chapter 1 Exam | Questions & Answers (Graded A+)

Computer Applications - Excel Chapter 1 Exam | Questions & Answers (Graded A+) Computer Applications - Excel Chapter 1 Exam | Questions & Answers (Graded A+) The Increase Indent button indents the content of a cell to the right by _____ spaces each time you click it - ANSWER - two A _____ reference is an adjusted cell reference in a copied and pasted formula - ANSWER - relative The adjusted cell reference in a copied and pasted formula are called _____ cell references - ANSWER - relative The path to the Format Painter button is _____ - ANSWER - (Home tab | Clipboard group) A(n) _____ IF function is one I which the action to be taken for the true or false case includes yet another IF function - ANSWER - nested One of the reasons EXCEL is such a valuable tool is that you can assign a(n) _____ to a cell, and Excel will calculate the result - ANSWER - formula Combining two or more selected cells into one cell is called _____ cells - ANSWER - merging 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 _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign - ANSWER - formula The _____ preceding a formula alerts Excel that you are entering a formula or function and not text - ANSWER - equal sign(=) Error messages begin with the _____ symbol - ANSWER - # 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 A character with a point size of 10 is about 10/72 of one inch in height - ANSWER - true In the accompanying figure, the split double arrow mouse pointer _____ - ANSWER - is the result of moving the mouse pointer to the boundary between column heading A and column heading B