DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
worksheet
|
|
|
chart area
|
|
|
chart sheet
|
|
|
None of the above
|
Detailed explanation-1: -A ChartSheet represents a chart sheet; that is, a worksheet that contains only a chart. If you want to create an embedded chart in a worksheet that also contains other items, such as cells or other controls, create a Chart instead. A ChartSheet provides all the chart-related features of a native Microsoft.
Detailed explanation-2: -A prebuilt set of chart elements that can include a title, legend, or labels. Chart sheet. A workbook sheet that contains only a chart and is useful when you want to view a chart separately from the worksheet data.
Detailed explanation-3: -A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data. Dragging a chart object to a new location on the worksheet will change the data in the worksheet. A chart must be located in a specific cell or at a specific address range.
Detailed explanation-4: -A chart sheet contains a single chart only; you cannot enter data and formulas on a chart sheet.