Match between columns Premises: Moves the insertion point to the end of data in a cell.

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

Match between columns Premises: Toggles between Insert and Overtype mode.

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

Exam 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)_____.

(Multiple Choice)

4.7/5

(31)

Question 41

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n)range .

(True/False)

4.8/5

(32)

Question 42

The characters that Excel displays on the screen are a specific _____.

(Multiple Choice)

4.8/5

(37)

Question 43

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

Premises:

Moves the insertion point to the end of data in a cell.

Responses:

ALT+PAGE DOWN

CTRL+HOME

BACKSPACE

Correct Answer:

Verified

Moves the insertion point to the end of data in a cell.

(Matching)

4.9/5

(30)

Question 44

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

(True/False)

4.9/5

(40)

Question 45

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

(True/False)

4.8/5

(31)

Question 46

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

Premises:

Toggles between Insert and Overtype mode.

Responses:

INSERT

ARROW

ALT+PAGE DOWN

Correct Answer:

Verified

Toggles between Insert and Overtype mode.

(Matching)

4.9/5

(42)

Question 47

A(n)_____ chart is drawn on the same worksheet as the data.

(Multiple Choice)

4.8/5

(35)

Question 48

A(n)_________________________ conveys a visual representation of data.

(Short Answer)

4.9/5

(32)

Question 49

To remove an embedded chart, you should _____ it and press the DELETE key.

(Multiple Choice)

4.8/5

(32)

Question 50

A character with a point size of 10 is about 10/72 of one inch in height.

(True/False)

4.9/5

(39)

Question 51

The first step in creating an effective worksheet is to make sure you _____.

(Multiple Choice)

4.8/5

(34)

Question 52

You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position.

(True/False)

4.8/5

(30)

Question 53

The _________________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

(Short Answer)

4.9/5

(30)

Question 54

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

(True/False)

4.8/5

(32)

Question 55

The easiest way to select a cell is to move the block plus sign _______________________ to the cell and then click.

(Short Answer)

4.9/5

(40)

Question 56

Excel can display characters in only three font colors: black, red, and blue.

(True/False)

4.8/5

(38)

Question 57

Worksheet _________________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

(Short Answer)

4.8/5

(30)

Question 58

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?

(Multiple Choice)

4.8/5

(43)

Question 59

To clear the entire worksheet, click the Clear All button on the worksheet.

(True/False)

4.9/5

(31)

Question 60

Showing 41 - 60 of 112

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)_____.

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n)range .

The characters that Excel displays on the screen are a specific _____.

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

A(n)_____ chart is drawn on the same worksheet as the data.

A(n)_________________________ conveys a visual representation of data.

To remove an embedded chart, you should _____ it and press the DELETE key.

A character with a point size of 10 is about 10/72 of one inch in height.

The first step in creating an effective worksheet is to make sure you _____.

You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position.

The _________________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

The easiest way to select a cell is to move the block plus sign _______________________ to the cell and then click.

Excel can display characters in only three font colors: black, red, and blue.

Worksheet _________________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

To clear the entire worksheet, click the Clear All button on the worksheet.

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Access: Querying a Database

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Formulas, Functions, and Formatting

Excel : What-If Analysis, Charting and Working With Large Worksheets

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters