A(n) ____ circular referral occurs once a formula in a cabinet refers to an additional cell or cell that include a formula the refers back to the original cell. a.indexed b.contiguous c.direct d.indirect | d.indirect |

The most usual error once entering a formula is to recommendation the wrong cell in the formula. | True |

As in algebra, you deserve to use base to override the bespeak of work Excel adheres to to execute formula calculations | False |

The Percent Style switch instructs Excel to screen a value as a percentage, established by multiplying the cabinet entry by 100, rounding the result to the nearest percent, and adding a percent sign. | True |

The Insert options button perform formatting options. | True |

The ____ duty displays the highest value in a range. a.MAX b.AVERAGE c.SUM d.MIN | a.MAX |

Excel attempts come guess which cell you want to encompass in the duty by searching for ranges that are adjacent to the selected cell and also that save on computer numeric data. | True |

The equal sign (=) comes before a formula. True False | True |

Excel has an ext than 400 attributes that execute just about every kind of calculation you can imagine. True/False | True |

A company or department may standardize with a specific ____ for this reason that all of their papers have a comparable appearance. a.style b.scheme c.theme d.gallery | c.theme |

Cooler colors tend to pull away from the reader. True False | True |

You deserve to click the ____ switch to drown an automatic correction. a.AutoCorrect Options b.Trace Error c.Auto to fill Options d.Paste Options | a.AutoCorrect Options |

Best fit way that the width of the tower will be boosted or reduced by a percentage you specify. True False | False |

You have the right to use the arrowhead keys to finish an entry in allude mode. True False | False |

The AVERAGE function requires that the debate be had within parentheses following the duty name. True False | True |

____ view allows you to develop or change a worksheet if viewing just how it will look in published format. a.Full Screen b.Normal c.Page break Preview d.Page Layout | d.Page Layout |

When friend click the to decrease Font size button, Excel assigns the next highest font size in the Font dimension gallery. True False | False |

Which of the adhering to Option buttons gives choices for pour it until it is full cells adhering to a to fill operation? a.Auto fill Options b.Insert Options c.Paste Options d.AutoCorrect Options | a.Auto fill Options |

The Sum switch menu allows you to enter one of 5 often-used functions quickly into a cell. True False | True |

The audit number layout assigns a floating dissension sign. True False | False |

Point mode permits you to pick cells for usage in a formula by utilizing your finger or the pointer. True False | True |

Which the the adhering to calculations multiplies 23 by 0.01? a.=23% b.=23 c.=23+.01 d.=24-.01 | a.=23% |

The ____ role determines the shortest number in a range. a.MIN b.BASE c.LEAST d.LOW | a.MIN |

The default see in Excel is called ____ view. a.Standard b.Basic c.Normal d.Values | c.Normal |

When you decrease the row height to ____, the heat is hidden. a.0 b.1 c.2 d.3 | a.0 |

When an ext than one arithmetic operator is associated in a formula, Excel complies with the same basic order of ____ that you usage in algebra. a.placement b.positioning c.operations d.selections | c.operations |

Clicking the Create duty box opens the function Arguments dialog box. True False | False |

To choose a number format, friend can choose a category in the Number tab in the layout Cells dialog box and then choose the number of decimal places, whether or no a dollar sign must be displayed, and also how an adverse numbers need to appear. True False | True |

All of the complying with are precious Excel arithmetic operators other than ____. a.* b.> c.% d.^ | b.> |

The Percent Style button instructs Excel to display a worth as a percentage, identified by multiply the cabinet entry by 100, rounding the result to the nearest percent, and adding a percent sign. True False | True |

To publish a range of cells in the energetic worksheet, click ____ in the setups area in the print gallery. a.Print active Sheets b.Print Selection c.Print whole Workbook d.none that the above | b.Print Selection |

The arithmetic operator, ^, directs Excel to carry out the department operation. True False | False |

You can not format whole column at once. True False | False |

Excel automatically appends the ____ to finish the AVERAGE function when girlfriend click the enter box or press the go into key. a.left bracket b.right parenthesis c.right bracket d.left parenthesis | b.right parenthesis |

An asterisk (*) complying with a cell reference in a formula is the arithmetic operator that directs Excel to execute the division operation. True False | False |

You can use the ____ to examine which cells space referenced in the formula assigned to the energetic cell. a.Range Finder b.Function Finder c.Formula Finder d.Calculation Finder | a.Range Finder |

While holding down the ALT key, you can select nonadjacent ranges and also cells. True False | False |

As in algebra, you have the right to use base to override the stimulate of work Excel follows to carry out formula calculations. True False | False |

With the audit number style, a floating dissension sign appears immediately to the left the the first digit in a dollar value with no spaces. True False | False |

A ____ is text and also graphics that publish at the bottom the every page. a.margin b.stopper c.toe d.footer | d.footer |

The adjusted cell references in a copied and also pasted formula are dubbed ____ cabinet references. a.alternative b.related c.relative d.pasted | c.relative |

You have the right to click the layout Cells Dialog box Launcher to open up the style Cells dialog box. True False | True |

The ____ button lists error-checking alternatives following the assignment of one invalid formula to a cell. a.Explain Error b.Fix Error c.Trace Error d.Find Error | c.Trace Error |

The ____ Option switch lists formatting choices following an insertion the cells, rows, or columns. a.Auto Fill b.Paste c.AutoCorrect d.Insert | d.Insert |

Which the the complying with happens as soon as you enter the formula =G15 right into a cell? a. Nothing; =G15 is one invalid formula b.Excel assigns the value in cell G15 come the energetic cell c.Excel assigns the sum of the values in the previous 15 cell to the energetic cell d.Excel recalculates all formulas in the worksheet | b.Excel assigns the value in cabinet G15 come the active cell |

The ____ button assigns a fixed dollar authorize to the numbers in a selected range, v the dollar sign to the much left with spaces in between it and also the very first digit in the cell. a.Percent layout format b.Accounting number format c.Comma format format d.Currency style format | b.Accounting number format |

A ____ is text and also graphics that publish at the top of each page. a.margin b.topper c.header d.crown | c.header |

When Excel follows the bespeak of operations, the formula, 8 * 3 + 2, equates to ____. a.13 b.48 c.40 d.26 | d.26 |

The most common error as soon as entering a formula is to recommendation the wrong cabinet in the formula. True False | True |

The Insert alternatives button perform formatting options. True False | True |

Using allude mode to get in formulas often is much faster and much more accurate than making use of the key-board to type the whole formula. | True |

The variety automatically selected by Excel is always correct. | False |

Moving native left to right, the an initial calculation in the stimulate of to work is negative (-). True False | True |

A ____ is a prewritten formula that is developed into Excel. a.task b.feature c.function d.calculation | c.function |

If you perform not entrust a style to a cell or cells in a column, the pillar width will remain ____ characters. a.8.43 b.11.65 c.7.52 d.9.43 | a.8.43 |

The ____ AutoComplete list includes those features that alphabetically complement the letters you type following the same sign. a.Function b.Formula c.Calculate d.Equal | b.Formula |

Moving from left come right, the very first calculation in the stimulate of to work is negation (-). | True |

If you do not entrust a layout to a cell or cell in a column, the column width will remain ____ characters. a. 11.65 b. 7.52 c. 8.43 d. 9.43 | c.8.43 |

The AVERAGE duty requires the the discussion be contained within parentheses complying with the duty name. | True |

The ____ function sums the number in the specified range and climate divides the amount by the number of cells v numeric worths in the range. a. DIVSUM b. RANGEAVG c. AVERAGE d. MAX | c. AVERAGE |

The bookkeeping number style assigns a floating disagreement sign. | False |

A ____ is a prewritten formula that is developed into Excel. a.feature b.calculation c.task d.function | d.function |

To publish a range of cell in the energetic worksheet, click ____ in the setups area in the publish gallery. |