EXCEL Skills Test 3 | Complete Questions & Answers (100% Verified)

EXCEL Skills Test 3 | Complete Questions & Answers (100% Verified) EXCEL Skills Test 3 | Complete Questions & Answers (100% Verified) Cell references in a formula are called ____ - ANSWER - assumptions T or F: Rotated text allows you to fit more text into a smaller column width? - ANSWER - T The __ function is useful when you want to assign a value to a cell based on a logical test. - ANSWER - if What is the error displayed that indicates a cell that uses a number incorrectly? - ANSWER - NUM! When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values. - ANSWER - constant T or F: The increase indent button indents the contents of a cell to the right by three spaces each time you click it? - ANSWER - two _____ text often provides a strong visual appeal - ANSWER - rotative When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell - ANSWER - 0 A ___ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from once cell to another - ANSWER - absolute T or F: If you drag the fill handle to the left of up, Excel will increment the series rather than decrement the series? - ANSWER - F What is the error displayed that indicated a cell us using a name Excel doesn't recognize? - ANSWER - #NAME? The ____Auto Fill Option that fills the destination area using the format of the source area; no content is filled - ANSWER - copy cells Which of the following cell contents is extended to Qtr 3, Qtr 4, Qtr 1 by dragging the fill handle? - ANSWER - Qtr 2 A sensitivity analysis is another name for a ___ - ANSWER - what if _____ keeps a cell reference constant when copying a formula or function - ANSWER - absolute _____ determines the value of a cell on which the formula depends - ANSWER - Goal seeking The spit double arrow mouse pointer - ANSWER - is the result of moving the mouse pointer to the boundary between column A and B The increase indent button is under the ___ tab and ___group - ANSWER - home, alignment The increase indent button indents the contents of a cell to the right by __ spaces each time you click it - ANSWER - 2 T or F: The default option to fill an area is Fill Series? - ANSWER - T What function returns a number that corresponds to the system date and time beginning with December 31, 1899? - ANSWER - NOW The copy button copies the contents and format of the office ________ - ANSWER - clipboard T or F: Using the mouse to move or copy cells is called drag and drop? - ANSWER - T What kind of formatting pastes the contents, format, and styles of the source area? - ANSWER - Keep source formatting The _______ scrutinizes the impact of changing values in cells that are referenced by a formula in another cell. - ANSWER - what-if Which of the following is not a valid format symbol - ANSWER - Semi-colon What is the absolute cell reference for B4? - ANSWER - $B$4 Which comparison operator means "not equal to" - ANSWER - What symbol refers to cells not wide enough to display the entire entry? - ANSWER - ###### Error messages begin with what symbol? - ANSWER - number sign A ______ chart provides a simple way to show trends and variations in a range of data within a single cell. - ANSWER - sparkline T or F: You should use a clustered column chart to compare values side by side, broken down by category? - ANSWER - T