DEVRY BIS 155 Week 5 Quiz .pdf
Original filename: DEVRY BIS 155 Week 5 Quiz .pdf
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 160 times.
File size: 308 KB (3 pages).
Privacy: public file
DEVRY BIS 155 Week 5 Quiz Data Analysis
with Spreadsheets with Lab
Check this A+ tutorial guideline at
For more classes visit
(TCO 5) The tabs of grouped worksheets are displayed with a ________ background. (Points : 2)
(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 :
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
(TCO 5) Which formula would return the #NAME? error? (Points : 2)
(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)