EXCEL-Chapter 2 Exam | Formulas, Functions, and Formatting Questions & Answers (100% Correct)

EXCEL-Chapter 2 Exam | Formulas, Functions, and Formatting Questions & Answers (100% Correct) EXCEL-Chapter 2 Exam | Formulas, Functions, and Formatting Questions & Answers (100% Correct) A _____ is a prewritten formula that is built into excel. - ANSWER - function An _____ alerts excel that you are entering a formula or function and not text. - ANSWER - equal sign Values used with a function are called _____ . - ANSWER - arguments The order in which calculations are performed in a formula is called the _____ . - ANSWER - order of operations. _____ allows you to select cells for use in a formula by using the mouse. - ANSWER - Point mode The _____ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range. - ANSWER - average Use the _____ function to display the highest value in a range. - ANSWER - max Use the _____ function to determine the lowest number in a range. - ANSWER - min An easy way to verify that a formula references the cells that you want it to reference is to use excel's _____ . - ANSWER - Range Finder To verify that a formula contains the intended cell references, use Excel's _____ . - ANSWER - Range Finder Formatting that appears only when the value in a cell meets specific conditions is called _____ . - ANSWER - conditional formatting A _____ is made up of two values and a relational operator. - ANSWER - condition _____ means that the width of a column will be increased or decreased so the widest entry will fit in the column. - ANSWER - Best fit To display your worksheet in formula view, press _____ . - ANSWER - Ctrl+Accent Mark The _____ version of a worksheet show the actual formulas. - ANSWER - formulas When you decrease a column width to _____ , the column is hidden. - ANSWER - 0 A blank cell in Excel has a numerical value of _____ . - ANSWER - zero The process of finding and correcting errors in a worksheet is called _____ . - ANSWER - debugging Excel displays which of the following for an invalid reference? - ANSWER - #REF! Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box? - ANSWER - Greater than To override the order of operations, use _____ . - ANSWER - parentheses In the formula: =A4/B4+C5-D5*E6 the _____ operation is performed first. - ANSWER - multiplication The Percent style button is used to display a value determined by multiplying the cell by _____, rounding the result to the nearest percent, and adding a percent sign. - ANSWER - 100 The arithmetic operator for multiplication is _____ . - ANSWER - * The _____ dollar sign displays to the far left in a cell. - ANSWER - fixed