INFO (Information): What is INFO in MS-Excel? The Microsoft Excel INFO function returns information about the operating environment. The INFO function is a built-in function in Excel that is categorized as an Information Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INFO function can be entered as part of a formula in a cell of a worksheet. I can say, the INFO is a key tool in MS-Excel Workbook because with INFO can cover a lot of important functions like: by using Encrypt with Password; can make a password protection to require a password when it open, Protect Workbook Structure; can be protected Workbook from stealing or editing and adding something new or saving Workbook for another copy in a different name that you already have entered and saved data, by using Protect Current Sheet; can control the type of changes others can make in the current sheet, by using Check Accessibility; is able to check the Workbook for content that people with disabilities might find difficulty to read, by using Add a Digital Signature; can add invisible digital signature to ensure the integrity of your Workbook, By using Mark as Final; is able to let readers know that the Workbook is final and make it read only and by using Manage Workbook; can recover or delete unsaved Workbook in the MS-Excel. Let me give an example for protecting the Workbook. How can you protect the Workbook with password encryption? Click File Tab=> Select Info => Click Protect Workbook Icon => Click Encrypt with Password =>Type your password in “Password” box (Ex: - “MS-Excel”) and then Click OK => Re-enter Password in the “Re-enter Password” Box and Click OK. New: (Ctrl+N) In MS-Excel, New tool is to create a new Workbook that probably uses for same or different type of work that you have, Workbook may be needed to create to enter same or different type of data. Once you clicked New tool that there are available a variety of Workbook types, so by clicking one of the Workbook that you can see from the list (Blank Workbook, Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, Time Card) to be created a new Workbook and it’s completely upon your data type that you are having at present. How to create a new blank Workbook while you are working in an opened Workbook? Click File menu => Click New menu => Click Blank Workbook. For more understanding, look at the screenshot below please: Open: (Ctrl+O) Open tool is to open a saved Workbook from this PC or from different places such as Cloud-Drive, Shared network computer and browse (from anywhere). The Open tool is interesting tool to use nowadays because when people try to open a saved Workbook from their PC or any other sources such as internet, that there are a lot of different paths to open it. Open tool is not an inserting tool because when user use this tool to open a Workbook that it is already have saved, it won’t open into the same Workbook as copy and paste. So, when the user is using this tool must understand about it real functional. I’m giving an example for open a Workbook that it is already saved in my PC. How to open a saved Workbook from your pc, while you are working in an active Workbook? Click File menu => Click Open menu => Click Browse icon => Select your location in the appeared dialog box and then Select your file name (example: “MS-Excel”) => Click Open button. For more understanding, look at the screenshot please:
0 Comments
|
Archives |