Question 1

The accompanying figure represents a Word document in ____ view.

Accepted Answer

A)   Outline
B)   Normal
C)   Print Layout
D)   Reading Layout A

Question 2

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

Accepted Answer

A)   inner
B)   embedded
C)   sub
D)   interactive B

Question 3

You can use ____ to move around in a document that is too large to fit on the screen at once.

Accepted Answer

A)   cell pointers
B)   mode indicators
C)   scroll bars
D)   sheet tabs C

Question 4

Which method of entering a function requires the user to know the name and initial characters of a function?

Accepted Answer

A)   manually typing the function
B)   using the Insert Function button
C)   using the Sum button
D)   using the Sum list arrow

Question 5

____ marks indicate the scale of measure for each value on the y-axis.

Accepted Answer

A)   Datapoint
B)   Tick
C)   Axis
D)   Legend

Question 6

In the accompanying figure, item 2 is the ____ list arrow.

Accepted Answer

A)   Number Format
B)   Accounting Number Format
C)   Commands in Number
D)   Decimal Number

Question 7

To move to the top of an embedded Excel worksheet, enter [Ctrl] [ ____ ].

Accepted Answer

A)   Insert
B)   Home
C)   Tab
D)   Alt

Question 8

After an Excel worksheet is embedded in a PowerPoint slide, how is the worksheet identified and displayed?

Accepted Answer

The answer of After an Excel worksheet is embedded in...

Question 9

Which two charts compare trends over time intervals?

Accepted Answer

A)   bar and pie
B)   pie and area
C)   area and line
D)   line and scatter

Question 10

The ____ size is the physical size of the text.

Accepted Answer

A)   style
B)   format
C)   serif
D)   font

Question 11

The ____ option helps fit the data on a single page without making changes to individual margins.

Accepted Answer

A)   Scale to Fit
B)   Paginate
C)   Page Break View
D)   Squeeze

Question 12

You can add a text box using the CHART TOOLS ____ tab.

Accepted Answer

A)   DESIGN
B)   LAYOUT
C)   FORMAT
D)   TEXT

Question 13

If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can determine that the text value in Word is ____ the source document.

Accepted Answer

A)   embedded in
B)   linked to
C)   copied to
D)   pasted to

Question 14

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

Accepted Answer

A)   =C12+(C13*F4) 
B)   =(C12+C13) *F4
C)   =$C12+$C13*F4
D)   =C12*F4+C13

Question 15

As shown in the accompanying figure, item ____ points to the formula bar.

Accepted Answer

A)   1
B)   2
C)   3
D)   4

Question 16

When you ____ an object to a PowerPoint slide, the object is still stored in the source file in the source program.

Accepted Answer

A)   embed
B)   define
C)   join
D)   link

Question 17

In Excel, the electronic spreadsheet you work in is called a ____.

Accepted Answer

A)   tablet
B)   databook
C)   numericsheet
D)   worksheet

Question 18

To link data other than a chart, you use the Select button and the Copy Link command to create a link between the source file and the destination file.

Accepted Answer

A) True 
 B)False

Question 19

Cell ____ are predesigned combinations of formats.

Accepted Answer

A)   resolutions
B)   dimensions
C)   alignments
D)   styles

Question 20

Clicking the ____________________ button sums the adjacent cell range above or to the left.

Accepted Answer

The answer of Clicking the ____________________ button sums the adjacent...

Exam 11: Excel 2013 Getting Started With Excel 2013