Exam 2: Creating a Worksheet and a Chart

A ____ reference is an adjusted cell reference in a copied and pasted formula.

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.

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

You should press the SPACEBAR to clear a cell.

The ____ button allows you to erase recent cell entries.

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

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

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

You can insert a function in a cell by ____.

The range of cells receiving copied content is called the ____ area.

By default, text is ____ in a cell.

Worksheet titles and subtitles should be as wordy as possible.

If the next entry you want to make is in an adjacent cell, use the ____________________ keys to complete the entry in the current cell and make the adjacent cell the active cell.

Clicking the ____ box completes an entry.

In Excel, a number can contain the characters ____.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects cell A1.

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.