Formulas & functions
1. You can use the formula palette to
A.  Format cells containing numbers B.  Create and edit formula containing functions C.  Enter assumptions data D.  Copy a range of cells
2. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A.  F8 B.  F9 C.  F10 D.  F11
3. Where can you change automatic or manual calculation mode in Excel?
A.  Double CAL indicator on status bar B.  Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button C.  Both of above D.  None of above
4. Concatenation of text can be done using
A.  Apostrophe ( ‘ ) B.  Exclamation ( ! ) C.  Hash ( # ) D.  Ampersand ( & )
5. Which area in an Excel window allows entering values and formulas?
A.  Title Bar B.  Menu Bar C.  Formula Bar D.  Standard Tool Bar
6. Multiple calculations can be made in a single formula using ________
A.  Standard Formulas B.  Array Formula C.  Complex Formulas D.  Smart Formula
7. In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.
A.  AutoFill B.  Auto correct C.  Auto sum D.  Auto format
8. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A.  ROUND ( ) B.  FACT ( ) C.  MOD ( ) D.  DIV ( )
9. Which function is not available in the Consolidate dialog box?
A.  Pmt B.  Average C.  Max D.  Sum
10. Which is not the function of "Edit, Clear" command?
A.  Delete contents B.  Delete notes C.  Delete cells D.  Delete formats