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 31

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

A(n)____________________ conveys a visual representation of data.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

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

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

Identify the letter of the choice that best matches the phrase or definition. -Selects the cell at the beginning of the row that contains the active cell.

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

Identify the letter of the choice that best matches the phrase or definition. -Deletes characters to the left of the insertion point.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

You use ____ to view an XPS file.

Press ____ to select the entire worksheet.

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

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

A given range contains the data that determines the size of slices in a corresponding pie chart;these entries are called the category names.

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

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.

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

Identify the letter of the choice that best matches the phrase or definition. -Should not be used to clear a cell.

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

A character with a point size of 10 is about 10/72 of one inch in height.