Page 241 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills

Notes Scenario management: Excel is often used for what-if analysis, that is, you can separate
sheets.
Status bar: It usually contains mode indicator button and keyboard mode
Templates: Excel has a template wizard that walks the user through the steps

The title bar: This identifies the name of the program and also holds some
Toolbars: It holds buttons to issue commands when clicked.
Using the autosum tool: The Sum function is probably the most often used function and the
AutoSum tool makes it very easy to enter SUM function onto worksheet. Wide assortment
of graph types.
Windows control menu buttons: There are three buttons which control the your worksheet.

1. Draw graph charts with the help of power point slide.
2. How to set page layout in power point?

11.8 Self-Assessment Questions

1. Excel uses the ...........…. Function when creating a data table
(a) Average (b) Count
(c) Sum (d) Table
2. 3-D reference in a formula

(a) Cannot be modified (b) Only appears on summary worksheets
(c) Limits the formatting options (d) Spans worksheets
3. The chart wizard
(a) Can place a chart on a new chart sheet or on any sheet in the workbook
(b) Can only place a chart on new chart sheet
(c) Can only place a chart on a new blank worksheet

(d) Can only be used to create embedded charts
4. What chart object is horizontal or vertical line that extends across the plot area to make
it easier to read and follow the values?
(a) Category axis (b) Data marker

(c) Data point (d) Gridline
5. What is the keyboard shorZ
(a) F3 (b) F5
(c) F7 (d) F11
6. You can use the formula palette to
(a) Format cells containing numbers
(b) Create and edit formulas containing functions

(c) Entered assumptions data
(d) Copy a range of cells

234 LOVELY PROFESSIONAL UNIVERSITY