WorksheetsExcel Study guide 1-4
Total questions: 9
Worksheet time: 5mins
Name the Command that displays all Excel Windows Side-by-Side.
Arrange All
New Window
Which feature adds keyboard code icons that can be used in conjunction with the ALT Key?
Hot Keys
Key Tips
What Command increases/decreases the view of selected cells to aid in making them more visible?
Zoom to Selection
Enlarge Selected Area
The Formula '=(June!A2)' is an example of what?
A Date
A Cell Reference
An External Reference
A Scope
Issac created a Billing Workbook that contained the formula '=(Summary!C31)'. 'Summary' is an example of what?
A Named Range
An External Reference
A Cell Reference
A Internal Reference
Which feature automatically adjusts cell references for the new copy location?
Absolute Reference
AutoFit
Relative Reference
Worksheet Reference
What term is used when referencing cells from other sheets using the sheet name instead of the cell address for a reference?
Name Reference
Worksheet Reference
Scope
External Reference
Which option would help in organizing and identifying Excel files?
Document Options
File Details
Document Properties
File Tab
What command allows you to be able to view multiple areas of the spreadsheet at the same time?
Arrange All
Freeze Panes
Split
Find
