Question 1

Discuss saving a project, including definitions of the terms file and file name in the discussion. Include the two reasons why it is important to save a workbook frequently, and discuss the considerations involved in the selection of a storage medium.

Accepted Answer

The answer of Discuss saving a project, including definitions of...

Question 2

The __________ specifies the size of the characters on the screen and is gauged by a measurement system called points. A single point is about 1/72 of one inch in height.

Accepted Answer

The answer of The __________ specifies the size of the...

Question 3

Match between columns
                        Premises: Press the ALT key to display this keyboard code icon for certain commands.

Accepted Answer

The Answer of Ribbon and menu and gridline and Quick is...

Question 4

Critical Thinking Questions Case 1-1 Perry has recently expanded his business from a sole proprietorship to include two new employees he has hired. As a result of this expansion, he is considering carefully how to save the workbooks that he and his employees will create, and what storage media would be the best for the workbooks. Which of the following storage media is the best choice for Perry and his team if they decide that they will not need to share their workbooks across the team and they will not need to transport their projects to other locations?

Accepted Answer

A hard drive is the best choice for Perry and his team if they do not need to share their workbooks across the team or transport their projects. Hard drives offer ample storage space, reliability, and quick access to files directly from their computers without the need for internet access or physical transportation of media.

Question 5

You can activate Excel Help by clicking the __________ button.

Accepted Answer

The answer of You can activate Excel Help by clicking...

Question 6

Critical Thinking Questions Case 1-2 Anita is new to Microsoft Office Excel 2007. As she uses the application, she is beginning to see that it offers many features designed to make her use of Excel very easy. Which of the following features would be helpful to Anita if she wants to see the impact of a particular gallery choice on her worksheet, but she is nervous about actually applying the feature from the outset?

Accepted Answer

The live preview feature allows Anita to see the impact of a particular gallery choice on her worksheet without actually applying the feature. This can help her feel more confident in her choices before committing to them. The other options, such as the Insert tab, Home tab, and keyboard indicators, do not offer this specific functionality.

Question 7

Critical Thinking Questions Case 1-2 Anita is new to Microsoft Office Excel 2007. As she uses the application, she is beginning to see that it offers many features designed to make her use of Excel very easy. Anita has decided that she would like to make better use of the keyboard. Which of the following features would alert her to any available keyboard shortcuts associated with commands on the Ribbon?

Accepted Answer

Enhanced ScreenTip will display information about the command including an available keyboard shortcut when you hover the mouse over a command on the Ribbon.

Question 8

The mouse pointer becomes the block plus sign whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns.

Accepted Answer

The mouse pointer typically becomes a block plus sign (or a thick cross) when you are about to perform actions like selecting cells, rows, or columns within a worksheet, not when moving outside the worksheet or dragging cell contents between rows or columns. When dragging cell contents, the pointer often changes to a different icon indicating the action being performed (e.g., a move or copy icon).

Question 9

Match between columns
                        Premises: A central location for managing and sharing workbooks.

Accepted Answer

The Answer of Key Tip badge and gridline and Ribbon is...

Question 10

Match between columns
                        Premises: Contains a list of commands.

Accepted Answer

The Answer of Microsoft Office Button and Mini toolbar and is...

Question 11

Discuss document properties. Include definitions of these terms: metadata, keywords, standard properties, and automatically updated properties. Be sure to give at least two reasons why document properties are valuable.

Accepted Answer

The answer of Discuss document properties. Include definitions of these...

Question 12

As you are clearing cell entries, always remember that you should never press the __________ to clear a cell.

Accepted Answer

The answer of As you are clearing cell entries, always...

Question 13

The opposite of cell merging is cell __________, which is done by selecting a merged cell and clicking the Merge and Center button.

Accepted Answer

The answer of The opposite of cell merging is cell...

Question 14

Excel remembers the last 100 actions you have completed. Thus, you can undo up to 100 previous actions by clicking the __________ button arrow to display the Undo list and then clicking the action to be undone.

Accepted Answer

The answer of Excel remembers the last 100 actions you...

Question 15

A letter above the worksheet grid, also called the row heading , identifies each column.

Accepted Answer

A letter above the worksheet grid identifies each column, not each row. The letter represents the column heading.

Question 16

Critical Thinking Questions Case 1-1 Perry has recently expanded his business from a sole proprietorship to include two new employees he has hired. As a result of this expansion, he is considering carefully how to save the workbooks that he and his employees will create, and what storage media would be the best for the workbooks. Perry decides that he will need to have access to particular workbooks on a variety of computers in the office. As a result, which of the following storage media is a good choice for him?

Accepted Answer

The answer of Critical Thinking Questions Case 1-1 Perry has...

Question 17

Excel positions text right-aligned in a cell, meaning the entry displays to the far left in the cell.

Accepted Answer

Excel positions text left-aligned in a cell, meaning the entry displays to the far right in the cell.

Question 18

While creating an Excel worksheet, several decisions will determine the appearance and characteristics of the finished worksheet. List and explain the general guidelines you should follow as you create a worksheet.

Accepted Answer

The answer of While creating an Excel worksheet, several decisions...

Question 19

The mouse pointer appears as a block arrow whenever it is located in a cell on the worksheet.

Accepted Answer

The mouse pointer typically appears as a thin, plus-shaped pointer (crosshair) when positioned over a cell in a worksheet, not a block arrow. The block arrow shape is more commonly seen when the mouse is over certain UI elements, not cells.

Question 20

Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers .

Accepted Answer

Excel only treats a combination of numbers as a number. If there are spaces or nonnumeric characters included, Excel will not recognize it as a number.

Quiz 8: Excel: Creating a Worksheet and an Embedded Chart

Discuss saving a project, including definitions of the terms file and file name in the discussion. Include the two reasons why it is important to save a workbook frequently, and discuss the considerations involved in the selection of a storage medium.

The __________ specifies the size of the characters on the screen and is gauged by a measurement system called points. A single point is about 1/72 of one inch in height.

Identify the letter of the choice that best matches the phrase or definition.

You can activate Excel Help by clicking the __________ button.

The mouse pointer becomes the block plus sign whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Discuss document properties. Include definitions of these terms: metadata, keywords, standard properties, and automatically updated properties. Be sure to give at least two reasons why document properties are valuable.

As you are clearing cell entries, always remember that you should never press the __________ to clear a cell.

The opposite of cell merging is cell __________, which is done by selecting a merged cell and clicking the Merge and Center button.

Excel remembers the last 100 actions you have completed. Thus, you can undo up to 100 previous actions by clicking the __________ button arrow to display the Undo list and then clicking the action to be undone.

A letter above the worksheet grid, also called the row heading , identifies each column.

Excel positions text right-aligned in a cell, meaning the entry displays to the far left in the cell.

While creating an Excel worksheet, several decisions will determine the appearance and characteristics of the finished worksheet. List and explain the general guidelines you should follow as you create a worksheet.

The mouse pointer appears as a block arrow whenever it is located in a cell on the worksheet.

Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers .