Question 1

Caroline is creating a worksheet to find the sum of different cell values such as A1, E1, and F1 and display it in cell G1. Which of the following formulas should Caroline enter into cell G1?
A)=A1+E1+F1
B)A1+E1+F1
C)A1+E1+F1=
D)A1;E1;F1=

Accepted Answer

The correct formula syntax for adding cell values in Excel starts with an equal sign (=) followed by the cell references separated by plus signs (+). Therefore, "=A1+E1+F1" is the correct formula to sum the values in cells A1, E1, and F1.

Question 2

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4? ​

​
A)=D6*E4
B)=D4*E4
C)=D3*E4
D)=D4*D6

Accepted Answer

The answer of In the following snippet of a Microsoft...

Question 3

The sheet currently displayed in the workbook window is called the _________. 
A)open sheet 
B)active sheet 
C)recent sheet 
D)explore sheet

Accepted Answer

The answer of The sheet currently displayed in the workbook...

Question 4

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?
A)SUM
B)PMT
C)CONVERT
D)AVERAGE

Accepted Answer

The PMT function is used in Excel to calculate the payment for a loan based on constant payments and a constant interest rate, making it the appropriate choice for calculating loan payments.

Question 5

Victor is working on a worksheet and realizes that he has entered incorrect information in a column. He selects the entire column and clicks the Delete button in the Cells group on the Home tab. Which of the following happens when Victor clicks the button?
A)The entire column will be deleted.
B)The first cell of the selection will be deleted.
C)The data in the first cell will be cleared.
D)The data in the entire column will be cleared.

Accepted Answer

When Victor selects the entire column and clicks the Delete button in the Cells group on the Home tab, the entire column will be deleted, not just the data within the cells. This action removes the column from the worksheet, shifting the remaining columns to the left.

Question 6

Mike is working on a project that requires him to calculate the scaled up values of parts from an engineering plan to a working model. In order to do this, items in column B need to be raised to the tenth power to meet the values in column C and the final value should appear in columnD)Which of the following formulas should Mike enter in the first row of column D?
A)=B1*10
B)=(C1 D1)^10
C)= (B1*B1*B1)*10
D)=B1^10

Accepted Answer

The correct formula to raise the value in cell B1 to the tenth power is "=B1^10". This directly applies the mathematical operation of raising B1 to the power of 10, which is what is required for the task.

Question 7

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?

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

Accepted Answer

The answer of In the following snippet of a Microsoft...

Question 8

A _________ is a group of values and other data organized into rows and columns. 
A)dataset 
B)spreadsheet 
C)log 
D)list

Accepted Answer

The answer of A _________ is a group of values...

Question 9

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it.
However, before she prints, she wants to  see what data will appear on each page  . In order to do this, she should use the _____.
A)Page Break view
B)Page Layout view
C)Backstage view
D)Normal view

Accepted Answer

The Page Break view in Excel allows users to see where pages will break when the document is printed, enabling them to adjust the layout as needed before printing.

Question 10

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it.
There are many worksheets in her file, and so Megan selects the Print command from the Backstage view. The preview of her work is shown in a page that is taller than it is wide. Which of the following orientations will make sure her work is printing on a sheet that is wider than it is tall?
A)Justified orientation
B)Portrait orientation
C)Landscape orientation
D)Scaled orientation

Accepted Answer

The answer of Case 13-2 Megan has created a workbook...

Question 11

Which of the following happens if you choose to wrap text within a cell?
A)The row height increases as needed to fit the text.
B)The column width increases as needed to fit the text.
C)The text font decreases to fit within the cell.
D)The cells next to the cell with text in it merge to fit the text.

Accepted Answer

When you choose to wrap text within a cell in spreadsheet software like Microsoft Excel or Google Sheets, the row height automatically adjusts to accommodate the text, ensuring that all the text is visible within the cell without increasing the column width, changing the text font size, or affecting adjacent cells.

Question 12

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

Accepted Answer

Using the Wrap Text feature allows the contents of a cell to be displayed on multiple lines within the same cell, making it easier to view all the data without having to click on each cell individually.

Question 13

In the following snippet of a Microsoft Excel 2016 worksheet, when the selected cells are inserted into a worksheet, the rest of the cells shift to the right because:

A)the range is as wide as it is long.
B)the range is wider than it is long.
C)the range is longer than it is wide.
D)the range is exactly 10 cells in size.

Accepted Answer

The answer of In the following snippet of a Microsoft...

Question 14

Elsa has collated information for a meeting using Excel. Due to certain developments, some of the data in her worksheet is now redundant. She deletes three rows from her worksheet to reflect the developments. Which of the following will happen to the rest of the rows in the worksheet when Elsa deletes three rows?
A)There will be an empty space where the deleted rows were.
B)The data from the rows will be shifted to rows at the bottom of the worksheet.
C)The data from the rows will be shifted to the rows at the beginning of the worksheet.
D)The remaining rows will shift up to take the place of the rows that were deleted.

Accepted Answer

When rows are deleted in Excel, the remaining rows automatically shift up to fill the gap left by the deleted rows, ensuring there are no empty spaces in that part of the worksheet.

Question 15

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:
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.

Accepted Answer

The Wrap Text button in the Alignment group on the Home tab is used to make text fit within a cell by breaking it into multiple lines. If text was forced to fit by using this feature, toggling it off will return the cells to their default size, assuming the issue was caused by text wrapping.

Question 16

Every Excel formula:
A)begins with an equal sign followed by an expression.
B)begins with the appropriate operator for the formula.
C)can only return numerical data as a result.
D)can only return data in the form of text or dates.

Accepted Answer

Every Excel formula starts with an equal sign (=), which is followed by the formula's expression. This signals Excel to evaluate the expression as a formula.

Question 17

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it.
Megan is trying to print the worksheets of her workbook in landscape format. The information on one of the worksheets is too large to print and has to be printed on an A4 sheet. In order to do this, Megan must:
A)use the Wrap Text button in the Alignment group on the Home tab.
B)use the Width or Height arrow in the Scale to Fit group on the Page Layout tab.
C)use the Remove Duplicate button in the Data tools group on the Data tab.
D)use the Arrange All in the Window group on the View tab.

Accepted Answer

To print a large worksheet on an A4 sheet in landscape format, adjusting the scaling is necessary. This can be done by using the Width or Height arrow in the Scale to Fit group on the Page Layout tab, which allows the worksheet to fit onto a single page without altering the content's layout directly.

Question 18

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?
A)SUM
B)MAX
C)COUNT
D)AVERAGE

Accepted Answer

MAX function is used to find the largest number in a set of values, making it the correct choice for selecting the largest value in a column.

Question 19

In the following snippet of Microsoft Excel 2016 document, when the selected range is inserted into a worksheet, the rest of the cells shift down because:

A)the range is longer than it is wide.
B)the range is wider than it is long.
C)the range is as wide as it is long.
D)the range is exactly 4 cells in size.

Accepted Answer

The answer of In the following snippet of Microsoft Excel...

Question 20

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

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

Accepted Answer

The answer of In the following snippet of a Microsoft...

Quiz 13: Creating a Workbook

Caroline is creating a worksheet to find the sum of different cell values such as A1, E1, and F1 and display it in cell G1. Which of the following formulas should Caroline enter into cell G1?

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4? ​ ​

The sheet currently displayed in the workbook window is called the _________. A)open sheet B)active sheet C)recent sheet D)explore sheet

Victor is working on a worksheet and realizes that he has entered incorrect information in a column. He selects the entire column and clicks the Delete button in the Cells group on the Home tab. Which of the following happens when Victor clicks the button?

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?

A _________ is a group of values and other data organized into rows and columns. A)dataset B)spreadsheet C)log D)list

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it. However, before she prints, she wants to see what data will appear on each page . In order to do this, she should use the _____.

Which of the following happens if you choose to wrap text within a cell?

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?

In the following snippet of a Microsoft Excel 2016 worksheet, when the selected cells are inserted into a worksheet, the rest of the cells shift to the right because:

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:

Every Excel formula:

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it. Megan is trying to print the worksheets of her workbook in landscape format. The information on one of the worksheets is too large to print and has to be printed on an A4 sheet. In order to do this, Megan must:

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 the following snippet of Microsoft Excel 2016 document, when the selected range is inserted into a worksheet, the rest of the cells shift down because:

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

In the following snippet of a Microsoft Excel 2016 worksheet, which of the following is the formula that is in cell F4?