Business > EXAM > BIS 155 Week 3 Quiz,2021 LATEST WITH CORRECT ANSWERS. (All)

BIS 155 Week 3 Quiz,2021 LATEST WITH CORRECT ANSWERS.

Document Content and Description Below

Question 5. Question : (TCO 4) Which of the following best describes conditional formatting? Student Answer: 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 Question 6. Question : (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____. Student Answer: displays a particular color based on the relative value of the cell contents to other selected cells displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range helps locate where data may be missing helps locate errors in cells quickly Question 7. Question : (TCO 4) When data is grouped, the margin area displays the _____. Student Answer: aggregate columns group headings collapse and expand buttons group totals Question 8. Question : (TCO 4) _____ are created to organize and summarize data in PivotTables. Student Answer: Categories Types Titles Levels I Question 9. Question : (TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below? Student Answer: Column Labels Report Filter Row Labels Values Question 10. Question : (TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____. Student Answer: enter formulas using field names instead of cell references enter a description column heading for the calculated field build formulas using mathematical operands such as +, -, and * enter formulas using cell references Question 11. Question : (TCO 4) A Pivot Table Style controls all the following EXCEPT _____. Student Answer: bolding font colors number format shading colors Question 12. Question : (TCO 4) The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter. Student Answer: Formula bar F4 function key Go to dialog box Find and Replace dialog box Question 13. Question : (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____. Student Answer: PivotTable Field List Chart Layout command Format Tab Data Tab Question 14. Question : (TCO 4) After creating a PivotChart, you can sort or filter categories or subcategories in rows by clicking the _____. Student Answer: Report Filter arrows Legend Field arrows Axis Field arrows Values arrows Question 15. Question : (TCO 4) Which of the following will NOT delete a PivotChart? Student Answer: Go to the Home tab and click Cut Right-click the chart and click Cut Select the chart and then press Delete Click and drag the PivotChart off the worksheet [Show More]

Last updated: 1 year ago

Preview 1 out of 7 pages

Add to cart

Instant download

We Accept:

We Accept
document-preview

Buy this document to get the full access instantly

Instant Download Access after purchase

Add to cart

Instant download

We Accept:

We Accept

Reviews( 0 )

$21.00

Add to cart

We Accept:

We Accept

Instant download

Can't find what you want? Try our AI powered Search

OR

REQUEST DOCUMENT
57
0

Document information


Connected school, study & course


About the document


Uploaded On

Apr 30, 2021

Number of pages

7

Written in

Seller


seller-icon
[email protected]

Member since 3 years

19 Documents Sold


Additional information

This document has been written for:

Uploaded

Apr 30, 2021

Downloads

 0

Views

 57

Document Keyword Tags

Recommended For You

Get more on EXAM »

$21.00
What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·