Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
50 Cards in this Set
- Front
- Back
- 3rd side (hint)
Edits active cell and puts cursor at the emd |
F2 |
|
|
Repeats last worksheet action |
F4 |
|
|
Moves to next pane in a workbook |
F6 |
|
|
Put a formula in that determines individual project profit. |
Profit is determined by revenue - cost |
|
|
|
Sum symbol |
|
|
When you click on a tab it opens a _____ |
Ribbon |
|
|
Ribbons have subcategories called _____. Name an example on the page layout tab. |
Groups. Themes, page setup and sheet options are different groups on page layout. |
|
|
When you have clicked on a tab and opened a ribbon there is a small button in each category. This is called _______ |
The launch button. These provide even more options |
|
|
Shift F11 |
Inserts a new worksheet (before active sheet) into active workbook. |
|
|
Shift + F12 |
Save's and displays dialog box if a new workbook. |
|
|
Range |
A group of cells that are together, next to each other. |
|
|
The symbol for "through" is a ___ |
: |
|
|
Shift + Enter |
You move up on sheet |
|
|
Just hitting Enter |
Move down on sheet |
|
|
Tab |
Tab moves to the right |
|
|
Shift + Tab |
Move left |
|
|
To create one large cell (ex: make an overarching title for records) what do you do? |
Click and drag across the length that you want. Click the merge and center button on the home tab. |
|
|
What is the quickest way to adjust width of columns for ALL columns? |
Highlight all columns and double click between any two columns to auto adjust all of them. |
|
|
Format Painter |
Click on the cell you want to duplicate the formatting of. Click on the cell or drag across the range you want to change and release. |
|
|
Conditional Formatting: Color scales |
Applies color gradient to show value of cell within a range. |
|
|
Add 5+5 in Excel language |
=5+5 (equals sign always comes first) |
|
|
How does Excel solve formulas? |
Order of operations PEMDAS |
|
|
Name 2 types of cell references |
Relative and absolute |
|
|
Absolute references have what distinguishing feature? |
$ |
|
|
$A$2 |
Column AND row do not change when copied |
|
|
A$2 |
Row does not change when copied |
|
|
$A2 |
Column does not change when copied |
|
|
To reference a cell from another worksheet which steps do you take? |
='Menu Order'!E14 place the worksheet name exactly how it appears in the tab, enclosed in single quotation marks |
Punctuation |
|
Argument |
Contain info you want to calculate. A1:A20 is an argument |
|
|
Alt = |
Autosum shortcut |
|
|
Freezing column or roll |
Go to view and click on freeze panes. This helps you keep a column or row always within sight when scrolling |
|
|
Explain how to freeze top row when scrolling down and 1st column when scrolling right. |
Clear any previous freezes. Chose a pane near the top row and next to the 1st column. Hit freeze pane. A line should appear on the right side of the first column and under the row |
|
|
Alphabatize |
Click the topmost column and pick asscending in data tab. |
|
|
Line charts are best for? |
Showing change over time. |
|
|
Pie charts |
Show data in proportion instead of in a graph |
|
|
When creating a chart how would you switch the information in the legend with the labels on the cart? |
Under design, click "switch Row/Column" |
|
|
How do you set your chart to auto update? |
Format it as a table first |
|
|
Goal seek let's you move _____ to find the unknown values you're looking for. |
Backwards EX: passing grade |
|
|
When using gaol seek does the "changing cell" need to be relative or absolute? |
Absolute $A$1 |
|
|
Ctrl F2 |
Print preview |
|
|
Ctrl F4 |
Closes workbook window |
|
|
Ctrl F10 |
Maximizes window |
|
|
Ctrl F9 |
Minimizes window |
|
|
Alt F1 |
Creates chart of highlighted range. |
|
|
Alt F2 |
Displays save as dialog box |
|
|
Alt F4 |
Save's all workbooks then closes and exits Excel. |
|
|
Which tab are Spell check and Theasurus under? |
Review Tab |
|
|
Which tab is the freeze function under? |
View Tab |
|
|
Name the 4 arguments needed for Vlookup |
Data you know, table array, column reference, FALSE (you want an exact match) |
|
|
What does TRUE help you find in Vlookup? |
Quantities that don't exactly match. Ex: Want to buy 104 items what is discount? With True you can leave argument blank. |
|