(BIS 155 Week 4)
BIS 155 Week 4 Lab Exercise: Warming Hut Income, Seasonal Activities & X Games
BIS-155 Week 4 Discussion Answer: Data Consolidation
Discuss and compare the group summations and consolidation tools used with Excel. You may need to look up (research) the group summations.
Under what circumstances would you use each of these features? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.
BIS-155 Week 4 Consolidating Data – 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 nonadjacent 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 method for removing a split window?
- Question: (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?
- Question: (TCO 5) Excel’s ability to manage worksheets allows you to do which of the following?
- Question: (TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)?
- Question: (TCO 5) You use the _____ to find personal data stored in the workbook or personal document properties.
- Question: (TCO 5) You annotate a cell with a reminder by inserting a _____.
- Question: (TCO 5) To distribute a workbook to others so that it retains the same format and cannot … changed, you would save the workbook as a(n) _____ file.
- Question: (TCO 5) Which of the following items cannot be added to the Ribbon?
- Question: (TCO 5) What is the cause of the error message File in Use?
- Question: (TCO 5) Where is the Track Changes feature located?
- Question: (TCO 5) In Excel, what displays the file name, file type, location, size, creation date, modification date, and last accessed date?
- Question: (TCO 5) In Excel, what properties are updated automatically that cannot … changed?