Excel Final Exam-Multiple Choice Already Solved

Give an example of a range. - Answer A2:A10 What is a relative reference? - Answer an adjusted cell reference in a copied and pasted formula What happens when text is linger than the width of a column(if there is nothing in the adjacent cell)? - Answer Excel displays the overflow characters in adjacent cells to the right Do you need to type in the dollar signs, commas, and any trailing zeros when entering dollar values in cells? - Answer No Where does a cell reference appear? - Answer In the name box What does the SUM function do? - Answer Adds all of the numbers in a range of cells How should you clear a cell? - Answer Delete, backspace, clear contents What does AutoCorrect do? - Answer Automatically changes misspelled or mistyped words Why would you enter document properties? - Answer To organize and identify workbook files What does the Average function do? - Answer Sums the number in the specified range and then divides the sum by the number of cells with numeric values in the range What is the most common error when entering a formula? - Answer To reference the wrong cell in the formula What does the division sign look like? - Answer / What is a circular reference? - Answer A formula in a cell that contains a reference back to itself Where is the fill handle? - Answer Small black square in the lower-right corner of the active cell or active range What does the MAX function do? - Answer Displays the highest value in a range How do you display the worksheet with formulas showing? - Answer CTRL+Accent Mark What does the Currency style do? - Answer Puts the dollar sign immediately to the left of the first digit of a value What does conditional formatting do? - Answer Easily spot trends and patterns in your data using bars, colors, and icons to visually highlight important values Give an example of an absolute - Answer $B$4 Why would you use a Sparkline chart? - Answer Provides a simple way to show trends and variations in a range of data within a single cell What do these signs mean:<,>,<=,>=? - Answer <~less than;>~greater than,<=~less than or equal to,>=~greater than or equal to What happens when you change numbers that a chart is dependent on? - Answer Excel immediately redraws the chart based on the new value What does the Fill Formatting Only option on the Auto Fill Options menu do? - Answer Fills the destination area using the format of the source area;no content is copied unless the fill is a series When do you use the IF function? - Answer When you want to assign a value to a cell based on a logical test What does the Now function do? - Answer Displays the system date and time beginning with December 31,1899 What does the what-if analysis do? - Answer Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell What does ###### in a cell mean? - Answer That you need to increase the width of the column What kind of cell references are named cells? - Answer Absolute When a formula fails to pass a rule and background formula checking is enabled, what appears in the upper-left corner of the cell - Answer Green triangle What happens when you click on a cell that has a name assigned to it when creating a formula? - Answer Excel will insert the name of the cell rather than the cell reference What does cell protection do? - Answer Ensures that users do not change values inadvertently that are critical to the worksheet What does the PMT function do? - Answer Used to determine the monthly payment for a loan