What Is The Purpose Of The Document Inspector In Excel

Posted By admin On 19.04.21

Document Inspector In Excel 2016
Excel Document Inspector Warning

One of the feature’s uses is to explain a formula in a cell, especially when other people will use the Excel file. Also, Excel comments can also be used to add reminders or notes for other users, as well as for cross-referencing with other Excel workbooks. However, as developer, I recommend a code that's rather compatible with all versions of Excel instead of making system changes because system changes will be required on each end user's machine as well. Solution 2: VBA Code Code Compatible: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Office 365. The Document Inspector feature in Word, Excel, PowerPoint, or Visio can help you find and remove hidden data and personal information in documents that you plan to share. Hidden information can include: hidden data or personal information that you might not want to share in Word documents. Excel Labels, Values, and Formulas. Labels and values. Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data. The Insert Function dialog box (shown in the following figure) is designed to simplify the task of using functions in your worksheet. The dialog box not only helps you locate the proper function for the task at hand, but also provides information about the arguments that the function takes. Use the Insert Function.

Excel Labels, Values, and Formulas

Labels and values

Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data.

All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values.

Notice also that the labels (composed of letters) are all left justified and the values (composed of numbers) are all right justified in their cells.

Simple Formula:

Click the cell in which you want the answer (result of the formula) to appear. Press Enter once you have typed the formula.

All formulas start with an = sign.

Refer to the cell address instead of the value in the cell e.g. =A2+C2 instead of 45+57. That way, if a value changes in a cell, the answer to the formula changes with it.

+ means add	e.g. A2+C2	Add the value (number) in A2 to the value (number) in C2.
- means subtract	e.g. A2-C2	Subtract the value (number) in C2 from the value (number) in A2.
* means multiply	e.g. A2*4	Multiply the value (number) in A2 by 4.
/ means divide	e.g. A2/3	Divide the value (number) in A2 by 3.

Functions

These formulas are used for working with long lists of numbers. A typical function looks like this:

=SUM(A3:A30)

SUM is a function, meaning that it sums (adds up) the list of numbers.
The list of numbers is indicated in brackets.
The address of the first cell in the list is A3.
A colon : separates this cell address from the last cell in the list, which is A30.

=SUM(B3:B9)

Adds list of values from cell B3 to cell B9

=AVERAGE(B3:B9)

Averages the values from cell B3 to cell B9

Other functions:

There are many functions that you could explore with time. SUM and AVERAGE are two of the most common, below are a few more:

SUM	adds the numbers in the list
AVERAGE	averages the numbers in the list
PRODUCT	Gta sa pc highly compressed. multiplies the numbers in the list
MAX	identifies the highest number in the list
MIN	identifies the lowest number in the list
COUNT	counts the number of numerical items in the list
COUNTA	counts the number of alphabetical items in the list
COUNTIF	counts the number of items that satisfy certain criteria e.g. =COUNTIF(A4:A20,'>50') counts the number of values that are higher than 50 in the list from A4 to A20 - notice the use of the comma and quotation marks to separate the list (A4:A20) from the criteria (>50).

Document Inspector In Excel 2016

Excel Document Inspector Warning