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;
28 Cards in this Set
- Front
- Back
CTRL+SHIFT+~
|
Applies the General number format.
|
|
CTRL+SHIFT+%
|
Applies the Percentage format with no decimal places.
|
|
CTRL+0
|
Hides the selected columns.
|
|
CTRL+D
|
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
|
|
CTRL+G
|
Displays the Go To dialog box.
|
|
CTRL+T
|
Displays the Create Table dialog box.
|
|
F1
|
Displays the Microsoft Office Excel Help task pane.
|
|
ALT+F1
|
ALT+F1 creates a chart of the data in the current range.
|
|
CTRL+F2
|
displays the Print Preview window.
|
|
ALT+F8
|
displays the Macro dialog box to create, run, edit, or delete a macro.
|
|
SHIFT+F9
|
calculates the active worksheet.
|
|
CTRL+ALT+F9
|
calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
|
|
F11
|
Creates a chart of the data in the current range.
|
|
SHIFT+F11
|
inserts a new worksheet.
|
|
ALT+F11
|
opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
|
|
F12
|
Displays the Save As dialog box.
|
|
ALT+ENTER
|
starts a new line in the same cell.
|
|
CTRL+SHIFT+L
|
TURNING ON AUTO-FILETR
|
|
Ctrl +1
|
FORMAT CELLL DIALOG BOX
|
|
Unique items count
|
SUMPRODUCT(1/COUNTIF(B5:B15,B5:B15))
|
|
F3
|
Show defined names
|
|
Ctril+f3
|
Name a cell
|
|
CTRL-[
|
Go to precedent cell(s)
|
|
left, right,mid, sub, length, find,
|
Text formulas
|
|
F9
|
Evaluating range within certain formula
|
|
1. Outline questions beforehand ( 2x quick search beforehand)_generating additional nuanced questions
2. Summarizing reading for quizzing; Outlining actionable reading points 3. Answer own questions through experimentation and small-scale examples 4. Remember to repeat; Apply to other learning objectives |
Top 4 Learning checklist steps
|
|
1. Organize data for the model on the spreadhseet 2. Researve separate cells in the sheet for represent each decision variable in the algebraic model 3. Create a formula in the sheet that corresponds to the objective function 4. For each contracint, create a fourmla in a spearate cell in the spreadsheet that corresponds to the LHS of the constraint
|
Steps for implementing LP Model in a Spreadsheet
|
|
1. Workbooks > Worksheets
2. Variables/Parameters= THE BRAIN 3. Design w/end users in mind ( comments, easy to read) 4. Convenient workbook navigation ( TOC, hyperlinks) |
Spreadsheet Feng Shui
|