Excel Reinforcement Ch.3


 



  • 1) You can rotate text counterclockwise by entering a number between 1 and 180 on the Alignment sheet in the Format Cells dialog box.
  • 2) If you drag the fill handle to the left or up, Excel will decrement the series.
  • 3) When pasting cells in a destination area, you are required to select the entire destination area before you click the Paste button.
  • 4) To insert multiple rows, insert a row by using the Insert command then repeatedly press F4.
  • 5) The move and copy command accomplish the same task.
  • 6) A date stamp shows the date a workbook or report was created, or the period it represents.
  • 7) F61 is an absolute reference, and $F$61 is a relative reference.
  • 8) The IF function is useful when you want to assign a value to a cell based on a logical test.
  • 9) The nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
  • 10) Even if you enter a formula in lowercase letters, Excel converts them to uppercase.
  • 11) The fill handle can be used to do which of the following?



  • 12) Which of the following will decrease the indent by three spaces each time you click it?



  • 13) The Copy button copies the contents and format of the source area to the ____________.



  • 14) Which of the following is a valid format symbol?



  • 15) To freeze worksheet titles use the ___________ button on the ___________ tab.



  • 16) A cell reference of $B17 is a(n) ____________ cell reference.



  • 17) If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function =IF(E5>4*F5,“Deductions”,“No deductions”), then cell G5 displays the message, ____________.



  • 18) Excel displays error messages that begin with ____________ to indicate when there is an error.



  • 19) After you use the Insert command on the shortcut menu to insert a row, you can press ____________ to keep inserting rows.



  • 20) The Goal Seeking command is located on the ____________ tab on the Ribbon.



  • 21) After the Paste button is clicked, Excel displays the _______________ button.
    Answer:
  • 22) Using the mouse to move or copy cells is called _______________.
    Answer:
  • 23) The _______________ on the shortcut menu allows you to insert rows between rows that already contain data.
    Answer:
  • 24) The _______________ on the Insert gallery of the Insert button on the Ribbon allows you to insert a single cell or range of cells.
    Answer:
  • 25) Excel allows you to _______________, so that Excel displays the titles on the screen, no matter how far down you scroll.
    Answer:
  • 26) The _______________ returns a number that corresponds to the system date and time beginning with December 31, 1899.
    Answer:
  • 27) Excel uses a technique called _______________ to keep a cell reference constant when copying a formula or function.
    Answer:
  • 28) If the value you want to assign to a cell is dependent on a logical test, use the _______________.
    Answer:
  • 29) You can _______________ a slice of a 3-D pie chart to make it stand out from the rest.
    Answer:
  • 30) You can magnify or shrink the appearance of a worksheet or chart by using the _______________ button on the View tab on the Ribbon.
    Answer: