Exam 12: Excel: Creating a Worksheet and a Chart

____ is an electronic image format,sometimes called a fixed format.

Combining two or more selected cells into one cell is called ____ cells.

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

The ____ feature works behind the scenes,fixing common typing or spelling mistakes when you complete a text entry.

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

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

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

Excel recognizes the following as text: 401AX21,921-231,619 321,883XTY.

When entering dollar values in cells,you also must type the dollar sign ($),commas,and any trailing zeros.

To enter data in a cell,you must first select the ____.

Which of the following keys moves the insertion point to the end of data in a cell?

Like an area chart,a(n)____________________ chart often is used to illustrate changes in data over time.

Case 1-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 ____.

When you tap or click the Enter box to complete an entry in a cell,the active cell moves down to the next cell in the same column.

The Microsoft Office Specialist (MOS)program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

Case 1-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 also decides that he should approve ____ of any proposed worksheet.

Identify the letter of the choice that best matches the phrase or definition. -Toggles between Insert and Overtype mode.

____________________ involves reducing the electricity consumed and environmental waste generated when using computers,mobile devices,and related technologies.

You can click the ____________________ button arrow (HOME tab | Editing group)to view a list of often-used functions.

Identify the letter of the choice that best matches the phrase or definition. -Selects the cell one worksheet window to the right.