Excel- Module 3 Exam | Complete Questions & Answers (Graded A+)

Excel- Module 3 Exam | Complete Questions & Answers (Graded A+) Excel- Module 3 Exam | Complete Questions & Answers (Graded A+) Cell references in a formula are called - ANSWER - assumptions When you set up a worksheet, you should use cell references in formulas whenever possible, rather than __ Values - ANSWER - conastant The __ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. - ANSWER - Fill Formatting only Which of the following Auto Fill Options menu options is the same as the Fill Series Option - ANSWER - Fill Months Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr 1 by dragging the fill handle - ANSWER - Qtr2 Which of the following is an extension of the fill pattern Sunday, Tuesday? - ANSWER - Thursday, Saturday, Monday The Increase Indent button indents the contents of a cell to the right by __ spaces each time you click it - ANSWER - two 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 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 Using the mouse to move or copy cells is called __ - ANSWER - drag and drop 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! Which of the following is not a valid format symbol? - ANSWER - semi-colon (;) 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 Which of the following formulas contains an absolute cell reference - ANSWER - =$B$4 The __ function is useful when you want to assign a value to a cell based on a logical test - ANSWER - IF Which comparison operator means "not equal to" - ANSWER - A __ chart provides a simple way to show trends and variations in a range of data within a single cell - ANSWER - Sparkline You can press the __ keys to open the Format Cells dialog box - ANSWER - CTRL+1 The path to the Format Painter button is __ - ANSWER - (HOME TAB / Clipboard group) You should use a __ chart to compare values side by side, broken down by category - ANSWER - Clustered Column Charts can either be embedded in a worksheet or placed in a separate - ANSWER - chart sheet Which of the following is the path to the Zoom button - ANSWER - (VIEW tab/ Zoom group) When working with a large worksheet, you can split the window into __ panes - ANSWER - two or four