MISY 5325 MS Excel Midterm Exam Questions With Answers Latest (100% VERIFIED)

MISY 5325 MS Excel Midterm Exam Questions With Answers Latest (100% VERIFIED) When you hide a column or row, the data is not deleted, it is just hidden. - ANSWER True Text in a cell can by angle clockwise - ANSWER True The ___ command is helpful for navigating to a cell that is not visible onscreen - ANSWER Go to The ___ view displays print options and displays a worksheet in print preview - ANSWER Office Backstage Comma, Date, Time, and Fraction are all number formats available in Excel 2013. - ANSWER True Click Format in the Cells group o the __ tab to change the color of a worksheet tab. - ANSWER Home Formatting data makes it difficult to read and tends to obscure meaningful details. - ANSWER False In Excel 2013, it is only possible to add a new worksheet when the workbook is created. - ANSWER False Excel data can be copied and pasted into a Word or PowerPoint document. - ANSWER True A Special number format allows characters such as hyphens. - ANSWER True MISY 5325 MS Excel Midterm Exam Questions With Complete Solution | Latest 2024/2025 (100% CORRECT) The Date number format only allows Long Date, for example, march 14, 2016. - ANSWER False An argument is an operator such as an equal sign or a plus sign needed to complete a function. - ANSWER False A range name cannot include special characters or __ - ANSWER spaces Which of the following is a new feature in Excel 2013? - ANSWER Quick Analysis Formula ___ displays a list of functions and defined name that match the letters that you start typing when creating a formula. - ANSWER AutoComplete Which of the following is False about a function in Excel - ANSWER Functions are organized into two categories in Excel. The IF function only evaluates a condition of the condition is true. - ANSWER False Because the Sum function is a rarely used function it has no button on the Ribbon. - ANSWER False An absolute cell reference: - ANSWER indicates a cell's specific location and the reference does not change when you copy the formula. The lookup value: - ANSWER is a reference to a cell containing a value to look up. The __ function finds the midpoint value of a list. - ANSWER Median The IF function: - ANSWER evaluates a condition and returns one value if the condition is true, a different if false. A range name: - ANSWER is a word or string of characters tat represent one or more cells. The IF function in Excel 2013 has __ arguments. - ANSWER three A nested function: - ANSWER contains another function embedded inside one or more of its arguments. A range name contain up to 450 characters and it must begin with a number. - ANSWER False Match the argument types to their function: (Number1) () (logical_test) (....,table_array,...) (rate,..,...) - ANSWER =SUM =TODAY =IF =VLOOKUP =PMT In Excel 2013, the function name describes the purpose of the function. - ANSWER True A chart sheet: - ANSWER contains a single chart and no spreadsheet data. Gridlines on a chart in Excel 2013 are: - ANSWER horizontal and vertical line that span across the chart compares groups set side by side relationship of individual data points to the whole - ANSWER Clustered column chart Stacked column chart A(n) __ is a grid that contains the data source values and labels. - ANSWER data table A pie chart - ANSWER shows each data point in proportion to the whole data series as a slice in a circular pie. A stacked column chart: - ANSWER 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. A chart is: - ANSWER a visual depiction of numerical data A chart__ controls which data series and categories are visible in a chart. - ANSWER filter Excel automatically determines the starting, incremental, and stopping values on a chart based on the data selected. - ANSWER True Which of the following is NOT one of most commonly used chart types? - ANSWER X Y chart A(n) ___ chart is a derivative of a scatter chart in which both axes are value axes. - ANSWER bubble Excel 2013 automatically assigns a different pattern to each column of a clustered column chart. - ANSWER False To begin creating sparklines on a worksheet, click the __ tab. - ANSWER Insert To print only a chart, select the chart, click the __ tab, and click Print. - ANSWER file Axes, chart tittles, and data tables are examples of chart elements. - ANSWER True In addition to sorting and filtering cells by content you can sort and/or filter by __. - ANSWER conditional formatting Excel enables you to sort data on __ different levels. - ANSWER 64 Print order: - ANSWER is the sequence in which pages print. EMAIL ME: EMAIL ME: Freeze Panes only locks columns above the active cell as you scroll through a worksheet. - ANSWER false Table style controls Table Style Options group Sorting Text A to Z Sorting Dates oldest to newest Sorting Values smallest to largest - ANSWER fill color of the header row, columns and records in a table check boxes to select format actions arranges data in alphabetical order displays data in chronological order arranges numbers in sequential order In addition to sorting and filtering cells by content, you can sort and/or filter by __ formatting - ANSWER conditional Highlight Cells Rules Top Bottom Rules Data bar Color scale Icon set - ANSWER highlights cells meeting criteria with a color, font, or border formats cells based on the value in relation to the other cells horizontal gradient of solid fill indicating a cell's relative value conditional format that displays a particular color based on the relative value of a EMAIL ME: EMAIL ME: cell conditional format that displays a small image representing a value A(n) __ defines the range of data from a worksheet to print. - ANSWER print area The ___ Table Style option displays the field names of a table when checked. - ANSWER header row Top/Bottom Rules: - ANSWER format cells based upon their value in relation to the value of other cells. Function key __ accesses to Go To command in Excel. - ANSWER F5 To ___ a table into a range, click within the table, click the Table Tools Design tab, and from the Tools group, select Convert to Range. - ANSWER convert You can apply text, value, and date filters to fields based on the data in a particular field. - ANSWER true 1.Filtering 2.Top 10 option 3.Custom Filter 4.Duplicate Values