PDF Archive

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

Share a file Manage my documents Convert Recover PDF Search Help Contact



DEVRY BIS 155 Week 3 Quiz Data Ana .pdf



Original filename: DEVRY BIS 155 Week 3 Quiz Data Ana.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 02/03/2017 at 12:21, from IP address 43.224.x.x. The current document download page has been viewed 191 times.
File size: 222 KB (3 pages).
Privacy: public file




Download original PDF file









Document preview


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

Check this A+ tutorial guideline at
http://www.assignmentcloud.com/bis155/bis-155-week-3-quiz-data-analysiswith-spreadsheets-with-lab
For more classes visit

http://www.assignmentcloud.com
(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
(TCO 4) In Excel, the print area is defined as _____. (Points : 2)
an individual piece of data, such as a last name
a complete set of data for an entity
the sequence in which pages print

the range of data to print
TCO 4) _____ column and row headings enables you to keep these headings on the
screen when scrolling through a large spreadsheet. (Points : 2)
Indicates where data starts on a new printed page
Collection of structured, related data in columns and rows
Freezing rows to keep them visible
Freezing panes to keep them visible
(TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2)
by the number of pages in the worksheet
by the number of pages in the workbook
by the value in field(s) within a table
by permanently removing extraneous data
(TCO 4) Filtering the Last_Name column (field) to show only records that begin with
the letter S is an application of _____. (Points : 2)
the use of a table element as a formula
a Number Filter
a Text Filter
a Date Filter
(TCO 4) Which of the following best describes conditional formatting? (Points : 2)
Highlights or emphasizes cells that meet certain conditions
Tags a table element as a reference in a formula
Formats the condition of the worksheet in preparation for printing
Calculates an aggregate for values in a range or database
(TCO 4) Using Conditional Formatting to draw attention to cells containing errors
_____. (Points : 2)

helps locate errors in cells quickly
displays a particular color based on the relative value of the cell contents to other
selected cells
calculates an aggregate for values in a range or database
displays an icon representing a value in the top third based on values in the selected
range
(TCO 4) When data is grouped, the margin area displays the _____. (Points : 2)
aggregate columns
group headings


DEVRY BIS 155 Week 3 Quiz Data Ana.pdf - page 1/3
DEVRY BIS 155 Week 3 Quiz Data Ana.pdf - page 2/3
DEVRY BIS 155 Week 3 Quiz Data Ana.pdf - page 3/3

Related documents


PDF Document devry bis 155 week 3 quiz data ana
PDF Document devry bis 155 week 1 quiz data a
PDF Document devry bis 155 week 2 quiz dat
PDF Document devrycomp 122 lab 5 lab report and source code
PDF Document devrycomp 122 lab 5 lab report and source code
PDF Document advanced excel 2010


Related keywords