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;
44 Cards in this Set
- Front
- Back
SLIDE PANE VIEW |
SHOWS THE CURRENT SLIDE AS IT SHOWS DURING THE SLIDE SHOW |
|
TITLE SLIDE |
IS THE FIRST SLIDE IN A PRESIDENTION. IT GENERALLY CONTAINS THE AUTHORS NAME AND INFORMATION TO IDENTIFY THE CONTENT OF THE PRESENTATION |
|
LIST ITEM LEVEL |
A FIRST-LEVEL ITEM IS A MAIN ITEM IN A LIST, A SECOND-LEVEL ITEM-SOMETIMES CALLED A SUBITEM -IS AN ITEM BENEATH AND INDENTED FROM A FIRST -LEVEL ITEM. usually the font size the size of the text in subitems is small than the size used for the text in the level above |
|
AUTO FIT |
CHANGES THE COLUMN WIDTH OR ROW HEIGHT TO DISPLAY THE LONGEST OR TALLEST ENTRY WITHIN THE COLUMN OR ROW |
|
SAVE AS |
AS YOU MODIFY A WORKBOOK YOU SHOULD SAVE IT REGULARLY EVERY 10 MINUTES OR SO IS A GOOD PRACTICE THE FIRST TIME YOU SAVE A WORKBOOK THE SAVE AS DIALOG BOX OPENS SO YOU CAN NAME THE FILE AND CHOOSE WHERE TO SAVE IT |
|
THEME |
RECALL THAT A THEME IS A COORDINATE SELECTION OF FONTS COLORS AND GRAPHICAL EFFECTS THAT ARE APPLIED THOUGHOUTA WORKBOOK TO CREATE A SPECIFIC LOOK AND FEEL WHEN YOU SWITCH TO A DIFFRENT THEME THE THEME RELATED FONTS COLORS AND EFFECTS CHANGE THOUGHOUT THE WORKBOOK TO REFLECT THE NEW THEME |
|
ANIMATING A LIST OF ITEMS |
YOU ANIMATE A LIST THE DEFAULT IS FOR THE FIRST LEVEL ITEMS TO APPEAR ONE AT A TIME IN OTHER WORDS EACH FIRST LEVEL BULLETED ITEM IS SET TO ANIMATE ON CLICK TJIS TYPE OF ANIMATION FOCUSES YOUR AUDIENCES ATTENTION ON EACH ITEM WITHOUT DISTRACTION OF ITEMS THAT YOU HAVENT DISSCUSSED YET |
|
POSTER FRAME |
THE FRAME THAT APPEARS WHEN THE VIDEO IS NOT PLAYING |
|
TRIM A VIDEO CLIP |
YOU CAN ADD VIDEO TO SLIDES TO PLAY DURING YOUR PRESENTATION POWER POINT SUPPORTS VARIOUS FILE FORMATS BUT THE MOST COMMONLY USED ARE MPEG 4 FORMAT THE WINDOWS MEDIA AUDIO/VIDEO FORMAT |
|
SLIDE HEADER AND FOOTER |
SOMETIMES IT CAN BE HELPFUL TO HAVE INFORMATION ON EACH SLIDE SUCH AS THE TITLE OF THE PRESENTATION OR THE COMPANY NAME THIS IS A FOOTER |
|
ELECTRONIC SPREADSHEET |
TO PREPARE FINANCIAL REPORTS ANALYZE INVESTMENT PORTFOLIOS CALCULATE AMORTIZATION TABLE EXAMINE ALTERNATIVE BID PROPOSALS AND PROJECT INCOME AS WELL AS PERFORM MANY OTHER TASKS INVOLVED IN MAKING INFORMED BUSINESS DECISIONS |
|
FORMAT PAINTER |
COPIES AND PASTE FORMATTING FROM ONE CELL OR RANGE TO ANOTHER WITHOUT DUPLICATING ANY DATA |
|
CONDITIONAL FORMATS LEFT AND |
EXCEL HAS FOUR CONDITIONAL FORMATS DATA BARS HIGHLIGHTING COLOR SCALES AND ICON SETS |
|
PAGE MARGIN |
A MARGIN IS A SPACE BETWEEN THE PAGE CONTENT AND THE EDGES OF THE PAGE . BY DEFAULT EXCEL SETS THE PAGE MARGINS TO 0.7 ON THE AND RIGHT SIDES AND 0.75 INCH ON THE LEFT AND 0.75 ON THE BOTTOM /TOP |
|
PRINT AREA |
IS A RANGE OR RANGES IN A WORKBOOK THAT YOU SPECIFY TO BE PRINTED IN PAGE BREAK THE PRINT AREA IS NOT GRAYED OUT |
|
MANUAL PAGE BREAK |
IS ONE YOU SET TO INDICATE WHERE A NEW PAGE OF THE PRINTOUT SHOULD START AND IS IDENTIFIED BY A SOLID BLUE LINE |
|
RANGE |
A GROUP OF CELLS IN A RECTANGULAR BLOCK IS CALLED A CELL RANGE ( OR RANGE) IF THE BLOCKS ARE NOT CONNECTED AS SHOWN HERE IT IS A NONADJACENT RANGE |
|
HANDOUTS |
PRINTS THE PRESENTATION WITH ONE OR MORE SLIDES ON EACH PIECE OF PAPER |
|
DRAWING TOOLS FORMAT |
TAB APPEARS WHEN A DRAWING OR A TEXT BOX INCLUDING THE SLIDES TITLE AND CONTENT PLACE HOLDERS ARE SELECTED |
|
TOUCH MODE |
IN POWERPOINT YOU CAN CLICK ON THIS OPTION IN THE MAIN MODE BY SWITCHING FROM MOUSE MODE TO TOUCH MODE |
|
SHAPES GALLERY |
YOU CAN ADD SHAPES TO A SLIDE INCLUDING LINE, RECTANGLES STARS AND MORE |
|
RESET PICTURE BUTTON |
IS USED TO UNDO FORMATTING AND SIZING CHANGES YOU MADE TO A PICTURE |
|
ROTATING PICTURES |
YOU CAN QUICKLY ROTATE A PICTURE BY DRAGGING THE ROTATION HANDLE THAT APPEARS ON THE PHOTOS BORDER WHEN THE PHOTO IS SELECTED |
|
GRADIENT |
THE OPTIONS IN THE THEME COLORS SECTION OF THE MENU ARE COMPLEMENTARY COLORS THAT WORK WELL WHEN USED TOGETHER IN A DOCUMENT |
|
THE ANIMATION PAINTER |
IS USED TO COPY THE ANIMATION EFFECTS AND DURATION APPLIED TO ONE OBJECT TO ANOTHER OBJECT |
|
LIVE PREVIEW |
SHOWS HOW THE CHART WILL LOOK WHEN THE DATA LABELS SHOWING THE PRODUCTION GOAL FOR EACH WINE ARE ADDED TO THE PIE |
|
FONT STYLE |
IS A SET OF FORMATTING OPTIONS THAT YOU CAN APPLY BY CLICKING AN ICON IN THE STYLE GALLERY ON THE HOME TAB |
|
NUMBER GENERAL FORMAT |
NUMBERS ARE ORIGINALLY FORMED IN THE GENERAL FORMAT WHICH FOR THE MOST PART DISPLAYS NUMBERS EXACTLY AS THEY ARE TYPED |
|
DATE AND TIMES |
EXCEL HAS SEVERAL FUNCTIONS THAT WORK WITH DATES AND TIMES |
|
ALIGNMENT TITLES NUMBERS AND TEXT |
BY DEFAULT TEXT IS ALIGNED WITH THE LEFT AND BOTTOM BORDERS YOU MIGHT WANT TO CHANGE THE ALIGNMENT TO MAKE THE TEXT AND NUMBERS MORE READABLE OR VISUALLY APPEALING |
|
MAX FUNCTION |
THE MAX FUNCTION DISPLAYS THE MAXIMUM VALUE IN THE RANGE |
|
RELATIVE ABSOLUTE AND MIX |
YOU CAN QUICKLY SWITCH A CELL REFERENCE FROM RELATIVE TO ABSOLUTE OR MIXED. RATHER THAN RETYPING THE FORMULA YOU CAN SELECT THE CELL REFERENCES IN EDIT MODE AND THEN PRESS F4 KEY TO CHANGE THE MODE |
|
CELL REFERENCE |
THE WORKSHEET IS ORGANIZED INTO INDIVIDUAL CELL EACH CELL IS IDENTIFIED BY A CELL REFERENCE |
|
ARITHMETIC OPERATORS |
THE MOST COMMON OPERATORS ARE ARITHMETIC OPERATORS THAT PERFORM ADDITION SUBTRACTION MULTIPLICATION DIVISION AND EXPONENTIATION |
|
ORDER OF OPERATIONS |
IS A SET OF PREDEFINED RULES TO DETERMINE THE SEQUENCE IN WHICH OPERATORS ARE APPLIED IN A CALCULATION |
|
LOGICAL EXCEL FUNCTIONS |
A LOGICAL FUNCTION RETURNS A DIFFERENT VALUE DEPENDING ON WHETHER THE GIVEN CONDITION IS TRUE OR FALSE |
|
EXCELS STATISTICAL FUNCTIONS |
LIKE THE COUNT FUNCTION MANY OF EXCEL FUNCTIONS IGNORE CELLS THAT ARE BLANK OR CONTAIN TEXT |
|
NESTED FUNCTION |
FUNCTIONS CAN ALSO BE PLACED INSIDE ANOTHER FUNCTION OR NESTED EXAMPLE IF A FUNCTION CONTAINS SEVERAL APPLICATION |
|
FUNCTION ARGUMENTS |
SOME GENERAL ARGUMENTS ARE OPTIONAL YOU CAN INCLUDE A OPTIONAL ARGUMENTS OR OMIT IT FROM THE FUNCTION |
|
CROP PHOTOS |
SOMETIMES YOU MAY WANT TO DISPLAY ONLY PART OF A PHOTO TO DO THIS IS TO CROP THE PHOTO |
|
SIZING HANDLES |
ARE THE SMALL SQUARES THAT APPEAR IN THE CORNERS AND IN THE MIDDLE OF THE SIDES OF THE BORDER OF A SELECTED OBJECT |
|
SPEAKER NOTES |
SIMPLY NOTES ARE INFORMATION YOU ADD ABOUT SLIDE CONTENT TO HELP SPEAKER REMEMBER POINTS DURING THE PRESENTATION |
|
USING AUTO FILL |
USED TO ENTER FORMULAS AND DATA AND COMPLETE A SERIES |
|
COMPARISONS OPERATORS |
A1=B1 EQUAL A1>B1 GREATER THAN A1 >= GREATER OR EQUAL <= LESS OR EQUAL <> NOT EQUAL |