BIS 155 Data Analysis with Spreadsheets

$67.00

BIS 155 Data Analysis with Spreadsheets
You are the assistant to the band director for the Upper Saddle River Marching Band, and you…

 

Description

BIS 155 Data Analysis with Spreadsheets

BIS 155 Data Analysis with Spreadsheets

A+ iLab Week 1-7| Excel Project Week 6| Quiz Week 1-5| Discussions Week 1-7| Final Exam

iLab Week 1-7 

https://www.hiqualitytutorials.com/product/bis-155-ilab-week-1-7/

iLab Week 1 Upper Saddle River Marching

https://www.hiqualitytutorials.com/product/bis155-ilab-week-1/

iLAB OVERVIEW

Scenario/Summary Upper Saddle River Marching

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 trustees. The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook, create formulas, format for presentation to the board, and add charts to graphically depict the sales over time and by product.

BIS 155 Data Analysis with Spreadsheets

iLab Week 2 First National Bank

https://www.hiqualitytutorials.com/product/bis155-ilab-week-2/

iLAB OVERVIEW

Scenario/Summary

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.

BIS 155 Data Analysis with Spreadsheets

iLab Week 3 Regional Realty Association

https://www.hiqualitytutorials.com/product/bis155-ilab-week-3/

iLAB OVERVIEW

Scenario/Summary

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 Data Analysis with Spreadsheets

iLab Week 4 XYZ Corporation Charitable Trust

https://www.hiqualitytutorials.com/product/bis155-ilab-week-4/

iLAB OVERVIEW

Scenario/Summary

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 provide the following pieces of information:

  • Full Name and Address
  • First Name
  • Donated Item
  • Value
  • Number of tickets requested

Memo to Northwind Trades and XYZ company included

BIS 155 Data Analysis with Spreadsheets

iLab Week 5 Bruno’s Pizza

https://www.hiqualitytutorials.com/product/bis155-ilab-week-5/

iLAB OVERVIEW

Scenario/Summary

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 task is to consolidate the data into a single workbook that shows the total sales for each quarter and each dining category. The information should be shown in tabular, as well as graphical formats. You will also create a documentation sheet so that Joe will know exactly what you have created.

BIS 155 Data Analysis with Spreadsheets

iLab Week 6 Day Care Wonders

https://www.hiqualitytutorials.com/product/bis-155-ilab-week-6/

iLAB OVERVIEW

A+ Scenario/Summary

Day Care Wonders Income Statement of Jane Morales.  This spreadsheet provides What-If analysis based on the Income Statement of Jane Morales. This What-If analysis will help Ms. Morales determine whether is viable for her to start this business.

Income Statement with One and Two Variable Data Tables Scenario Summary

I would recommend to Jane to continue having her Day Care Wonders Business because of the amount of profit she can accumulate. However, since the fixed expense remains the same, despite…

BIS 155 Data Analysis with Spreadsheets

iLab Week 7 Access Data 

https://www.hiqualitytutorials.com/product/bis155-ilab-week-7/

iLAB OVERVIEW

Scenario/Summary

Hopefully you will find this week’s lab activity fun and useful. If you have never created a database, you will be able to tell all of your friends and family that you are now a database designer! You will walk through the steps of creating and populating an Access database to keep a record of items in your home. The database will have a table, a form, a query, and a report. You will need to use Microsoft Access 2010. In the event you do not have Access, you can use the iLab environment. Make sure to copy your files down to your pc and upload to the Dropbox. The following videos will refresh you with the use of the iLab environment and transfer of files.

BIS 155 Data Analysis with Spreadsheets

Project Northwind Traders Week 6

https://www.hiqualitytutorials.com/product/bis-155-northwind-traders/

Objectives

The general instructions for this project can be found in the Week 6 Lecture material. The Week 6 Lecture describes the assignment and provides an overview of the project as a whole. There are no step-by-steps for the course project. The following are grading criteria for this project.

Guidelines

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 the worksheet.

Analyze the Data

Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, comments, and explanation. Remove any extra sheets so your workbook is as compact as possible when you turn it in. Go back and review your labs for assistance in completing the different types of analysis.

The following are some examples of analysis you might wish to do:

  • Sort by discount level. Have discounts increased sales volumes? Is there any discount level that appears to be more effective than others?
  • Graph sales over time to see trends. Are there any peaks and lows in sales? Is there any time of year in which sales are highest? Lowest?
  • Pivot the data to see total sales by quarter, country, category, and salesperson. Are there any highs? Are there any lows that need to be addressed?
  • Subtotal the data. How are quarterly sales totals? Sales totals by salesperson? By Country?
  • Challenge Option: Perform What-If Analysis. What if prices were raised by a certain percentage with a slight decline in sales? What combination of price increases and decline in sales makes most sense?

Present your Conclusions in a Memo

Use the integration techniques we worked on in the course to develop a Memo (Word document) that includes data and graphs copied and pasted from your spreadsheet. You will turn in both your Recommendation Memo and your spreadsheet. (To help you formulate your report, there is a Word document named “ExcelProjectMemoTemplate” located in DocSharing – Course Project Materials. The yellow-lined information provides an explanation of what should be included in each section of the Memo.)

Your Memo will focus one paragraph on each of the Data Analysis sheets in your workbook. Explain the type of analysis you completed, the conclusions you drew, and a recommendation based on the analysis. (45 points)

You should include a final paragraph that explains three things you learned about using Excel for data analysis. (15 points)

This week, you will be performing an independent data analysis activity. The Excel project for this week is designed to meet the requirements of TCO 9 and bring together all that you have learned in Week 1 through Week 5. The focus of the TCO is: Given data in a database application, perform an analysis of the data in a spreadsheet program and prepare a Memo, which summarizes the analysis and makes a recommendation to management. You will be provided with the data, and then required to analyze the data in three different methods. You will then be required to provide a Memo with your summary and recommendations. In past weeks, you have been provided with step-by-step instructions as we have worked through the labs; now, you will have the opportunity to take data exported from a company database, format it professionally as a spreadsheet, and then perform data analysis. In this lecture, we will look at the steps that professionals follow as they face an open-ended data-analysis problem, and then walk you through the process of completing the analysis.

Memo – Preview:

Northwind Traders conducts business in twenty-one countries and manages eight food categories with a total of 88 product items.  Sales in all categories have been fluctuating overall, but are generally, increasing from August 2004 to May 2006 (Chart 1).  Note that for the purpose of our analysis, June period is considered incomplete and therefore,…

ANALYSIS 2: SALES, BY CUSTOMER

BIS 155 Data Analysis with Spreadsheets

Quiz Week 1-5 

https://www.hiqualitytutorials.com/product/bis-155-all-quizzes/

Quiz Week 1 

https://www.hiqualitytutorials.com/product/bis155-quiz-week-1/

(TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)

A range of cells containing results based upon manipulation of the variables in the input area

Displays the name of a worksheet within a workbook

A range of cells containing values for variables used in formulas

Displays the content of the active cell

(TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)

Must have formulas entered into it

Cannot be used for labels or headings

Must have text entered into it

Is the intersection of a column and a row

(TCO 1) Which of the following best describes the AutoComplete function? (Points : 2)

Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

(TCO 1) Why would you use cell references in formulas instead of constant values? (Points : 2)

You can easily include letters, numbers, and spaces

It is easier to debug the errors

You can change the input values without changing the formulas

You can control the sequence in which Excel performs arithmetic operations

(TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula? (Points : 2)

Cannot complete a sequence of dates in a column

Changes the background color of the selected cells to yellow

Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula

Has two or more sub-commands related to the command

(TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)

A shortcut to cell A1

There are two or more sub-commands related to the command

The next step in the process

Directionality

(TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a: (Points : 2)

Workbook.

Ledger

Document

Journal

(TCO 1) Which of the following describes the horizontal Alignment in Excel 2010? (Points : 2)

Refers to the up-down position of contents in a cell

Removes the vertical lines running through the data

Puts a line horizontally through the data

Refers to the left-right position of contents in a cell

(TCO 3) A data series is a group of related ____________. (Points : 2)

Charts on a worksheet

Category labels on a horizontal axis

Data points on a chart

Numerical values on a vertical axis

(TCO 3) Which of the following best describes a column chart? (Points : 2)

Displays data comparisons vertically in columns

A horizontal line that borders the plot area to provide a frame of reference for measurement

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

(TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)

Compares values for one set of data

Groups or clusters similar data in columns to compare values across categories

Is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Compares two or more sets of data in one chart

(TCO 3) When creating a chart in Excel, a multiple data series _______. (Points : 2)

Groups or clusters similar data in columns to compare values across categories

Compares two or more sets of data in one chart

Is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color

(TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart. (Points : 2)

Expanded

Exploded

Displaced

Clustered

(TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: (Points : 2)

Design, Layout, and Format

Home, Insert, and Page Layout

Chart, Type, and Formulas

Data, Review, and Data

(TCO 3) Which of the following best describes a sparkline? (Points : 2)

A label that describes either the category axis or the value axis

A miniature chart contained in a single cell

The value or name of a data point

A label that describes the chart

 Additional Questions to Quiz 1

 (TCO 1) Which of the following best describes a cell address?

Identifies the electronic “neighborhood” of a spreadsheet

Identifies a cell by a column letter and a row number

Searches for and displays similar labels as you type

Is a number that represents a quantity and can be the basis of calculations

(TCO 1) Which of the following best describes the AutoComplete function?

Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

(TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?

Includes letters, numbers, and spaces

Controls the sequence in which Excel performs arithmetic operations

Is a software application used to create and modify business communications

Includes formulas, functions, and formatting

(TCO 1) When you paste copied data, Excel displays the Paste Options button:

In the status bar at the left of the screen

In the next set of nonadjacent ranges

On the toolbar

In the bottom right corner of the pasted data

(TCO 3) Groups of related numeric values in an Excel worksheet are:

Data point

Data roles

Categories

Data series

(TCO 3) Which of the following best describes the chart area?

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

A vertical line that borders the plot area to provide a frame of reference for measurement

A horizontal line that borders the plot area to provide a frame of reference for measurement

(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:

Stacked column chart

Pie chart

3-D column chart

Box diagram

(TCO 3) In Excel, an area chart _______

Shows the high, low, and close prices for individual stocks over time

Trends using two dimensions on a continuous curve

Emphasizes the magnitude of changes over time by filling in the space between lines with a color

Shows a relationship between two variables

(TCO 3) After creating a chart, you can change the chart type by using _____.

Page Layout tab / Chart Options button

Design tab / Change Chart Type button

Data tab / Chart Changer tool

You cannot change the chart

BIS 155 Data Analysis with Spreadsheets

Quiz Week 2 

https://www.hiqualitytutorials.com/product/bis-155-quiz-week-2/

(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 2) Which of the following best describes a mixed cell reference? (Points : 2)

Occurs when a formula directly or indirectly refers to the cell containing the formula

Causes a potential error

Contains absolute or relative cell references, but not both

Contains both an absolute and a relative cell reference

(TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2)

Abstract

Relative

Mixed

Absolute

(TCO 2) Which of the following describes the SUM function? (Points : 2)

Identifies the midpoint value in a set of values

Calculates the total of values contained in two or more cells

Calculates the arithmetic mean or average of values in a range

Displays the lowest value in a range

(TCO 2) The _____ function returns a result based on a condition. (Points : 2)

Max

Today

Find

If

(TCO 2) Which of the following best describes the COUNT function? (Points : 2)

Tallies the number of cells in a range that are not empty

Tallies the number of blank cells in a range

Displays the current date

Tallies the number of cells in a range that contain values

(TCO 2) The NOW function would perform which of the following? (Points : 2)

Contains another function embedded inside one or more of its arguments

Evaluates a condition and returns one value if the condition is true and a different value if the condition is false

Evaluates true or false

Displays the current date and time

(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)

Lookup value
Column index

Lookup table

Random
(TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2)

Sizing handle

Pointer

Fill handle

Insertion point

(TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2)

It directly or indirectly refers to the cell containing the formula

It contains both an absolute and a relative cell reference

It identifies the present value of the loan

If you copy the formula, you do not have to make the cell reference absolute

(TCO 2) The PMT function is best described by which of the following? (Points : 2)

It is the periodic interest rate, such as a monthly interest rate

It is the total number of payment periods

It is the present value of a loan

It calculates the periodic payment for a loan with a fixed interest rate and a fixed term

(TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks? (Points : 2)

Macros

Templates

Themes

Background

(TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit. (Points : 2)

Format

Hide

Lock

Unlock

(TCO 7) By default, a macro records cells as _____ references if they are selected while recording the macro. (Points : 2)

Absolute

Relative

Flexible

Mixed

(TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2)

Saves

Deletes

Runs

Disables

(TCO 2) In Excel, a function can be defined as a _____. (Points : 2)

Predefined formula that performs a calculation

Cell reference or a value

List of values and defined names as you enter data into a spreadsheet

Set of rules that govern the structure and components for a formula

(TCO 2) The rules for constructing a function can be referred to as the function’s _____.

Synthesis

Synergy

synchronization

syntax

(TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____.

Logical test

Lookup value

Breakpoint

Table array action

(TCO 2) If you enter an = and the first few letters of a function in the formula bar, Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.

Syntax Helper

Formula AutoComplete

Formula Wizard

Function Finder

(TCO 2) Which of the following best describes the HLOOKUP function?

The periodic interest rate, such as a monthly interest rate

Calculates the periodic payment for a loan with a fixed interest rate and fixed term

Looks up a value in a lookup table where the first column contains the values to compare with the lookup value

Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value

(TCO 7) Which of the following file formats can store macros?

Xlsm

CSV

XML
XLSX

(TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.

View

Data

Insert

Developer

BIS 155 Data Analysis with Spreadsheets

Quiz Week 3 

https://www.hiqualitytutorials.com/product/bis155-quiz-week-3/

(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, a table is defined as _____. (Points : 2)

An area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis

A complete set of data for an entity

A Field, which is an individual piece of data

An individual piece of data, such as a last name

(TCO 4) To create a table from an existing range of data, _____. (Points : 2)

Click within the range, click the Table Tools Design tab, and then select Convert to Table

Select any cell in the worksheet and then click Existing Range in the Tools group

Click in a cell and on the Home tab, and click the Insert arrow in the Cells group

Click the Insert tab and then click Table in the Tables group

(TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. (Points : 2)

A Date Filter

A Text Filter
the use of a table element as a formula

A Number Filter

(TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____. (Points : 2)

A PivotTable

A multiple level sort

Conditional formatting

A range name

(TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____. (Points : 2)

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

(TCO 4) For Subtotals to be useful and accurate, it is important that the data be _____ correctly. (Points : 2)

sorted
formatted

aligned

labeled

(TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group. (Points : 2)

Tables

Format

Layout

Chart

(TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____. (Points : 2)

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

(TCO 4) Data displayed in the PivotTable will be updated _____. (Points : 2)

When you right-click a cell in the PivotTable and select Refresh

Automatically as soon as the source data changes

When you select the worksheet containing the PivotTable

When you create a PivotChart

(TCO 4) A quick way to display the Go to dialog box is to press the _____ key(s). (Points : 2)

F4

Ctrl+Home

Ctrl+End
F5

(TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s). (Points : 2)

Ctrl+End

Arrow

Ctrl+Home

Esc

(TCO 4) Click the _____ to sort or filter the chart representation based on the values. (Points : 2)

Axis Field arrows

Report Filter arrows

Values arrows

Legend Field arrows

(TCO 4) Pivot Charts look best when they use basic charts, such as a _____. (Points : 2)

Column chart

Scatter chart

Radar chart

Surface chart

(TCO 4) Which of the following best describes a page break?

Freezes only the top row

The sequence in which pages print

Indicates where data starts on a new printed page

Stops the printer from printing

(TCO 4) The Subtotal command is located on the _____ tab.

Data

Formula

Page layout

Insert

(TCO 4) _____ are created to organize and summarize data in PivotTables.

Categories

Types

Titles

Levels

(TCO 4) To create a calculated field, select _____ located on the PivotTable Tools Options tab.

Calculations

Insert Calculated Field dialog launcher

Tools

PivotTable Calculation

(TCO 4) A Pivot Table Style controls all the following EXCEPT _____.

Bolding

Font colors

Number format

Shading colors

(TCO 4) The PivotChart Tools contextual tab includes all the following EXCEPT _____.

Design

Layout

Format

Type

(TCO 4) Which of the following will NOT delete a PivotChart?

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

BIS 155 Data Analysis with Spreadsheets

Quiz Week 4 

https://www.hiqualitytutorials.com/product/bis155-quiz-week-4/

(TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2)

Commas

Tabs
Spaces

Hyphens

(TCO 8) Which of the following is NOT a text file? (Points : 2)

Tab-delimited

Comma-separated value

XML

Fixed-width

(TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2)

Click the Refresh All command.

Save the Excel workbook.

Click the Refresh All arrow, then click Refresh.

Right-click in a range of data and then select Refresh.

(TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2)

File

Data

Insert

Page Layout

(TCO 8) To change the text string jOHn dOE to John Doe, use the ________ function. (Points : 2)

CONCATENATE

PROPER

UPPER

LOWER

(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2)

UPPER

LOWER

PROPER

CONCATENATE

(TCO 8) Which of the following functions does not change the case or capitalization of text? (Points : 2)

PROPER

CAPS

UPPER

LOWER

(TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon. (Points : 2)

Merge

Mailings

Home

Review

(TCO 8) The New Comment command is located on the ________ tab. (Points : 2)

View

Review

Data

File

(TCO 8) If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need: (Points : 2)

Empty columns to the right of column C.

Empty rows at the bottom of the worksheet.

Empty columns to the left of column C.

Empty rows at the top of the worksheet.

(TCO 8) The command to track changes is located on the ________ tab. (Points : 2)

File

Data

Review

View

(TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab. (Points : 2)

File

Home

Insert

View

(TCO 8) The ________ command displays additional document properties such as Company. (Points : 2)

Options

Permissions

Show Fewer Properties

Show All Properties

(TCO 8) To join two or more text strings into one text string, you can use the ___________. (Points : 2)

Convert Text to Columns Wizard

Merge and Center command on the Home tab of the Ribbon

CONCATENATE function

Street Address

(TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password. (Points : 2)

Check for Issues

Protect Workbook

Manage Versions

Options

Additional Questions/Answers

(TCO 8) Which of the following is one of the most common file types imported into Excel?

Text

PowerPoint

Web

Word

(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.

Fixed

Mixed

Divided

Text

(TCO 8) Which of the following is a frequently used function to manipulate txt?

CONCATENATE

PMT

IF

DATE

(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.

CONCATENATE

PROPER

UPPER

LOWER

(TCO 8) Which of the following will produce the same result as the CONCATENATE function?

=A4&B4

=A4+B4

=A4B4

=A4,B4

(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.

Type New List

Use Existing List

Import from Excel

Select from Outlook Contacts

(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.

Split Names Wizard

PivotTable feature

CONCATENATE function

Convert Text to Columns Wizard

(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.

Gmail

Hotmail

Yahoo

Outlook

(TCO 8) Windows can search for files by author name or keywords that have been entered into ________.

a file name

the Trust Center

document properties

cell A1

(TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text.

PROPER

UPPER

SUBSTITUTE

RESPOND

BIS 155 Data Analysis with Spreadsheets

Quiz Week 5 

https://www.hiqualitytutorials.com/product/bis155-quiz-week-5/

(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 workbook are opened, Excel adds ________ to the title bar of the second window. (Points : 2)

The letter B

The number 2

The letter A

The number 1

(TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet? (Points : 2)

Drag a split box

Double-click a split box.

Right-click in the active cell and click Split.

Click Split in the Window group on the View tab.

(TCO 5) If a worksheet name has a space in it, ________ surround the worksheet name in the worksheet reference. (Points : 2)

Double quotation marks

Single quotation marks

Parentheses

Brackets

(TCO 5) Which formula would return the #NAME? error? (Points : 2)

=SUM(B6.B12)

=MAX(B6:B12)

=AVG(B6:B12)

=IF(A6=”Atlanta”,A3,0)

(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)? (Points : 2)

A1

A2

A3

A1 & A2

(TCO 6) A one-variable data table must have at least ________ blank row(s) and ________ blank column(s) between the dataset and the data table. (Points : 2)

Two, two

Two, one

One, two

One, one

(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments? (Points : 2)

Scenario Manager

Goal Seek

One-variable data table

Two-variable data table

(TCO 6) What is the main difference between Goal Seek and variable data tables? (Points : 2)

Goal Seek produces a list of result values.

Goal Seek uses the original worksheet data to change an input.

Goal Seek manipulates multiple variables to produce multiple results.

Goal Seek shows results in a separate table.

(TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)

What-If Analysis

Data Validation

Consolidate

Advanced

(TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? (Points : 2)

Scenario Manager

Goal Seek

Data Table

Solver

(TCO 6) What happens when you add a new scenario and generate a new scenario summary report? (Points : 2)

The new report will be created on a new worksheet.

The new scenario will be included into the old report.

The new report will be added directly below the original report.

The new report will replace the original report.

(TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box? (Points : 2)

Add

Format

Change

Delete

(TCO 6) The maximum number of scenarios Scenario Manager can handle is: (Points : 2)

30

32

18

16

Additional questions

(TCO 5) Excel’s multiple worksheet abilities can do all of the following EXCEPT:

Create Pivot Charts

Group worksheets together to enter data

Display worksheets side by side

Create links among the worksheets

(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?

Click the first tab, hold Shift, and then click the last tab.

Click the first tab, hold Ctrl, and then click the last tab.

Right-click a worksheet tab, then select All Sheets.

Right-click a worksheet tab, then select Group.

(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening the ________ file.

Worksheet

Workspace

Workview

worklink

(TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?

“[New.Jersey.xlsx]Qtr4!”B6

‘[New.Jersey.xlsx]Qtr4!’B6

[NewJersey.xlsx]Qtr4!B6

Textbook Chapter 8

(TCO 5) Before you can create an external reference you must first __________.

Select the cell or cells to hold the external reference.

Open the destination workbook and all source workbooks.

Switch to the source workbooks and click the cells.

Click on Insert Function on the Formulas tab.

(TCO 5) Which of the following is the proper use of a 3D formula?

=SUM(Yr1:Yr5!C7)

=SUM(Yr1-Yr5!C7)

=SUM(‘Yr1:Yr5’!C7)

=SUM(“Yr1:Yr5”!C7)

(TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?

Solver

Data Table

Scenario Manager

Goal Seek

(TCO 6) The Scenario Manager dialog box enables you to do all the following EXCEPT:

Format scenarios.

Add scenarios.

Delete scenarios.

Edit scenarios.

(TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the:

Scenario names.

Formatting of the results.

Cells containing the formulas that generate the results

Final results.

(TCO 6) The initial results of a Goal Seek are:

Automatically entered into the worksheet.

Inserted into a new worksheet.

Presented visually in a chart.

Shown in the Goal Seek Status dialog box.

BIS 155 Data Analysis with Spreadsheets

Final Exam 

https://www.hiqualitytutorials.com/product/bis-155-final-exam/

(TCO 1) The salespeople for The Edwards Company earn a commission on top of their regular pay if they sell more than $5,000 in a week. You have started a worksheet shown below to track sales each week and calculate the commission, if any, earned for that week. Two rows of sample data have been entered to test formulas.

https://www.hiqualitytutorials.com/product/salespeople-edwards-company-earn/

Part 1: Write the formulas needed in Cells I7 and J7 to total sales and calculate commission, if any, earned for the week. Use cell references in your formulas, and write them so that they may be copied to Cells I8 through I11 and J8 through J11.

I7 is the total sales of the week and…

Part 2: Write the formula needed in Cell B19 to show the amount of the highest sales for the week, and the formula needed in B20 to show the average sales by salesperson for the week.

To find the maximum sales, the…

Part 3: Describe the formatting needed to give the worksheet a professional appearance.

Professional appearance makes it…

Part 4: You know others in your company may have questions about the worksheet, so you want to be sure they know who created it and the purpose of the worksheet. Describe the best way to incorporate this information into your workbook.

The information on the purpose and the creator of a…

BIS 155 Data Analysis with Spreadsheets

(TCO 3) Assume you work for a local business person who owns 3 different fast food franchise locations in town. The owner would like to analyze the productivity and operations of each store individually as well as in comparison to each other. Each location is currently tracking operations in a spreadsheet which includes sheets for analyzing three key areas of interest to the owner.

The first sheet for tracking inventory quantity and prices for food and paper products looks something like the following:

https://www.hiqualitytutorials.com/product/assume-work-local-business/

The owner also wants to track the following:

  • revenue/sales by product category and by individual item
  • employee data including schedules and salary expenses

Part 1: Select one of the above mentioned key areas and identify and explain what fields should be included in this analysis. Also explain HOW you would recommend organizing the data using features like data tables or pivot tables.

If using data tables explain how you would accomplish the sorting, filtering and formatting using the fields you identify.

If using a pivot table then explain how you would create the pivot using the categories mentioned above. Which fields would be placed in the report, column, row and value fields when organizing the data?

Using the revenue/sale by individual item I would consider using first…

Part 2: Using the data table or pivot table explained above, identify what type of chart you would recommend to use when comparing the 3 locations for the owner. Clearly explain WHY you are recommending that specific type of chart for the data – why is that data a good fit for that type of chart? Also include ideas for formatting this chart to make this important information more “readable” for the franchisee owner.

(Points : 40)

The best chart to use in this case to compare the…

https://www.hiqualitytutorials.com/product/ted-has-been-retired/

Ted has been retired the last few years and has passionately resumed golfing. He has recorded the round number, date, golf course, number of putts, and total score for each round in Excel as shown in the truncated diagram above. After almost three years of data collection and 300+ rounds of golf, Ted decides to analyze the data to determine if he has improved during this time.

Part 1: Ted would like to calculate the average scores for each golf course over the past three years. What Excel tool will allow you to do this? Be sure to specify the exact steps to obtain the desired results.

The best excel tool to use in this case is the…

Part 2: Based on your response from part 1, what other Excel tool can be used to produce the same results? Again, be sure to specify the exact steps to obtain the desired results.

The other tool that can be used to….

Part 3: Ted would also like to view only the rounds of golf where he had greater than 32 putts for the round. The number of putts should be displayed from highest to lowest. Please describe the steps to achieve this result.

To select the values that are greater than 32….

Part 4: To determine if he has improved over the past 3 years, Ted would like to calculate a running average in column F. A running average displays the average for all rounds played to date. For example, the running average in cell F4 should show the average for the total scores for round numbers 1 through 3. Write this formula as if it were in Cell F2. Write the formula so that it may be copied down the column without modification.

(Points : 40)

=if(F1 + F2 +….

BIS 155 Data Analysis with Spreadsheets

(TCO 5) You are the owner of three clothing stores and you would like to see how much combined profit you made from your three stores. Below are three worksheets titled “John”, “Bob”, and “Ruth” which show the ‘Total Sales’ during the months of January and February.

https://www.hiqualitytutorials.com/product/owner-three-clothing-stores/

Using the three worksheets shown above, you will create a new worksheet called “2014” which will consolidate and summarize the information from the stores of John, Bob, and Ruth. The new worksheet will look similar to what you see below.

Part 1. Write out a 3-D formula using the SUM function as if it were in (Cell B2) of worksheet “2014” that will calculate the Total Shirt Sales for John, Bob, and Ruth. Write the formula so that it may be copied to the month of February (Cell B3) without modification.

A 3-D formula will be…

Part 2. Write out a worksheet reference formula without the SUM function as if it were in (Cell C2) of worksheet “2014” that will calculate the Total Pant Sales for John, Bob, and Ruth. Write the formula so that it may be copied to the month of February (Cell C3) without modification.

= CountIf….

Part 3. Now that there are Total Shirt Sales and Total Pant Sales for January and February in the “2014” worksheet, it is time to calculate CLOTHING TOTAL in all four worksheets (“John”, “Bob”, “Ruth”, and “2014”). Explain how you will complete this step without retyping the formula in each worksheet. Discuss the advantages of doing it this way and describe any pitfalls that might take place.

To calculate the clothing total, one can comfortably use the…

Part 4. Write out a formula using the SUM function as if it were in (Cell D2) of ALL worksheets that will calculate the CLOTHING TOTAL. Write the formula so that it may be copied to the month of February (Cell D3) and to the CLOTHING TOTAL YEARLY TOTAL (Cell D4) without modification. Also, write out a formula using the SUM function as if it were in (Cell B4) of ALL worksheets that will calculate the YEARLY TOTAL for Total Shirt Sales. Write the formula so that it may be copied to YEARLY TOTAL for Total Pant Sales (Cell C4) without modification.

=Sumif….

Part 5. You are interested in viewing the contents of all four worksheets (John, Bob, Ruth, and 2014) side-by-side on the screen. Describe the steps that will arrange the worksheet tabs this way and discuss the advantages of doing this.

Basically, this will involve viewing of the three…

BIS 155 Data Analysis with Spreadsheets

(TCO 3) A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales manager at the corporate office. The data is sent in an Excel spreadsheet. Describe a data consolidation strategy and at least two different types of visualization techniques the sales manager can use to analyze the data received from all stores. Be sure to include formulas that are to be used in the Excel spreadsheet. (Points : 40)

https://www.hiqualitytutorials.com/product/retail-chain-keeps-daily/

Data consolidation strategy is a new concept that a majority of mangers are trying to adopt in order to keep track of their…

(TCO 9) You are a current student with DeVry University and have a work study job in the College of Business & Management. The Dean understands that you have completed BIS155 and has a data set saved to a .csv file format that needs to be analyzed. There are a total of ten employees with 216 record entries for the 2014 year including individual hours worked in the range of 15 to 79 hours per week. The data set includes the following fields: Employee Name, Week Ending Date, Hours Worked, Hourly Wage, Gross Pay, and Net Pay. The Dean has asked you to use your skills learned from BIS155 to create the following reports with the support of Microsoft Excel integrated into Microsoft Word:

Report 1: Total Net Pay by Employee to Date

Report 2: Total Hours Work to Date

Report 3: Comparison of Total Net and Gross Pay to Date

Report 4: Employees that have worked Over 40 hours for any given week

In scholarly and descriptive details, share with the dean a complete step by step process in how you plan to create these four reports presented in Microsoft Word. Also take into account that the Dean may also like illustrative options with charts.

(Points : 40)

https://www.hiqualitytutorials.com/product/you-are-current-student/

To create report 1, The user will select the….

To create report 2, The user will select the name of each employee from the employee…

To create report 3, The user will select the…

(TCO 5) Mark Jacobs, owner of Jacob’s Mini-Mart currently operates two stores in Atlanta. His business has been very successful, and he is now opening two new stores. He will no longer be able to manage all stores himself, so he is hiring managers for three of the four stores. He will continue to operate one store, and act as general manager over the company. He is looking for an easy and efficient way to collect information from the stores, and he would like your help with the following:

PART 1 Marc wants you to design a worksheet for his managers to complete showing the sales by product category by month at each store. He wants to be sure the managers don’t change the formulas in the worksheet. Describes the characteristics of the worksheet.PART 2 Describe the process Mark will use in combining the completed worksheets into on workbook and creating the summary report.(Points : 40)

https://www.hiqualitytutorials.com/product/mark-jacobs-owner-mini-mart/

Part 1 For the case of Jacob’s Mini-Mart, he needs to have a way of …

Part 2 For the completed worksheets to make sense to the users….

BIS 155 Data Analysis with Spreadsheets

(TCO 9) You are assigned to analyze a large dataset containing the detailed records of invoices of a company’s customers which contain the customer ID, their address, city, region, post code, country and sales person and additional information about specific order id, order date, shipped date, shipper, product ordered, unit price, quantity, discount, ship address, ship city, ship postal code, ship country, and product category name. Explain how you would use Excel and Excel formulas to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations. (Points : 40)

https://www.hiqualitytutorials.com/product/assigned-analyze-large-dataset/

The use of excel for data analysis is one the best processes that data…

(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. 

https://www.hiqualitytutorials.com/product/payroll-manager-for-employer/

Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification.
Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula…
Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula…
Part 4: Salaried and Exempt employees (Pay Codes E and S) are covered by the company’s health insurance. The deduction is $10.00 per week. Write a formula as if it were in Cell H2 that calculates the Insurance deduction (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. (Points : 40)

(TCO 3) You are a Microsoft Office trainer for DeVry University. The training topic for the current month is charts using Microsoft Excel. During each training session from different departments or cohorts, the following frequently asked questions were asked and you decide to create a document formalizing answers and suggestions.

https://www.hiqualitytutorials.com/product/you-microsoft-office-trainer/

  1. My supervisor, Sally, likes my charts; however, she instructs me to take more time planning my charts before creating the actual chart itself. Why is planning the creation and development of a chart so important?
  2. My supervisor, John, ask me to chart some comparative data but my first attempt with a column chart did not illustrate the data as well as he would have liked. What type of chart is ideal and best to illustrate comparative data of individual items in a data series and why?
  3. My supervisor, Jessica, asked me to project future data trends using a chart. Most of the data is associated with sales and depending on the nature of what is sold, data either fluctuates or increases quickly. What chart feature added to a column chart can help project these data trends and why?
  4. My supervisor, Thomas, asked me to add some creativity with color and enhancements on all charts used during weekly meetings. What should I consider to avoid being overly creative and why is this important? (Points : 40)

(TCO 5) You work for a local construction firm “DeVry Engineering Group” and your supervisor, Jessica, needs an updated earned value analysis index of the prior month for an existing capital project (0000001) that has a current Budget at Completion (BAC) of $1500.00, a current earned value of (EV) of $300, a current actual cost (AC) of $500.00, and a current planned value (PV) of $350.00. In order to calculate the current average index, assume the following variables and standard formulas below:

https://www.hiqualitytutorials.com/product/work-for-local-construction/

Cost Variance(CV)EV–AC
Cost Performance Index(CPI)EV/AC
Schedule Variance(SV)EV–PV
Schedule Performance Index(SPI)EV/PV
Estimate to Completion(ETC)EAC–AC
Estimate at Completion(EAC)BAC/CPI
Variance at Completion(VAC)BAC–EAC
Status (Earned Value Index)(EVI)(CPI+SPI)/2

Also assume that a final calculated average index of 1.00 or greater represents a project being on track and in good standing. In addition, there could be several options for the descriptive methods to design this worksheet and below is a worksheet setup with the following “3” columns including any other needed top labels like for the existing Month already calculated.

  1. Based on the current calculated earned Status (Earned Value Index) for work order 0000001, is the current capital project in good standing?
  2. Your supervisor, Jessica, wants the worksheet, on row 16 or 17, to automatically provide a project status as being “In the Red” (Poor Standing) or “In the Black” (Good Standing). Explain descriptively how you could use a conditional formula to report the project status.
  3. Your Supervisor, Jessica, has 3 additional projects with work orders, 0000002, 0000003, and 0000004 she wants added to this Excel Workbook where each work order is monitored on a separate worksheet like work order 0000001. Jessica would like to have a summary worksheet which compiles all information for all work orders. The overall design of the summary worksheet will match the same general design as with work orders 0000001 through 0000004. Descriptively describe steps needed to link these worksheets together along with any ideas for formulas and functions to give an overall picture of all project work orders combined so that Jessica can see an overall holistic view of the Status (Earned Value Index) across all these work orders being managed.
  4. Based on the summary worksheet, Jessica, would like to see a chart which can help with future projections of the Status (Earned Value Index). Descriptively describe which chart you would recommend with any features that will help Jessica with future projections. Also using your intuition and creative mind, descriptively describe if any other information needs to be charted from the summary worksheet which may help Jessica with future cost projections and why? (Points : 400

(TCO 5) A table named “Daily Sales” in a Microsoft Access database has the following fields:

Product A
Product B
Product C
Product D

Each record on the table represents a day of total sales for each product and the data covers the last five years. Your boss asks you to create a visual report of the sales performance of each product during the last 12 months.

Prepare a step-by-step description of how you would use Microsoft Excel to prepare the report and email it to your boss following these steps:

Step 1 – Import data from Access to Excel
Step 2 – Summarize Monthly Data for each product during the last 12 months
Step 3 – Create a visual representation of monthly data
Step 4 – Email the spreadsheet with your comments to your boss (Points : 40)

BIS 155 Data Analysis with Spreadsheets

(TCO 9) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data.  Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.
Note: This is a one part question. (Points : 40)

BIS 155 Data Analysis with Spreadsheets

Discussions Week 1-7

All Students Posts 265 Pages 

https://www.hiqualitytutorials.com/product/bis-155-all-discussions/

Getting Familiar with Excel Discussions Week 1 All Students Posts – 39 Pages

https://www.hiqualitytutorials.com/product/getting-familiar-with-excel/

Excel was introduced in 1985. Since then, it has become a standard business tool. In this thread, discuss the different features of Excel that make it a valuable business tool. In addition, discuss why Excel skills are so important in today’s job market. Many people take Excel for-granted this day in age.  I remember when it didn’t exist.  What did people do before they had such an amazing tool? What was the first electronic spreadsheet named?  It wasn’t Excel…..

Formulas and Functions Discussions Week 2 All Students Posts – 48 Pages 

https://www.hiqualitytutorials.com/product/bis-155-formulas-functions/

One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.

  • You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
  • You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50.
  • You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due….

Data Analysis Discussions Week 3 All Students Posts – 37 Pages

https://www.hiqualitytutorials.com/product/data-analysis-with-spreadsheets/

Excel provides many different ways in which to analyze data.  Discuss the different methods by which you can analyze data in your spreadsheet.  Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amounts of sales data you have.  What are some of the ways Excel can be used to analyze this data?  What are some examples of reports you might want to review?  Using the concepts from this week, how will you determine where to start and what tools can you use within Excel to help you organize everything and make decisions? What types of data might a sales manager need to track?…

Excel Data Exchange Discussions Week 4 All Students Posts – 30 Pages 

https://www.hiqualitytutorials.com/product/bis155-excel-data-exchange/

Excel 2010 provides the capability to exchange data with other applications.  Discuss the different types of ways to exchange data between Excel and other Microsoft applications.  Are there limitations to the exchange process?  How can you exchange data with other applications that are not part of the Microsoft Office Suite?  Discuss how you would exchange data with external data sources such as websites. There are several ways to exchange data between Microsoft Access and Microsoft Excel.  Describe a business scenario where it might be important to have these two popular pieces of software share data?…

Data Consolidation and What-if Analysis Discussions Week 5 All Students Posts – 39 Pages 

https://www.hiqualitytutorials.com/product/data-consolidation-if-analysis/

Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used. Let’s begin by defining the terms we will be working with this week. What is meant by Data Consolidation?  What are some examples in which you might want to consolidate data?…

Bringing it All Together Discussions Week 6 All Students Posts – 37 Pages 

https://www.hiqualitytutorials.com/product/bringing-it-all-together/

Database Decisions Discussions Week 7 All Students Posts – 35 Pages 

https://www.hiqualitytutorials.com/product/bis-155-database-decisions/

Discuss the differences between storing data in Access and Excel.  Why would you use a spreadsheet over a database?  At what point does it become more efficient to store your data in a database rather than a spreadsheet?  If you are deciding whether to use a spreadsheet or database, what questions should you consider? What can a relational database do for a person or company? Access is designed to handle data integrity … How do relational database tables help handle data integrity?…

BIS 155 Data Analysis with Spreadsheets

DeVry