![]() ![]() To enable graphical representation of the data in Excel, charts are provided. By entering a password, you can secure your sheet from getting copied by others. To protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect Sheet > Password. VBA was introduced in Excel 5 and mostly used now.ĩ) Is it possible to prevent someone from copying the cell from your worksheet? Macros can be either written or recorded depending on the user.Ĩ) Which are the two macro languages in MS-Excel? Users can create macros for their customized repetitive functions and instructions. Macros are used for iterating over a group of tasks. You must select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell. It’s defined by the term “PEMDAS” or “BEDMAS”.Ħ) How can you wrap the text within a cell? The order of operations in Microsoft Excel is same as in standard mathematics. Text Formats – Stores data as string of textsĥ) Specify the order of operations used for evaluating formulas in Excel.Percentage – Stores numbers as a percentage.Currency – Stores data in the form of currency.It consists of rows and columns and their intersection called cells.Ĥ) How many data formats are available in Excel? Name some of them.Įleven data formats are available in Microsoft Excel for data Storage. Spreadsheet can be compared to a paper ledger sheet. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |