| AB | |
| Worksheet | |
| The _____ box display screens the active cell reference. EX6 | Name |
| When you start typing a cabinet entry, Excel displays two extr boxes in the formula bar: _____. EX 7 | the cancel box and also the go into box |
| The _____ function of Excel works behind the scenes, correcting usual mistakes once you finish a message entry in a cell. EX 9 | AutoCorrect |
| When you enter numeric data in a cell, Excel recognizes the values as numbers and also _____ the values. EX 13 | Right-aligns |
| A _____ is a series of two or an ext adjacent cells in a column or heat or a rectangular team of cells. EX 14 | Range |
| A coming before _____ advises Excel the you are entering a formula or duty and not text. EX 20 | Equal Sign |
| Font size is gauged through a measure system dubbed _____. EX 23 | Points |
| In _____ mode, as you form a character, Excel inserts the character and moves all characters to the right of the typed personality one position to the right. EX50 | Insert |
| The _____ command ~ above the Clear menu is the just command that clears both the cabinet entry and the cell formatting. EX52 | Clear All |
| A formula in a cabinet that contains a reference back to itself is called a(n) _____ reference. EX73 | Circular |
| If the following arithmetic operations all are uncovered in a formula through no parentheses, which one is perfect last? EX75 | + |
| When girlfriend copy a formula v a relative cell referral down a row, _____. EX 78 | the heat references readjust in the formula |
| The _____ function is used to determine the shortest number in a provided range. EX 84 | MIN |
| To assign a dollar sign to appear immediately to the left the the very first digit through no spaces, use a _____ dollar sign. EX 99 | Floating |
| Which that the complying with is a precious conditional formatting operator discovered in the new Formatting preeminence dialog box? EX 103 | Greater than |
| A period on the display screen that contains a color is referred to as a _____. EX 103 | Pixel |
| Excel consists of a(n) _____ you can use to check a worksheet for spelling errors. EX 107 | Spell Checker |
| A(n) _____ is text and also graphics that print at the bottom of every page. EX 110 | Footer |
| The _____ version of a worksheet shows the results of formulas. EX 115 | Values |
| _____ room values in cells the you can change to determine new values because that formulas. EX 130 | Assumptions |
| The _____ is a short-lived storage area in the computer’s memory that permits you to collection text and also graphics from an Office paper and then dough them into practically any other type of document. EX 141 | Office Clipboard |
| Valid layout symbols include all of the following except _____. EX 147 | + |
| A _____ shows the date a workbook, report, or other paper was developed or the time duration it represents. EX 148 | Date Stamp |
| A formula utilizing the _____ cell reference B4 instructs Excel to adjust the cell recommendation as it duplicates it come the location area. EX 151 | Relative |
| Excel display screens the error article _____ in cell that space not large enough to display entire entry. EX 157 | ##### |
| An Excel _____ chart gives a simple way to display trends and also variations in a variety of data in ~ a single cell. EX 160 | Sparkline |
| The _____ feature evaluates the selected data and makes suggestions regarding which chart types will carry out the most perfect representation. EX 171 | Recommended Charts |
| When you _____ a worksheet, Excel enlarges the check out of the characters on the screen, however displays fewer columns and rows. You are watching: Allows data to be summarized and charted easily See more: Solved What Is The Current Through The Battery Is, How Does Current Flow In A Battery EX 182 | Freeze |
| When working v a huge worksheet, you can separation the home window into two or 4 _____ to view different parts the the worksheet in ~ the same time. EX 184 | Panes |
 |