Question 1

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?
A) Erase All
B) Clear All
C) Delete All
D) Remove All

Accepted Answer

The option "Remove All" is the most appropriate choice as it clearly indicates that all unwanted data will be removed from the document. The other options, such as Erase All, Clear All, and Delete All, may suggest different actions that could potentially delete important information in the document.

Question 2

To embed an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Accepted Answer

The answer of To embed an object from another application,click...

Question 3

Annemarie wants to save a workbook as a shared workbook to allow several users to work on it simultaneously.For this,she clicks X > Y > Share Workbook > Editing tab > Allow changes by more than one user at the same time > OK > Save the shared workbook on a network location for other users to access it in Save As dialog box.What can X and Y be in the series of clicks?
A) X- View tab,Y- Show group
B) X- Insert tab,Y- Links group
C) X- Review tab,Y- Changes group
D) X- Developer tab,Y- Controls group

Accepted Answer

Annemarie needs to access the Share Workbook feature, which is located in the Changes group on the Review tab in Microsoft Excel. Therefore, X should be the Review tab and Y should be the Changes group. The other options listed do not contain the necessary feature or tab for Annemarie to share the workbook.

Question 4

Kimani is working on a data set in which she has to add pictures into cells adjacent to the respective names of objects in her file.To do so,she clicks on the following series: Insert tab > X > Pictures > Insert Picture dialog box > Locate the picture that she wants to insert into a cell in Excel > Insert > Format tab > Y > Edit height and width to fit into cell > Place picture into cell.What can X and Y in the series of clicks/entries be? A) Apps group,Arrange group B) Illustrations group,Size group C) Sparklines group,Adjust group D) Charts group,Picture Styles group

Accepted Answer

The option "Illustrations group, Size group" is the correct choice for X and Y in the given series of clicks because the "Illustrations group" contains the option "Pictures" to insert a picture into the cell, and the "Size group" in the "Format" tab allows editing the height and width of the picture to fit into the cell. The other options mentioned in the question such as Apps group, Arrange group, Sparklines group, Adjust group, Charts group, and Picture Styles group do not contain the relevant options required to insert and edit pictures in an Excel cell.

Question 5

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be? ​
A) Next
B) Delete
C) Previous
D) New Comment

Accepted Answer

The "Next" button in the Comments group on the Review tab is used to move to the next change or comment in the document, allowing Esther to review and accept changes sequentially.

Question 6

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?
A) Click the thumbnail image of the window whose screenshot he wants to insert.
B) Click Screen Clipping,then press and hold the left mouse button to drag and capture the window screen.
C) Select a thumbnail of the required window,then press and hold the left mouse button to drag and capture the window screen.
D) Click Screen Clipping,and when the pointer becomes a hand icon,capture the window screen.

Accepted Answer

Ernie should click the thumbnail image of the window whose screenshot he wants to insert from the Available windows gallery.

Question 7

To insert an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Accepted Answer

This is the correct procedure to insert an object from another application in Microsoft Office.

Question 8

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file.To do so,she can click File > Info > Protect (Document,Presentation,or Workbook)> Protect Current Sheet > OK.

Accepted Answer

To mark a workbook as final, Lilia can click File > Info > Protect Workbook > Mark as Final. To protect the workbook as Read-Only, she can click File > Save As > Tools > General Options > check the Read-only recommended box > OK > Save.

Question 9

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010,or 2013.To do so,he can click File > Info > Check for Issues > Check Compatibility > OK.

Accepted Answer

This is the correct process to check compatibility in Excel.

Question 10

Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?
A) Send
B) Send Now
C) Send to Mail Recipient
D) Send to Exchange Folder

Accepted Answer

The option "Send to Mail Recipient" is the most appropriate option out of the given choices to email a workbook as an attachment. The other options do not specifically refer to email and may not provide the required functionality.

Question 11

Return value comments help others understand what values are returned by a procedure.

Accepted Answer

Return value comments are used to explain the value or values returned by a procedure, helping others understand the expected outcome of calling that procedure.

Question 12

What is the default number of days for Excel change history?
A) 15
B) 30
C) 60
D) 90

Accepted Answer

The default number of days for Excel change history is 30. This means that Excel will keep a record of changes made to a file for the last 30 days. If you need to access changes made before that period, you will need to look for a previous version of the file or use a backup.

Question 13

Stella wants to merge two workbooks.She begins by opening the workbooks,then selects the worksheets she wants to copy by clicking on the first sheet tab that she wants to copy,pressing and holding the Shift key,and then clicking on the last sheet tab.Then she right-clicks on one of the selected tabs and selects an option from the menu.Which of the following can her selection be?
A) Insert
B) Rename
C) View Code
D) Move or Copy

Accepted Answer

The option to copy selected worksheets from one workbook to another would involve using the Move or Copy function in Excel. The other options listed (Insert, Rename, View Code) do not relate to the task of merging two workbooks.

Quiz 15: Collaborating with Your Team.(Digital Only).

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?

To embed an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be? ​

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

To insert an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file.To do so,she can click File > Info > Protect (Document,Presentation,or Workbook)> Protect Current Sheet > OK.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010,or 2013.To do so,he can click File > Info > Check for Issues > Check Compatibility > OK.

Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?

Return value comments help others understand what values are returned by a procedure.

What is the default number of days for Excel change history?

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be?