MS EXCEL Questions and Answers | Online Quiz for Practice

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

1. Pmt
2. Average
3. Max
4. Sum

47. Which of the following methods will not enter data in a cell?

1. Pressing the Esc key
2. Pressing an arrow key
3. Pressing the tab key
4. Clicking the enter button to the formula bar

48. Getting data from a cell located in a different sheet is called

1. Referencing
2. Accessing
3. Functioning
4. None of the above

49. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

1. Re-format the spreadsheet
2. Insert a row
3. Increase the column width
4. Use the spacebar

50. Text formula:

1. Replace cell references
2. Return ASCII value of chracters
3. Concatenate and manipulate text
4. None of the above

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