Table of Contents### Review Questions

Entire Site

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 |