Excel CH10

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

30

Sven wants to create a custom theme font set for the heading and body of a presentation. Under tab X, he selects Fonts, and then selects Create New Theme Fonts. Then he selects a heading font, a body font, types in a name for his theme font set and clicks Save. Which of the following can tab X be in the above-mentioned procedure?

Design

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she select in the Protect Workbook box under Options in the File tab to do this?

Encrypt with Password

To copy and paste comments in an Excel sheet, select the cell containing the comment and press Ctrl+V. Then select the cell where you want to paste the comment, right click on it and select Paste Special from the popup menu.

False

To create your own theme color, click on Page Layout, then Colors, then Customize Colors, then click the button next to the theme color you want to change, and finally pick a color under Theme Colors.

False

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

False

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?

Move or Copy

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?

Next

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

Page Layout

Musa wants to choose a standard color theme for an Excel worksheet he is working on. He clicks on the Page Layout tab and then clicks Colors. What should he do next to complete the procedure?

Pick the color set he wants

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

Send to Mail Recipient

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

The People in <name of your organization>.

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

True

To change theme effects, click on Effects on the Page Layout tab, then select the set of effects that you want to use.

True

To edit a comment in a cell, select the cell that contains the comment, right-click on it and select the Edit Comment option from the menu.

True

To go to a previous comment, use the Previous button in the Comments group on the Review tab.

True

To show a comment in an active cell, select the cell, then click Review tab > Comments group > Show/Hide Comment.

True

To show all comments in a worksheet, click Review tab > Comments group > Show All Comments.

True

To turn track changes on in an Excel sheet, click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).

True

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?

X- Review tab, Y- Changes group