Excel Skills Exam | Questions & Answers (Rated 100%)

Excel Skills Exam | Questions & Answers (Rated 100%) Excel Skills Exam | Questions & Answers (Rated 100%) A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. - ANSWER - theme A ____ is a prewritten formula that is built into Excel. - ANSWER - function A ____ is text and graphics that print at the bottom of every page. - ANSWER - footer A ____ is text and graphics that print at the top of each page. - ANSWER - header A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. - ANSWER - indirect All of the following are valid Excel arithmetic operators EXCEPT ____. - ANSWER - Clicking the ____ opens the Insert Function dialog box. - ANSWER - Insert Function box in the formula bar Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. - ANSWER - right parenthesis If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters. - ANSWER - 8.43 Point mode allows you to ____, as shown in the accompanying figure. - ANSWER - select cells for use in a formula using the mouse pointer The adjusted cell references in a copied and pasted formula are called ____ cell references. - ANSWER - relative The default view in Excel is called ____ view. - ANSWER - Normal The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign. - ANSWER - Formula The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. - ANSWER - Accounting number format The ____ button lists error-checking options following the assignment of an invalid formula to a cell. - ANSWER - Trace Error