An Excel _____ enables data to it is in summarized and also charted easily.
AB
Worksheet
The _____ box display screens the active cell reference. EX6Name
When you start typing a cabinet entry, Excel displays two extr boxes in the formula bar: _____. EX 7the 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 9AutoCorrect
When you enter numeric data in a cell, Excel recognizes the values as numbers and also _____ the values. EX 13Right-aligns
A _____ is a series of two or an ext adjacent cells in a column or heat or a rectangular team of cells. EX 14Range
A coming before _____ advises Excel the you are entering a formula or duty and not text. EX 20Equal Sign
Font size is gauged through a measure system dubbed _____. EX 23Points
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. EX50Insert
The _____ command ~ above the Clear menu is the just command that clears both the cabinet entry and the cell formatting. EX52Clear All
A formula in a cabinet that contains a reference back to itself is called a(n) _____ reference. EX73Circular
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 78the heat references readjust in the formula
The _____ function is used to determine the shortest number in a provided range. EX 84MIN
To assign a dollar sign to appear immediately to the left the the very first digit through no spaces, use a _____ dollar sign. EX 99Floating
Which that the complying with is a precious conditional formatting operator discovered in the new Formatting preeminence dialog box? EX 103Greater than
A period on the display screen that contains a color is referred to as a _____. EX 103Pixel
Excel consists of a(n) _____ you can use to check a worksheet for spelling errors. EX 107Spell Checker
A(n) _____ is text and also graphics that print at the bottom of every page. EX 110Footer
The _____ version of a worksheet shows the results of formulas. EX 115Values
_____ room values in cells the you can change to determine new values because that formulas. EX 130Assumptions
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 141Office 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 148Date Stamp
A formula utilizing the _____ cell reference B4 instructs Excel to adjust the cell recommendation as it duplicates it come the location area. EX 151Relative
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 160Sparkline
The _____ feature evaluates the selected data and makes suggestions regarding which chart types will carry out the most perfect representation. EX 171Recommended 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 184Panes
*