MS excel set 4 Detailed Explanation And More Example

Question : 1

When you link data maintained in Excel workbook to a Word document

a) The Word document cannot be edited

b) The Word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

e) None of these

Question : 2

You can use the drag and drop method to

a) Copy cell contents

b) Move cell contents

c) Add cell contents

d) a and b

e) None of these

Question : 3

The Chart wizard term data categories refers to;

a) A chart plot area

b) A horizontal axis

c) The organization of individual values with a chart's data series

d) The data range that supply chart data

e) None of these

Question : 4

Which would you choose to create a bar diagram?

a) Edit, Chart

b) Insert, Chart

c) Tools, Chart

d) Format, Chart

e) None of these

Question : 5

You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

a) word processing

b) spreadsheet

c) database

d) graphics

e) None of these

Question : 6

Which setting you must modify to print a worksheet using letterhead?

a) Paper

b) Margin

c) Layout

d) Orientation

e) None of these