MS EXCEL MCQ Quiz - Multiple Choice Questions & Answers Page 6

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

1. ROUND()
2. MOD ( )
3. FACT ( )
4. None of the above

52. Which of the following function will return a value of 8?

1. ROUNDUP(8.4999, 0)
2. ROUNDDOWN(8.4999, 0)
3. ROUND(8.4999, 0)
4. Only B and C

53. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use ?

1. Save
2. Save As
3. Both (A) and (B)
4. None of the above

54. What is the correct way to refer the cell A10 on sheet3 from sheet1?

1. sheet3!A10
2. sheet1!A10
3. Sheet3.A10
4. A10

55. The Software which contains rows and columns is called

1. Spreadsheet
2. Word processing
3. Database
4. None of the above

56. It is a collection of data that is stored electronically as a series of records in a table.

1. spreadsheet
2. presentation
3. database
4. MS Word

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

1. Standard Tool Bar
2. Title Bar
3. Formula Bar
4. None of the above

58. Excel displays the current cell address in the

1. Status Bar
2. Name Box
3. Formula bar
4. None of the above

59. Which one is not a Function in MS Excel ?

1. SUM
2. AVG
3. MAX
4. MIN

60. Hyperlinks can be

1. Text
2. Drawing
3. Picture
4. All of the above