DEVRY BIS 155 Week 5 Quiz Data Ana .pdf
Original filename: DEVRY BIS 155 Week 5 Quiz Data Ana.pdf
This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on pdf-archive.com on 02/03/2017 at 12:21, from IP address 43.224.x.x.
The current document download page has been viewed 92 times.
File size: 326 KB (3 pages).
Privacy: public file
Download original PDF 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)