MS excel set 4 Detailed Explanation And More Example

Question : 1

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 : 2

You can insert labels for

a) All the data markers on a chart

b) A data series

c) A selected data marker

d) All

e) None of these

Question : 3

When you copy a formula

a) Excel erases the original copy of the formula

b) Excel edits cell references in the newly copied formula

c) Excel adjusts absolute cell references

d) Excel doesn't adjust relative cell references

e) None of these

Question : 4

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 : 5

You can group noncontiguous worksheets with

a) The group button on the standard toolbar

b) The shift key and the mouse

c) The Ctrl key and mouse

d) The alt+enter key

e) None of these

Question : 6

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