Page 242 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 11: Operations of MS Excel

7. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report Notes
if the source data character changed
(a) Format Report (b) Pivot Table
(c) Refresh Data (d) Show Detail

8. Which of the following setup options can not be set in the page setup dialog box?
(a) Printer selection (b) Vertical or horizontal placement
(c) Orientation (d) Row and column titles
9. Charts tips can
(a) Show the formatting of a data label

(b) Show the name of a data series
(c) Show the value of data point
(d) Both (b) and (c)
10. You can use the horizontal and vertical scroll bars to

(a) Split a worksheet into two panes
(b) View different rows and columns
(c) Edit the contents of a cell
(d) View different worksheets

11.9 Review Questions

1. Name the elements which a formula can contain.
2. Can a formula be removed from the worksheet without removing the calculated
value?

3. How will you make the cell address in a formula absolute?
4. How is relative addressing different from absolute addressing?
5. Discuss the different kinds of errors that could occur while working in Excel.

6. Briefly explain the AutoSum tool available in Excel.
7. What is a circular reference?
8. What is formatting and why is it used?
9. What do you understand by a cell and a range?
10. What are the different ways to select a range?

11. What is the difference between a contiguous and a non-contiguous selection?
12. Explain the following in brief:
(a) Menu bar (b) Formula bar
(c) Status bar (d) Active window

13. How can you cancel a print job which has already been placed in the printer queue?
14. What are Excel Headers and Footers?
15. How to add headers and footers to a worksheet?

LOVELY PROFESSIONAL UNIVERSITY 235