New Perspectives Excel 2013
Tutorial 1: Getting Started with Excel
Key Terms
active cell The cell currently selected in the active worksheet. (EX 2)
active sheet The sheet currently displayed in the workbook window. (EX 2)
arithmetic operator Anoperator that performs addition, subtraction, multiplication, division, or exponentiation. (EX 32)
AutoComplete The feature that displays text that begins with the same letters as a previous entry in the same column to help make entering repetitive text easier. (EX 20)
AutoFit The feature that changes the column width or row height to display longest or tallest entry within the column or row.(EX 27)
AutoSum The button that inserts functions to sum, average, or count values in a range, or find the minimum or maximum value in a range.(EX 31)
Backstage viewThe FILE tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options. (EX 4)
border A line you can add along an edge of cell that prints. (EX 30)
cell The intersection of a row and a column. (EX 3)
cell range (range) A group of cells in a rectangular block. (EX 2)
cell reference The column and row location that identifies a cell within a worksheet. (EX 9)
chart sheet A sheet that contains only a chart that provides a visual representation of worksheet data. (EX 7)
clearingTo remove the data from a row or column but leaves the blank row or column in the worksheet. (EX 45)
Clipboard A temporary storage location for text and graphics. (EX 35)
column headings The letters along the top of the worksheet window that identify the different columns in the worksheet. (EX 3)
date data A value in a recognized date format. (EX 17)
deleteTo remove the data from a row or column as well as the row or column itself. (EX 45)
drag and drop The technique to move a cell or range by selecting it, dragging the selection by its bottom border to a new location, and then releasing the mouse button to drop the selection in the new location. (EX 40)
Edit mode The mode in which you can edit cell contents. (EX 19)
Flash FillThe feature that enters text based on patterns it finds in the data. (EX 48)
formattingChanges to a worksheet’s appearance to make its content easier to read. (EX 49)
formulaA mathematical expression that returns a value. (EX 31)
formula bar The bar locatedbelow the ribbon thatdisplays the value or formula entered in the active cell. (EX 2)
font size The size of text. (EX 30)
functionA named operation that replaces the action of an arithmetic expression in a formula. (EX 31)
groupA collection of buttons for related commands on a ribbon tab. (EX 3)
hideTo make a row, column, or worksheet not visible. (EX 48)
keyboard shortcut A key or combination of keys that you press to access a feature or perform a command. (EX 6)
Key Tips Labels that appear over each tab and command on the ribbon when you press the Alt key that specify the key or keys to click to access that tab, button, or command. (EX 6)
landscape orientation The page orientation where the page is wider than it is tall. (EX 53)
Maximize button The button that expands a window to fill the screen.(EX 3)
Microsoft Excel 2013 (Excel)An application used to enter, analyze, and present quantitative data. (EX 1)
Minimize button The button that hides a window so that only its program button is visible on the taskbar.(EX 3)
Name box The box located at the left side of the formula bar thatdisplays the cell reference of the active cell. (EX 2)
nonadjacent range A collection of separate ranges. (EX 2)
Normal view The Excel view that shows the contents of the active sheet in the workbook window. (EX 31)
numeric data Any number that can be used in a mathematical calculation. (EX 17)
operatorA mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell. (EX 32)
order of operationsA set of predefined rules used to determine the sequence in which operators are applied in a calculation. (EX 32)
Page Break Preview The Excel view that shows the location of page breaks in the printed sheet. (EX 31)
Page Layout view The Excel view that shows how the sheet will appear when printed. (EX 31)
pixelA single point on a computer monitor or printout. (EX 25)
planning analysis sheet A series of questions that help you think about a workbook’s purpose and how to achieve your desired results. (EX 13)
pointA unit of measure equal to approximately 1/72 of an inch. (EX 28)
portrait orientation The page orientation where the page is taller than it is wide. (EX 53)
range reference The cell reference of the upper-left cell in the range and the cell reference of the lower-right cell separated by a colon that identifies the range. (EX 11)
Restore Down buttonThe button that returns a window to its previous size.(EX 3)
ribbonThe main set of commands organized into tabs and groups with buttons that you click to execute commands.(EX 2)
row headings The numbers along the left side of the workbook window that identify the different rows of the worksheet. (EX 2)
scaleTo changethe size of the worksheet on the printed page. (EX 54)
ScreenTip A box with descriptive text about a command that appears when you point to a button on the ribbon.(EX 6)
sheetA page included in a workbook; can be a worksheet or a chart sheet. (EX 2)
sheet tab The area at the bottom of the worksheet that identifies the sheet by name. (EX 2)
shortcut menu A list of commands related to a selection that opens when you click the right mouse button. (EX 17)
spreadsheetA grouping of text and numbers in a rectangular grid or table. (EX 4)
status barAn area at the bottom of the Excel window that provides information about the workbook. (EX 2)
SUM The function that adds values in a specified range. (EX 31)
syntaxA set of rules that specifies how a function should be written. (EX 36)
tabThe part of the ribbon that includes commands related to particular activities or tasks. (EX 2)
templateA preformatted workbook with many design features and some content already filled in. (EX 4)
text data Any combination of letters, numbers, and symbols. (EX 17)
text string A series of text characters (EX 17)
time data A value in a recognized time format. (EX 17)
Touch Mode The mode for use with a touchscreen; changesthe ribbon to make it easier to use a finger or a stylus to tap a button. (EX 6)
unhideTo redisplay a hidden row, column, or worksheet. (EX 48)
workbook An Excel file that stores a spreadsheet; contains a collection of worksheets and chart sheets. (EX 2)
workbook window The area of the Excel window that displays the contents of the workbook. (EX 3)
worksheetA grid of rows and columns in which content is entered. (EX 3)
Zoom controls The controls that increase or decrease the magnification of the worksheet content. (EX 3)