Exam 16: Introduction to Microsoft Excel 2016

Nancy, a teacher, creates a table using Excel to list the number of students in her class. She uses rows and columns to add subject names and the grades received by each student. Nancy's table is also called a ________.

Using the F2 function key is recommended when a user has a long value in a cell and wants to edit a letter or two without retyping the whole entry.

Which of the following keys is used to edit the value in a cell without retyping the whole entry?

In Excel, a sequence of tabs that appear in a horizontal line, just below the Excel icon, controls the contents of the ribbon.

In Excel, the most frequently used tools and selections appear under the ________ tab.

Each cell in an Excel spreadsheet is identified by the data entered in it.

Which of the following is an incorrect formula in Excel?

Excel lacks features that can add data into a spreadsheet based on a pattern.

John is working in Excel and notices that his rows are numbering past 2000. What would be the best action in this situation?

Excel creates multiple worksheets when a new workbook is created.

What is a spreadsheet?

Excel can only locate patterns within numbers.

Excel has a few ways to format the spreadsheet.

Which tab holds the most frequently used tools and selections?

A user enters a formula into cell G9. Which of the following would be possible if the user presses the F2 function key after selecting the cell G9?

If you want to use a formula in a different cell you have to input it again.

In Excel, when the HOME tab is selected, the contents of the ribbon concern charts, filter, tables, and so forth.

In Excel, the intersection of a row and a column is called a ________.

Explain the process of inserting rows and columns in Microsoft Excel.

If you are learning Excel it is best to begin with the previous version.