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