Excel Certification Exam | with complete solution | updated

Excel Certification Exam | with complete solution | updated import files - dataget external data specify delimitaton, column formats Comments - Review new comment Wrap text - home wrap text center across selection - home alignment alignment setting (arrow in BR) Horizontal alignment insert a column in between each column - use CTRL when selecting the columns manually adjust column and row height - home format column width export a worksheet to pdf - file export pdf inspect a w/s for personal info - file check for issues inspect inspect remove all doc prop and personal info inspect a w/s for accessibility, compatibility - file check for issues check compatibility or accessibility adjust page breaks - view page break preview drag around specify print titles - page layout print titles select rows and columns to have print on each page change page margins and scaling - file print outline data - data group auto outline (has to already have subtotals) format cell borders - home font square format painter - select cells clipboard format painter DC to do sets of cells esc to stop insert image - easier fit: format, arrange and align, snap to grid sum using destination cells - click where you want it to go auto sum sum using source cells - select the cells you want it to use autosum apply table style to cell range - home format as table turn table to cell range - design convert to range remove duplicates - select table remove duplicates sorting data - select column sort custom list? sort order custom list insert subtotals - MAKE SURE ITS NOT A TABLE also that its properly sorted in the column you want subtotaled put the column, the function, and subtotal appearance count function - how many cells have numbers in it? COUNT(cell #, cell #...) counta fxn - how many cells have anything? COUNTA(cell #, cell #...) average function - averages the cells AVERAGE(cell #, cell #...) mix / max functions - returns min or max number of the cells M