Question 1

Match between columns
                        Premises: Not used to clear a cell.

Accepted Answer

The Answer of SHIFT-RIGHT ARROW and ARROW and DELETE and is...

Question 2

A single point is about 1/32 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 3

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet, as shown in the accompanying figure.

Accepted Answer

A) True 
 B)False

Question 4

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Accepted Answer

A) save 
B) print 
C) format 
D) clear 
A) save 
B) print 
C) format 
D) clear

Question 5

Which of the following keys is an alternative to double-clicking the cell to edit it?

Accepted Answer

A) F1 
B) FN-F2 
C) F3 
D) F4 
A) F1 
B) FN-F2 
C) F3 
D) F4

Question 6

To enter a number as text, start the entry with a(n)____________________.

Accepted Answer

The answer of To enter a number as text, start...

Question 7

The cell that has a heavy border and whose reference appears in the Name box is referred to as the ____________________ cell.

Accepted Answer

The answer of The cell that has a heavy border...

Question 8

Match between columns
                        Premises: Deletes characters to the left of the insertion point.

Accepted Answer

The Answer of FN-RIGHT ARROW and FN-F2 and DELETE and is...

Question 9

The ____ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

Accepted Answer

A) AutoComplete 
B) AutoCorrect 
C) AutoFormat 
D) AutoTyping 
A) AutoComplete 
B) AutoCorrect 
C) AutoFormat 
D) AutoTyping

Question 10

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button on the Charts tab.

Accepted Answer

A) True 
 B)False

Question 11

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

A) the font and font size 
B) a chart 
C) a sketch 
D) the title and subtitle text 
A) the font and font size 
B) a chart 
C) a sketch 
D) the title and subtitle text

Question 12

You should press the SPACE BAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 13

The ____ command is located in the Standard toolbar, as shown in the accompanying figure.

Accepted Answer

A) Undo 
B) Cell Style 
C) Bold 
D) Increase Decimal 
A) Undo 
B) Cell Style 
C) Bold 
D) Increase Decimal

Question 14

Excel remembers the last ____ actions you have completed.

Accepted Answer

A) 25 
B) 50 
C) 75 
D) 100 
A) 25 
B) 50 
C) 75 
D) 100

Question 15

Excel uses the default Oriel theme for all new workbooks.

Accepted Answer

A) True 
 B)False

Question 16

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

Accepted Answer

A) True 
 B)False

Question 17

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Accepted Answer

A) True 
 B)False

Question 18

What effect does the Accounting Number Format have on the selected cells?

Accepted Answer

A) Converts alphabetic characters to numbers 
B) Displays cell contents with two decimal places that align vertically 
C) Performs tax calculations 
D) Copies the numbers of one cell to another 
A) Converts alphabetic characters to numbers 
B) Displays cell contents with two decimal places that align vertically 
C) Performs tax calculations 
D) Copies the numbers of one cell to another

Question 19

You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).

Accepted Answer

A) True 
 B)False

Question 20

When analyzing a problem in designing a worksheet solution, what is the first step?

Accepted Answer

A) design the worksheet 
B) define the problem 
C) enter the data and formulas 
D) test the worksheet 
A) design the worksheet 
B) define the problem 
C) enter the data and formulas 
D) test the worksheet

A single point is about 1/32 of one inch in height.

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet, as shown in the accompanying figure.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Which of the following keys is an alternative to double-clicking the cell to edit it?

To enter a number as text, start the entry with a(n)____________________.

The cell that has a heavy border and whose reference appears in the Name box is referred to as the ____________________ cell.

The ____ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button on the Charts tab.

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.

You should press the SPACE BAR to clear a cell.

The ____ command is located in the Standard toolbar, as shown in the accompanying figure.

Excel remembers the last ____ actions you have completed.

Excel uses the default Oriel theme for all new workbooks.

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

What effect does the Accounting Number Format have on the selected cells?

You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).

When analyzing a problem in designing a worksheet solution, what is the first step?

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Formulas, Functions, and Formatting

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

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media

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

Word: Creating a Research Paper With Citations and References

Filters

Exam 3: Excel: Creating a Worksheet and an Embedded Chart

A single point is about 1/32 of one inch in height.

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet, as shown in the accompanying figure.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Which of the following keys is an alternative to double-clicking the cell to edit it?

To enter a number as text, start the entry with a(n)____________________.

The cell that has a heavy border and whose reference appears in the Name box is referred to as the ____________________ cell.

The ____ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button on the Charts tab.

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.

You should press the SPACE BAR to clear a cell.

The ____ command is located in the Standard toolbar, as shown in the accompanying figure.

Excel remembers the last ____ actions you have completed.

Excel uses the default Oriel theme for all new workbooks.

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

What effect does the Accounting Number Format have on the selected cells?

You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).

When analyzing a problem in designing a worksheet solution, what is the first step?

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Formulas, Functions, and Formatting

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

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media

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

Word: Creating a Research Paper With Citations and References

Filters