Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
John would like to remove a worksheet from his workbook. Which option would he choose?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
How would you move sheet tabs to a new position in the workbook
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
Wendy has created a spreadsheet to keep track of company sales. Sales for the East region are located in cells D1 through D13. Which function would she use to find the highest sales for the East region?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
John would like to change the order of the worksheets in his workbook. Which option would he choose?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
=B4-C4
=MAX(D1:D13)
move
unhide
relative reference
delete
Click and drag the sheet tab to the new location
freeze
Check it!