Name ________________________________________ CA Sect. ______ Score _____/36

Excel Sect. 1 & 2 Test Review Sheet
Test date: Thurs., Nov. 8, 2007

  1. Columns are designated with _________________and rows are numbered in a worksheet. p. 2
  2. How many columns are in an Excel worksheet? p. 2 ________
  3. Information is created in Excel in a worksheet and is saved in a file called a ___________________ p. 2
  4. If you change the contents of a cell that is included in a formula, the resulting values from that formula will automatically be recalculated or _______________________. p. 4
  5. The _______________________ feature will complete text entries for you as you start to type a new entry in a cell. (See “In Addition”) p. 5
  6. ________________ are generally entered first in creating a new worksheet since they define the layout of the date in the columns and rows. p. 6
  7. Text or labels are ______________ aligned in a cell by default when entered into cells and values or numbers are right aligned p. 6
  8. To edit the value or data in a cell, you must ______________ the cell and retype the entry. p. 6
  9. To type a new entry in a cell, you can key it in the cell or the ________________ bar, and it appears in both places. p. 6
  10. If you type Sun in a cell and then use the ____________ handle to place data in the next cell, the resulting entry in the adjacent cell will be Mon. p. 7
  11. Formulas begin with ____________. p. 10
  12. Since the ________________ function is the most widely used function in Excel, a button with that name on the Standard toolbar will enter the function. p. 12
  13. A ______________ of cells is the starting and ending cell, separated by a colon, or several consecutive cells that are used in the calculation of a formula. p. 12
  14. The values identified within parentheses of a formula are called the _________________. p. 12
  15. When copying formulas from one cell to another, Excel uses __________________ addressing which means that the same function will be used, but the letters or row numbers will be changed relative to the destination location. p. 14
  16. The feature you should always use before printing to view how the page will appear when printed is _________________________. p. 22
  17. From the “Print what” options in the print dialog box, you can choose to print either an entire _______________________ or individual worksheets. p. 22
  18. Scrolling with the scroll bars does not move the position of the _______________ cell but scrolling with the arrow keys does. p. 24
  19. (from the Keyboard movement commands table) Pressing the ___________________ key will take you to the first cell in the current row. p. 25
  20. To move to the first cell in the worksheet (A1), press _______________________. p. 25
  21. Clearing a cell can involve removing the cell contents or _______________, or both. p. 34
  22. When a row or column is ___________________ from view, data and formulas are still valid and not deleted. – p. 38
  23. To move a range of cells, select the range and then point to the ______________ of the area until the pointer changes to a white arrow with the move icon attached to it. p. 40
  24. When you select a range of cells, there’s a border around it and the area is ___________ (what color?) except for the first cell you selected which stays white. p. 40
  25. To copy a range of cells using drag and drop method, select the cell or range, point at any of the selected cell borders until the pointer displays as a white arrow with the move icon attached, hold down ________ and then drag the mouse to the location where you want it copied.. p. 41
  26. For a cell address in a formula not to change or to remain fixed when the formula is copied, use ________________________ addressing. p. 41 “In Addition”
  27. Column width and row height are all _____________ by default. p. 42
  28. Labels spill over into the next cell or column if it’s ____________. p. 42
  29. The default font and font size in Excel is _____-point. p. 44
  30. The button to use on the formatting toolbar to center a title over the spreadsheet width is __________________________. p. 45
  31. A numeric value formatted using the _________________ format adds a dollar symbol, comma in the thousands, and two decimal places to each value; the Accounting format is similar except that the dollar signs and commas will be aligned vertically. p. 46
  32. The Increase indent increases the data within the cells about one ____________________ ____________________. p. 48
  33. To change text so that you read it from top down toward the bottom of a cell, use Text orientation – p. 49 “In Addition” Yes, it’s a freebie J
  34. The _________________ tab in the Format Cells dialog box contains options to rotate text, align text vertically, control the length of labels within a cell and designate the reading order for text. p. 49
  35. AutoFormat affects the range of cells that is ________________, not the entire worksheet. p. 52
  36. When you freeze panes, all rows _________________ and to the left of the active cell are frozen. p. 56
  37. The ______________ setting does not affect the printing of a worksheet, but only magnifies or reduces the monitor display. p. 57