Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
How would you move sheet tabs to a new position in the workbook
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
How is an exact copy of a worksheet created within the same workbook?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
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 calculate total sales for the East region?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
today
freeze
=SUM(D1:D13)
Click and drag the sheet tab to the new location
text
calculation
=B4-C4
Check it!