Question 1

Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.Perry decides that before either of his employees creates a new workbook he must give them a(n)_____.

Accepted Answer

A requirements document outlines the necessary specifications and guidelines for creating a new workbook, ensuring that the employees understand what is needed before they begin.

Question 2

Match between columns
                        Premises: Highlights one or more adjacent characters to the right.

Accepted Answer

The Answer of CTRL+F and SHIFT+RIGHT ARROW and INSERT and is...

Question 3

Match between columns
                        Premises: Selects the adjacent cell in the direction of the arrow on the key.

Accepted Answer

The Answer of HOME and SPACEBAR and SHIFT+RIGHT ARROW and is...

Question 4

Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.Perry also decides that he should approve _____ of any proposed worksheet.

Accepted Answer

The answer of Perry has recently expanded his business and...

Question 5

Anita is new to Microsoft Office Excel 2010.As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive.Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

Accepted Answer

AutoCorrect is a feature in Excel that automatically corrects common spelling and typing errors, helping users like Anita reduce mistakes and improve productivity.

Question 6

Match between columns
                        Premises: Selects the cell one worksheet window to the right.

Accepted Answer

The Answer of ARROW and HOME and ALT+PAGE DOWN and is...

Question 7

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

Question 8

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 9

Anita is new to Microsoft Office Excel 2010.As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive.Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

Accepted Answer

Document properties help Anita organize and identify her workbook files by allowing her to add metadata such as author, title, and keywords, making it easier to manage and search for files.

Question 10

Discuss how to correct errors after entering data into a cell using in-cell editing.

Accepted Answer

The answer of Discuss how to correct errors after entering...

Question 11

Match between columns
                        Premises: Displays the Find dialog box.

Accepted Answer

The Answer of HOME and ALT+PAGE DOWN and CTRL+F and is...

Question 12

Match between columns
                        Premises: Selects the cell at the beginning of the row that contains the active cell.

Accepted Answer

The Answer of END and ARROW and HOME and CTRL+HOME is...

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

Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.Perry decides that before either of his employees creates a new workbook he must give them a(n) _____.

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.

Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.Perry also decides that he should approve _____ of any proposed worksheet.

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.

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.

Discuss how to correct errors after entering data into a cell using in-cell editing.

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.