57 Microsoft Excel Questions and Answers

excel questions

Try Microsoft Excel Questions and Answers

Test your Excel skills!

1. What is the name of the program that allows you to create and edit spreadsheets?

Answer: Microsoft Excel

2. What is the name of the rectangular grid of cells used in Excel?

Answer: Worksheet

3. How do you enter data into a cell?

Answer: By clicking on the cell and typing in the data

4. What is the name of the column that appears on the left side of the worksheet and is used to identify individual rows?

Answer: Row heading

5. What is the name of the row that appears at the top of the worksheet and is used to identify individual columns?

Answer: Column heading

6. What is the shortcut key to insert a new row in Excel?

Answer: Ctrl + Shift + +

7. What is the shortcut key to insert a new column in Excel?

Answer: Ctrl + +

8. What is the shortcut key to delete a selected row in Excel?

Answer: Ctrl + –

9. What is the shortcut key to delete a selected column in Excel?

Answer: Ctrl + Shift + –

TRY OUT: MICROSOFT WORD REVISION QUESTIONS

10. What is the shortcut key to rename a worksheet tab in Excel?

Answer: Right-click on the tab and select Rename

11. How do you format a cell or range of cells in Excel?

Answer: By selecting the cell or range of cells and then going to the Home tab and using the formatting tools

12. How do you sort data in Excel?

Answer: By selecting the data to be sorted and then going to the Data tab and using the Sort option

13. How do you filter data in Excel?

Answer: By selecting the data to be filtered and then going to the Data tab and using the Filter option

14. How do you use conditional formatting in Excel?

Answer: By selecting the data to be formatted and then going to the Home tab and using the Conditional Formatting option

15. How do you insert a new worksheet in Excel?

Answer: Right-click on the worksheet tab, or go to Home > Insert > Insert Worksheet.

16. How do you hide a row in Excel?

Answer: Right-click on the row number and select “Hide”

17. How do you make a cell bold in Excel?

Answer: Select the cell, then press Ctrl + B

18. How do you merge cells in Excel?

Answer: Select the cells you want to merge, then go to Home > Merge & Center.

19. How do you change the font size in Excel?

Answer: Select the cells, then go to Home > Font Size.

20. How do you align text in a cell in Excel?

Answer: Select the cell, then go to Home > Align Text Left, Center, or Right.

21. How do you add a border to a cell in Excel?

Answer: Select the cell, then go to Home > Borders.

22. How do you freeze a row or column in Excel?

Answer: To freeze a row or column in Excel, go to the View tab and select Freeze Panes, then choose the appropriate option (Freeze Top Row or Freeze First Column).

23. How do you create a chart in Excel?

Answer: To create a chart in Excel, select the data you want to include in the chart and then go to the Insert tab and select the type of chart you want to create (e.g. column chart, line chart, etc.).

24. How do you create a pivot table in Excel?

Answer: To create a pivot table in Excel, select the data you want to include in the pivot table and then go to the Insert tab and select PivotTable.

25. What is the function of the SUM function in Excel?

Answer: To add up the values in a range of cells

26. How do you use the AutoSum function in Excel?

By selecting the cells to be summed and then going to the Home tab and using the AutoSum option.

27. What is the function of the AVERAGE function in Excel?

Answer: To calculate the average of a range of cells

28. What is the function of the COUNT function in Excel?

Answer: To count the number of cells that contain numbers in a range

29. What is the function of the MAX function in Excel?

Answer: To find the largest value in a range of cells

30. What is the function of the MIN function in Excel?

Answer: To find the smallest value in a range of cells

31. What is the function of the IF function in Excel?

Answer: To test a condition and return one value if the condition is met and another value if the condition is not met

32. What is the function of the VLOOKUP function in Excel?

Answer: To look up and retrieve a value from a table based on a given lookup value

33. What is the function of the INDEX and MATCH function in Excel?

Answer: To look up and retrieve a value from a table based on a given lookup value

34. How do you use the IF function in Excel?

Answer: The IF function in Excel is used to test a condition and return one value if the condition is true and another value if the condition is false. The syntax for the IF function is =IF(condition, value if true, value if false).

35. Illustrate how to use the VLOOKUP function in Excel?

Answer: The VLOOKUP function in Excel is used to look up a value in a table and return a corresponding value from a specified column. The syntax for the VLOOKUP function is =VLOOKUP(lookup value, table range, column number, [exact match]).

36. How do you use the LEFT function in Excel?

Answer: The LEFT function in Excel is used to extract a specified number of characters from the beginning of a text string. The syntax for the LEFT function is =LEFT(text, number of characters).

37. How do you use the RIGHT function in Excel?

Answer: The RIGHT function in Excel is used to extract a specified number of characters from the end of a text string. The syntax for the RIGHT function is =RIGHT(text, number of characters).

38. How do you use the LEN function in Excel?

Answer: The LEN function in Excel is used to find the number of characters in a text string. The

39. What is the keyboard shortcut for the AutoSum function in Excel?

Answer: Alt + =

40. How do you use the AND function in Excel?

Answer: =AND(logical1, logical2, …)

41. How do you use the OR function in Excel?

Answer: =OR(logical1, logical2, …)

42. How do you use the NOT function in Excel?

Answer: =NOT(logical)

43. How do you use the CONCATENATE function in Excel?

Answer: =CONCATENATE(text1, text2, …)

44. How do you use the TRIM function in Excel?

Answer: =TRIM(text)

45. How do you use the SUBSTITUTE function in Excel?

Answer: =SUBSTITUTE(text, old_text, new_text)

46. How do you use the MID function in Excel?

Answer: =MID(text, start_num, num_chars)

47. How do you use the FIND function in Excel?

Answer: =FIND(find_text, within_text, start_num)

48. How do you use the IFERROR function in Excel?

Answer: =IFERROR(value, value_if_error)

49. How do you use the ROUND function in Excel?

Answer: =ROUND(number, num_digits)

50. How do you use the ROUNDUP function in Excel?

Answer: =ROUNDUP(number, num_digits)

51. How do you use the ROUNDDOWN function in Excel?

Answer: =ROUNDDOWN(number, num_digits)

52. How do you use the INT function in Excel?

Answer: =INT(number)

53. How do you use the MOD function in Excel?

Answer: =MOD(number, divisor)

54. How do you use the POWER function in Excel?

Answer: =POWER(number, power)

55. How do you use the ABS function in Excel?

Answer: =ABS(number)

56. How do you use the SUMPRODUCT function in Excel?

Answer: =SUMPRODUCT(array1, array2, …)

57. State four applications for MS Excel.

Answer: a) Accounting

b) Finance analysis

c) Data entry

d) Task management

Spread the love