Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Key terms published

Total questions: 10

Worksheet time: 30mins

Name
Class
Date
1.

Match the following

a)

displays across the top of the window.

1.

Ribbon

b)

Ribbion is organized into these tabs

2.

command tabs

c)

The tabs are divided in these groups.

3.

Command groups

d)

Also known as a spreadsheet is imagined as a physical book with many pages.

4.

Workbook

e)

Sheet1) by default—similar to the first page in a book—where you enter information

5.

Worksheet

2.

Match the following

a)

starts at the top of the worksheet and goes to the bottom of the worksheet and is identified by a letter.

1.

Column

b)

starts at the left edge of the worksheet and continues to the right edge and is identified by a number

2.

Row

c)

on the grid is identified by the intersection of a column and a row.

3.

Cell

d)

You enter information by typing it into it.

4.

Active Cell

e)

gives you fast and easy access to the tools you use most often in any given Excel session.

5.

Quick access bar

3.

Match the following

a)

which are small, onscreen boxes that display descriptive text when you rest the pointer on a command or control.

1.

Screen Tips

b)

indicates the current cell you are in as well as gives you the opportunity to move to a cell or to name the cell or a range.

2.

Name box

c)

takes the information from one location and duplicates it.

3.

Copy

d)

to put this information into another location.

4.

Paste

e)

located between the Ribbon and the worksheet.

5.

Formula bar

4.

Match the following

a)

you highlight the text that is to be changed.

1.

Selecting Text

b)

options that automatically fill cells with data and/or formatting.

2.

Auto Fill

c)

a small green square in the lower-right corner of a selected cell or range of cells.

3.

Fill Handle

d)

a group of adjacent cells that you select to perform operations on all of the selected cells.

4.

Range

e)

a formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.

5.

Natural Series

5.

Match the following

a)

Another time-saving option for filling in data

1.

Flash Fill

b)

(arrow with a plus), you can drag the cell or range of cells to the new location

2.

Copy Pointer

c)

collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Microsoft Office programs.

3.

Office Clipboard

d)

you can drag the cell or range of cells to a new location.

4.

Move Pointer

e)

insert) selected items from the Clipboard to a new location in the worksheet.

5.

Paste

6.

Match the following

a)

pre-set options that determine how Excel will behave when performing an action.

1.

Default Settings

b)

commands on the default Ribbon tabs are related in functionality.

2.

Group

c)

Files that already include formatting and formulas complete with designs, tools, and specific data types.

3.

Templates

d)

an equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.

4.

Formula

e)

e a number, a cell address, a date, text, or Boolean data, but is usually a number or cell address in terms of formulas.

5.

Value

7.

Match the following

a)

identify the values to be used in the calculation.

1.

Operands

b)

a number or text value that is entered directly into a formula.

2.

Constant

c)

a symbol or name that represents something else, which can be a cell address, a range of cells, and so on.

3.

Variable

d)

specify the calculations to be performed.

4.

Calculation Operators

e)

Excel follows a specific order to calculate the formula.

5.

Order of Operations

8.

Match the following

a)

Parentheses inside of parentheses

1.

Nested Parentheses

b)

identifies a cell’s location in the worksheet, based on its column letter and row number.

2.

Cell Reference

c)

one that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.

3.

Relative Cell Reference

d)

a specific cell or range of cells regardless of where the formula is located in the worksheet.

4.

Absolute Cell Reference

e)

a cell reference that uses an absolute column or row reference, but not both.

5.

Mixed Cell Reference

9.

Match the following

a)

a cell or range in a worksheet in another Excel workbook, or to a defined name in another workbook.

1.

External Reference

b)

s a group of cells, and occasionally a single cell, with a designated name.

2.

Named Range

c)

a name is the location within which Excel recognizes the name without qualification.

3.

Scope

d)

moved) data is removed from the worksheet but is still available for you to use in multiple locations.

4.

Cut

e)

nclude items you directly change such as keywords.

5.

Workbook properties

10.

Match the following

a)

e

1.

e

b)

w

2.

w

c)

q

3.

q

d)

y

4.

y

e)

i

5.

i