MS excel set 2 Detailed Explanation And More Example

Question : 1

In Excel Graphics objects on a chart are used to

a) Add emphasis to chart data

b) Add interest to a chart

c) Help explain the chart data

d) All the above

Question : 2

In order to perform a calculation in a spreadsheet, you need to use a:

a) table

b) formula

c) field

d) variable

e) None of these

Question : 3

What is the AutoSummarize feature used for in Word 2000

a) It creates a 250 word, 500 word or 1000 word summary of the document

b) It adds Automatic headers, bold and italic characters as well as' automatic formatting of the document to give the look of a well summarized document

c) it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs

d) It identifies the key points in a document for your to share with others or quickly scan

e) None of these

Question : 4

Which of the following methods can not be used to enter data in a cell

a) Pressing an arrow key

b) Pressing the Tab key

c) Pressing the Esc key

d) Clicking on the formula bar

e) None of these

Question : 5

The chart wizard term data series refers to

a) A chart legend

b) A collection of chart data markers

c) A set of values you plot in a chart

d) A data label

e) None of these

Question : 6

Which is an example of a function?

a) =add(A1:A2)

b) =A1+A2

c) »SUM(A1:A2)

d) A1+A2

e) None of these