PREMIUM LOGIN

ClassTools Premium membership gives access to all templates, no advertisements, personal branding and other benefits!

Username:    
Password:    
Submit Cancel

 

Not a member? JOIN NOW!  

QR Challenge: Excel Vocabulary Part 2

QuestionAnswer
Absolute cell reference - A cell reference that does not change when copied or moved to a new cell
Argument - The value the function uses to perform a calculation, including a number, text, a cell reference, or even a formula that acts as an operand
Automatic page break - Excel inserts this whenever it runs out of room on what would be a printed page
Chart - A graphical representation of data
Conditional formatting - Highlights worksheet data by changing the look of cells that meet a specified condition you create
Fill (2nd Meaning) - Copies a cells contents (any numbers, text, or formulas) and formatting into an adjacent cell or range
Fill handle - The little box that appears in the lower-right corner of the active cell or range, and is used to fill cells
Freeze pane - Rows and/or columns you select to remain visible on the screen as the rest of the worksheet scrolls in the window
Function - Shorthand way to write an equation that performs a calculation. For example the SUM function is used to make adding a range easier
Manual calculation - Lets you determine when Excel calculates the formulas
Manual page break - A page break you insert manually to start a new page
Mixed cell reference - Cell references that contain both relative and absolute column or row references
Operand - A constant (text or number) or cell reference used in a formula. For example in 8 + 2, the 8 and 2 are the operands
Operator - A symbol that indicates the type of calculation to perform on operands. For example, in 8 + 2, the + is the operator
Order of evaluation - The sequence used to calculate the value of a formula – exactly the same as order of operation in math
Page Break Preview - View that shows where the page breaks are in a worksheet, which is helpful when you prepare a worksheet for printing
Point-and-click method - Allows you to point and click (or touch) each cell in a formula rather than typing out cell references
Print area - Consists of the cells and ranges you can designate for printing and does not have to be the entire spreadsheet
Print title - Rows and/or columns in a worksheet that you assign to print on each page
Relative cell reference - A cell reference that changes by adjusting to its new location when copied or moved
Scale - Enables you to resize a worksheet to print on a specific number of pages
Sort - Rearranging the data in a spreadsheet in a more meaningful order. For example, putting a range in alphabetical order
Split - Divides the worksheet window into two or four panes that you can scroll and work in independently from one another
Sum button - The button at the top right of the Home tab that makes using functions to write formulas much easier to do

Back