Show:
Excel Basics
Changing the appearance of a worksheet
Organizing a worksheet
Entering worksheet formulas
Working with charts
100
A ____________________ is a computerized spreadsheet.
What is a worksheet.
100
If you want to change the background color of a cell or group of cells you would change this.
What is fill color.
100
The _________________ are the blank space around the top, bottom, left and right sides of the page.
What are margins.
100
This type of cell reference will not adjust to its new location when copied to a new cell.
What is absolute.
100
When creating a chart, in order to insert a chart into the worksheet you must do this.
What is Insert, Chart
200
This describes a cell that is ready for data entry.
What is an active cell.
200
By double-clicking the edge of a row or column you can do this to fit the text best in a cell.
What is AutoFit.
200
___________________________ shows how the worksheet will appear on paper.
What is page layout view.
200
The equation used to calculate values based on numbers in a cell.
What is a formula.
200
If the chart is on the same page as the data it is this.
What is an embedded chart.
300
A group of cells is called this.
What is a range.
300
If text is too long to fit within a cell you can do this.
What is wrap text.
300
To keep the titles and column labels of a worksheet on the screen no matter where you are working you would do this.
What is freeze panes.
300
The sequence used to calculate the value of a formula is caled this.
What is order of evaluation.
300
The group of cells or range that you choose to chart is called this.
What is data source.
400
This identifies a cell by the column letter and the row number.
What is the cell reference.
400
The _______________________ copies all the formatting from one cell or range without copying the contents of the cell.
What is format painter.
400
You press this key to copy data using the drag-and-drop method.
What is CTRL.
400
A formula always begins with this.
What is an equal sign.
400
This identifies the colors or labels assigned to each area of the chart.
What is the legend.
500
The contents of the active cell always appears here.
What is the formula bar.
500
When text has been hidden from view we say that it has been what?
What is truncated.
500
This is a small black square in the bottom right-hand corner of the active cell. It allows copying of information to other cells.
What is the fill handle.
500
To perform a calculation you must have these between cell references or numbers. ex. +, -, *, /
What are operators.
500
By applying this it changes the colors, fonts, and effects of a chart.
What is chart style.