MISY 5325 MS Excel Midterm Exam Study Guide 2024 With Complete Solution.

MISY 5325 MS Excel Midterm Exam Study Guide 2024 With Complete Solution. Which of the following is Not a number format available in the Number group on the Home tab? - ANSWER Date Format To begin a formula in a cell, first type the # symbol. - ANSWER False 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 Study Guide 2024 With Complete Solution 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.