MS EXCEL Interview Questions

1.  Which function in Excel helps in finding out how many numerical entries are there?

Count 

2. A feature that displays data on a column according to specific criteria?

Filter 

4. Which data type will be placed on the left comer side of the cell?

Text - left,  number - right,  error-free middle 

5. Which data type will be placed on the right corner side of the cell?

Right - numeric 

 

7.What is the name of the intersection of a column and a row on worksheet?

 Cell

8.What type of chart is useful in comparing values versus categories?

column chart 

9. What function displays row data in a column or column data in a row?

Transpose

10. How are data organized in Excel spreadsheet?

        a) Rows and Columns

12. A function inside another function is called?

a) Nested Function

13. Which of the following functions cannot be used to edit the content of a cell?

b) Pressing Ese key

14. To copy cell contents using drag and drop. press the

Ctrl key

15. What is the use of AUTOFILL feature?

AutoFill feature of Excel is a great time saver. This command can automatically extend the sequence, adds range of cell values, applies a boarder around the selected cells

16. Which is used to filter Dates by Years, Months, Quarters and Days?

Timeline

19. An Excel workbook is a collection of?

d) Worksheets and Charts

20. Excel files have a default extension of?

Xlsx

21. How can we use format painter multiple times before 

Double-click the format painter

22. Why Excel file is called as worksheet?

I contains many sheets including worksheets and charts

23. Which of the following is not the valid data type in Excel?

Character

24. Which of the following methods cannot be used to edit the content in a cell?

a) Pressing Alt Key

25. You can select a single range of cells by

d) Dragging over the corresponding cells

26. What does a right-clicking on a cell in Excel do?

a) Opens a short menu with some options

27. Comments can be added to the cells using

Insert Comments

28.When you copy a formula

 Excel edits cell references in newly copied formula

29. Which formula is referred to as Absolute cell reference?

$A$1

30.

31. The Greater than sign(>) is an example of which operator?

Logical

32. B

33. D

34. Which of the following is not an example value?

a) 350

 b) Jan 10, 2021

c) 0.5

d) Serial Number 1021

35. Getting data from a cell

a) Referencing

36. What is the purpose of Tab Scrolling button

Allows viewing additional sheets tabs

37. Concatenation of a string can be done.  

&

38. Data can be arranged in Excel worksheet using?

Auto Formatting

Applying Styles

Changing fonts

39. The Auto Calculate feature

 Provides a quick way to view the Arithmetic operation result on a range of cells

40. Which feature in Excel quickly completes a series of data?

 Auto Fill

41.The process of arranging the items of the column in some sequence is known as?

 Sorting

42_43

44.What type of chart is good for a single series of data?

 Bar Chart

45.How many sheets are there, by default when we create a new Excel file?

3

46. 47

48.Which chart type is best for comparing sales between two products?

Column Chart or bar chart

49.What dialog box allows you to change the field name in Pivot Table?

Field Settings

50. Merge cells option can be applied from?

Format Cells dialog box Alignment Tab

51.When you insert an Excel file into a Word document, the data are

 Linked

52. You can set page border in Excel from

Not possible to set page border

53. Which of the following format you can decide to apply or not in Auto Format dialog box?

a) Number format

b) Border format

c) Font format.

d) All the Above

54. Which of the following option can check the conditions against when applying conditional formatting?

a) Cell value

b) Formula

c) Both A and B

55. You can use the formula palette to

 Create and edit formula containing functions

56.How to join some cells and place the content at the middle of the joined cell?

From Format Cells dialog box click on Merge Cells check box

57. Tab scroll buttons are placed on Excel screen

towards the top left corner.

58. The Name boxes on to the left of the formula bar

 Shows the name of cell or range currently working on

59.  Which of the following cannot be a sheet in workbook?

a) Work Sheet

b) Data Sheet

c) Macro Sheet

d) Chart Sheet

60.How can you update the values of formula cells if Auto Calculate mode of Excel is

disabled?

a) F8.

b) F9

c) F10

d) Fil

F9 is used to update the values of formula cells. Explanation: F8 mode turns on / off the extent mode.

61. Which of the following Excel screen components can NOT be turned on or off?

a) Formula Bar

b) Status Bar

c) Tool Bar

d) None of Above

hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.

62. What happens when you press Ctrl + X after selecting some cells in Excel?

a) It will disappear

b) Marked for Cutting

e) Cells are Deleted and shifted left

d) Cells are deleted and shifted up

63. Which of the following option is not available in Paste Special dialog box?

a) ADD

b) SQRT

c) SUBTRACT

d) DIVIDE

64. Which command will you choose to convert a column of data into row?

a) Cut and Paste

b) Paste  special  > Transpose

c) Paste Special > Reverse

d) None of Above

65. Which of the cell pointer indicate that you can move the content to another cell?

a) Big Plus icon or doctor symbol 

b) Small Plus icon

c) Mouse Pointer with Anchor at the tip

d) None of Above

66.Long text can be broken down into many lines within a cell. You can do this through uron

a) Wrap Text Format > Cells

b) Justify in Edit > Cells

c) Text Wrapping in Format > Cells

d) All the above

67. Excel provides the default value in step in Fill Series dialog box

a) 0

b) 1

c) 2

d) 5

68. Which chart type is best for comparing sales between two products?

a) Column Chart

b) Pie Chart

c) Line Chart

d) None of the Above

69. The Shortcut key Ctrl + D is used in Excel to

a) Open the font dialog box

b) Apply double underline for the active cell

c) Fill down in the election

d) None of Above

70. The shortcut key Ctrl+ R is used in Excel to

a) Right align the content of cell

b) Remove the cell contents of selected cells

c) Fill the selection with active cells to the right

d) None of the Above