Module 1Excel Definitions Flashcards
Learn Excel Definitions
active cell
The cell currently selected in the active worksheet.
active sheet
The sheet currently displayed in the workbook window.
arithmetic operator
A mathematical symbol representing the operations of addition, subtraction, multiplication, division, or exponentiation.
AutoComplete
The feature that helps make entering repetitive text easier; as you type text into the active cell, Excel displays text that begins with the same letters as a previous entry in the same column.
AutoFit
The Excel feature that changes the column width or row height to display its longest or tallest entry within the column or row.
AutoSum
A button that inserts Excel functions to sum, average, or count all the values in a range, or find the minimum or maximum value in a range.
Backstage view
The File tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options.
border
A line added along the edge of a cell to improve the readability of the worksheet. (EX 30)
cell
The intersection of a single row and a single column.
cell range (or range)
A group of cells in a rectangular block, which can be either adjacent or nonadjacent.
cell reference
The column and row location that identifies a cell within a worksheet.
chart sheet
A sheet that contains only a chart that provides a visual representation of worksheet data.
clear
To remove data from selected cells, but leave the blank cells in the worksheet.
column headings
The letters along the top of the worksheet window that identify the different columns of the worksheet.
date data
A value in a recognized date format.
drag and drop
The technique to move a cell or range by selecting it, positioning the pointer over the bottom border of the selection, and then dragging the selection to a new location
Edit mode
The mode in which you can edit cell contents.
delete
To remove both the data and the selected cells from the worksheet.
Excel
A spreadsheet program used to enter, analyze, and present quantitative data.
Flash Fill
The Excel feature that enters text based on patterns in the data.
font size
A measurement of the size of text.
formatting
A process by which a workbook’s appearance is changed to make it easier to read.
formula
A mathematical expression that calculates a value.
formula bar
The bar located below the ribbon that displays the value or formula entered into the active cell.
function
A named operation that replaces the action of an arithmetic expression
group
A part of an Excel ribbon that organizes related commands within a particular tab.
keyboard shortcut
A key or combination of keys that you press to access a feature or perform a command.
landscape orientation
The page orientation where the page is wider than it is tall.
Maximize button
A button that expands the Excel window to fill the screen.
Microsoft Excel 2016 (Excel)
A spreadsheet program used to enter, analyze, and present quantitative data.
hide
A process by which a row or column is removed from a worksheet by essentially decreasing its height or weight to 0 pixels.
Minimize button
A button that hides the Excel window so that only its program button is available on the taskbar.
Name box
The box located at the left side of the formula bar that displays the cell reference of the active cell.
nonadjacent range
Two or more adjacent ranges that are not connected.
Normal view
The Excel view that shows the contents of the active sheet in the workbook window.
numeric data
Any number that can be used in a mathematical calculation.
operator
A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell.
order of operations
The sequence in which operators are applied in a calculation.
Page Break Preview
The Excel view that shows the location of page breaks in the printed sheet.
Page Layout view
The Excel view that shows how the sheet will appear when printed.
Page orientation
The direction in which content is printed.
portrait orientation
The page orientation where the page is taller than it is wide.
range
A group of cells in a rectangular block, which can be either adjacent or nonadjacent.
range reference
The cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a colon.
ribbon
The part of the Excel window containing buttons you click to execute Excel commands.
Ribbon Display Options button
A button used to display all, part, or none of the ribbon.
row headings
The numbers along the left side of the worksheet window that identify the different rows in the worksheet.
scale
To change the size of the worksheet on the printed page.
ScreenTip
A box with descriptive text about a command.
sheet
An individual page within a workbook.
sheet tab
The area at the bottom of the worksheet window that identifies the sheet by name.
shortcut menu
A list of commands related to a selection that opens when you click the right mouse button.
spreadsheet
A grouping of text and numbers in a rectangular grid or table.
status bar
The part of the Excel window that provides information about the workbook.
SUM function
An Excel function that adds the values in a specified range.
syntax
A set of rules that specifies how a function should be written.
tab
The part of the Excel ribbon containing commands related to particular activities or tasks.
Tell me what you want to do box
An Excel feature that provides quick access to commands and online help.
text data
Any combination of letters, numbers, and symbols.
text string
A series of text characters.
time data
A value in a recognized time format.
unhide
A process by which a hidden row or column is redisplayed.
workbook
An Excel file containing a collection of worksheets and chart sheets.
workbook window
The Excel window containing the contents of the worksheet
worksheet
A grid of rows and columns in which the contents of the spreadsheet are laid out.
Zoom controls
Excel workbook controls that increase or decrease the magnification of the worksheet content.