MIS Midterm Reviewer: Excel Multiple Choice Quiz
12 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What does an arrow in the lower-right corner of a group on the ribbon indicate?

  • A dialog box or task pane is available (correct)
  • An additional workbook is available
  • A list of worksheets is available
  • An additional part of the current range is available

Which feature allows you to preview headers, footers, page breaks, and other printing features?

  • Synchronous Scrolling
  • Page Layout
  • ScreenTips
  • Print Layout (correct)

When you split a window, how many panes does the window divide into?

  • two (correct)
  • two or four
  • three
  • four

What is the intersection of a row and column in a worksheet called?

<p>cell (B)</p> Signup and view all the answers

Which of the following starts with Save, Undo, and Redo and can be customized to contain frequently used commands?

<p>The Quick Access Toolbar (D)</p> Signup and view all the answers

How many worksheets does a new Excel 2016 workbook open with by default?

<p>one (D)</p> Signup and view all the answers

Which command is used to insert a cut or copied selection to a cell or range of cells?

<p>Paste (B)</p> Signup and view all the answers

If you want to use a workbook in another kind of document, you have the option to save using which of the following?

<p>File format (A)</p> Signup and view all the answers

Which 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?

<p>Fill handle (A)</p> Signup and view all the answers

Which of the following can you drag or double-click to change the width of a column?

<p>Column marker (A)</p> Signup and view all the answers

Which of the following can you assign so that others can search for your documents online?

<p>Keywords (C)</p> Signup and view all the answers

Which of the following formulas is the correct way to write the function: IF B4 is greater than 200, show "High", otherwise, show "Low"?

<p>=IF(B4&gt;200,&quot;High&quot;,&quot;Low&quot;) (A)</p> Signup and view all the answers

Study Notes

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&gt;=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$.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Description

Test your knowledge of Excel features with this multiple-choice quiz. Questions cover topics like ribbon groups, printing options, window splitting, and more.

More Like This

Use Quizgecko on...
Browser
Browser