Excel Certification Exam | with complete solution | updated

Excel Certification Exam | with complete solution | updated import files - data>get 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