Managing Workbook Properties — Unit test Answers…

What is required to utilize Excel Online?

local administrative account

product key for Excel

Office 365 user account

compact disc version of Excel

Dante has a worksheet shared with multiple users. He would like the ability to approve or reject changes that are made.Which feature should he use?

Protection

Change Tracking

Comments

Data Consolidation

Which combination of options is the keyboard shortcut to access the Find dialog box and search a worksheet for particular values?

Ctrl+H

Ctrl+R

Ctrl+F

Ctrl+E

Xavier wants to ensure that if he scrolls down through a worksheet that contains numerous rows of data that the initial column headings are not scrolling, making it easier to read the information in the spreadsheet. Which step should Xavier follow?

Hide the column heading rows.

Freeze the column heading rows.

Split the worksheet.

Merge the worksheet.

Liam would like to duplicate the formatting of cells in an easy fashion. Which option should he use?

Format Cells dialog box

Quick Access tool bar

Format Painter

Ribbon

Which key(s) will launch the Spelling Checker dialog box?

Ctrl+H

Where are commonly accessed commands located by default in Excel 2016?

status bar

View tab

search field

Quick Access tool bar

On which tab are the print commands in Excel 2016 accessed?

Home

File (Backstage)

View

Edit

Excel 2016 is primarily what type of program?

word processor

presentations

database management

spreadsheet

Which keyboard shortcut will create a hyperlink in an Excel document?

Ctrl+F

Ctrl+H

Ctrl+K

Ctrl+End

Which characters in the function shown represent the arguments?=MAX(B2:B6,C4,100)

MAX

(B2:B6,C4,100)

( ,

Donte needs to print specific sections in the workbook, as opposed to the entire workbook. Which feature should he use?

Page Setup

Backstage view

Print Area

Option

Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?

The worksheets that are hidden will retain data, but references to those worksheets will no longer function.

The worksheets that are hidden will have their data removed.

The worksheets that are hidden will retain their data, and references will continue to function as normal

You will have to unhide the worksheets to make references function correctly.

Which character will always precede an Excel formula?

Janet is working on a highly confidential company budget spreadsheet, and she needs to prevent anyone, including administrators in the IT department, from being able to open the file and view its contents.What should she do?

Use the Home tab, select Protect Sheet, and enter a password to prevent access to the sheet.

Click the Info tab in the Backstage view, select Protect Workbook, select Encrypt with Password, and enter a password.

Click the Review tab, select Protect Workbook, and enter a password for protecting the sheet.

Click the View tab and customize the view to protect the sheet from unauthorized users.

Which character is used to create an absolute reference to a cell?

( )

Other than the New Sheet button, which method can be used to add an additional worksheet to a workbook?

Backstage view

Format tab

Insert tab

Worksheet context menu

Lisa intends to use the Hide command on a column in her spreadsheet. How are the cells in this column affected by this command?

The data in all of the cells is deleted.

The data in only some of the cells is deleted.

The cells can no longer be referenced in functions or formulas.

The cells can still be referenced in functions or formulas.

Chris is working with other employees on a worksheet. The other employees have made comments, but they are not visible.What should Chris do to ensure that he can see others’ comments?

Select Show All Comments on the Review tab.

Select Show No Comments on the Review tab.

Select Add Comment on the Review tab.

Select Track Changes on the Review tab.

How can Workbook Protection that has been applied to a workbook be removed?

Open the file, enter the password, and then resave the workbook to remove the protection.

Right-click the workbook and select Remove Protection from the menu list.

Select the cells to unprotect, click the Home tab on the ribbon, and select Lock Cells in the Format menu.

Click the Review tab on the ribbon and click Protect Workbook in the Changes group.

Did you find these answers helpful?