Excel Basics
Adding and Formatting Worksheets
Cell Entries and Ranges
Formulas
Moving Data and Printing
100
The location of a cell in a worksheet as identified by its column letter and row number.
What is Cell Reference
100
A combination of a font, text color, cell color, and other font attributes applied to a single cell.
What is cell style
100
A black box on the the lower-right corner of the selected cell or range that you can use to fill (copy) a series or formula.
What is the fill handle
100
a worksheet instruction that performs a calculation
What is a formula
100
true/false. Pressing the delete key on the keyboard deletes the cell that is selected
What is false
200
As you enter data in a cell, it simultaneously appears in the _____________, which is located above the worksheet
What is the formula bar
200
A style that displays dollar signs ($) immediately preceding the number and includes a thousands separator (,)
What is currency format
200
A list of sequential numbers, dates, times, or text.
What is a series
200
Which takes precedence in a formula? * or -
What is * multiplication
200
to move a range, first select it, then click where and drag?
What is the border
300
tabs that appear at the bottom of the workbook window, which display the name of each worksheet
What are sheet tabs
300
to center text over a group of selected cells, which option would you choose?
What is merge and center
300
To change the mode of a cell to "edit", you have to do what to the cell?
What is double click
300
a formula always begins with what?
What is an equals sign =
300
To use the mouse to copy or move information from one location to another on a worksheet, between worksheets, or between workbooks.
What is drag and drop
400
An Excel file with one or more worksheets.
What is a workbook
400
Name at least 3 number formats
What are currency, accounting, short date, long date, general, number, etc...
400
A block of cells in an Excel worksheet.
What is a range
400
a built in calculation used to add a range of values together
What is SUM function
400
rows always insert ______ the selected cell, while columns always insert ___________ of the selected cell
What is above, to the left
500
When a cell is selected, its cell reference appears in the
What is the name box
500
When a cell is in date format, it is assigned a __________ that can be used in formulas
What is a number
500
to automatically change the width of a column to fit text, double click the _________ __________
What is column heading
500
a cell address that can change in a copied formula, so the new address is expressed in relation to the cell containing the copied formula.
What is relative cell reference
500
When you change a worksheet's size to make it printable, you are ____________ the worksheet
What is scaling
M
e
n
u