Details of this Paper

DEVRY BIS155 week 1 quiz- An Output Area (as it applies to Excel 2010) is defined as

Description

solution


Question

CO 1) An Output Area (as it applies to Excel 2010) is defined as_______.;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;Question 2. Question;(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;Question 3. Question;(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;Question 4. Question;(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;Question 5. Question;(TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?;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;2 of 2;Comments;Question 6. Question;(TCO 1) Ribbon Commands with arrows indicate_____.;a shortcut to cell A1;there are two or more sub-commands related to the command;the next step in the process;directionality;Question 7. Question;(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;workbook.;ledger.;document.;journal.;Question 8. Question;(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.;Question 9. Question;(TCO 3) Groups of related numeric values in an Excel worksheet are;data point.;data roles.;categories.;data series;Question 10. Question;(TCO 3) Which of the following best describes a column chart?;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;Question 11. Question;(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;Question 12. Question;(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.;Question 13. Question;(TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart.;expanded;exploded;displaced;clustered;Question 14. Question;(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;Question 15. Question;(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.

 

Paper#30116 | Written in 18-Jul-2015

Price : $34
SiteLock