# PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

## DEVRY BIS 155 Week 5 Quiz .pdf

Original filename: DEVRY BIS 155 Week 5 Quiz .pdf
Author: LENOVO

This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on pdf-archive.com on 24/03/2016 at 13:46, from IP address 103.12.x.x. The current document download page has been viewed 237 times.
File size: 308 KB (3 pages).
Privacy: public file

### Document preview

DEVRY BIS 155 Week 5 Quiz Data Analysis

Check this A+ tutorial guideline at
For more classes visit

http://www.assignmentcloud.com

(TCO 5) The tabs of grouped worksheets are displayed with a ________ background. (Points : 2)
Gray
Yellow
Blue
White
(TCO 5) In Excel, which of the following would you perform to group nonadjacent
worksheets? (Points : 2)
Click the first tab, hold Shift, and then click the last tab
Click the first tab, hold Ctrl, and then click last tab.

Right-click a worksheet tab, then select Select All Sheets.
Right-click a worksheet tab, then select Group.
(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title
bar of the second window. (Points : 2)
The letter B
The number 2
The letter A
The number 1
(TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet? (Points :
2)
Drag a split box
Double-click a split box.
Right-click in the active cell and click Split.
Click Split in the Window group on the View tab.
(TCO 5) If a worksheet name has a space in it, ________ surround the worksheet name in the
worksheet reference. (Points : 2)
Double quotation marks
Single quotation marks
Parentheses
Brackets
(TCO 5) Which formula would return the #NAME? error? (Points : 2)
=SUM(B6.B12)
=MAX(B6:B12)
=AVG(B6:B12)
=IF(A6=”Atlanta”,A3,0)

(TCO 5) If A1 contains the hourly pay rate of \$10.25, A2 contains the hours worked (40), and
A3 contains =A1*A2, which cell is the dependent cell(s)? (Points : 2)
A1