Question 1

When there are multiple worksheets,you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.

Accepted Answer

The keyboard shortcut Ctrl + PgDn allows you to move one worksheet to the right in a multi-worksheet Excel workbook. This works by switching to the next worksheet to the right.

Question 2

The keyboard shortcut to move one column to the left is ________.

Accepted Answer

The Shift + Tab shortcut allows you to move to the previous cell in the row or the previous column in the table. Therefore, by pressing Shift + Tab once, you can move one column to the left. The other options are not relevant to this action. Ctrl + Tab is used to switch between open tabs, Tab moves the cursor to the next cell in the row or table, and Ctrl + Home takes you to the beginning of the document.

Question 3

The file extension for Microsoft Excel 2016 workbooks is ________.

Accepted Answer

The correct file extension for Microsoft Excel 2016 workbooks is .xlsx. This extension was introduced with the release of Microsoft Office 2007 and is used for all Excel files created with version 2007 or later. The other options listed are either incorrect or outdated.

Question 4

A comment is indicated by the presence of a ________ in the upper-right corner of a cell.

Accepted Answer

The answer of A comment is indicated by the presence...

Question 5

If you click ________,the insertion point is displayed in the formula bar.

Accepted Answer

Clicking in the formula bar places the insertion point there, allowing the user to edit and enter formulas and functions directly into the bar.

Question 6

Which of the following is typically NOT contained in a separate documentation worksheet?

Accepted Answer

A separate documentation worksheet typically contains information such as modification dates, author, and modification history, but not charts. Charts are often included directly in the document being documented or in a separate appendix within the same document.

Question 7

A ________ application is a computer program has a user interface comprised of a grid of rows and columns.

Accepted Answer

A spreadsheet is a computer program that presents data in a grid of rows and columns. Each cell can contain data or a formula that performs calculations on the data in other cells.

Question 8

Formulas and functions begin with a(n)________ sign.

Accepted Answer

All formulas and functions in Excel start with the equal sign (=).

Question 9

If you enter a date or time that is not recognized,Excel treats the information as ________ and left-aligns it in the cell.

Accepted Answer

When a date or time is entered in a format that is not recognized, Excel assumes it is text and left-aligns it in the cell. This is because text data is always left-aligned in Excel. Numeric data would be right-aligned, and date/time data would be displayed in the appropriate format.

Question 10

To move right one screen,you would use the keyboard shortcut ________.

Accepted Answer

The answer of To move right one screen,you would use...

Question 11

Which of the following data types is NOT automatically right-aligned by Excel?

Accepted Answer

Numeric, Date, and Time data types are automatically right-aligned by Excel, while Text data types are left-aligned by default.

Question 12

The intersection of a row and column is called a ________.

Accepted Answer

The intersection of a row and column in a spreadsheet or table is commonly called a cell.

Question 13

The base date for date and time data in Excel 2016 is ________.

Accepted Answer

The base date for date and time data in Excel 2016 is January 1, 1900. This is the default date system for Excel on Windows, which is used to calculate dates as serial numbers.

Question 14

The keyboard shortcut for Undo is ________.

Accepted Answer

The keyboard shortcut for Undo is Ctrl + Z in most programs and operating systems, including Windows and Mac. This allows you to go back one step or action if you made a mistake or want to undo an action you just performed.

Question 15

The keyboard shortcut to move to cell A1 is ________.

Accepted Answer

The keyboard shortcut to move to cell A1 is Ctrl + Home. This combination will take the user to the beginning of the worksheet in column A and row 1. The Home key alone will only take the user to the beginning of the current row, while the Shift + Home combination will select all cells from the current cell to the beginning of the row. The Alt + Home combination has a different function, depending on the version of Excel being used.

Question 16

Which of the following is NOT an example of worksheet documentation?

Accepted Answer

Descriptive drop-down menus are not a form of documentation for worksheets, as they do not provide information about the contents or purpose of the worksheet. Descriptive worksheet names, cell labels, and column titles all serve as forms of documentation to help users understand the data and purpose of the worksheet.

Question 17

A ________ is a grid of columns and rows in which data is entered.

Accepted Answer

A worksheet is designed as a grid of columns and rows where data can be entered, analyzed, and stored. It is also known as a spreadsheet and can perform various mathematical functions and calculations. Options A, B, and C are not appropriate as they refer to different types of documents that do not necessarily include a grid of columns and rows.

Question 18

To insert a line break or hard return in a cell,you would press ________.

Accepted Answer

To insert a line break or hard return in a cell, you would press Alt + Enter. This will move the cursor to the next line within the same cell. The other options (Ctrl + Enter, Enter, and Shift + Enter) do not insert line breaks within a cell.

Question 19

To insert a comment into a cell,you click New Comment in the:________ tab.

Accepted Answer

This option is correct as it refers to the "New Comment" button that allows users to insert a comment into a cell. The other options are not relevant as they don't have a "New Comment" button or don't have a Comments group.

Question 20

Which of the following is NOT a type of data that can be contained in a cell?

Accepted Answer

Cells in a spreadsheet program, such as Microsoft Excel, can contain various types of data including formulas, functions, and text. However, subroutines are not a type of data that can be contained in a cell. Subroutines are a type of procedure or code that can be run within a program, but they do not reside within a cell.

Quiz 7: Create, Navigate, Work With, and Print Worksheets