Excel

Created by luckybyu5 

Upgrade to
remove ads

33 terms

What does an operating system do?

An operating system is the basic software that controls the computer's hardware

What is an icon?

An icon is a graphical representation of a command. When the icon is clicked the command is executed

What is Windows 7/Vista/XP?

These are operating systems that empty a graphical user interface

What is a cell?

A cell is the intersection of a column and a row

What is the purpose of a cell pointer?

The cell pointer is a black rectangular box that highlights the cell that is currently selected.

What are 3 ways to select A1?

To select A1, you could click on it, press the arrow keys, or press CTRL + Home

What is the Go TO key in excel?

F5. also Find and select, Go to in the home ribbon

What is the GO To dialog box key?

CTRL + G

Find and Replace Keys

CTRL + H, Replace under Finde and Select

Home Key

HOME

What key will move the cell pointer to the last row and column containing data?

CTRL + End

What will the End Key do?

move the cursor to the last cell in that row or column containing data

What will ALT + Page Down Keys do?

move the cell pointer one screen to the right at a time

What will ALT + Page up keys do?

move the cell pointer one screen to the left at a time

Why are Formulas useful?

they can perform functions on other cells

what is a constant?

contents in cells that do not change (13 or tiger)

ways excel will interpret as dates

month day, year and month/day/year
can also use hyphens

2 types of data entries that can be interred in a cell

constant value and formula

How do you bring up the format dialog box?

Right click in the cell you want to format and then left-click on the selection "Format Cells" from the pop-up menu that appears

what does + do?

addition

what does - do?

subtraction

what does * do?

multiplication

what does / do?

divide

what does ^ do?

exponentiation

what does % do?

percent

How can you modify a formula without using a keyboard

Click the formula bar and place the cursor where you want to insert a new cell. Click on the new cell to insert the cell reference into the formula. Click the green Enter arrow to complete the formula

Three ways to make a correction to a cell

push ESC if you haven't already entered the entry, select the cell and then push F2, or overwrite the old contents by making a new entry over the old one

four ways to open a workbook

1. File tab, open 2. Open toolbar button 3. File tab, new, Blank Workbook 4. CTRL + O

file extensions

.xlsx, .txt, .csv

Bitmap extensions

.jpg, gif

vector extensions

.wmf

extension of microsoft word

.docx

extension of powerpoint

.pptx

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