Description of this paper

DeVry Chicago BIS 155 Week 1 Quiz 2014

Description

solution


Question

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

 

Paper#35177 | Written in 18-Jul-2015

Price : $22
SiteLock