MIS Midterm Reviewer: Excel Multiple Choice Quiz

Excel Features and Functionalities

• An arrow in the lower-right corner of a group on the ribbon indicates that a dialog box or task pane is available.
• The Page Layout feature enables you to preview headers and footers, page breaks, and other features that will print.
• When you split a window, the window is divided into two or four panes.

Worksheets and Cells

• The intersection of a row and column is called a cell.
• A new Excel 2016 workbook opens with one worksheet.
• The Quick Access Toolbar starts with Save, Undo, and Redo and can be customized to contain the commands you use most frequently.

Document Properties and File Management

• Document properties consist of details that describe or identify a file, including the author.
• The Paste command is used to insert a cut or copied selection to a cell or range of cells.
• You can save a workbook using different file formats, including those for use in previous versions of Excel.

Cell Formatting and Editing

• The Fill handle is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series.
• Using the Delete key removes both text and formats from a cell.
• You can assign keywords to documents so that others can search for them online.

Formulas and Functions

• The correct way to write a formula: =IF(B7>=50, "Bonus", "No Bonus").
• A group of cells is called a Cell range.
• Valid formulas include =A+B+C, C8+C7, =1-M2, and =J5+C21/D21.
• A number format in Excel tells Excel how to display data in a cell.
• You can format cells as Currency, Number, Percent, or Scientific.
• Excel will not always tell you if there is a problem with a formula you've created.

Lookup and Reference Functions

• The LOOKUP() function is used to search for an item of data in a table and then extract the rest of the information relating to that item.
• An absolute cell reference is written as $B2$.