MISY 5325 MS Excel Midterm Exam Study Guide Questions With Complete Solutions | Expert Verified | 2025/2026

MISY 5325 MS Excel Midterm Exam Study Guide Questions With Complete Solutions | Expert Verified | 2025/2026 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-FalseExcel 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 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. - answerFalse 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