Info. Tech. Applications Semester Final Review

The ____ is the small green square located in the lower-right corner of the border around the active cell. Black Cross.

Values in cells that you can change to determine new values for formulas.

The ____ in Microsoft Word is where the tabs are located, and all commands, formatting, and tools are:

_____ is used to check a worksheet for spelling errors.

A1 is known as the _____ & A2 is known as the ______.

A __ consists of cell references, numbers, and arithmetic operators that instruct Excel to perform a calculation.

Research Papers - This is an example of: (what should be used on a research paper?) SELECT 1

Planning a ____ before you start is important! (What problem do you want to solve or what information are you needing?

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

What is a specific design with the same colors, fonts, & special effects such as shadows and reflections in PowerPoint?

In Excel, you can easily perform calculations using _____, or a predefined formula.

____ that displays the common or middle number in a range.

Boxes with dotted borders that are displayed when you create a new slide in PowerPoint are called Placeholders.

The easiest way to ___ (make it active) is to use the mouse to click on the cell.

An Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells.

NOW Function: The NOW function returns a number that corresponds to the system date and time. Keeps the Date Updated.

Which of the following statements about online relationships is true?

A cell reference error.

A ______ show the contribution of each piece of data to the whole, or total, of the data.

A formula in a cell that contains a reference back to itself is called a circular reference.

A ____ is a predefined font, font size, and font color that you can apply to a cell.

What is an __? The cell that is highlighted with a green border, that you are able to add text, numbers, or formulas to.

____ that displays the HIGHEST value in a range.

What is a special effect used to progress from one slide to the next in a slide chain?

What section of a business letter identifies the organization or individual?

_____ is the process of finding and correcting errors in the worksheet.

A _____, which is short for picture element, is a dot on the screen that contains a color.

_____ is $ Dollar Signs, commas, percent signs, and decimal signs.

A ____ formats a worksheet by applying a collection of fonts, font styles, colors, and effects.

_____: to perform a logical test

What key do you hold down on the keyboard to highlight more than one cell range?

We define who we are online (Digital Footprint)

Describes a collection of data organized in a manner that allows access, retrieval, and use of that data (information).

To print an Excel worksheet you need to change these three properties. SELECT 1!

____ that displays the LOWEST value in a range.

___ is the rules that define which mathematical operations come first in expressions with multiple operations

You use a $ sign before the column letter, and a $ before the row number. $B$19 is an example of this.

__ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

The _______ of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

A _____ is where the pie chart resides on a separate sheet in the Excel workbook. You can create multiple of these.

What are the three Rings of Responsibility you should consider when you use social media?