Category 1
I just uploaded the payoff. What do you do next?
Update the Approval Worksheet - "Last Mortgage Payment"
To put in order.
Sort
The rectangular fields you can type in on a spreadsheet formed when a column intersects with a row.
Cell
Information at the top margin of a page that is repeated on every page like a book title or author name or page number.
Header
A formula or equation use to generate an answer.
Function
Just uploaded the payoff and change the worksheet, what comes next?
Upload to title via integration.
A cool way to representing your information -- organization charts, flow charts, Venn diagrams, pyramids, etc.
Smart Art
A tool which fills in a field or cells automatically.
Autofill
To remove unwanted pieces of data from view in a table.
Filter
A file format that provides an electronic image of text or text and graphics that looks like a printed document and can be viewed, printed or emailed.
A spreadsheet cell that does not change regardless of its attributes.
Absolute Value
A part/page on an excel spreadsheet file you are working in.
Worksheet
To format data in such a way that it can be used by another application.
Export
The horizontal space at the top of the window that organizes commands on tabs, and then groups the commands by topic. It’s where all of your tabs and menus are.
Ribbon
Use this Gallery to create, store, and find reusable pieces of content, including AutoText, document properties such as title and author, and fields.
Quick Parts
The entire Excel spreadsheet file you are working in, it can contain one or more worksheets
Workbook
Also known as comments, these are notes other people can leave you on your document.
Markup
Shows buttons to perform frequently used commands with a single click.
Quick Access Toolbar
Where you manage your slideshow’s data and information— create, save, and send documents, inspect documents for hidden stuff or personal information and set options such as turning on or off AutoComplete.
Backstage
Premade text, SmartArt, chart, table or image formatting so you can make objects look good quickly and easily
Styles
A function that tallies how many cells contain a value that meets a specific criterion.
Countif
A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on.
Relative Value
Apply a format to a cell or a range of cells based on certain criteria
Conditional Formatting
A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes.
Sparklines
To combine strings of text, usually used when combing a last name and first name in 2 separate cells into one full name in one cell.
Concatenate