| [ LiB ] |
| 1: | What key must you press to begin an Excel formula? |
| A: | See ' Creating Formulas ' in Chapter 6 |
| 2: | When might you want to use an absolute reference in a formula? |
| A: | See ' Creating an Absolute Reference in a Formula ' in Chapter 6 |
| 3: | When does Excel display #DIV/0! in a cell ? |
| A: | See ' Understanding Common Formula Error Messages ' in Chapter 6 |
| 4: | What are Excel functions? |
| A: | See ' Using Excel Functions ' in Chapter 7 |
| 5: | What are function arguments? |
| A: | 'See ' Understanding Function Syntax ' in Chapter 7 |
| 6: | Which Excel function displays the current date in a cell? |
| A: | See ' Using the NOW Function ' in Chapter 7 |
| 7: | What does Excel call a file with multiple worksheets? |
| A: | See ' Working with Larger Workbooks ' in Chapter 8 |
| 8: | What does Excel do when you first open a workbook with a link to another workbook? |
| A: | See ' Creating Links to Other Workbooks ' in Chapter 8 |
| 9: | What can you do so the row and column headings always remain visible as you move through a large worksheet? |
| A: | See ' Freezing Panes ' in Chapter 9 |
| 10: | Why might you give a group of cells a range name ? |
| A: | See ' Creating Range Names ' in Chapter 9 |
| [ LiB ] |