Excel Exam 1 Tutorials 1-5
RGB Color model
A format used to create custom colors by specifying varying intensities of red, green, and blue
worksheet
A grid of rows and columns in which content is entered
Cell range (range)
A group of cells in a rectangular block
spreadsheet
A grouping of text and numbers in a rectangular grid or table
keyboard shortcut
A key or combination of keys that you press to access a feature or perform a command
legend
A key that identifies the colors or the shapes used in a worksheet or a chart
Border
A line you can add along an edge of cell that prints
shortcut menu
A list of commands related to a selection that opens when you click the right mouse button
formula
A mathematical expression that returns a value
Operator
A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell
gallery
A menu or grid that shows a visual representation of the options available or the selected button
function
A named operation that replaces the action of an arithmetic expression in a formula
automatic page break
A page break Excel sets automatically when the page of the printout is full
manual page break
A page break you insert to indicate where a new page of the printout should start
sheet
A page included in a workbook; can be a worksheet or a chart sheet
template
A preformatted workbook with many design features and some content already filled in
Live Preview
A preview of how a workbook would be affected by an option in a gallery
planning analysis sheet
A series of questions that help you think about a workbook's purpose and how to achieve your desired results
text string
A series of text characters
font
A set of characters that employ the same typeface, such as Arial, Times New Roman, and courier
order of operations
A set of predefined rules used to determine the sequence in which operators are applied in a calculation
Syntax
A set of rules that specifies how a function should be written
Chart sheet
A sheet that contains only a chart that provides a visual representation of worksheet data
pixel
A single point on a computer monitor or printout
Clipboard
A temporary storage location for text and graphics
Mini toolbar
A toolbar that contains buttons to perform common formatting options for a selection
point
A unit of measure equal to approximately 1/72 of an inch
date data
A value in a recognized date format
time data
A value in a recognized time format
Microsoft Excel 2013 (Excel)
An application used to enter, analyze, and present quantitative data
status bar
An area at the bottom of the Excel window that provides information about the workbook.
arithmetic operator
An operator that performs addition, subtraction, multiplication, division, or exponentiation
text data
Any combination of letters, numbers, and symbols
numeric data
Any number that can be used in a mathematical calculation
formatting
Changes to a worksheet's appearance to make its content easier to read
font style
Formats that can applied to a font such as italic, bold, bold italic, underline, strikethrough, and color
conditional format
Formatting applied to a cell when its value meets a specified condition
Currency format
The number format that places a currency symbol directly to the left of the first digit of the currency value, adds a thousands separator to the value, and shows two decimal places; lines up numbers within a column by their decimal points; negative numbers are displayed with a negative sign
General format
The number format that, for the most part, displays values exactly as they are typed
Normal view
The Excel view that shows the contents of the active sheet in the workbook window
Page Break Preview
The Excel view that shows the location of page breaks in the printed sheet
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
sheet tab
The area at the bottom of the worksheet that identifies the sheet by name
workbook window
The area of the Excel window that displays the contents of the workbook
formula bar
The bar located below the ribbon that displays the value or formula entered in the active cell
Name box
The box located at the left side of the formula bar that displays the cell reference of the active cell
Maximize button
The button that expands a window to fill the screen
Minimize button
The button that hides a window so that only its program button is visible on the taskbar
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
Restore Down button
The button that returns a window to its previous size
active cell
The cell currently selected in the active worksheet
range reference
The cell reference of the upper-left cell in the range and the cell reference of the lowerright cell separated by a colon that identifies the range
row headings
The numbers along the left side of the workbook window that identify the different rows of the worksheet
Cell reference
The column and row location that identifies a cell within a worksheet
Zoom controls
The controls that increase or decrease the magnification of the worksheet content
AutoFit
The feature that changes the column width or row height to display longest or tallest entry within the column or row
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
Flash Fill
The feature that enters text based on patterns it finds in the data
SUM
The function that adds values in a specified range
Cell
The intersection of a row and a column
column headings
The letters along the top of the worksheet window that identify the different columns in the worksheet
ribbon
The main set of commands organized into tabs and groups with buttons that you click to execute commands
Edit mode
The mode in which you can edit cell contents
Percent style
The number format for percentages that adds the % symbol after the number and no decimal places
Comma style
The number format that adds a thousands separator to numbers, adds two decimal places, and lines up values within a column by their decimal points
Accounting format
The number format that places a currency symbol at the left edge of the column, adds a thousands separator to the value, and shows two decimal places; lines up numbers within a column by their currency symbols and decimal points; negative numbers are enclosed in parentheses
Format Painter
A feature that copies and pastes formatting from one cell or range to another without duplicating any data
sans serif font
A font that does not include extra strokes, such as Arial
serif font
A font that has extra strokes at the end of each character, such as Times New Roman
Long Date format
A format for dates that displays the day of the week and the full month in addition to the day of the month and the year
Short Date format
An abbreviated format for dates in the format mm/dd/yyyy
non-theme font
A font that is not associated with a particular theme; non-theme fonts retain their appearance no matter what theme is used with the workbook
fill color
A background color that can be added to cells to help differentiate parts of a worksheet or highlight data
ScreenTip
A box with descriptive text about a command that appears when you point to a button on the ribbon
Quick Analysis tool
A button that appears whenever you select a range of cells, providing access to the most common tools for data analysis and formatting for the selected range
group
A collection of buttons for related commands on a ribbon tab
nonadjacent range
A collection of separate ranges
cell highlighting
A conditional format that changes a cell's font color or fill color based on the cell's value
workbook
An Excel file that stores a spreadsheet; contains a collection of worksheets and chart sheets
Average function
An Excel function that calculates the average value from a collection or numbers
footer
Information that appears at the bottom of each printed page
header
Information that appears at the top of each printed page
print title
Information that appears on every printed page; specified as rows or columns to repeat on the top or left of each page
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
cell style
Predefined formatting options that you can apply to cells in a worksheet
Page Layout view
The Excel view that shows how the sheet will appear when printed
portrait orientation
The page orientation where the page is taller than it is wide
landscape orientation
The page orientation where the page is wider than it is tall
Tab
The part of the ribbon that includes commands related to particular activities or tasks
print area
The range or ranges in a worksheet that you specify to be printed
active sheet
The sheet currently displayed in the workbook window.
font size
The size of text
margin
The space between the page content and the edges of the page
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
scale
To change the size of the worksheet on the printed page
merge
To combine, such as several cells into one cell
hide
To make a row, column, or worksheet not visible
unhide
To redisplay a hidden row, column, or worksheet
delete
To remove the data from a row or column as well as the row or column itself
clearing
To remove the data from a row or column but leaves the blank row or column in the worksheet