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

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

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

Check this A+ tutorial guideline at

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...