DeVry Chicago BIS 155 Week 1 Quiz 2014

profileKnowledgeCats
 (Not rated)
 (Not rated)
Chat

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 

 

  clustered 

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 

    • 7 years ago
    DeVry Chicago BIS 155 Week 1 Quiz 2014 with 100% Correct Answers
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      devry_chicago_bis_155_week_1_quiz_2014.docx