Microsoft Excel MCQs

1 The maximum number of predefined margin options available in MS Excel are:

2 What is a group of cells called in Excel?

3 Another name for a pre-programmed formula in Excel is:

4 How do you display the current date and time in MS Excel?

5 Which shortcut key is used to create a chart in MS Excel?

6 What is the use of a horizontal Scroll Bar in MS Excel?

7 Which of the following is not a valid data type in Excel?

8 Which shortcut key is used for AutoSum in MS Excel?

9 Which shortcut key is suitable for reaching the last row of a data region in MS Excel?

10 Which of the following is the last column in MS Excel 2016?

11 In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

12 What are the small squares arranged in rows and columns called in Excel?

13 What is the maximum zoom percentage in MS Excel?

14 What is the default file name in MS Excel?

15 To insert a chart in MS Excel, which shortcut key is used?

16 What is the function of the VLOOKUP function in Excel?

17 What is the function of the IF function in Excel?

18 What is the function of the SUM function in Excel?

19 Title bar in MS Excel displays the name of the:

20 In Excel, columns are labelled as:

21 User-developed instructions for Excel are called:

22 What displays the content of the active cell in MS Excel?

23 In a computer spreadsheet, a block of cells is called:

24 Microsoft Excel 2019 files have a default extension of:

25 Which of the following is the latest standalone version of MS Excel?

26 In MS Excel, Conditional Formatting is in which tab?

27 You can set a page border in Excel from:

28 Excel displays the current cell address in the:

29 The first cell in an Excel worksheet is labelled as:

30 An Excel workbook is a collection of:

31 Which key combination is used in MS Excel to insert the current time in a workbook?

32 Getting data from a cell located in a different sheet is called:

33 You can edit existing Excel data by pressing the:

34 Which function displays row data into a column or column data into a row?

35 Which shortcut key moves to the next sheet in MS Excel?

36 Which of these keys are used in MS Excel to copy a formula from the above cell?

37 Which key is used for Help in MS Excel?

38 With which of the following do all formulas in Excel start?

39 A comment put on an Excel cell which is displayed by taking the mouse pointer there is called:

40 How many columns are in one Microsoft Excel sheet?

41 If you press ___, the cell accepts your typing as its contents?

42 In a computer spreadsheet, rows are labeled:

43 A computer spreadsheet cell that is highlighted with a heavy border is a:

44 Main window in a computer spreadsheet is called:

45 In a computer spreadsheet, cell range A3 through G3 should be keyed in as:

46 In a computer spreadsheet, each cell can contain a:

47 In Microsoft Word, Superscript, Subscript, Outline, Emboss and Engrave are known as:

48 What is an Excel Worksheet?

49 Which function is used to calculate the average in a range of cells?

50 What does the Freeze Panes feature do?

Study Mode