MISY 5325 MS Excel Midterm Exam Study Guide Latest Updated 2024 passed Which of the following is Not a number format available in the Number group on the Home tab? - Correct Answer Date Format To begin a formula in a cell, first type the # symbol. - Correct Answer False When you hide a column or row, the data is not deleted, it is just hidden. - Correct Answer True Text in a cell can by angle clockwise - Correct Answer True The ___ command is helpful for navigating to a cell that is not visible onscreen - Correct Answer Go to The ___ view displays print options and displays a worksheet in print preview - Correct Answer Office Backstage Comma, Date, Time, and Fraction are all number formats available in Excel 2013. - Correct Answer True Click Format in the Cells group o the __ tab to change the color of a worksheet tab. - Correct Answer Home Formatting data makes it difficult to read and tends to obscure meaningful details. - Correct Answer False In Excel 2013, it is only possible to add a new worksheet when the workbook is created. - Correct Answer False Excel data can be copied and pasted into a Word or PowerPoint document. - Correct Answer True A Special number format allows characters such as hyphens. - Correct Answer True 1 / 4
The Date number format only allows Long Date, for example, march 14, 2016. - Correct Answer False An argument is an operator such as an equal sign or a plus sign needed to complete a function. - Correct Answer False A range name cannot include special characters or __ - Correct Answer spaces Which of the following is a new feature in Excel 2013? - Correct Answer Quick Analysis Formula ___ displays a list of functions and defined name that match the letters that you start typing when creating a formula. - Correct Answer AutoComplete Which of the following is False about a function in Excel - Correct Answer Functions are organized into two categories in Excel.The IF function only evaluates a condition of the condition is true. - Correct Answer False Because the Sum function is a rarely used function it has no button on the Ribbon. - Correct Answer False An absolute cell reference: - Correct Answer indicates a cell's specific location and the reference does not change when you copy the formula.The lookup value: - Correct Answer is a reference to a cell containing a value to look up.The __ function finds the midpoint value of a list. - Correct Answer Median The IF function: - Correct Answer evaluates a condition and returns one value if the condition is true, a different if false.A range name: - Correct Answer is a word or string of characters tat represent one or more cells. 2 / 4
The IF function in Excel 2013 has __ arguments. - Correct Answer three A nested function: - Correct 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. - Correct Answer False
Match the argument types to their function:
(Number1) () (logical_test) (....,table_array,...) (rate,..,...) - Correct Answer =SUM
=TODAY
=IF
=VLOOKUP
=PMT In Excel 2013, the function name describes the purpose of the function. - Correct Answer True A chart sheet: - Correct Answer contains a single chart and no spreadsheet data.Gridlines on a chart in Excel 2013 are: - Correct Answer horizontal and vertical line that span across the chart compares groups set side by side relationship of individual data points to the whole - Correct Answer Clustered column chart Stacked column chart 3 / 4
A(n) __ is a grid that contains the data source values and labels. - Correct Answer data table A pie chart - Correct Answer shows each data point in proportion to the whole data series as a slice in a circular pie.A stacked column chart: - Correct 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: - Correct Answer a visual depiction of numerical data
A chart__ controls which data series and categories are visible in a chart. - Correct Answer filter Excel automatically determines the starting, incremental, and stopping values on a chart based on the data selected. - Correct Answer True Which of the following is NOT one of most commonly used chart types? - Correct Answer X Y chart A(n) ___ chart is a derivative of a scatter chart in which both axes are value axes. - Correct Answer bubble Excel 2013 automatically assigns a different pattern to each column of a clustered column chart. - Correct Answer False To begin creating sparklines on a worksheet, click the __ tab. - Correct Answer Insert To print only a chart, select the chart, click the __ tab, and click Print. - Correct Answer file Axes, chart tittles, and data tables are examples of chart elements. - Correct Answer True
- / 4