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