Question 1. � Question : � (TCO 1) An Input Area (as it applies to Excel 2013) is defined as_____. 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 Question 2. � Question : � (TCO 1) In Excel 2013, a cell is best described by which of the following? Must have formulas entered into it Cannot be used for labels or headings Must have text entered into it Question 3. � Question : � (TCO 1) Which of the following best describes the active cell? Is where all the functions of the database perform the calculations Is the cell that always holds the current date Is the location of the insertion point as indicated by a dark border Is where all the formulas of the workbook do the math 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 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? 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) Which of the following best describes a range in Excel 2013? Cannot be selected with the mouse Are the numbers that fall between the smallest and largest in the formula Is another word for the active worksheet Refers to a group of adjacent or contiguous cells Question 8. � Question : � (TCO 1) In Excel, a border _____. is data from another cell that is only temporarily residing in the active cell is a line that surrounds a cell or a range of cells never prints is preset and weight cannot be adjusted Question 9. � Question : � (TCO 3) A data series is a group of related _____. 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? 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, a single data series _____. 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 Question 12. Question : � (TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _____. line chart bar chart pie chart doughnut chart 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) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs Design, Layout, and Format. Home, Insert, and Page Layout. Chart, Type, and Formulas. Data, Review, and Data. 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.
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer