Exercise & Quiz Test – 82


Question 1

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 & Solution
(1) PMT (payments)
Question 2

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 & Solution
(4) Data
Question 3

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

Answer & Solution
(1) One
Question 4

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 & Solution
(2) Merging
Question 5

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

Answer & Solution
(1) cells
Question 6

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 & Solution
(2) SUM
Question 7

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

Answer & Solution
(1) left-aligned
Question 8

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 & Solution
(2) CTRL + E
Question 9

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 & Solution
(3) Bar charts, line graphs and pie charts
Question 10

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 & Solution
(3) Rows and columns