Home

To create a formula, you first:

A. Select the cell you want to place the formula into

B. Type the equals sign (=) to tell Excel that youre about to enter a formula

C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D. Choose the new command from the file menu

Correct Answer : B.


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. Which of the following is not a worksheet design criterion?
  2. Which is used to perform what if analysis?
  3. To record a sequence of keystrokes and mouse actions to play back later we use:
  4. To copy cell contents using drag and drop press the
  5. Which of the following methods can not be used to edit the contents of a cell?
  6. The auto calculate feature
  7. Which of the following options is not located in the Page Setup dialog box?
  8. Which elements of worksheet can be protected from accidental modification
  9. How do you display current date only in MS Excel?
  10. An excel workbook is a collection of
  11. How can you remove borders applied in cells?ACC
  12. While Finding and Replacing some data in Excel, which of the following statement is valid?
  13. It is acceptable to let long text flow into adjacent cells on a worksheet when
  14. Which of the following methods cannot be used to enter data in a cell
  15. Which tool you will use to join some cells and place the content at the middle of joined cell?
  16. What is the short cut key to highlight the entire column?
  17. Excel files have a default extension of
  18. Comments put in cells are called .....
  19. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  20. Which of the following is not a basic step in creating a worksheet?
  21. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  22. Which of the cell pointer indicates that you can fill series?
  23. Which of the following is an absolute cell reference?
  24. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  25. Which symbol must all formula begin with?
  26. What is represented by the small, black square in the lower-right corner of an active cell or range?
  27. A numeric value can be treated as label value if ...... precedes it.
  28. How can you find specific information in a list?
  29. Which of the following is not the correct method of editing the cell content?
  30. How can you show or hide the gridlines in Excel Worksheet?