Admin Table of Contents
- 1 IS are used to place worksheet column and row titles on a worksheet?
- 2 What is a worksheet that can only contain a chart and does not contain any cells for entering data?
- 3 When the chart is created on a separate worksheet it is called?
- 4 What is the intersection of a column and a row on a worksheet called?
- 5 How are columns in Excel worksheet Labelled?
IS are used to place worksheet column and row titles on a worksheet?
Excel Exam Review
| Question | Answer |
|---|---|
| Is/are used to place worksheet, column, and row titles on a worksheet. | Text |
| Is a series of two or more adjacent cells in a column or row or a rectangular group of cells. | Range |
| How many chart types does Excel offer? | 10 |
What is a worksheet that can only contain a chart and does not contain any cells for entering data?
A chart sheet contains a single chart only; you cannot enter data and formulas on a chart sheet.
Which of the following keys moves the intersection point to the end of data in a cell?
| Press | To |
|---|---|
| CTRL+END | Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1 |
| CTRL+PAGE DOWN | Move to the next sheet in the workbook |
When the chart is created on a separate worksheet it is called?
When we can create a chart on a separate sheet in the same workbook, it is called a. Chart sheet.
What is the intersection of a column and a row on a worksheet called?
Understanding cells Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column—in other words, where a row and column meet. Each cell has its own name—or cell address—based on its column and row.
How do you go to the end of a column in Excel?
To select to end of column from a cell, use excel shortcut Ctrl+Shift + Down arrow.
How are columns in Excel worksheet Labelled?
By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65,536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number.