Excel Access Final Review 41-60 Question Preview (ID: 19972)


Excel Access Final Review 41-60. TEACHERS: click here for quick copy question ID numbers.

Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
a) theme
b)
c)
d)

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
a) unhide
b) split
c)
d)

Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
a) text
b) numbers
c)
d)

How would you move sheet tabs to a new position in the workbook
a) Click and drag the sheet tab to the new location
b) Choose Relocate on the Quick Access Toolbar
c)
d)

John would like to remove a worksheet from his workbook. Which option would he choose?
a) delete
b) insert
c)
d)

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
a) freeze
b) hide
c)
d)

How is an exact copy of a worksheet created within the same workbook?
a) Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
b) Choose Move or Copy from the Quick Access Toolbar
c)
d)

John would like to change the order of the worksheets in his workbook. Which option would he choose?
a) move
b) insert
c)
d)

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
a) split
b) hide
c)
d)

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
a) string
b) thread
c)
d)

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
a) freeze
b) header
c)
d)

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
a) move
b) rename
c)
d)

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
a) relative reference
b) absolute reference
c)
d)

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
a) =B4-C4
b) =B4+C4
c)
d)

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?
a) =SUM(D1:D13)
b) =SUM(D1-D13)
c)
d)

Which of the following is made up of two values and a relational operator, and is true or false for each cell in the range?
a) condition
b) restrictions
c)
d)

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
a) average
b) max
c)
d)

Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
a) today
b) if
c)
d)

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?
a) =MAX(D1:D13)
b) =MAX(1D:13D)
c)
d)

Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
a) calculation
b) formula auditing
c)
d)

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 19972 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links