Keywords

bis 155
bis 155 week 5
bis 155 week 4
bis 155 week 3
bis 155 week 2
bis 155 week 1
bis 155 free
bis 155 course project
devry bis 155 final exam
bis 155 final exam
bis 155 exercise
bis 155 ilabs
devry bis 155
bis 155 devry
bis 155 entire course
bis 155 week 6


Authorizations, license

Visible by: Everyone
All rights reserved

6 visits

DEVRY BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab


DEVRY BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab This doc cannot be viewed.

DEVRY BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab

Check this A+ tutorial guideline at

www.assignmentclick.com/bis-155/bis-155-week-5-quiz-data-analysis-with-spreadsheets-with-lab

For more classes visit
www.assignmentclick.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

Comments