BIS 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab (TCO 2) In Excel, a relative cell reference: (Points : 2) Indicates a cell’s specific location and the reference does not change when you copy the formula. Contains both an absolute and a relative cell reference Indicates a cell’s relative location from the cell containing the formula; the reference changes when you copy the formula Occurs when a formula directly or indirectly refers to the cell containing the formula (TCO…

BIS 155 Week 6 iLab Data Analysis with Spreadsheets with Lab

TCO 5) The tabs of grouped worksheets are displayed with a ________ background. (Points : 2) Gray Yellow Blue White (TCO 5) In Excel, which of the following would you perform to group nonadjacent worksheets? (Points : 2) Click the first tab, hold Shift, and then click the last tab Click the first tab, hold Ctrl, and then click last tab. Right-click a worksheet tab, then select Select All Sheets. Right-click a worksheet tab, then select Group. (TCO 5) When two windows of the same…

BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab

The owner of Bruno’s Pizza, Joe Bruno, wants to evaluate the profitability of his three restaurants before he expands further. He is particularly interested in the comparative results of three dining categories, dine-in, pickup, and delivery. Joe has asked for your help in doing this analysis in return for a small stipend and all the pizza you can eat. You have already prepared a template and distributed it to each restaurant manager, who has entered the sales data for last year. Your next…

BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab

You work with the XYZ Corporation Charitable Trust allows you to demonstrate your expertise with Excel. The trust is sponsoring an auction, and you have received a list of all donors who have contributed to this auction. The list was pulled from the Corporation’s database as a comma separated text file. You have been asked to create a letter that will go out to each of the contributors that will accept their donation. Tickets to the event will be enclosed. The letter requires that you…

BIS 155 Week 4 iLab Data Analysis with Spreadsheets with Lab

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…

BIS 155 Week 3 Quiz Data Analysis with Spreadsheets with Lab

You are an intern with the Regional Realty Association and are analyzing the claim made by Alice Barr Realty that “we get your price.” You have prepared a spreadsheet that shows data relating to 3 months’ sales by Alice Barr Realty. You are going to determine the percent of asking price for each home sold and analyze the sales data to determine the true track record of the company in selling homes for the asking price.

BIS 155 Week 6 Course Projects

You are an intern at First National Bank working in the loan department, and your boss has asked you to prepare the monthly “New Loan Report” for the Board of Directors. This analysis report will clearly list and summarize all new loans for residential housing in the past month. The summary area includes the loan statistics as labeled data in the data file. The format of the report is appropriate for the Board of Directors for the First National Bank.