Devry Bis 155 Week 3 Quiz - Updated

DeVry BIS 155 Week 3 Quiz - Updated
IF You Want To Purchase A+   Work then Click The Link Below For Instant Down Load
http://www.acehomework.net/?download=devry-bis-155-week-3-quiz-updated
IF You Face Any Problem Then E Mail Us At   JOHNMATE1122@GMAIL.COM
DeVry BIS 155 Week 3 Quiz

Page 1
Question 1.1. (TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2)
        Formatting
        Freezing
        Resizing
        Tiling


Question 2.2. (TCO 4) In Excel, a table is defined as _____. (Points : 2)
        an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis
        a complete set of data for an entity
        a Field, which is an individual piece of data
        an individual piece of data, such as a last name


Question 3.3. (TCO 4) To create a table from an existing range of data, _____. (Points : 2)
        click within the range, click the Table Tools Design tab, and then select Convert to Table
        select any cell in the worksheet and then click Existing Range in the Tools group
        click in a cell and on the Home tab, and click the Insert arrow in the Cells group
        click the Insert tab and then click Table in the Tables group


Question 4.4. (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. (Points : 2)
        a Date Filter
        a Text Filter
        the use of a table element as a formula
        a Number Filter


Question 5.5. (TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____. (Points : 2)
        a PivotTable
        a multiple level sort
        conditional formatting
        a range name


Question 6.6. (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____. (Points : 2)...