I Hate CBT's

View Original

Microsoft Excel Vocab

absolute value a spreadsheet cell that does not change regardless of its attributes

autofill a tool which fills in a field or cells automatically

backstage 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

cell the rectangular fields you can type in on a spreadsheet formed when a column intersects with a row

cell reference refers to a cell or range of cells on a worksheet and can be used in a formula so that Excel can find the values or data that you want that formula to calculate

CONCATENATE to combine strings of text, usually used when combining a last name and first name in 2 separate cells into one full name in one cell

conditional formatting apply a format to a cell or range of cells based on certain criteria

COUNTIF a function that adds how many cells contain a value that meets a specific criteria

Export to format data in such a way that it can be used by another application

Filter to remove unwanted pieces of data from view in a table

Function a formula or equation used to generate an answer

Header any information at the top margin of a page that is repeated on every page like a book title or author name or page number

Markup Also known as comments, these are notes other people can leave you on your document

Merge to combine into one

PDF 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

Quick Access Toolbar Shows buttons to perform frequently used commands with a single click

Quick Parts Use this gallery to create, store, and find reusable pieces of content, including AutoText, document properties such as title and author, and fields

Relative value A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on

Ribbon 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.

SmartArt A cool way to represent your information -- organization charts, Venn diagrams, pyramids, etc.

Sort to put in order

Sparklines a small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes

Styles Pre-made text, SmartArt, chart, table, or image formatting so you can make objects look good quickly and easily

Workbook The entire Excel spreadsheet file you are working in, it can contain one or more worksheets (think of it as a book made up of sheets of paper)

Worksheet A part/page on a excel spreadsheet file you are working in (think how many sheets make up a book)