Home

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

A. Custom List

B. Auto Fill Options

C. Fill Across Worksheet

D. Fill Series

You can do it
  1. You can copy data or formulas
  2. You can check the conditions against __________ when applying conditional formatting
  3. Hyperlinks can be
  4. It is acceptable to let long text flow into adjacent cells on a worksheet when
  5. Which of the following is a correct order of precedence in formula calculation?
  6. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  7. Which symbol must all formula begin with?
  8. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  9. How do you display current date only in MS Excel?
  10. Long text can be broken down into many lines within a cell. You can do this through
  11. Rounding errors can occur
  12. You can enter which types of data into worksheet cells?
  13. Which elements of a worksheet can be protected from accidental modification?
  14. You can use the horizontal and vertical scroll bars to
  15. To remove the content of selected cells you must issue ______ command
  16. Getting data from a cell located in a different sheet is called ......
  17. How do you rearrange the data in ascending or descending order?
  18. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  19. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  20. When a row of data is to be converted into columns
  21. Which of the following is the oldest spreadsheet package?
  22. How do you select an entire column?
  23. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  24. You can select a single range of cells by
  25. It is acceptable to let long text flow into adjacent cells on a worksheet when
  26. Which of the following is not a way to complete a cell entry?
  27. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  28. In Excel, a Data Series is defined as what?
  29. What do you mean by a Workspace?
  30. Right clicking something in Excel: