Study sets, textbooks, questions
Upgrade to remove ads
Tutorial 1 - 3
Definitions and Key Terms
Terms in this set (147)
Microsoft Excel 2010
A computer program used to enter, analyze, and present quantitative data.
Spreadsheets stored in files. The contents are shown shown in a workbook window.
Displays the cell reference of the active cell.
Select All Button
Used to select all of the cells in the active worksheet.
The numbers along the left side of the worksheet window that identify the different rows in the worksheet. You click a row heading to select the entire worksheet row.
Sheet Tab Scrolling Buttons
Scroll the list of sheet tabs in the worksheet.
The sheet currently displayed in the workbook window. Its sheet tab is whiite.
Displays the value or formula entered in the active cell.
A workbook is made up of these, individually.
This sheet is identified by a sheet name.
Displays the value or formula entered in the active cell.
The intersection of a row and column.
The cell currently selected in the active worksheet. Outlined with a thick border and the corresponding row and column headings are highlighted.
Increase or decrease the display of content in the worksheet.
The letters along the top of the worksheet window that identify the different columns in the worksheet. You click a letter to select the entire column.
Displays the contents of the spreadsheet laid out in a grid of rows and columns.
A collection of text and numbers laid out in a rectangular grid.
Changes one or more values in a spreadsheet and then asses the effect those changes have on the calculated values.
Contains an Excel chart that provides a visual representation of worksheet data.
What each cell within a worksheet is identified by, and indicates its column and row location.
Up, Down, Left, or Right Arrow Keys on the D-Pad.
Up, down, left, or right one cell.
To column A of the current row.
To cell A1.
To the last cell in the worksheet that contains data.
Down one row or to the start of the next row of data.
Up one row.
One column to the right.
One column to the left.
Page Up or Page Down Key
Up or down one screen.
Ctrl+Page Up or Ctrl+Page Down Key
To the previous or next sheet in the workbook.
Any combination of latters, numbers, and symbols that form words and sentences.
Any numerical value that can be used in a mathematical calculation.
Date and Time Data
Any commonly recognized formula formats for date and time values.
Excel anticipating the remaining characters by by displaying text that begins with the same letters as a prvious entry in the same column. Helps make entering repetative text easier.
A single point on a computer monitor kor printout.
The height of an excel row is measured in _ _ _ _ _ _ or pixels. _ _ _ _ _ _ is approximately 1/72 of an inch. Aka a pixel.
Eliminates empty space by matching the row height or column width to its tallest or longest cell entry.
Removes the data, leaving blank cells where the data had been in the worksheet..
Removes both the data and the cells from the worksheet.
Verifies the words in the active worksheet against the program's dictionary.
Opens backstage view, which provides access to commands for saving and printing the workbook or worksheet.
Cell Range or "Range"
A group of cells. Can either be adjacent or nonadjacent.
Indicates whether you are in Ready Mode or Edit Mode.
Renaming the Worksheet Tab
Renaming the tab with a breif description of its contents or purpose.
Insert Worksheet Tab
Inserts a new worksheet and respective tab at the end of the workbook.
Page Layout Tab
Provides commands to change the way worksheets appear on printed pages. Has options you can use define print formatting.
An expression that returns a value.
Two or more distinct adjacent ranges.
A group of cells in a singular rectangular block of cells.
Change how the worksheet content is displayed (Normal View, Print Layout View, or Page Break Preview).
Aka AutoSum Button. Inserts Excel functions to Sum, Average, or Count all the values in the in a column or row, as well as display the Minimum or Maimum value in a column or row.
Indicates the location and size of a cell range.
Hint: Just as a cell reference indicates the location of an individual worksheet cell.
Drag and Drop
Select a cell or range, position the pointer over the bottom border of the selection to a new location.
Places the cell contents into computer memory or on the Clipboard. Contents can then be pasted from the Clipboard into a new location in the worksheet.
Used when writting a formula. The combined different values, resulting in a single value that is then displayed within the cell.
Performs addition, subtraction, multiplication, division, and exponentation.
Order of Precedence
A set of predefined rules used to determine the sequence in which operators are applied in a calculation.
The mode in which you can cell contents.
Using the Find Commmand to search a string of characters.
In a Search String, replacing the search string characters with new text characters.
A view used to show the contents of the entire workksheet.
Page Layout View
A view showing how the worksheet will appear when printed.
Page Break Preview
A view displaying the location of of the different page breaks within the worksheet.
The page is taller than it is wide.
The page is wider than it is tall.
A view of the worksheet contents that displays formulas instead of the resulting values.
Scaling a Printout
Reduces the width and the height of the printout to fit the number of pages (or percentage) you specify by shrinking the text size as needed.
Copies and pastes formatting from one cell or range to another without duplicating any data.
The specific design of a set of characters, including letters, numbers, punctuation marks, and symbols.
The process of changing a workbook's appearance by defining the fonts, styles, colors, and decorative features. Any text that can be changed to italic, bold or bold italic, and special effects such as underline, strikethrough, and color.
Adds a thousands seperator and two decimal places to the right of the decimal point, and lines up values by their decimal points.
A set of characters that employ the same typeface, such as Ariel, Times New Roman, and Courier.
Lines up curraency values by their currency symbol and decimal point.
Has buttons for setting the horizontal and vertical alignment, the orientation, indents, and text wrapping of text in a cell, as well as merging cells.
Combining several cells into one cell.
Background color; can be added to cells to help differentiate parts of a worksheet or highlight data.
Formats numbers with the % symbol after and two digits to the right of the decimal point.
A line you add along an edge of a cell to improve readability of the data.
Associated with a particular theme and used for heading and body text in the workbook.
Not applying a font associated with a particular design. Retains its appearance no matter what theme is used with the workbook.
A font, such as Times New Roman, that has extra decorative strokes at the end of each character.
Sans Serif Fonts
A font, such Arial, does not include extra decorative strokes at the end of each character.
A collection of formats for text, colors, images, and graphical effects applied throughout a workbook.
The 12 colors that belong to the workbook's theme.
Each theme has five variations in which a different tint or shading is applied to the theme color.
Dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple are always available regardless of the workbook's theme.
Specifying a mixture of red, blue, and green color values, making available 16.7 million custom colors.
Some dialog boxes have an option that uses your Windows default text and background colors, usually black text while on a white brackground.
Displays the values in a way that makes it easy for the reader to quickly understand and interpret them.
General Number Format
Excel formats numbers by default, which, for the most part, displays values exactly as they are typed by the user.
Merge & Center
Merges the range into one cell and horizontally centers the content.
Merges each of the rows in the selected range across the columns in the range.
Merges the range into a single cell, but does not horizontally center the cell content.
Reverses a merge, returning the merged cell back into a range of individual cells.
Provides options for formatting the appearance of numbers, including dates and numbers treated as text.
Provides options for how data is aligned within a cell.
Provides options for selecting font types, sizes, styles, and other formattting attributes such as underlining and font colors.
Provides options for adding and removing cell borders as well as selecting a line style and color.
Provides options for creating and applying background colors and patterns to cells.
Provides options for locking or hiding cells to prevent other users from modifying their contents.
Information that appears in the top margin of each printed page.
Set of information that appears on every printed page, by specifying rows or columns to repeat on the top or left of each page.
Banded Rows or Columns
Displays alternate rows or columns in an Excel table with different fill colors.
Information that appears in the botttom margin of each printed page.
Cell Styles Button
You can apply a collection of common formats, called a style, to different cells.
Table Tools Tab
Appears when an Excel table is selected. The optional elements can be added or removed from a Table Style Options Group.
After identifying a range as an Excel Table this "style" formats the entire table as a single unit.
The space between the page content and the edges of the page.
Applies formatting only whe a cell's value meets a specified condition. This is often used to help analyze data.
Treating a range of data distinct object in a worksheet. The entire table is formmated using a single table style.
Formats the first row of the table.
Inserts a new row at the bottom of the table that adds the column values.
Formats the first column of the table.
Formats the last column of the table.
Formats alternating rows in different colors.
Formats alternating columns in different colors.
Greater than Rule
Cells that are greater than a specified number.
Less than Rule
Cells that are less than a specified number.
Cells that are between two specified numbers.
Equal to Rule
Cells that are equal to a specifed numer.
Text that Contains Rule
Cells that contain specified text.
A Date Occurring Rule
Cells that contain a specified date.
Duplicate Values Rule
Cells that contain duplicate or unique values.
A key that shows each color used in the worksheet and what it means, so others know why certain cells are highlighted.
The region that is sent to the printer from the active sheet .
Automatic Page Breaks
A page break Excel inserts automatically after fitting as much of the content on single page as possible without resizing the text.
Manual Page Breaks
Specifies where exactly the page breaks occur.
Insert Function Button
Opens the Insert Function dialog box from which you can select a function.
Remains fixed when the cell formula is copied to a new location, and has $ in front of the column letter and the row number.
Is interpreted in relation to the location of the cell containing the formula.
In bold, are needed for the function to return a value.
Are the numbers, text, or cell references used by the function to return a value.
Not required for the function to return a value.
Returns the sum of the values in the range.
Returns the minimum value in the range.
Returns the average value in the range.
Returns the maximum value in the range.
Contains an absolute row or an absolute column.
Placing a function inside of another function.
A function that works with statements that are either true or false.
A function related to monetary calculations, such as loans and payments.
A function that inserts or calculates dates and times.
A logical function that tests a condition and then returns one value if the condotion is true and another if the condition is false.
A financial function that calculates the monthly payment required to pay back a loan.
Calculates the amount of a monthly loan payment, based on rate (the interest rate per month), nper (the total number of months per to pay back the loan), and pv (the present value of the loan).
Copies content and formats from a cell or range into am adjacent cell or range.
Appears in the lower-right corner of a selected cell or range. Click and drag over an adjacent cell or range copies the content and formatting from the original cells into the selected range.
Rate, nper, pmt, [pv=0] [,type=0]
Calculates the future value of an investment, where rate is the interest rate per period, nper is is the total number of periods, pmt is the payment ini each period, pv is the present value of the investment, and type indicates whether payments should be made at the end of the period (0) or the beginning of the period (1).
Sets found in the same folder
Excel Tutorial 3
Practice Test 2- AGRI
Sets with similar terms
Excel Exam 1
Spreadsheet Terms 2012
Excel 2016 Vocabulary
Other sets by this creator
MAN 3025 UCF Clevenger Ch. 12
Financial Accounting II - Ch. 19 - 21
INTRO/ CHAPTER 1
MKT 315 Final Exam Worksheet
Other Quizlet sets
Basic parts of a word window
14 parts of the word window
My Spreadsheet Skills Vocabulary