Question 1

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

Accepted Answer

The Delete key in Excel is used to clear the content of the selected cells without deleting the cells themselves or their formatting. In this case, pressing the Delete key after selecting data in a column will clear the data in those selected cells.

Question 2

In Microsoft Excel 2016, which of the following date data format displays dates in mm/dd/yyyy format?
A)Cardinal Date format
B)Long Date format
C)Short Date format
D)Universal Date format

Accepted Answer

The Short Date format in Microsoft Excel 2016 displays dates in the mm/dd/yyyy format, which is a common way to represent dates in a concise manner.

Question 3

Column widths are expressed in terms of either the number of characters the column can contain or the size of the column in _____.
A)inches
B)points
C)pixels
D)centimeters

Accepted Answer

Column widths can be expressed in pixels, which is a common unit of measurement for digital displays and layouts.

Question 4

In Microsoft Excel, the data entered in a worksheet appears in the _____.
A)status bar
B)formula bar
C)name box
D)dialog box

Accepted Answer

The data entered in a worksheet appears in the formula bar, allowing users to view and edit the content of the currently selected cell.

Question 5

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

Accepted Answer

The Font group on the Home tab in Excel offers various options to format text, such as changing the font color, size, or style, which can help make certain data, like achievements, stand out.

Question 6

Which of the following happens when you insert a new row into a worksheet?
A)The new row is added at the end of the sheet.
B)The new row is added at the beginning of the sheet.
C)The new row is added and the remaining rows shift down to accommodate it.
D)The new row is added and the remaining rows shift up to accommodate it.

Accepted Answer

When a new row is inserted into a worksheet, the existing rows below the insertion point shift down to make space for the new row. This ensures that the data remains intact and the new row is accommodated without overwriting any existing data.

Question 7

Which of the following is the default number format that Microsoft Excel uses to enter numerical values?
A)Percentage format
B)Currency format
C)General format
D)Accounting format

Accepted Answer

The default number format in Microsoft Excel is the General format. This format does not apply any specific number formatting rules and displays the number as is, or in a basic, general manner.

Question 8

Which of the following can you do to edit cell contents directly in a cell?
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.

Accepted Answer

Double-clicking a cell in a spreadsheet application like Microsoft Excel or Google Sheets allows you to directly edit the contents of that cell.

Question 9

Which of the following features in Microsoft Excel 2016 makes entering repetitive text easier?
A)AutoFit
B)AutoSum
C)AutoComplete
D)AutoFormat

Accepted Answer

AutoComplete in Microsoft Excel helps in entering repetitive text easier by predicting text as you type, based on previously entered values in the same column.

Question 10

Which of the following is a reason why there is a space between the dollar sign and the left edge of the cell in the accounting format?
A)To format numbers in the default number format for Microsoft Excel
B)To ensure that there is space for decimal points
C)To leave space on either side for the parentheses that surround negative numbers
D)To make sure that all the cells are aligned with the numbers

Accepted Answer

The space between the dollar sign and the left edge of the cell in the accounting format is specifically designed to leave space for parentheses that might be needed to surround negative numbers, ensuring a consistent alignment of currency symbols and numbers within a column.

Question 11

Which of the following allows you to cancel the changes you made while editing a cell?
A)Pressing the Esc key while editing the cell
B)Selecting the cell and using the Delete cells command
C)Pressing the Insert key while editing the cell
D)Selecting the cell and using the Remove Duplicates command

Accepted Answer

Pressing the Esc key while editing a cell cancels any changes made during that editing session, reverting the cell to its previous state before editing began.

Question 12

Which of the following should be considered when setting column widths?
A)Keeping the column and row counts even
B)Setting the column width in terms of pixels per column
C)Setting the column width in terms of characters per column
D)Keeping the column size same as the row size

Accepted Answer

Setting the column width in terms of characters per column ensures that the data fits well and is readable, as it aligns with the typical content size.

Question 13

When a number is too large to be entered into a cell, Microsoft Excel:
A) replaces the numbers with a series of pound (#) signs. ​
B)merges the cell next to it to create more space.
C)increases the row height to fit the data.
D)rounds off the number to fit it in the cell.

Accepted Answer

When a number is too large to fit in a cell, Excel displays a series of pound (#) signs instead of the number to indicate that the cell is not large enough to display the value.

Question 14

When entering text data in a cell, pressing the Alt+Enter keys:
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.

Accepted Answer

Pressing Alt+Enter while entering text in a cell in Excel allows you to insert a line break within the cell, enabling the text to appear on multiple lines within the same cell.

Question 15

In the following snippet of a Microsoft Excel 2016 worksheet, the information in cell B5 extends beyond the cell's border because:

A)the cell borders have been removed.
B)the text has been copied and pasted from a different cell.
C)the cell next to it is empty.
D)the format of row 5 allows text to spill over.

Accepted Answer

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

Question 16

Abdul has been working on a worksheet at a stockbroking firm. Data in this sheet is updated on a daily basis. He adds a new column as the third column of the sheet to accommodate the different aspects of his analysis. Which of the following changes will occur when Abdul adds the new column?
A)The data will shift one column to the right and leave the next column blank.
B)The new column will be inserted at the end of the sheet.
C)The new column will be inserted leaving the next column blank.

Accepted Answer

The answer of Abdul has been working on a worksheet...

Question 17

Laura has been entering dates in worksheets using the Long Date format. Her manager sends her an email asking her to change all the dates from the Long Date format to the Short Date format. Laura can make the changes by:
A)holding the Alt key while clicking the cells with dates in them and clicking the Consolidate option in the Data tab.
B)making a new worksheet, changing the format, and copying the cells to the original worksheet.
C)using the Number Format box arrow in the Number group on the Home tab.
D)re-entering all the dates manually using slashes to divide the numbers.

Accepted Answer

The Number Format box in the Number group on the Home tab allows users to change the format of dates, numbers, and other values in Excel without needing to re-enter the data manually or perform complex operations. Changing from Long Date to Short Date format can be easily done through this method.

Question 18

You can select an entire column in Microsoft Excel 2016 by:
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.

Accepted Answer

Left-clicking the column header is the correct method to select an entire column in Microsoft Excel 2016. This action selects all cells within that column.

Question 19

One of the ways to get more characters to fit into a cell is by:
A)using the Cell Styles button on the Home tab to specify cell width.
B)dragging the left-hand side border of the cell.
C)reducing the font size.
D)increasing the row height of the cell.

Accepted Answer

Reducing the font size allows more characters to fit into a cell because the characters take up less space, thus allowing more text to be visible within the same cell dimensions.

Question 20

Rajiv has been working on a file containing numerical data up to three decimal places. He changes the number format in cell B1 from Accounting to Currency format and reduces the number of decimal places by one. The value in the cell was originally $115.34. The new value displayed after the format change Rajiv has made will be _____.
A)115.34
B)$115.34
C)#115.34

Accepted Answer

Changing the number format from Accounting to Currency and reducing the decimal places does not alter the numerical value but changes its display format. The value remains $115.34, but is displayed with the Currency format.

Quiz 13: Creating a Workbook

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?

In Microsoft Excel 2016, which of the following date data format displays dates in mm/dd/yyyy format?

Column widths are expressed in terms of either the number of characters the column can contain or the size of the column in _____.

In Microsoft Excel, the data entered in a worksheet appears in the _____.

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:

Which of the following happens when you insert a new row into a worksheet?

Which of the following is the default number format that Microsoft Excel uses to enter numerical values?

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

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

Which of the following is a reason why there is a space between the dollar sign and the left edge of the cell in the accounting format?

Which of the following allows you to cancel the changes you made while editing a cell?

Which of the following should be considered when setting column widths?

When a number is too large to be entered into a cell, Microsoft Excel:

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

In the following snippet of a Microsoft Excel 2016 worksheet, the information in cell B5 extends beyond the cell's border because:

Abdul has been working on a worksheet at a stockbroking firm. Data in this sheet is updated on a daily basis. He adds a new column as the third column of the sheet to accommodate the different aspects of his analysis. Which of the following changes will occur when Abdul adds the new column?

Laura has been entering dates in worksheets using the Long Date format. Her manager sends her an email asking her to change all the dates from the Long Date format to the Short Date format. Laura can make the changes by:

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

One of the ways to get more characters to fit into a cell is by: