Comp Lit Final Exam

Front 1

SLIDE PANE VIEW

Back 1

SHOWS THE CURRENT SLIDE AS IT SHOWS DURING THE SLIDE SHOW

Front 2

TITLE SLIDE

Back 2

IS THE FIRST SLIDE IN A PRESIDENTION. IT GENERALLY CONTAINS THE AUTHORS NAME AND INFORMATION TO IDENTIFY THE CONTENT OF THE PRESENTATION

Front 3

LIST ITEM LEVEL

Back 3

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

Front 4

AUTO FIT

Back 4

CHANGES THE COLUMN WIDTH OR ROW HEIGHT TO DISPLAY THE LONGEST OR TALLEST ENTRY WITHIN THE COLUMN OR ROW

Front 5

SAVE AS

Back 5

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

Front 6

THEME

Back 6

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

Front 7

ANIMATING A LIST OF ITEMS

Back 7

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

Front 8

POSTER FRAME

Back 8

THE FRAME THAT APPEARS WHEN THE VIDEO IS NOT PLAYING

Front 9

TRIM A VIDEO CLIP

Back 9

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

Front 10

SLIDE HEADER AND FOOTER

Back 10

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

Front 11

ELECTRONIC SPREADSHEET

Back 11

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

Front 12

FORMAT PAINTER

Back 12

COPIES AND PASTE FORMATTING FROM ONE CELL OR RANGE TO ANOTHER WITHOUT DUPLICATING ANY DATA

Front 13

CONDITIONAL FORMATS LEFT AND

Back 13

EXCEL HAS FOUR CONDITIONAL FORMATS DATA BARS HIGHLIGHTING COLOR SCALES AND ICON SETS

Front 14

PAGE MARGIN

Back 14

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

Front 15

PRINT AREA

Back 15

IS A RANGE OR RANGES IN A WORKBOOK THAT YOU SPECIFY TO BE PRINTED IN PAGE BREAK THE PRINT AREA IS NOT GRAYED OUT

Front 16

MANUAL PAGE BREAK

Back 16

IS ONE YOU SET TO INDICATE WHERE A NEW PAGE OF THE PRINTOUT SHOULD START AND IS IDENTIFIED BY A SOLID BLUE LINE

Front 17

RANGE

Back 17

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

Front 18

HANDOUTS

Back 18

PRINTS THE PRESENTATION WITH ONE OR MORE SLIDES ON EACH PIECE OF PAPER

Front 19

DRAWING TOOLS FORMAT

Back 19

TAB APPEARS WHEN A DRAWING OR A TEXT BOX INCLUDING THE SLIDES TITLE AND CONTENT PLACE HOLDERS ARE SELECTED

Front 20

TOUCH MODE

Back 20

IN POWERPOINT YOU CAN CLICK ON THIS OPTION IN THE MAIN MODE BY SWITCHING FROM MOUSE MODE TO TOUCH MODE

Front 21

SHAPES GALLERY

Back 21

YOU CAN ADD SHAPES TO A SLIDE INCLUDING LINE, RECTANGLES STARS AND MORE

Front 22

RESET PICTURE BUTTON

Back 22

IS USED TO UNDO FORMATTING AND SIZING CHANGES YOU MADE TO A PICTURE

Front 23

ROTATING PICTURES

Back 23

YOU CAN QUICKLY ROTATE A PICTURE BY DRAGGING THE ROTATION HANDLE THAT APPEARS ON THE PHOTOS BORDER WHEN THE PHOTO IS SELECTED

Front 24

GRADIENT

Back 24

THE OPTIONS IN THE THEME COLORS SECTION OF THE MENU ARE COMPLEMENTARY COLORS THAT WORK WELL WHEN USED TOGETHER IN A DOCUMENT

Front 25

THE ANIMATION PAINTER

Back 25

IS USED TO COPY THE ANIMATION EFFECTS AND DURATION APPLIED TO ONE OBJECT TO ANOTHER OBJECT

Front 26

LIVE PREVIEW

Back 26

SHOWS HOW THE CHART WILL LOOK WHEN THE DATA LABELS SHOWING THE PRODUCTION GOAL FOR EACH WINE ARE ADDED TO THE PIE

Front 27

FONT STYLE

Back 27

IS A SET OF FORMATTING OPTIONS THAT YOU CAN APPLY BY CLICKING AN ICON IN THE STYLE GALLERY ON THE HOME TAB

Front 28

NUMBER GENERAL FORMAT

Back 28

NUMBERS ARE ORIGINALLY FORMED IN THE GENERAL FORMAT WHICH FOR THE MOST PART DISPLAYS NUMBERS EXACTLY AS THEY ARE TYPED

Front 29

DATE AND TIMES

Back 29

EXCEL HAS SEVERAL FUNCTIONS THAT WORK WITH DATES AND TIMES

Front 30

ALIGNMENT TITLES NUMBERS AND TEXT

Back 30

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

Front 31

MAX FUNCTION

Back 31

THE MAX FUNCTION DISPLAYS THE MAXIMUM VALUE IN THE RANGE

Front 32

RELATIVE ABSOLUTE AND MIX

Back 32

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

Front 33

CELL REFERENCE

Back 33

THE WORKSHEET IS ORGANIZED INTO INDIVIDUAL CELL EACH CELL IS IDENTIFIED BY A CELL REFERENCE

Front 34

ARITHMETIC OPERATORS

Back 34

THE MOST COMMON OPERATORS ARE ARITHMETIC OPERATORS THAT PERFORM ADDITION SUBTRACTION MULTIPLICATION DIVISION AND EXPONENTIATION

Front 35

ORDER OF OPERATIONS

Back 35

IS A SET OF PREDEFINED RULES TO DETERMINE THE SEQUENCE IN WHICH OPERATORS ARE APPLIED IN A CALCULATION

Front 36

LOGICAL EXCEL FUNCTIONS

Back 36

A LOGICAL FUNCTION RETURNS A DIFFERENT VALUE DEPENDING ON WHETHER THE GIVEN CONDITION IS TRUE OR FALSE

Front 37

EXCELS STATISTICAL FUNCTIONS

Back 37

LIKE THE COUNT FUNCTION MANY OF EXCEL FUNCTIONS IGNORE CELLS THAT ARE BLANK OR CONTAIN TEXT

Front 38

NESTED FUNCTION

Back 38

FUNCTIONS CAN ALSO BE PLACED INSIDE ANOTHER FUNCTION OR NESTED EXAMPLE IF A FUNCTION CONTAINS SEVERAL APPLICATION

Front 39

FUNCTION ARGUMENTS

Back 39

SOME GENERAL ARGUMENTS ARE OPTIONAL YOU CAN INCLUDE A OPTIONAL ARGUMENTS OR OMIT IT FROM THE FUNCTION

Front 40

CROP PHOTOS

Back 40

SOMETIMES YOU MAY WANT TO DISPLAY ONLY PART OF A PHOTO TO DO THIS IS TO CROP THE PHOTO

Front 41

SIZING HANDLES

Back 41

ARE THE SMALL SQUARES THAT APPEAR IN THE CORNERS AND IN THE MIDDLE OF THE SIDES OF THE BORDER OF A SELECTED OBJECT

Front 42

SPEAKER NOTES

Back 42

SIMPLY NOTES ARE INFORMATION YOU ADD ABOUT SLIDE CONTENT TO HELP SPEAKER REMEMBER POINTS DURING THE PRESENTATION

Front 43

USING AUTO FILL

Back 43

USED TO ENTER FORMULAS AND DATA AND COMPLETE A SERIES

Front 44

COMPARISONS OPERATORS

Back 44

A1=B1 EQUAL

A1>B1 GREATER THAN

A1

>= GREATER OR EQUAL

<= LESS OR EQUAL

<> NOT EQUAL