BIS 155

BIS 155 WEEK 6 Organize the Data Data imported from SalesData.csv text file located in Course Project Materials in DocSharing. Professional formatting follows the formatting guidelines we studied during the first week of class. Documentation sheet added to provide author, purpose, and date and provide information about each of the sheets you will create as you analyze the data. At least one calculated field added and copied to all cells in t

15 Other / Other strayer university / BIS 155 27 Nov 2015

BIS 155 WEEK 5 Week 5 Quiz Question : (TCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT: Question : (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? Question : (TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes. Question : (TCO 5) In Excel, which of the following is NOT a metho

9 Other / Other strayer university / BIS 155 23 Nov 2015

BIS 155 WEEK 4 1. Question : (TCO 8) In a tab-delimited file, ________ separate the data. Question 2. Question : (TCO 8) The Text Import Wizard displays when a(n) ________ file is imported. Question 3. Question : (TCO 8) Which of the following is NOT a method for refreshing data? Question 4. Question : (TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width. Quest

9 Other / Other strayer university / BIS 155 23 Nov 2015

BIS 155 WEEK 3 Week 3 Quis Question : (TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later, _____ the unneeded columns to allow users to focus on only the essential information. Question : (TCO 4) Which of the following best describes a page break? Question : (TCO 4) To create a table from an existing range of data, _____. Question : (TCO 4) Which of the following best

9 Other / Other strayer university / BIS 155 23 Nov 2015

BIS 155 WEEK 2 Week 2 Quiz Question 10. Question : (TCO 2) One benefit of using range names in formulas is that _____ . Question 9. Question : (TCO 2) Which of the following best describes the HLOOKUP function? Question 8. Question : (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. Question 7. Question : (TCO 2) The _____ function can be used to find an answer located

9 Other / Other strayer university / BIS 155 23 Nov 2015

BIS 155 Lab 5 of 7 Bruno s Pizza Analysis 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

15 Other / Other strayer university / BIS 155 19 Oct 2015

BIS 155 Lab 3 of 7 Alice Barr Realty Analysis Lab 3 of 7 Alice Barr Realty Analysis 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 trac

12 Other / Other strayer university / BIS 155 19 Oct 2015

BIS 155 Lab 1 of 7: Saddle River Marching Band Lab 1 of 7 Saddle River Marching Band 50 Points Submit your assignment to the Dropbox located on the silver tab at the top of this page L A B O V E R V I E W Scenario/Summary You are the assistant to the band director for the Upper Saddle River Marching Band, and you must prepare a report showing the status of the marching band fundraising event for presentation to the board of trustee

12 Other / Other strayer university / BIS 155 19 Oct 2015

BIS 155 Lab 1 of 7: Saddle River Marching Band Lab 1 of 7 Saddle River Marching Band 50 Points Submit your assignment to the Dropbox located on the silver tab at the top of this page L A B O V E R V I E W Scenario/Summary You are the assistant to the band director for the Upper Saddle River Marching Band, and you must prepare a report showing the status of the marching band fundraising event for presentation to the board of trustee

12 Other / Other strayer university / BIS 155 19 Oct 2015

BIS 155 Entire Course BIS 155 Week 6 Course Project Excel Project BIS 155 Lab 1 of 7 Saddle River Marching Band BIS 155 Lab 2 of 7 Excel's Advanced Formulas & Functions BIS 155 Lab 3 of 7 Alice Barr Realty Analysis BIS 155 Lab 4 of 7 Create Address Labels BIS 155 Lab 5 of 7 Bruno's Pizza Analysis BIS 155 Lab 6 of 7 Day Care Center BIS 155 Lab 7 of 7 Access Database BIS 155 Week 1 Qu

65 Other / Other strayer university / BIS 155 19 Oct 2015