Excel Certification Exam questions and 100% correct answers

import files - correct answers dataget external data specify delimitaton, column formats Comments - correct answers Review new comment Wrap text - correct answers home wrap text center across selection - correct answers home alignment alignment setting (arrow in BR) Horizontal alignment insert a column in between each column - correct answers use CTRL when selecting the columns manually adjust column and row height - correct answers home format column width export a worksheet to pdf - correct answers file export pdf inspect a w/s for personal info - correct answers file check for issues inspect inspect remove all doc prop and personal info inspect a w/s for accessibility, compatibility - correct answers file check for issues check compatibility or accessibility adjust page breaks - correct answers view page break preview drag around specify print titles - correct answers page layout print titles select rows and columns to have print on each page change page margins and scaling - correct answers file print outline data - correct answers data group auto outline (has to already have subtotals) format cell borders - correct answers home font square format painter - correct answers select cells clipboard format painter DC to do sets of cells esc to stop insert image - correct answers easier fit: format, arrange and align, snap to grid sum using destination cells - correct answers click where you want it to go auto sum sum using source cells - correct answers select the cells you want it to use autosum apply table style to cell range - correct answers home format as table turn table to cell range - correct answers design convert to range remove duplicates - correct answers select table remove duplicates sorting data - correct answers select column sort custom list? sort order custom list insert subtotals - correct answers 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 - correct answers how many cells have numbers in it? COUNT(cell #, cell #...) counta fxn - correct answers how many cells have anything? COUNTA(cell #, cell #...) average function - correct answers averages the cells AVERAGE(cell #, cell #...) mix / max functions - correct answers returns min or max number of the cells MIN(cell #, cell #...) or MAX(cell #, cell #...) sum in a total table row and filter results - correct answers design total row can change filter to change results conditional formatting: highlighting - correct answers home conditional formatting highlight conditional formatting: icon sets - correct answers conditional formatting icon sets relative cell referencing - correct answers cell reference in formula that changes automatically when formula moved absolute cell referencing - correct answers cell reference in formula that wont change when moved to different lacation ex. $A$4 mixed cell referencing - correct answers either the row or the column is an absolute reference Int function - correct answers rounds number down to nearest integer