Name Box is used to return to a particular area of the worksheet by typing the range name or cell address in the name box. To add a new Excel worksheet, you should insert worksheet tab at the bottom of the screen.ġ5) What is the use of NameBox in MS-Excel? ![]() Hover the mouse over it, and you can read the full comment.ġ4) How can you add a new Excel worksheet? The red triangle indicates that some comment is associated with the cell. Date and Time functions – NOW(), DATEVALUE(), WEEKDAY(NOW())ġ3) What does a red triangle at the top right of a cell indicate?.Logical Functions – IF, AND, FALSE, TRUE.Math and Financial Functions – SQRT, DEGREE, RAND(), GCD.by selecting an option from Insert tab’s Chart group.ġ1) How can you sum up the Rows and Column number quickly in the Excel sheet?īy using SUM function, you can get the total sum of the rows and columns, in an Excel worksheet.ġ2) Explain few useful functions in Excel.įollowing are the functions available in Excel for manipulating the data: A user can use any chart type, including column, bar, line, pie, scatter, etc. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |