Tech Tip: Create a Word text box/Exclude zero values in Excel/Use the Access crosstab query

Learn how to create a text box from existing text, compute an average that excludes zero values, and get quick answers with a crosstab query.

Create a text box from existing text

People often use text boxes to highlight a specific part of their document. But when you want to use a text box, there's no need to retype the text.

1. Copy the text you want to include in the text box to the location where you want to insert the text box.
2. Select the copied text and go to Insert | Text Box.

Word inserts a text box displayed with a crosshatch border and eight handles around the selected text, so you can resize or move it within the document. Any remaining document text automatically wraps around it.

The selected text retains the format of the original. As with any text box, you can reformat the text by selecting it, right-clicking the selection, and choosing Font.

Compute an average that excludes zero values

While Excel's AVERAGE function ignores blank cells, it doesn't ignore cells that contain 0. This can result in inaccurate analysis of the data.

For example, let's say you want to calculate the average score for all students who took the final exam. Using the AVERAGE function, you might enter: =AVERAGE(B3:B23).

But if two students were absent and received a grade of 0, the result of the formula wouldn't give a true picture of the average grade. However, you can calculate the average and exclude the absentee students' grades.

1. Enter the following formula: =AVERAGE(IF(B3:B23<>0,B3:B23))
2. Press [Ctrl][Shift][Enter].

The entered formula first creates an array that includes only nonzero values in the range. The AVERAGE function then uses this array as its argument.

Get quick answers with a crosstab query

When you need quick answers to everyday business questions, let Access' Crosstab Query Wizard help. For example, say you need to know the average number of hours each employee works per week. To find the answer, you need to analyze the data in the Hours Worked table, which contains three fields: EmployeeID, Week Ending, and Hours.