Home

Which of the following option is not available in Paste Special dialog box?

A. Add

B. Subtract

C. Divide

D. SQRT

Correct Answer : D.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

You can do it
  1. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  2. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  3. In Excel, a Data Series is defined as what?
  4. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  5. Where can you change automatic or manual calculation mode in Excel?
  6. What is represented by the small, black square in the lower-right corner of an active cell or range?
  7. What are the tabs that appear at the bottom of each workbook called?
  8. Which of the following methods cannot be used to enter data in a cell
  9. The Delete key of keyboard is assigned to which command in Excel?
  10. Files created with Lotus 1-2-3 have an extension
  11. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  12. Which elements of worksheet can be protected from accidental modification
  13. The auto calculate feature
  14. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  15. While Finding and Replacing some data in Excel, which of the following statement is valid?
  16. To save a workbook, you:
  17. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  18. A worksheet range is a
  19. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  20. What is the short cut key to highlight the entire column?
  21. Ctrl + D shortcut key in Excel will
  22. Which of the following is the oldest spreadsheet package?
  23. You can select a single range of cells by
  24. Comments can be added to cells using
  25. You can enter which types of data into worksheet cells?
  26. Which of the following is not a term of MS-Excel?
  27. An excel workbook is a collection of
  28. How do you display current date and time in MS Excel?
  29. The Chart wizard term data categories refers to;
  30. To return the remainder after a number is divided by a divisor in EXCEL we use the function?