BUS 150 STUDY GUIDE – EXAM #1 FALL 2023
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
BUS 150
STUDY GUIDE – EXAM #1
FALL 2023
Modules: 1,2,3,4
Formatting: Apply proper formatting to Cells – fonts, styles, borders, alignment, indentation, etc.
Apply proper formats to cell content: date, number formats, special formats, decimals, %,etc. Differentiate fontcolor vs cell fill color
Merge cells, text wrap, text orientation
Conditional Formatting with more than one rule and managing rules
Printing: Page Layout (orientation, define Print Area, page break, select print titles)
Horizontal and Vertical Alignment
Manage custom Header and Footer
Functions: MAX, MIN, COUNT, COUNTA, AVERAGE
SUM, ROUND, ROUNDUP
IF, IFERROR
VLOOKUP
DATE Functions –TODAY, YEAR, MONTH, DAY
Nested functions (a function inside another function)
Formulas: know when to apply function vs formulas and identify order of operands
Simplicity of formulas and functions is key
Absolute vs Relative cell references, using cell reference vs writing a number in the function/formula
Charts: Pie Charts, Column Charts, Line Charts
Sparklines, Data Bars
Select appropriate data, filter data, manipulate Data Series labels and axis Manipulate axis bounds, labels, colors, data labels, etc.
Work with all Chart Elements (legend, gridlines, etc.), move charts, position them properly
Format, color, etc. of the different chart elements
Move charts to another worksheet or a chart sheet
Insert Icons
Worksheet: Creating new one, moving and renaming it, manage columns and rows, hide/unhide
Chart sheet: Creating a new one and moving it
File Management – Save As as Excel file type, in proper folder, and uploading proper file to blackboard
2024-02-21