Question 1

Microsoft Office programs are designed to work together through a process called ____.

Accepted Answer

A)   validation
B)   integration
C)   certification
D)   authenticationE) A) and D)
F) B) and C)

Question 2

The COUNTA function is used to count the number of cells in a range that contain which type of data?

Accepted Answer

A)   numbers
B)   dates
C)   formulas
D)   All of the above.E) B) and C)
F) A) and B)

Question 3

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

Accepted Answer

A)   The user sees a "clipboard full" message.
B)   The clipboard automatically deletes all items and starts over with the new item.
C)   The clipboard prompts the user to delete items.
D)   The clipboard automatically deletes the oldest item on the clipboard.E) B) and C)
F) B) and D)

Question 4

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Accepted Answer

A) True 
 B)False

Question 5

You use the Copy and ____________________ commands when you want to copy an item from one program to another program.

Accepted Answer

The answer of You use the Copy and ____________________ commands...

Question 6

A(n)  ____ object in a PowerPoint file becomes a part of the PowerPoint file.

Accepted Answer

A)   persistent
B)   dynamic
C)   embedded
D)   immutableE) All of the above
F) None of the above

Question 7

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

Accepted Answer

A)   =B2xC2
B)   =B2%C2
C)   =B2*C2
D)   B2*C2E) B) and D)
F) All of the above

Question 8

You can edit a(n) embedded file by double-clicking it in the destination program to open the source program.  _________________________

Accepted Answer

A) True 
 B)False

Question 9

A collection of related data points is called a ____.

Accepted Answer

A)   data marker
B)   tick mark
C)   data point
D)   data seriesE) C) and D)
F) All of the above

Question 10

In the accompanying figure, item 2 points to the level of the currently selected ____.

Accepted Answer

A)   object
B)   text
C)   image
D)   formatE) B) and D)
F) C) and D)

Question 11

In the accompanying figure, the item marked as 2 points to the ____ button.

Accepted Answer

A)   Copy
B)   Cut
C)   Paste
D)   UndoE) None of the above
F) C) and D)

Question 12

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

Accepted Answer

A)   formulas
B)   formatting
C)   labels
D)   dataE) B) and C)
F) None of the above

Question 13

You can print a chart by itself or as part of the worksheet.

Accepted Answer

A) True 
 B)False

Question 14

You embed data created in other programs in PowerPoint when you want to be able to edit it from within the ____________________ file.

Accepted Answer

The answer of You embed data created in other programs...

Question 15

You should link an object to a PowerPoint slide when you always want your object to include the latest information.

Accepted Answer

A) True 
 B)False

Question 16

In the accompanying figure, item 4 points to a ____.

Accepted Answer

A)   data point
B)   tick mark
C)   data series
D)   data markerE) None of the above
F) A) and B)

Question 17

A(n)  ____ is an entry in a cell that contains text such as "2013 Sales" or "Travel Expenses."

Accepted Answer

A)   value
B)   label
C)   formula
D)   argumentE) A) and D)
F) B) and C)

Question 18

You can "collect" up to ____ items to the Clipboard and then switch to another program to paste them.

Accepted Answer

A)   8
B)   12
C)   16
D)   24E) A) and C)
F) A) and D)

Question 19

Explain conditional formatting.

Accepted Answer

You can use formatting to highlight impo...

Question 20

The = sign is also called the ____________________ and is automatically inserted when a function is selected.

Accepted Answer

The answer of The = sign is also called the...

Exam 11: Excel 2013 Getting Started With Excel 2013

A(n) ____ object in a PowerPoint file becomes a part of the PowerPoint file.

Correct AnswerverifiedShow Answer

Explain conditional formatting.

Correct AnswerverifiedYou can use formatting to highlight impo...View AnswerShow Answer

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

Correct AnswerverifiedShow Answer

Microsoft Office programs are designed to work together through a process called ____.

Correct AnswerverifiedShow Answer

You can "collect" up to ____ items to the Clipboard and then switch to another program to paste them.

Correct AnswerverifiedShow Answer

A(n) ____ is an entry in a cell that contains text such as "2013 Sales" or "Travel Expenses."

Correct AnswerverifiedShow Answer

In the accompanying figure, item 4 points to a ____.

Correct AnswerverifiedShow Answer

In the accompanying figure, the item marked as 2 points to the ____ button.

Correct AnswerverifiedShow Answer

You can edit a(n) embedded file by double-clicking it in the destination program to open the source program. _________________________

Correct AnswerverifiedShow Answer

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Correct AnswerverifiedShow Answer

You should link an object to a PowerPoint slide when you always want your object to include the latest information.

Correct AnswerverifiedShow Answer

In the accompanying figure, item 2 points to the level of the currently selected ____.

Correct AnswerverifiedShow Answer

You can print a chart by itself or as part of the worksheet.

Correct AnswerverifiedShow Answer

You embed data created in other programs in PowerPoint when you want to be able to edit it from within the ____________________ file.

Correct AnswerverifiedShow Answer

The = sign is also called the ____________________ and is automatically inserted when a function is selected.

Correct AnswerverifiedShow Answer

The COUNTA function is used to count the number of cells in a range that contain which type of data?

Correct AnswerverifiedShow Answer

A collection of related data points is called a ____.

Correct AnswerverifiedShow Answer

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

Correct AnswerverifiedShow Answer

You use the Copy and ____________________ commands when you want to copy an item from one program to another program.

Correct AnswerverifiedShow Answer

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
You can use formatting to highlight impo...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified