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

Get all objective type questions of Microsoft Excel MCQ

You can do it yup
  1. Multiple calculations can be made in a single formula using .......
  2. Which command will you choose to convert a column of data into row?
  3. Which of the following is not an example of a value?
  4. Which of the following is not true about Find and Replace in Excel
  5. Which of the following is the oldest spreadsheet package?
  6. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  7. Which of the following Excel screen components can NOT be turned on or off?
  8. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  9. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  10. You can edit a cell by
  11. A numeric value can be treated as label value if ...... precedes it.
  12. Excel displays the current cell address in the ........
  13. Which is used to perform what if analysis?
  14. When you want to insert a blank imbedded excel object in a word document you can
  15. To copy cell contents using drag and drop press the
  16. The Name box on to the left of formula bar
  17. Which of the following methods cannot be used to enter data in a cell
  18. Which of the following is invalid statement?
  19. Which of the following is not true regarding Conditional Formatting?
  20. Excel files have a default extension of
  21. How do you insert a row?
  22. Which key do you press to check spelling?
  23. Ctrl + D shortcut key in Excel will
  24. Long text can be broken down into many lines within a cell. You can do this through
  25. You can check the conditions against __________ when applying conditional formatting
  26. Comments can be added to cells using
  27. Concatenation of text can be done using
  28. Which of the following action removes a sheet from workbook?
  29. Which of the following options is not located in the Page Setup dialog box?
  30. Which of the following series type is not valid for Fill Series dialog box?