Formatting

One of the number cells in your worksheet shows as ###. What does this mean?

• The content in the cell is wider than the cell width.

• The cell is empty in a row of cells filled with content.

• There is a division-by-zero error in the cell contents calculation.

• The number you entered in the cell is larger than 1,000.

You want to change the columns in the worksheet shown below to the best fit for the data. What is the fastest way to accomplish this?

• Highlight the cells with data then double-click.

• Highlight columns A-E then use the Format option in the ribbon.

• Highlight the entire worksheet then double-click the boundary between any two columns.

• Highlight the entire worksheet then right-click to set the width.

How can you quickly add a border around a set of cells covering 3 rows and 12 columns?

• Highlight the cells, right-click, and then select Border.

• Use Draw Border Grid under Border on the ribbon under Home.

• Use Draw Border under Border on the ribbon under Home.

• Highlight the cells, double-click, select Format Cells, and then Border.

The worksheet shown below tracks badge numbers assigned to a company with 5,000 employees. How would you quickly find who is assigned a specific badge number?

• Use the Find tool, enter the badge number, and check the box next to Match Case.

• Use the Find tool, enter the badge number, and leave all boxes unchecked.

• Use the Find tool, enter the badge number, and check the box next to Match Case and Match Entire Cell Contents.

• Use the Find tool, enter the badge number, and check the box next to Match Entire Cell Contents.

In the worksheet shown below, you want to move the ID before the employee name. What is the fastest way to move this data?

• Click B to highlight the column and then left-click and hold to drag the data in front of the Employee column.

• Click B to highlight the column then hold the Shift key down and drag the column in front of the Employee column.

• Click A and right-click to insert a column. Click B and right-click and select Cut then Paste the data into the new column.

• Click B to highlight the column then hold the Ctrl key down and drag the column in front of the Employee column.

You have a worksheet with multiple hidden columns and you need to view all of the data that is hidden. What is the best way to unhide the columns?

• Select the entire worksheet and double-click any column boundary.

• Double-click the column boundary for each hidden column.

• Select the entire worksheet, then click Tools in the ribbon and select Unhide.

• Right-click the column to the right of each hidden column and select Unhide.

Your worksheet includes data for your company's IT department. How can you use Find and Select to quickly capitalize the many instances of IT appearing in the worksheet?

• Drag the capitalized version over each uncapitalized version.

• Use the Match case option under Replace.

• Use the Match entire cell contents option under Find.

• Use the Match entire cell contents option under Replace.

You want to view how your worksheet will print and make edits to the worksheet in this mode. What is the easiest way to accomplish this?

• Click Page layout on the bottom of the page in the status bar.

• Click Page layout on the top of the page in the ribbon.

• Click Print and then Print Preview on the top of the page.

• Click Design on the top of the page.

How would you most efficiently test a layout adjustment before printing on paper?

• Measure and count the cells.

• Use Print Preview as a trial and error.

• Calculate the required page area.

• Adjust the font size to be displayed.