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

8 visits

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


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

DEVRY BIS 155 Week 3 Quiz Data Analysis with Spreadsheets with Lab
s
Check this A+ tutorial guideline at

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

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

Comments