Formulas & functions

**1.**You can use the formula palette to

**2.**How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

**3.**Where can you change automatic or manual calculation mode in Excel?

**4.**Concatenation of text can be done using

**5.**Which area in an Excel window allows entering values and formulas?

**6.**Multiple calculations can be made in a single formula using ________

**7.**In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

**8.**To return the remainder after a number is divided by a divisor in EXCEL we use the function?

**9.**Which function is not available in the Consolidate dialog box?

**10.**Which is not the function of "Edit, Clear" command?