MISY 5325 MS Excel Midterm Exam 2025

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