Question 1

You use ____ to view an XPS file.

Accepted Answer

A) Adobe Reader 
B) Backstage View 
C) Microsoft PowerView 
D) XPS Viewer

Question 2

By default,text is ____ in a cell.

Accepted Answer

A) left-aligned 
B) centered 
C) justified 
D) right-aligned

Question 3

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.

Accepted Answer

A) ACCESS 
B) TOOLS 
C) EXIT 
D) FILE

Question 4

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

Accepted Answer

A) automatically updated 
B) baseline 
C) standard 
D) indexed

Question 5

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

Accepted Answer

A) exploded 
B) outer 
C) offset 
D) rasterized

Question 6

You should press the SPACEBAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) RIGHT ARROW 
B) LEFT ARROW 
C) UP ARROW 
D) DOWN ARROW

Question 8

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.

Accepted Answer

The answer of While typing in a cell,you can press...

Question 9

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

Accepted Answer

The answer of The automatically adjusted cell reference in a...

Question 10

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

Accepted Answer

A) Color 
B) Text 
C) Links 
D) Tabs

Question 11

Clicking the ____ box completes an entry.

Accepted Answer

A) Cancel 
B) Formula 
C) Enter 
D) Tab

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of 
-A cell is selected,or ____________________,when a heavy...

Question 14

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

Accepted Answer

The answer of ____________________ corrects two initial capital letters by...

Question 15

Excel remembers the last ____ actions you have completed.

Accepted Answer

A) 25 
B) 50 
C) 75 
D) 100

Question 16

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).

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) semi-colon (;) 
B) colon (:) 
C) period (. ) 
D) none of the above

Question 18

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.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 19

You can insert a function in a cell by ____.

Accepted Answer

A) tapping or clicking the Sum button arrow (HOME tab | Editing group) 
B) tapping or clicking the Insert Function button in the formula bar 
C) typing + and one or more letters and then selecting the function name from a list 
D) typing = and one or more letters and then selecting the function name from a list

Question 20

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

Accepted Answer

A) True 
 B)False

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.