How can we help?

You can also find more resources in our Help Center.

33 terms

Excel

STUDY
PLAY
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