Excel Chapter 2

Created by aprice 

Upgrade to
remove ads

wrap text

display text on multiple lines within a cell

number format

a specific wat that excel displays numbers

general format

whatever you type in a cell will display except trailing zeros to the right of a decimal point

Office Themes

specify a combination of colors, fonts, and graphic effects that look good together

arithmetic operators

symbols with which you can specify the type of mathmatical operation you want to perform in a formula

Formula autoComplete

assist in inserting functions

point and click method

type formulas or construct them by pointing and clicking

Accounting number Format

applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at both the right and left edges of the cell to accommodate parentheses for negative numbers.

Comma style

adds appropriate thousand comma separators and also applies the Accounting Number Format-two decimal places and space for parentheses in the event of a negative number-but without a dollar sign.

Absolute cell references

A cell reference that refers to cells by their fixed position in a worksheet, and that remains the same when the formula is copied.

range finder

outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula or for quickly positioning the insertion point within the cell to perform editing directly in the cell

F4 shortcut

inserts dollar signs

Percentage

Part of a whole expressed in hundredths. Photo album A presentation composed of pictures.

Percent style

A command that formats the selected cell as a percentage rounded to the nearest hundredth.

chart sheet

A workbook sheet that contains only a chart

Gross profit margin

In accounting, the sales revenue minus the cost of sales

sharepoint

Software from Microsoft that provides a website on which employees in an organization can upload and share information.

Office live workspace

Software from Microsoft that enables individuals to save and access Office documents on the Internet.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set