Excel Certification Exam
import files - Answer- dataget external data specify delimitaton, column formats Comments - Answer- Review new comment Wrap text - Answer- home wrap text center across selection - Answer- home alignment alignment setting (arrow in BR) Horizontal alignment insert a column in between each column - Answer- use CTRL when selecting the columns manually adjust column and row height - Answer- home format column width export a worksheet to pdf - Answer- file export pdf inspect a w/s for personal info - Answer- file check for issues inspect inspect remove all doc prop and personal info inspect a w/s for accessibility, compatibility - Answer- file check for issues check compatibility or accessibility adjust page breaks - Answer- view page break preview drag around specify print titles - Answer- page layout print titles select rows and columns to have print on each page change page margins and scaling - Answer- file print outline data - Answer- data group auto outline (has to already have subtotals) format cell borders - Answer- home font square format painter - Answer- select cells clipboard format painter DC to do sets of cells esc to stop insert image - Answer- easier fit: format, arrange and align, snap to grid sum using destination cells - Answer- click where you want it to go auto sum sum
Document information
- Uploaded on
- October 5, 2023
- Number of pages
- 5
- Written in
- 2023/2024
- Type
- Other
- Person
- Unknown
