click below
click below
Normal Size Small Size show me how
Excel Project 3
| Question | Answer |
|---|---|
| The ________ button indents the contents of a cell to the right by three spaces each time you click it. | Increase Indent |
| Even if you enter a formula in lowercase letters, Excel converts it to ________-. | uppercase |
| F61 is a(n) ____________ reference. | relative |
| $F$61 is a(n) __________ reference. | absolute |
| You can ensure correctness in your formulas by carefully checking them using _____. | Range Finder |
| Using the mouse to move or copy cells is called _____. | drag and drop |
| When assigned to a cell, the _____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. | NOW |
| The _____ function is useful when you want to assign a value to a cell based on a logical test. | IF |
| A(n) _____ chart provides a simple way to show trends and variations in a range of data within a single cell. | Sparkline |
| A Pie chart with one of more slices offset is called a(n) _____ pie chart. | exploded |
| Which of the following will decrease the indent by three spaces each time you click it? | Decrease Indent |
| Excel allows you to ____________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll. | freeze |
| To make a cell an absolute reference, you can press the ____ key. | F4 |