Question 1

In the following snippet of a Microsoft Excel 2016 worksheet, consider that a formula is applied to column F. If the formula applied to cell F6 is D6*E6, which of the following is the formula reflected in cell F7?

Accepted Answer

A) =D6*E6 
B) =D5*D6 
C) =D7*E7 
D) =D6*D7

Question 2

The _________ located on the right edge of the status bar allow you to change the outlook of a worksheet. 
A)trailer buttons 
B)adjustment buttons 
C)view buttons 
D)swift buttons

Accepted Answer

The answer of The _________ located on the right edge...

Question 3

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the correct range reference for selected cells?

Accepted Answer

A) A3:E3 
B) A3;E7 
C) A3:A7;D3:E7 
D) A3:E3;E3:E7

Question 4

The _________ feature tries to anticipate what you are about to enter by displaying text that begins with the same letters as a previous entry in the same column. 
A)AutoFit 
B)AutoComplete 
C)AutoCheck 
D)AutoMatch

Accepted Answer

The answer of The _________ feature tries to anticipate what...

Question 5

Samir is working on a worksheet he received from his colleague. His colleague has forced text to fit within cells using a button on the Home tab, causing the file to look disjointed. In order to bring the cells to their default sizes, Samir should select all the cells and:

Accepted Answer

A) press the Clear button on the Home tab to remove the content in the cells. 
B) press the Delete button in the Cells group on the Home tab to delete the cells. 
C) press the Merge & Center button in the Alignment group on the Home tab. 
D) press the Wrap Text button in the Alignment group on the Home tab.

Question 6

When entering text data in a cell, pressing the Alt+Enter keys:

Accepted Answer

A) inserts a cell to the left. 
B) inserts a cell below the active cell. 
C) inserts a new column to the left of the cell. 
D) inserts a line break within the cell.

Question 7

Case 13-1 Matt, a financial consultant, is auditing a friend's document.
Matt wants to select the largest value of a column in a worksheet. Which of the following AutoSum functions should Matt use?

Accepted Answer

A) SUM 
B) MAX 
C) COUNT 
D) AVERAGE

Question 8

In Excel, _____ are actually numbers that are formatted to appear as text.

Accepted Answer

A) formulas 
B) equations 
C) dates 
D) decimals

Question 9

Marion has been working on a worksheet in Microsoft Excel 2016. She needs to delete certain data in a column. She selects the data in the column and presses the Delete key. Which of the following is the result of Marion's action?

Accepted Answer

A) The selected cell will be deleted. 
B) The entire column will be deleted. 
C) The data in the column of the selected cell will be cleared. 
D) The data in the selected cells will be cleared.

Question 10

The cell in which you are currently working is known as the function cell.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following happens when you rename a sheet from Sheet1 to Inventory?

Accepted Answer

A) The sheet tab extends to accommodate the new sheet name. 
B) The sheet name is cut off and replaced with "…". 
C) A ScreenTip appears asking the user to enter an alphanumeric name. 
D) A new sheet is created instead of renaming the current sheet.

Question 12

Which of the following can you do to edit cell contents directly in a cell?

Accepted Answer

A) Right-click the cell, and select format. 
B) Double-click the cell. 
C) Select the cell, and press the F1 key. 
D) Drag the cell down to the sheet tab.

Question 13

When you paste a copied formula, Microsoft Excel 2016 adjusts the cell references in the formula to reflect the new location of the formula.

Accepted Answer

A) True 
 B)False

Question 14

The quickest way to move a sheet is to copy and paste them in the new location.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following features in Microsoft Excel 2016 makes entering repetitive text easier?

Accepted Answer

A) AutoFit 
B) AutoSum 
C) AutoComplete 
D) AutoFormat

Question 16

Case 13-1 Matt, a financial consultant, is auditing a friend's document.
Matt wants to calculate the amount of loan payments his friend needs to make on certain loans. He enters the data regarding interest and total principal in the worksheet. Which of the following functions should Matt use to calculate this?

Accepted Answer

A) SUM 
B) PMT 
C) CONVERT 
D) AVERAGE

Question 17

You can select an entire column in Microsoft Excel 2016 by:

Accepted Answer

A) double-clicking the active cell. 
B) Dragging the mouse over the last three cells. 
C) Left-clicking the column header. 
D) Using the select button in the Page Layout tab.

Question 18

Lucy enters large amounts of numerical and text data into every cell in a worksheet. She has to keep clicking the previous cells to refer to data in other cells. Which of the following would make it easier for Lucy to view the contents of all cells simultaneously?

Accepted Answer

A) Selecting the cells and using the Cell Styles on the Home tab to widen the column width 
B) Selecting the cells needed to refer and clicking the Merge & Center button on the Home tab 
C) Selecting all the cells and reducing the font until the data fits in the cells 
D) Selecting the cells and clicking the Wrap Text button on the Home tab

Question 19

Kim creates a worksheet that contains data about students in her class and their achievements in the previous year. She wants the achievements to stand out from the rest of the data. Kim can achieve this by:

Accepted Answer

A) making the changes in a Microsoft Word file and copying them to the cells. 
B) double-clicking the cell in which she wants the change to happen. 
C) clicking the Wrap Text button in the Alignment group on the Home tab. 
D) using the options available in the Font group on the Home tab.

Question 20

Text data is usually aligned to the center of the cell unless you change it.

Accepted Answer

A) True 
 B)False

Exam 13: Creating a Workbook

In the following snippet of a Microsoft Excel 2016 worksheet, consider that a formula is applied to column F. If the formula applied to cell F6 is D6*E6, which of the following is the formula reflected in cell F7?

The _________ located on the right edge of the status bar allow you to change the outlook of a worksheet. A)trailer buttons B)adjustment buttons C)view buttons D)swift buttons

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the correct range reference for selected cells?

The _________ feature tries to anticipate what you are about to enter by displaying text that begins with the same letters as a previous entry in the same column. A)AutoFit B)AutoComplete C)AutoCheck D)AutoMatch

Samir is working on a worksheet he received from his colleague. His colleague has forced text to fit within cells using a button on the Home tab, causing the file to look disjointed. In order to bring the cells to their default sizes, Samir should select all the cells and:

When entering text data in a cell, pressing the Alt+Enter keys:

Case 13-1 Matt, a financial consultant, is auditing a friend's document. Matt wants to select the largest value of a column in a worksheet. Which of the following AutoSum functions should Matt use?

In Excel, _____ are actually numbers that are formatted to appear as text.

Marion has been working on a worksheet in Microsoft Excel 2016. She needs to delete certain data in a column. She selects the data in the column and presses the Delete key. Which of the following is the result of Marion's action?

The cell in which you are currently working is known as the function cell.

Which of the following happens when you rename a sheet from Sheet1 to Inventory?

Which of the following can you do to edit cell contents directly in a cell?

When you paste a copied formula, Microsoft Excel 2016 adjusts the cell references in the formula to reflect the new location of the formula.

The quickest way to move a sheet is to copy and paste them in the new location.

Which of the following features in Microsoft Excel 2016 makes entering repetitive text easier?

You can select an entire column in Microsoft Excel 2016 by:

Lucy enters large amounts of numerical and text data into every cell in a worksheet. She has to keep clicking the previous cells to refer to data in other cells. Which of the following would make it easier for Lucy to view the contents of all cells simultaneously?

Kim creates a worksheet that contains data about students in her class and their achievements in the previous year. She wants the achievements to stand out from the rest of the data. Kim can achieve this by:

Text data is usually aligned to the center of the cell unless you change it.