Exam 7: Excel: Creating a Worksheet and a Chart

You use ____ to view an XPS file.

By default,text is ____ in a cell.

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 date you change a file is an example of a(n)____ property.

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

You should press the SPACEBAR to clear a cell.

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

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.

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

____ is/are used to place worksheet,column,and row titles on a worksheet.

Clicking the ____ box completes an entry.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

-A cell is selected,or ____________________,when a heavy border surrounds the cell,as shown in the accompanying figure.

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

Excel remembers the last ____ actions you have completed.

To add a pie chart,first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Selects the cell one worksheet window to the right.

You can insert a function in a cell by ____.

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