FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Excel: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

A) apply font formatting
B) understand what is required
C) insert a chart
D) enter the data

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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

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.

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

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

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.

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

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

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

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

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.

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 decides that before either of his employees creates a new workbook he must give them a ____.