MISY 5325 MS Excel Midterm Exam Study Guide 2024

Which of the following is Not a number format available in the Number group on the Home tab? - Date Format To begin a formula in a cell, first type the # symbol. - False When you hide a column or row, the data is not deleted, it is just hidden. - True Text in a cell can by angle clockwise - True The ___ command is helpful for navigating to a cell that is not visible onscreen - Go to The ___ view displays print options and displays a worksheet in print preview - Office Backstage Comma, Date, Time, and Fraction are all number formats available in Excel 2013. - True Click Format in the Cells group o the __ tab to change the color of a worksheet tab. - Home Formatting data makes it difficult to read and tends to obscure meaningful details. - False In Excel 2013, it is only possible to add a new worksheet when the workbook is created. - False Excel data can be copied and pasted into a Word or PowerPoint document. - True A Special number format allows characters such as hyphens. - True The Date number format only allows Long Date, for example, march 14, 2016. - False An argument is an operator such as an equal sign or a plus sign needed to complete a function. - False A range name cannot include special characters or __ - spaces Which of the following is a new feature in Excel 2013? - Quick Analysis Formula ___ displays a list of functions and defined name that match the letters that you start typing when creating a formula. - AutoComplete Which of the following is False about a function in Excel - Functions are organized into two categories in Excel. The IF function only evaluates a condition of the condition is true. - False Because the Sum function is a rarely used function it has no button on the Ribbon. - False An absolute cell reference: - indicates a cell's specific location and the reference does not change when you copy the formula. The lookup value: - is a reference to a cell containing a value to look up. The __ function finds the midpoint value of a list. - Median The IF function: - evaluates a condition and returns one value if the condition is true, a different if false. A range name: - is a word or string of characters tat represent one or more cells. The IF function in Excel 2013 has __ arguments. - three A nested function: - 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. - False Match the argument types to their function: (Number1) () (logical_test) (....,table_array,...) (rate,..,...) - =SUM =TODAY =IF =VLOOKUP =PMT In Excel 2013, the function name describes the purpose of the function. - True A chart sheet: - contains a single chart and no spreadsheet data.