Podcast
Questions and Answers
What does an arrow in the lower-right corner of a group on the ribbon indicate?
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?
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?
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?
What is the intersection of a row and column in a worksheet called?
Which of the following starts with Save, Undo, and Redo and can be customized to contain frequently used commands?
Which of the following starts with Save, Undo, and Redo and can be customized to contain frequently used commands?
How many worksheets does a new Excel 2016 workbook open with by default?
How many worksheets does a new Excel 2016 workbook open with by default?
Which command is used to insert a cut or copied selection to a cell or range of cells?
Which command is used to insert a cut or copied selection to a cell or range of cells?
If you want to use a workbook in another kind of document, you have the option to save using which of the following?
If you want to use a workbook in another kind of document, you have the option to save using which of the following?
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?
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?
Which of the following can you drag or double-click to change the width of a column?
Which of the following can you drag or double-click to change the width of a column?
Which of the following can you assign so that others can search for your documents online?
Which of the following can you assign so that others can search for your documents online?
Which of the following formulas is the correct way to write the function: IF B4 is greater than 200, show "High", otherwise, show "Low"?
Which of the following formulas is the correct way to write the function: IF B4 is greater than 200, show "High", otherwise, show "Low"?
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>=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.
Description
Test your knowledge of Excel features with this multiple-choice quiz. Questions cover topics like ribbon groups, printing options, window splitting, and more.
