ENV* K105 | Back

ENV* K105 Mid-term, In class 10/25, open book, notes, help files

Word

• Paragraph formatting, including alignment, spacing, space before
• Outline and number formatting
• Borders and shading
• Tab stops, including leader characters and alignment
• Tables, creating, formatting and modifying
• Insert symbol
• Equation editor
• Subscripts and superscripts
• Mail merge
• Word fields (eg, Date)
• Headers & footers

Excel

• Cell formatting, including number, alignment, borders, and font
• Importing data from text files
• Formulas
• SUM, AVERAGE
• IF function
• Absolute & relative reference
• Named ranges
• Making graphs
• Formatting graphs (including axis labels & titles, range, colors, and marker types)
• Inserting and formatting trendlines
• Using FORECAST, SLOPE, INTERCEPT