Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) An Input Area (as it applies to Excel 2013) is defined as_____.\t\u00a0 a range of cells containing results based on the output area\t\u00a0displays the name of a worksheet within a workbook\t\u00a0\u00a0 a range of cells containing values for variables used in formulas\t\u00a0\tQuestion 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) In Excel 2013, a cell is best described by which of the following?\tMust have formulas entered into it\t\u00a0Cannot be used for labels or headings\t\u00a0Must have text entered into it\t\u00a0\tQuestion 3. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) Which of the following best describes the active cell?\tIs where all the functions of the database perform the calculations\t\u00a0Is the cell that always holds the current date\t\u00a0Is the location of the insertion point as indicated by a dark border\t\u00a0Is where all the formulas of the workbook do the math\t\u00a0\tQuestion 4. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?\t\u00a0Includes letters, numbers, and spaces\tControls the sequence in which Excel performs arithmetic operations\t\u00a0Is a software application used to create and modify business communications\t\u00a0Includes formulas, functions, and formatting\t\u00a0\tQuestion 5. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?\tCannot complete a sequence of dates in a column\t\u00a0Changes the background color of the selected cells to yellow\t\u00a0\tCopies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula\t\u00a0Has two or more sub-commands related to the command\t\u00a0\tQuestion 6. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) Which of the following would allow you to adjust the column width and\/or row height of many cells at once?\tJust type longer or taller formulas in some of them.\t\u00a0Click and drag across the cells to select them and use any sizing method you choose.\t\u00a0Drag the fill handle across the cells.\t\u00a0Type A1 in the Go To dialog box.\t\u00a0\tQuestion 7. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) Which of the following best describes a range in Excel 2013?\tCannot be selected with the mouse\tAre the numbers that fall between the smallest and largest in the formula\t\u00a0Is another word for the active worksheet\t\u00a0Refers to a group of adjacent or contiguous cells\t\u00a0\tQuestion 8. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) In Excel, a border _____.\u00a0 is data from another cell that is only temporarily residing in the active cell\t\u00a0is a line that surrounds a cell or a range of cells\t\u00a0never prints\t\u00a0is preset and weight cannot be adjusted\t\u00a0\tQuestion 9. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 3) A data series is a group of related _____.\tcharts on a worksheet\t\u00a0category labels on a horizontal axis\t\u00a0data points on a chart\t\u00a0numerical values on a vertical axis\t\u00a0\tQuestion 10.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 3) Which best describes a data point?\t\u00a0A numeric value that describes a single value on a chart\t\u00a0A group of related data points\t\u00a0Displays data comparisons vertically in columns\t\u00a0Text that describes a collection of data points in a chart\t\u00a0\tQuestion 11.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 3) When creating a chart in Excel, a single data series _____.\tcompares values for one set of data\t\u00a0groups or clusters similar data in columns to compare values across categories\t\u00a0is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart\t\u00a0compares two or more sets of data in one chart\t\u00a0\tQuestion 12.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _____.\t\u00a0line chart\t\u00a0bar chart\t\u00a0pie chart\t\u00a0doughnut chart\t\u00a0\tQuestion 13.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) _____ pie chart.\texpanded\texploded\t\u00a0displaced\t\u00a0clustered\t\u00a0\tQuestion 14.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs\tDesign, Layout, and Format.\t\u00a0Home, Insert, and Page Layout.\t\u00a0Chart, Type, and Formulas.\t\u00a0Data, Review, and Data.\t\u00a0\tQuestion 15.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 3) After creating a chart, you can change the chart type by using _____.\t\u00a0Page Layout tab \/ Chart Options button\t\u00a0Design tab \/ Change Chart Type button\t\u00a0Data tab \/ Chart Changer tool\t\u00a0You cannot change the chart.<\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 1) An Input Area (as it applies to Excel 2013) is defined as_____. \u00a0 a range of cells containing results based on the output area \u00a0displays the name of a worksheet within a Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-202977","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=202977"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202977\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}