Test 9

Add the password to this workbook

Click the file tab on the info page click the protect workbook button and select encrypt with password

Mark the workbook as final

Click the file tab on the info page click the protect workbook button and select mark is final

This workbook will be used by people with XL 2003 only save it in the best format for those users allow compaitavly issues

Click the file tab. Click save as. On the save as page click the save as type arrow and select XL 97-2003 workbook click save as click continue

Display the accessibility checker task pain

Click the review tab click the check accessibility button

Save this workbook as an excel template

File, Save As, Drop down, Excel template

Apply data validation rules to the selected cells to allow only decimal numbers between 2.5 and 4.0. Do not allow blanks.

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data Validation menu, you clicked the Data Validation... menu item. Inside the Data Validation dialog in the Allow drop-down, you selected Decimal. Inside the Data Validation dialog, you typed 2.5 in the Minimum: input, clicked the DialogHeader view, clicked the dialog undefined button, clicked the DialogHeader view, clicked the dialog undefined button, typed 4.0 in the Maximum: input, unchecked the Ignore blank check box, and clicked the OK button.

In cells D2:D20, use data validation to display an in-cell drop-down list of values from the Days named range. Do not allow blanks.

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data Validation menu, you clicked the Data Validation... menu item. Inside the Data Validation dialog in the Allow drop-down, you selected List. Inside the Data Validation dialog, you typed =Days in the Source: input, unchecked the Ignore blank check box, and clicked the OK button.

Add GPA must be between 2.5 and 4. as an error alert to the validation rules for the selected cells. Do not include a title.

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data Validation menu, you clicked the Data Validation... menu item. You clicked the Error Alert tab. Inside the Data Validation dialog, you typed GPA must be between 2.5 and 4. in the Error message: input, clicked the OK button.

This worksheet is linked to an Access database. Update the worksheet data.

In the Design Ribbon Tab in the External Table Data Ribbon Group, you clicked the Refresh button arrow. Inside the Queries & Connections dialog from the 0 query list, you clicked the Class Schedule Refresh Icon item.

Unlock the cells be 3D8 so the user can edit the sales when the worksheet is protected

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you clicked the Lock Cell menu item.

Remove workbook protection so users can add new worksheets.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Protect Workbook button.

Remove worksheet protection from the Direct Mail worksheet.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Unprotect Sheet button.

Add a hyperlink from the selected cell to link to cell B4 in the Social Media worksheet. Don't forget the use B4 as the cell reference

In the insert ribbon tab in the links ribbon group you clicked the link button. Inside the insert hyperlink dialogue from the link to list you click the place in the document item. Inside the insert hyperlink dialogue from the or select a place in this document list from the cell reference list you select social media inside the insert hyperlink dialog you typed before in the type cell reference input click the OK button

Modify this workbook so users cannot change worksheet names

In the review ribbon tab and the changes ribbon group you click the protector workbook button inside the protect structure and windows dialogue you click the OK button

7) Use Consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets Bob, Cathy, and Mario. Include links to the source data to display subtotals.

On the Data tab, in the Data Tools group, click the Consolidate button. Click in the Reference box and then click the Bob worksheet tab. Click and drag to select B3:D8. Click the Add button. Click the Cathy worksheet tab. Click Add. Click the Mario worksheet tab. Click Add. Click the Create links to source data check box. Click OK.

Use Consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets Uptown, Downtown, and City Center. Do not include links to the source data.

On the Data tab, in the Data Tools group, click the Consolidate button. Click in the Reference box and then click the Uptown worksheet tab. Click and drag to select B3:D8. Click the Add button. Click the Downtown worksheet tab. Click Add. Click the City Center worksheet tab. Click Add. Click OK.

Protect this worksheet so users can select but not edit locked cells. Users should be able to select and edit any cells that are unlocked.

On the Review tab, in the Changes group, click the Protect Sheet button. Click OK.

Add Enter the dollar amount. as an input message to the validation rules for the selected cells. Do not include a title.

On the data tab, in the Data Tools group, click the Data Validation button. Click the Input Message tab. Type: Enter the dollar amount. Click OK.

Remove the hyperlink from cell B3

You click cell B3 right click cell B3. In the right click menu you click the delete menu item. Inside the delete dialogue you click the close button. In the insert ribbon tab in the links ribbon group you click the link button. Inside the inter-hyperlink dialogue from the link to list list you click the place in this document item. Inside the insert hyperlink dialogue you click the cancel button. You right click selfie three. In the right click menu you click the remove hyperlinks menu item

Check if this workbook contains elements that are not compatible with earlier versions of Excel. Close the Compatibility Checker without making any changes

You clicked the OK button in the Microsoft Excel - Compatibility Checker dialog.

Display all the comments in this worksheet at once.

You clicked the Show All Comments button in the Excel ribbon.

Run the document inspector and remove any issues found

You open the backstage view click the check for issues buttons. And the project workbook menu click the inspect document menu item. Inside the Microsoft excel dialog, you clicked the yes dialog. Inside the document inspector dialogue you click the reinspect button click the remove all document properties and personal information button click the remove all comments annotations button and click the close button

This worksheet has validation rules applied. Find and circle cells that violate those rules.

You selected the Circle Invalid data menu item in the Excel ribbon.