Table of Contents
What is the name of the area within a worksheet?
Excel Review Questions
| A | B |
|---|---|
| Active cell | The name of the area within a worksheet that is current, or ready to receive information |
| The key | |
| Values | Are used in calculations |
| Numeric Labels | Used for descriptive headings such as social security numbers, telephone numbers |
Where is the chart area in Excel?
All charts in Excel have a chart area, which encloses all elements of the chart. The easiest way to select the chart area is to click just below the top edge of the chart. The Chart Elements menu on the Format tab of the ribbon, and the Format Task pane title will confirm the chart area is selected.
What is a worksheet area?
A worksheet is a collection of cells where all your data and formulas are stored. Each cell can contain either data (numeric or text) or a formula. Cells are arranged in rows and columns in the workbook. Rows are labelled with numbers going from 1 at the very top to 1,048,576 at the very bottom.
Where does the name of the worksheet appears?
The names of the worksheets appear on tabs at the bottom of the workbook window. To move from sheet to sheet, click the worksheet tabs.
What is the total region surrounding the chart called?
Chart Area:- It is the area where chart components are enclosed.
What is called the total area of the chart?
Answer: An area chart or area graph displays graphically quantitative data. It is based on the line chart. The area between axis and line are commonly emphasized with colors, textures and hatchings.
What is chart area and plot area?
Chart area includes all the area and objects in the chart. Plot area is a window with in the Chart area. It contains the actual chart itself, and includes plotted data, data series, category, and value axis. 4. Legend depicts the colors, patterns, or symbols assigned to the data series.
What are the parts of worksheet?
What are the three important parts of a worksheet?
- Worksheet – rectangular grid of rows (numbers) and columns (letters)
- Cell – intersection of row and column.
- Cell reference – unique address, coordinates of the intersection of a column and row (B7)
- Gridlines – horizontal and vertical lines.
Where is the worksheet tab in Excel?
bottom
The worksheet tab can be found at the bottom of every excel worksheet tab.
What is the area surrounding the chart?
Explanation: Chart Area:- It is the area where chart components are enclosed.
How to view more than one embedded chart in Excel?
T F An embedded chart is placed on a separate sheet than the data it represents. T F More than one worksheet of a workbook may be viewed on screen by selecting Split from the View menu.
Do you have to print entire worksheet to make chart?
T F When creating a new chart sheet, you must first cut and paste the data that is to be included in the chart. T F You may print an entire workbook or selected worksheets, but not selected areas of a workbook.
How does a T F chart work in Excel?
T F Charts make it easier to visually detect changes in data. T F If you click the Print button on the toolbar, you cannot change the printing options and the sheet will automatically be sent to the printer. T F A spreadsheet may be saved in HTML format.