|
Tech Kaki Tips and Tricks for Mac OS X, Windows, Linux and office suite software.
|
 Subscribe RSS Feed
Comments Feed
|
I just purchased Word 2011 for office used. When my user open some of the Word document, it keep on pop up the following warning message
Word cannot start the spelling checker.
The spelling checker files may be missing.
Make sure the spelling checker files are
installed or use the Microsoft Office Installer
to install the spelling checker.
Sometimes your Excel formula may return an error message. Before you know how to correct or hide formula errors. The first thing you should know is to understand what each error type means.
Below are few possible error types:-
#Name?
- Means that you entered something in your formula that Excel interprets as an incorrect reference cell, range or function name.
#REF!
#Value!
#DIV/0
#NUM!
In Excel there are two types of cell references, these are Relative and Absolute.
An absolute cell reference consists of the column letter and row number surrounded by dollar signs ( $ ).
A relative cell reference consists of the column letter and row number that intersect at the cell’s location . Relative ranges do not use the $ character.
The $ character indicates to Excel that it should not increment the column and/or row reference as you fill a range with a formula or as you copy a range.
In summary, most cell references in a spreadsheet are relative cell references, which change when copied and pasted to other cells.Whereby absolute cell reference does not change when it a formula is copied and pasted to other cells. (more…)
