• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Review Questions

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint