Standard Formulas

Array Formula

Complex Formulas

Smart Formula

**Which button do you click to add up a series of numbers?****Ctrl + D shortcut key in Excel will****Which elements of a worksheet can be protected from accidental modification?****You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…****How do you display current date only in MS Excel?****The autofill feature****The first cell in EXCEL worksheet is labeled as****Comments put in cells are called .....****The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…****Which of the following is not true regarding Conditional Formatting?****Which of the following formulas will Excel Not be able to calculate?****How do you insert a row?****Which is not the function of Edit, Clear command?****You can use the horizontal and vertical scroll bars to****Which would you choose to create a bar diagram?****To view a cell comment****If you need to remove only the formatting done in a range (numbers and formula typed there should not…****Status indicators are located on the****When the formula bar is active, you can see****You can move a sheet from one workbook into new book by****Comments can be added to cells using****The Paste Special command lets you copy and paste:****A numeric value can be treated as label value if ...... precedes it.****Rounding errors can occur****You cannot link excel worksheet data to a word document****Which of the following is a popular DOS based spreadsheet package?****You can use the drag and drop method to****When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply****How many characters can be typed in a single cell in Excel?****How do you display current date and time in MS Excel?**