MS Excel -04

01. When the formula bar is active, you can see

  • 1The edit formula button
  • 2The cancel button
  • 3The enter button
  • 4All of the above

02. Which button do you click to add up a series of numbers?

  • 1The autosum button
  • 2The Formula button
  • 3The quicktotal button
  • 4The total button

03. To activate the previous cell in a pre-selected range, press

  • 1The Alt key
  • 2The Tab key
  • 3The Enter key
  • 4None of the above

04. Hyperlinks can be

  • 1Text
  • 2Drawing objects
  • 3Pictures
  • 4All of above

05. You can use the horizontal and vertical scroll bars to

  • 1Split a worksheet into two panes
  • 2View different rows and columns edit the contents of a cell
  • 3Edit the contents of a cell
  • 4view different worksheets

06. Which is used to perform what if analysis?

  • 1Solver
  • 2Goal seek
  • 3Scenario Manager
  • 4All of above

07. Comments put in cells are called

  • 1Smart Tip
  • 2Cell Tip
  • 3Web Tip
  • 4Soft Tip

08. The name box

  • 1Shows the location of the previously active cell
  • 2Appears to the left of the formula bar
  • 3Appears below the status bar
  • 4Appears below the menu bar

09. When integrating word and excel, word is usually the

  • 1Server
  • 2Destination
  • 3Client
  • 4Both b and c

10. How can you find specific information in a list?

  • 1Select Tools > Finder from the menu
  • 2Click the Find button on the standard toolbar
  • 3Select Insert > Find from the menu
  • 4Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Page 1 Of 2
Test
Classes
E-Book