Question 1

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

Accepted Answer

This statement is true. The Date category in the Format Cells dialog box allows you to apply various date format options to cells in Excel.

Question 2

To rotate cell contents to an exact value, you change its _____.
A) Font
B) Width
C) Indent
D) Orientation

Accepted Answer

To rotate cell contents to an exact value, you change its orientation.

Question 3

You need to add another product to your inventory worksheet, which shows product names in row A.Which of the following should you add?
A) a row
B) a column
C) a button
D) conditional formatting

Accepted Answer

To add another product to our inventory worksheet, we need to enter the name of the new product in a new row or column. Adding a new row will keep the product names in row A, so it is the best choice. Adding a button or using conditional formatting will not add a new product to the list.

Question 4

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Accepted Answer

To remove conditional formatting from a selected range, you need to select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Question 5

After you delete a worksheet column, _____.
A) the columns to its right shift left
B) the columns to its left shift right
C) the row remains but its contents are deleted
D) only its formats are deleted

Accepted Answer

When a worksheet column is deleted, the columns to its right shift left to fill in the empty space.

Question 6

To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.

Accepted Answer

This is correct, you can rotate cell contents using the Alignment tab in the Format Cells dialog box.

Question 7

The Clipboard task pane shows the contents of the _____.
A) Office Clipboard
B) Table Styles gallery
C) Quick Analysis tool
D) Recently-Used Add-Ins

Accepted Answer

The Clipboard task pane shows the contents of the Office Clipboard, which allows multiple items to be copied and pasted at once.

Question 8

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

Accepted Answer

The Edit Scenario dialog box allows for a maximum of 35 changing cells to be modified in the Scenario Values dialog box.

Question 9

Arlo wants to use goal seek to answer "what if" questions in a file.To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek...from the drop down menu.What is X in the procedure?
A) What-if Analysis
B) Data Validation
C) Consolidate
D) Relationships

Accepted Answer

The "X" in the procedure refers to "What-if Analysis," which is the correct option for accessing Goal Seek in Excel. Goal Seek is a part of the What-if Analysis tools that allow users to find the input value needed to achieve a desired result.

Question 10

Which of the following does the Accessibility Checker look for? Select all the options that apply.
A) Worksheets with default names.
B) Images without alternative text.
C) Worksheets with calculation errors.
D) Hyperlinks without alternative text.

Accepted Answer

The answer of Which of the following does the Accessibility...

Question 11

To copy a cell's formatting to another cell, which of the following can you use?
A) Format Cells dialog box
B) Format Painter
C) Quick Analysis Tool
D) Format as Table

Accepted Answer

Format Painter allows you to copy the formatting (such as font style, color, border, etc.) of one cell and apply it to another cell with a single click.

Question 12

You double-click the Format Painter button when you want to _____.
A) copy a cell's format to more than one cell
B) copy a cell's format to only one cell
C) use conditional formatting
D) clear a cell's formatting

Accepted Answer

Double-clicking the Format Painter button allows you to copy a cell's format to more than one cell.

Question 13

To delete a worksheet column, you can first select it by _____.
A) clicking the column heading
B) double-clicking the column heading
C) clicking anywhere in the column
D) double-clicking anywhere in the column

Accepted Answer

Clicking the column heading will select the entire column, allowing you to delete it using the "Delete" option from the "Home" tab or the context menu. Double-clicking the column heading will select the entire column and auto-fit the column width to the contents, but it does not provide a way to delete the column directly. Clicking or double-clicking anywhere in the column will only select individual cells rather than the entire column.

Question 14

Which of the following is true about deleting a worksheet row?
A) After you delete a row, the rows below it shift down one row.
B) To delete a row, you can select the row, then press the DELETE key on the keyboard.
C) To delete a row, you can select the row, then use the Delete button in the Cells group.
D) If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.

Accepted Answer

When you delete a row in a worksheet, the rows below it shift up to fill the gap, not down. Pressing the DELETE key on the keyboard after selecting a row will clear the content of the cells in that row but will not remove the row itself. The Delete Sheet option is used for deleting an entire worksheet, not a single row. The correct way to delete a row is by selecting it and then using the Delete button in the Cells group on the Home tab, which shifts the rows below it up to fill the space.

Question 15

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.
A) CTRL
B) ALT
C) SHIFT
D) ESC

Accepted Answer

Pressing and holding down the CTRL key while selecting cells or ranges allows you to select nonadjacent cells or ranges on a worksheet.

Question 16

To change the name of a worksheet, you rename the _____.
A) sheet columns
B) sheet rows
C) sheet header
D) sheet tab

Accepted Answer

To change the name of a worksheet, you need to rename the sheet tab.

Question 17

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

Accepted Answer

Excel's Spell Checker checks the spelling in the current worksheet only, not in all worksheets at once. You need to manually select each worksheet and run the Spell Checker for each one.

Question 18

Which of the following is true about changing worksheet column width?
A) In Normal view, the Column Width dialog box lets you set column width to an exact value in inches.
B) In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
C) When you drag the right column border in Normal view, a ScreenTip displays the exact width in inches.
D) When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels.

Accepted Answer

In Normal view, the Column Width dialog box allows you to set the exact number of characters that can fit in a column. When you drag the right column border in Normal view, the ScreenTip shows the number of characters currently visible in the column. Option A is incorrect because the Column Width dialog box allows you to set the exact value in characters, not inches. Option C is incorrect because the ScreenTip shows the number of characters, not the width in inches. Option D is incorrect because in Page Layout view, the ScreenTip displays the width in inches, not pixels.

Question 19

Currency is an example of a number format.

Accepted Answer

Currency is a specific format of numbers that includes a symbol representing a specific unit of currency such as dollars or euros. It is commonly used in financial and monetary transactions.

Question 20

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.

Accepted Answer

- left
False - Left
False - LEFT

Quiz 8: Excel

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

To rotate cell contents to an exact value, you change its _____.

You need to add another product to your inventory worksheet, which shows product names in row A.Which of the following should you add?

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

After you delete a worksheet column, _____.

To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.

The Clipboard task pane shows the contents of the _____.

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.

Arlo wants to use goal seek to answer "what if" questions in a file.To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek...from the drop down menu.What is X in the procedure?

Which of the following does the Accessibility Checker look for? Select all the options that apply.

To copy a cell's formatting to another cell, which of the following can you use?

You double-click the Format Painter button when you want to _____.

To delete a worksheet column, you can first select it by _____.

Which of the following is true about deleting a worksheet row?

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

To change the name of a worksheet, you rename the _____.

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

Which of the following is true about changing worksheet column width?

Currency is an example of a number format.

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.