Looks Right… But Is Wrong
3D Clustered Column
Chart creation
The worksheet title must use the Title cell style. What feature is being
Cell Styles
Where is the letter head?
Header
The citation must be inserted using MLA 7 style through a specific tab. Which tab must be used?
References tab
This feature checks spelling and grammar automatically.
Spell Check
Placing the chart in range A18:G32 tests what ability?
object positioning and resizing
border around A1:A2
Borders
This tab is used to apply bullet formatting in Word.
Home tab?
Which three functions require values?
MAX, AVERAGE, and MIN
Congrats, you got free points
Free points
Entering Title, Tags, Status, and Subject through File > Info tests what area?
Document Properties
Making cells A1 through G1 one. What feature performs this action?
Merge and Center
The title must be 28-point
Font Size
Applying Brown, Accent 4, Lighter 60% background tests knowledge of what Excel feature?
Theme Colors
If a document requires citations at the end of the document instead of the bottom of each page, what should be used instead?
Endnotes
formatting changes cells is called
Conditional Formatting
Changing column width to exactly measurements
column formatting
If the header contains the student’s name but is not center aligned, what exact instruction is violated?
alignment
A manager wants totals by department instantly without complex formulas. What tool should be used?
Pivot Table.
A total was typed manually instead of using a formula. What happens when data changes?
The total does not update automatically
A student uses 10 spaces to align text in a resume. It looks perfect on their screen but shifts when printed. What should have been used?
Tabs
Taxes formula subtracts Dependents × 24.36 before multiplying by 20%. What mathematical concept is critical here?
order of operations
This tab contains Margins, Orientation, and Size settings.
Layout tab
floating dollar sign
Accounting or Currency format
What Word feature ensures exact alignment?
Tab Stops