Bissoy.com
Doctors Medicines MCQs Q&A

What is the use of the formula palette in MS-Excel?

What is the use of the formula palette in MS-Excel? Correct Answer Create and edit formulas containing functions

Formula palette is used to create and edit formula.

Steps to use Formula Palette:

  1. Select the cell that will hold the formula.
  2. Click the Edit Formula button (the “=” sign to the left of the Formula bar) to open the Formula Palette.
  3. When the Formula Palette appears, either enter the function name (in our example, “sum”) in the Formula bar, or select it from the list in the upper left corner of the Formula Palette.
  4. When the input fields appear, enter the range in the Number1 field. Note that Excel displays the values from the cells to the right of the field, and the result of the formula at the bottom of the Formula Palette, so you can check your work as you go.
  5. Click OK. Excel enters the formula into the worksheet.

Related Questions

You can use the formula palette to
In the following questions are to be based on the details given below. A salesman visits 274 houses in a town to find out the views about three products X, Y and Z. He found that 157 use X, 98 use only X, 22 use all the three, 14 use X and Z but not Y, 39 use Y and Z, 48 use only Y. How many use product Z only?
Which key is used to obtain properties palette in AutoCAD?
In the following question, select the related word from the given alternatives. Palette : Colours : : Report card : ?
The question below consists of a set of labelled sentences. Out of the four options given, select the most logical order of the sentences to form a coherent paragraph. P: His primary focus were paintings in oil mediums. Q: Vincent van Gogh was a self-taught artist who changed the face of Post-Impressionism forever.  R: Unlike Pablo Picasso's limited colours used, Vincent van Gogh adopted a bright palette and developed a unique style. S: The primary subjects of his paintings were those of landscapes, cityscapes, scenery and figure. 
Which key combination is used to obtain properties palette in AutoCAD?
The _________ Builder is an Access tool for selecting colors from a palette or creating custom colors.
In creating which tin-glazed earthenware, produced from the 15th century, was the painter’s palette usually restricted to five colors?
There is only one runway which will be used by seven flights one by one. P and Q will use the runway neither first nor last. S will use it second after R. M will use it second before O. N will use it after O and before R. Q will use it just before S. Who will use the runway third after O?
Persons who use fans are 40% more than those who use coolers and people who use coolers are twice as much as people who use ACs. By how much percentage are the people who use the fans more than those who use ACs?