A | B |
when you assign a(n) _______________ to a cell, and Excel will calculate the result | formula |
allows you to select cells for use in a formula by using the mouse | Point Mode |
values used with a function are called _______________ | arguments |
_______________ means that the width of a column will be increased or decreased so the widest entry will fit | Best fit |
formatting that appears only when the value in a cell meets specific conditions is called _______________ | conditional formatting |
an easy way to verify that a formula references the cells that you want it to reference is to use Excel’s _______________ | Range Finder |
use this function to display the highest value in a range | MAX |
this function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range | AVERAGE |
alerts Excel that you are entering a formula or function and not text | equal sign |
the order in which calculations are performed in a formula | order of operations |