Plus how to use Excel calculation operators.
This article appears in the November 06 issue of PC Advisor, onsale now in all good newsagents.
Password-protect Office documents
You can assign a password to any Office document when you save it. In Excel, Word and PowerPoint, click on Tools, Options and Security to set a password. You can choose to add a password, to prevent anyone from opening or modifying the document.
Excel calculation operators
Excel evaluates all operations within a formula using a strict left-to-right order of precedence, unless you use brackets to interrupt this order. If you want a refresher on this order, press F1 within Excel to access the help files and search for calculation operators. Then click on the About Calculation Operators link.