2023 DeVry Chicago BIS 155 Week 1 2 3 4 5 Quiz 2014 Midterm employment law Exam Week 1 Quiz | Assignment Collections

DeVry Chicago BIS 155 Week 1,2,3,4,5 Quiz 2014 & Midterm employment law Exam

Week 1 Quiz

1. Question : (TCO 1) An Input Area (as it applies to Excel 2010) is defined as______.

  Student Answer:    a range of cells containing results based on the output 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

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

  Student Answer:   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

Question 3. Question : (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use?

  Student Answer:   F4      Ctrl + Alt + Delete      The Ctrl + D key combination       The Ctrl and semicolon key combination

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

  Student Answer:   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

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

  Student Answer:   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

Question 6. Question : (TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?

  Student Answer:   Just type longer or taller formulas in some of them       Click and drag across the cells to select them and use any sizing method you choose
     Drag the fill handle across the cells      Type A1 in the “Go To” dialog box

Question 7. Question : (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________.

  Student Answer:   columns, rows, and fields      numbers, fonts, and styles      functions, comments, and macros       text, values, and formulas
Question 8. Question : (TCO 1) When you paste copied data, Excel displays the Paste Options button:

  Student Answer:   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.
Question 9. Question : (TCO 3) A data series is a group of related ____________.

  Student Answer:   charts on a worksheet      category labels on a horizontal axis       data points on a chart      numerical values on a vertical axis

Question 10. Question : (TCO 3) Which best describes a data point?

  Student Answer:    A numeric value that describes a single value on a chart      A group of related data points      Displays data comparisons vertically in columns      Text that describes a collection of data points in a chart
Question 11. Question : (TCO 3) When creating a chart in Excel, the plot area ________.

  Student Answer:    contains graphical representation of values in data series      is a vertical line that borders the plot area to provide a frame of reference for measurement
     is a horizontal line that borders the plot area to provide a frame of reference for measurement
     provides descriptive group names for subdividing the data series

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

  Student Answer:   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

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

  Student Answer:   expanded       exploded      displaced     

Question 14. Question : (TCO 3) In Excel, an area chart _______.

  Student Answer:   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   

Question 15. Question : (TCO 3) Which of the following best describes a trendline?

  Student Answer:    A line used to depict trends and forecast future data      Text that describes a collection of data points in a chart      A group of related data points      Displays data comparisons vertically in columns   

DeVry Chicago BIS 155 Week 2 Quiz 2014

Week 2 Quiz

 1. Question : (TCO 2) In Excel, a relative cell reference:

  Student Answer:   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.

Question 2. Question : (TCO 2) Which of the following best describes a mixed cell reference?

  Student Answer:   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. 
 

Question 3. Question : (TCO 2) =$E2-G$4 contains examples of _____ cell references.

  Student Answer:   absolute 
      mixed 
     relative 
     constant 

Question 4. Question : (TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.

  Student Answer:   PRESENT 
      TODAY 
     CURRENT 
     SET 

Question 5. Question : (TCO 2) The MEDIAN function would identify the ____.

  Student Answer:   lowest value in a range. 
      midpoint value in a range. 
     highest value in a range. 
     total number of cells in a range. 

Question 6. Question : (TCO 2) Which of the following best describes the COUNT function?

  Student Answer:   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. 
 

Question 7. Question : (TCO 2) The _____ function can be used to find an answer located in a vertical table.

  Student Answer:   FIND 
     SEARCH 
     HLOOKUP 
      VLOOKUP 
 

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

  Student Answer:   lookup value 
      column index 
     lookup table 
     random 

Question 9. Question : (TCO 2) Which of the following best describes the HLOOKUP function?

  Student Answer:   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.
 

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

  Student Answer:   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
 

Question 11. Question : (TCO 2) When calculating a PMT function, the PV is best described by which of the following?

  Student Answer:   It is a set of range names. 
     It is a word or a string of characters that represent one or more cells.
      It is the present value of the loan. 
     It is why you do not have to make the cell reference absolute in the formula.
 

Question 12. Question : (TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.

  Student Answer:   theme 
     style 
      template 
     macro 
 

Question 13. Question : (TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.

  Student Answer:    home 
     page layout 
     data 
     view 
 

Question 14. Question : (TCO 7) Which of the following file formats can store macros?

  Student Answer:    xlsm 
     csv 
     xml 
     xlsx 
 

Question 15. Question : (TCO 7) Users must click _____ Content to use the workbook and run the macros in the workbook.

  Student Answer:    Enable 
     Disable 
     Run 
     Delete 
DeVry Chicago BIS 155 Week 3 Quiz 2014

Week3 Quiz

 1. 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.

  Student Answer:     hide
      delete
       freeze
      format

Question 2. Question : (TCO 4) Which of the following best describes a page break?

  Student Answer:    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

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

  Student Answer:     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

Question 4. Question : (TCO 4) Which of the following best describes the Excel filtering feature?

  Student Answer:    Helps to clean the data before printing in Backstage view
      Displays data in chronological order
       The process of displaying only records that meet specific conditions
       Arranges dates in alphabetical order

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

  Student Answer:    a PivotTable
      a multiple level sort
       conditional formatting
      a range name

Question 6. Question : (TCO 4) In addition to sorting and filtering cells by content, you can sort and/or filter by _____.

  Student Answer:    top/bottom rules
       conditional formatting
      icon sets
      the data bar

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

Question 9. Question : (TCO 4) Data mining techniques such as PivotTables can detect _____ of data.

  Student Answer:     patterns
       categories
      styles
      groups

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) Excel applies basic formatting to PivotTables such as _____.

  Student Answer:    subtotals in italics
       primary row labels in bold
      primary row labels in italics
      subtotals in red

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) To go to the top of your spreadsheet quickly, use the _____ key(s).

  Student Answer:    Ctrl+End
      Arrow
       Ctrl+Home
      Esc

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

  Student Answer:    Axis Field arrows
      Report Filter arrows
      Values arrows
       Legend Field arrows

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

  Student Answer:     column chart
      scatter chart
      radar chart
      surface chart

QUIZ 5
Week 5 Quiz
1. Question : (TCO 5) Excel’s multiple worksheet abilities can do all of the following EXCEPT:

  Student Answer:    create Pivot Charts. 
     group worksheets together to enter data. 
      display worksheets side by side. 
     create links among the worksheets. 

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

  Student Answer:    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 Select All Sheets. 
     Right-click a worksheet tab, then select Group. 

Question 3. 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.

  Student Answer:    horizontal 
     vertical 
     diagonal 
     square 

Question 4. Question : (TCO 5) In Excel, which of the following is NOT a method for removing a split window?

  Student Answer:   Drag a split bar to the edge of the worksheet. 
     Double-click a split bar. 
     Click Split in the Window group on the View tab. 
      Right-click in the active cell and click Remove. 

Question 5. Question : (TCO 5) Which of the following functions do NOT work with 3D formulas?

  Student Answer:   SUM 
      VLOOKUP 
     AVERAGE 
     COUNT 

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

  Student Answer:   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. 

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

  Student Answer:   =SUM(Yr1:Yr5!C7) 
     =SUM(Yr1-Yr5!C7) 
      =SUM(‘Yr1:Yr5’!C7) 
     =SUM(“Yr1:Yr5”!C7) 

Question 8. Question : (TCO 6) When creating a range for the substitution values in a one-variable data table, it is best to arrange them in a(n) ________ orientation.

  Student Answer:   horizontal 
      vertical 
     alphabetical 
     reverse 

Question 9. Question : (TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables.

  Student Answer:    one 
     two 
     three 
     four 

Question 10. Question : (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?

  Student Answer:   Scenario Manager 
     Solver 
     Data Table 
      Goal Seek 

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

  Student Answer:    What-If Analysis 
     Data Validation 
     Consolidate 
     Advanced 

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

  Student Answer:   scenario names. 
     formatting of the results. 
      cells containing the formulas that generate the results. 
     final result. 

Question 13. Question : (TCO 6) Where is Solver located if it is already loaded onto Excel?

  Student Answer:    Add-Ins tab 
     Formulas tab 
      Analysis group on the Data tab 
     Data Tools group on the Data tab 

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

  Student Answer:   Add 
      Format 
     Change 
     Delete 

Question 15. Question : (TCO 6) The maximum number of scenarios Scenario Manager can handle is:

  Student Answer:   30 
      32 
     18 
     16 

DeVry Chicago BIS 155 midterm employment law Exam
1. Question : TCO 1: John comes into the school’s office and sees Betty at the front desk. She’s the receptionist, but John doesn’t know what her job is. John asks Betty if she can register him for classes and provide some financial aid information. Betty says, “sure,” though Betty is not authorized to do these things. Betty registers John for the classes he requests & hands him a financial aid package. What type of authority does Betty display?
a) actual authority 
b) apparent authority 
c) implied authority 
d) expert authority 

2. Question : TCO 1: In determining whether a worker is an employee or an independent contractor, which of the following factors would a court consider?
a) Training. 
b) Control over the time and the manner of doing the work. 
c) Payment of business expenses and providing of tools. 
d) All of the above. 

  Comments:  3. Question : TCO 1: The number of states that have adopted the Model Employment Termination Act is:
a) All 50. 
b) 33. 
c) 1. 
d) Zero. 
  Instructor Explanation: p. 142
 
 
    
4. Question : TCO 1: An agreement not to go to work for your employer’s competitor is called a:
a) Noncompete Agreement. 
b) Unemployment Agreement. 
c) Collective Bargaining Agreement. 
d) Planned Agreement. 
 
 5. Question : TCO 9: John’s employer has a reasonable suspicion that John has been involved in a theft of several thousand dollars worth of tools. As part of the investigation, John undergoes a polygraph test and is asked a series of questions. Which of the following questions would be prohibited by the EPPA?
a) Questions about John’s use of prescription drugs. 
b) Questions about John’s performance of his job duties. 
c) Questions about inaccuracies on John’s employment application. 
d) Questions about John’s whereabouts at the time the tools went missing. 
    6. Question : TCO 9: The Drug-Free Workplace Act of 1988 applies to:
a) Student Answer:   all private employers. 
b) all state government employers. 
c) certain federal government contractors. 
d) all public school systems.
7. Question : TCO 4: Employees of the federal government have their privacy rights protected by the:
a) Privacy Act of 1974. 
b) Title VII. 
c) State law. 
d) Federal Employees Act. 
 
 
 8. Question : TCO 4: When an employee’s work environment becomes so intolerable that the employee has no choice but to resign, the employee’s job loss is referred to as:
a) Constructive discharge. 
b) Retaliation. 
c) Wrongful firing. 
d) Hostile discharge. 
 9. Question : TCO 1: What is apparent authority? Give an example?
   10. Question : TCO 1: What are the duties of the employee and/or the independent contractor?
 11. Question : TCO 2: Explain the three criteria for reverse discrimination under Affirmative Action plans
      12. Question : TCO 2: Barbara Ann Smith, from London, Connecticut, is white and applied for the leading role as a slave in a documentary on slaves and their escape from the South prior to the Civil War. She was not selected for the position because she is white, and therefore doesn’t look like the character she is wanting to protray. Is this a case of discrimination? Support your position.
 
 
    
   
 13. Question : TCO 9: ACME Co. believes that its employee, Teddy Thief, has knowledge of the theft of company property. Under what circumstances can ACME Co. require Teddy to submit to a polygraph test?