WorksheetsExcel Key terms published
Total questions: 10
Worksheet time: 30mins
Match the following
displays across the top of the window.
Ribbon
Ribbion is organized into these tabs
command tabs
The tabs are divided in these groups.
Command groups
Also known as a spreadsheet is imagined as a physical book with many pages.
Workbook
Sheet1) by default—similar to the first page in a book—where you enter information
Worksheet
starts at the top of the worksheet and goes to the bottom of the worksheet and is identified by a letter.
Column
starts at the left edge of the worksheet and continues to the right edge and is identified by a number
Row
on the grid is identified by the intersection of a column and a row.
Cell
You enter information by typing it into it.
Active Cell
gives you fast and easy access to the tools you use most often in any given Excel session.
Quick access bar
which are small, onscreen boxes that display descriptive text when you rest the pointer on a command or control.
Screen Tips
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.
Name box
takes the information from one location and duplicates it.
Copy
to put this information into another location.
Paste
located between the Ribbon and the worksheet.
Formula bar
you highlight the text that is to be changed.
Selecting Text
options that automatically fill cells with data and/or formatting.
Auto Fill
a small green square in the lower-right corner of a selected cell or range of cells.
Fill Handle
a group of adjacent cells that you select to perform operations on all of the selected cells.
Range
a formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
Natural Series
Another time-saving option for filling in data
Flash Fill
(arrow with a plus), you can drag the cell or range of cells to the new location
Copy Pointer
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.
Office Clipboard
you can drag the cell or range of cells to a new location.
Move Pointer
insert) selected items from the Clipboard to a new location in the worksheet.
Paste
pre-set options that determine how Excel will behave when performing an action.
Default Settings
commands on the default Ribbon tabs are related in functionality.
Group
Files that already include formatting and formulas complete with designs, tools, and specific data types.
Templates
an equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
Formula
e a number, a cell address, a date, text, or Boolean data, but is usually a number or cell address in terms of formulas.
Value
identify the values to be used in the calculation.
Operands
a number or text value that is entered directly into a formula.
Constant
a symbol or name that represents something else, which can be a cell address, a range of cells, and so on.
Variable
specify the calculations to be performed.
Calculation Operators
Excel follows a specific order to calculate the formula.
Order of Operations
Parentheses inside of parentheses
Nested Parentheses
identifies a cell’s location in the worksheet, based on its column letter and row number.
Cell Reference
one that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
Relative Cell Reference
a specific cell or range of cells regardless of where the formula is located in the worksheet.
Absolute Cell Reference
a cell reference that uses an absolute column or row reference, but not both.
Mixed Cell Reference
a cell or range in a worksheet in another Excel workbook, or to a defined name in another workbook.
External Reference
s a group of cells, and occasionally a single cell, with a designated name.
Named Range
a name is the location within which Excel recognizes the name without qualification.
Scope
moved) data is removed from the worksheet but is still available for you to use in multiple locations.
Cut
nclude items you directly change such as keywords.
Workbook properties
e
e
w
w
q
q
y
y
i
i
