Exam 12: Excel: Creating a Worksheet and a Chart

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

If you accidentally undo an action,you can use the Redo button to redo it._________________________

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

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

When text is longer than the width of a column,Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

____ properties are associated with all Microsoft Office files and include author,title,and subject.

To erase an entire entry in a cell and then reenter the data from the beginning,press the ____ key.

As you type,Excel displays the entry (and the Cancel box and Enter box)in the ____________________.

Case 1-2 Anita is new to Microsoft Excel 2013.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?

If a major error is made when typing data into a cell,tap or 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.

If you wish to sign out of your Microsoft account,tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery,and tap or click the Sign out link.

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate,easy to read,flexible,and useful.

Identify the letter of the choice that best matches the phrase or definition. -Selects the adjacent cell in the direction of the arrow on the key.

____________________ indicates how characters are emphasized.

The automatically adjusted cell reference in a pasted formula is called a(n)____________________.

The active cell reference appears in the ____________________ on the left side of the formula bar.

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

List and briefly describe six chart types from which you can choose in Excel.Mention how you select the appropriate type of chart.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.