computer 4

1. Which function calculates your monthly mortage payment________
   (1) PMT (payments)
   (2) NPER (number of periods)
   (3) PV (present value)
   (4) All of above
   (5) None of these
   
   Answer

   (1) PMT (payments)
2. You can open the Sort dialog box by choosing Sort from the_______menu.
   (1) View
   (2) Format
   (3) Tools
   (4) Data
   (5) None of these
   
   Answer

   (4) Data
3. In MS Access, a table can have________primary key /keys.
   (1) One
   (2) Two
   (3) Three
   (4) Four
   (5) None of these
   
   Answer

   (1) One
4. _______cells involves creating a single cell by combining two or more selected cells.
   (1) Formatting
   (2) Merging
   (3) Embedding
   (4) Splitting
   (5) None of these
   
   Answer

   (2) Merging
5. The horizontal and vertical lines on a worksheet are called________
   (1) cells
   (2) sheets
   (3) blocklines
   (4) gridlines
   (5) None of these
   
   Answer

   (1) cells
6. The most common subtotal used Subtotals command is the________function, which causes Excel to display a sum each time the corurol field change.
   (1) ADD
   (2) SUM
   (3) TOTAL
   (4) LIST
   (5) None of these
   
   Answer

   (2) SUM
7. By default, Excel positions text in a cell_______
   (1) left-aligned
   (2) right-aligned
   (3) centered
   (4) justified
   (5) None of these
   
   Answer

   (1) left-aligned
8. To centre a paragraph using shortcut keys, press_______
   (1) CTRL + C
   (2) CTRL + E
   (3) CTRL + L
   (4) CTRL + R
   (5) None of these
   
   Answer

   (2) CTRL + E
9. Which types of charts can excel produce________
   (1) Line graphs and pie charts only
   (2) Only line graphs
   (3) Bar charts, line graphs and pie charts
   (4) Bar charts and line graphs only
   (5) None of these
   
   Answer

   (3) Bar charts, line graphs and pie charts
10. How are data organized in a spreadsheet________
    (1) Lines and spaces
    (2) Layers and planes
    (3) Rows and columns
    (4) Height and width
    (5) None of these
    
    Answer

    (3) Rows and columns