Module 1.1
Module 1.2
Module 2.1
Module 2.2
Terms and Definitions
100

This is the default text alignment in a cell.

What is: Left 

100

This function will add together contents from multiple cells.

What is: the SUM function

100

This type of color option is available by default based on the Theme of the workbook.

What is: a Theme Color

100

This handy option allows for the copying and pasting of Formats from one or more cells.

What is: the Format Painter

100

This label describes the column and row in which a cell is located.

What is: a Cell Reference

200

This diverse menu at the top of the Excel application goes by a name normally associated with decorations.

What is: The Ribbon

200

This function will count the number of numeric values in a range.

What is: the COUNT function

200

This type of formatting error occurs if the contents of a cell are too wide to fit on the screen.

What is: the ###### (hashtag) error

200

This common function allows for finding the mean of a collection of numbers.

What is: the Average Function

200

This type of sheet contains only a chart that is linked to data within a workbook.

What is: a Chart Sheet

300

This term is often used when referring to an entire Excel document.

What is: A Workbook

300

This type of argument in a function is surrounded by brackets.

What is: an Optional Argument

300

From a File, Bing, and OneDrive are all methods of selecting and inserting this item into a worksheet.

What is: a Background Image

300

This tool appears whenever you select a range of cells and provides access to the most common tools for data analysis and formatting.

What is: the Quick Analysis Tool

300

This method of editing a worksheet involves changing its font, size, color, or alignment.

What is: Formatting

400

This keyboard shortcut is used for Pasting content in Excel.

What is: CTRL+V

400

This flashy feature allows for instant entering of text based on patterns in the data.

What is: Flash Fill

400

This term refers to the 10 colors always available regardless of a workbook's theme.

What are: Standard Colors

400

The default theme applied to a new workbook.

What is: the Office Theme

400

The method of resizing a worksheet to fit within a single page or set of pages is referred to by this name.

What is: Scaling

500

A person needing to save or print their document may want to visit this behind-the-scenes view in Excel.

What is: The Backstage View

500

This is the way that page breaks are indicated in Page Break Preview.

What is: a Dotted Blue Border (or Line)

500

This group on the Ribbon contains options such as Accounting Number Format, Percent Style, and Increase/Decrease decimal.

What is: the Number Group

500

A person want to modify page breaks before printing would most likely utilize this view in Excel.

What is: Page Break Preview

500

Landscape View and Portrait View are examples of this method of modifying a printed page.

What is: Changing Page Orientation

M
e
n
u