Exam 2: Creating a Worksheet and a Chart

____________________ corrects two initial capital letters by changing the second letter to lowercase.

You use ____ to view an XPS file.

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.

In a worksheet, columns typically contain information that is similar to a list.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Highlights one or more adjacent characters to the right.

Critical Thinking Questions 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 features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

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.

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

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

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

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.

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

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

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

The date you change a file is an example of a(n) ____ property.

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

Critical Thinking Questions 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 ____.

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area.