[ 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 ] |