Excel MCQ Questions:Test Excel Knowledge with Best 100 MCQ

Welcome to your learningsector21 : Excel MCQ Part - 2

Which keyboard shortcut is used to select non-adjacent cells or ranges in Excel?

d) Alt+Click

c) Ctrl+Shift+Click

b) Shift+Click

a) Ctrl+Click

Which function in Excel is used to calculate the sum of a range of cells, excluding specified criteria?

d) SUMIF

a) SUMIFS

c) AVERAGEIFS

b) COUNTIFS

Which Excel feature is used to calculate the present value of an investment?

c) NPV

d) IRR

b) FV

a) PV

Which Excel function is used to calculate the largest value in a range of cells?

b) MIN

d) AVG

a) MAX

c) SUM

Which function in Excel is used to calculate the median of a range of cells?

b) MODE

d) AVERAGE

c) MEAN

a) MEDIAN

Which option in Excel allows you to change the font style of a cell?

b) Text Style

d) Cell Font

a) Font Style

c) Change Font

Which keyboard shortcut is used to insert the current date in a cell in Excel?

d) Ctrl+Shift+:

c) Ctrl+:

b) Ctrl+Shift+;

a) Ctrl+;

Which option in Excel allows you to create a drop-down list in a cell?

d) Cell Options

c) Drop-Down Menu

b) List Selection

a) Data Validation

Which function in Excel is used to calculate the sum of a range of cells, including only numbers and ignoring text or blank cells?

b) COUNT

a) SUM

c) AVERAGE

d) SUMIFERROR

10.

Which function in Excel is used to calculate the tangent of an angle?

d) ATAN

c) SIN

b) COS

a) TAN

11.

Which Excel feature is used to sort data in ascending or descending order?

a) Sort Data

d) Sort & Filter

c) Arrange Data

b) Filter Data

12.

Which keyboard shortcut is used to open the Excel Help window?

c) F3

d) F4

a) F1

b) F2

13.

Which Excel feature is used to calculate the average of a range of cells, including numbers, text, and logical values?

d) AVERAGEA

c) SUM

b) COUNT

a) AVERAGE

14.

Which keyboard shortcut is used to select the entire worksheet in Excel?

b) Ctrl+Shift+Space

c) Ctrl+Alt+Space

d) Shift+Space, then Ctrl+A

a) Ctrl+A

15.

Which Excel feature is used to calculate the total number of cells in a range that contain numbers?

d) COUNTA

b) SUM

c) AVERAGE

a) COUNT

16.

Which option in Excel allows you to convert text to lowercase?

a) Lowercase

d) Text to Lower

b) Convert to Lowercase

c) Change Case

17.

Which keyboard shortcut is used to select the entire column in Excel?

b) Shift+Space, then Ctrl+Shift+Right Arrow

d) Ctrl+Alt+Space

c) Ctrl+Shift+Space

a) Ctrl+Space

18.

Which keyboard shortcut is used to select all cells in a worksheet in Excel?

b) Ctrl+Shift+A

c) Ctrl+Alt+A

a) Ctrl+A

d) Shift+A

19.

Which Excel feature is used to freeze rows or columns so that they remain visible while scrolling?

c) Split Panes

a) Freeze Panes

b) Lock Panes

d) Fix Panes

20.

Which option in Excel allows you to insert the file path and name into a cell?

c) Insert File

a) Insert Path

d) File Path

b) File Name

21.

Which Excel feature is used to calculate the sum of a range of cells, excluding hidden rows or columns?

a) SUBTOTAL

c) COUNT

d) AVERAGE

b) SUMIF

22.

Which Excel feature is used to calculate the difference between two dates?

a) DATEDIF

c) DATEDIFF

b) DATEADD

d) DATEDELTA

23.

Which option in Excel allows you to insert the current time in a header or footer?

c) Current Time

d) Time Placeholder

b) Add Time

a) Insert Time

24.

Which option in Excel allows you to insert a line break within a cell?

a) Wrap Text

b) Insert Line Break

c) Break Text

d) Text Wrap

25.

Which keyboard shortcut is used to undo the last action in Excel?

d) Ctrl+X

b) Ctrl+U

c) Ctrl+Y

a) Ctrl+Z

26.

Which function in Excel is used to round a number to the nearest integer or specified decimal places?

d) INT

c) FLOOR

b) CEILING

a) ROUND

27.

Which function in Excel is used to calculate the square root of a number?

b) SUM

d) COUNT

a) SQRT

c) AVERAGE

28.

Which Excel feature is used to apply a specific format to a cell based on its value or condition?

d) AutoFormat

a) Conditional Formatting

c) Sort & Filter

b) Data Validation

29.

Which keyboard shortcut is used to copy the selected cells in Excel?

c) Ctrl+V

d) Ctrl+P

a) Ctrl+C

b) Ctrl+X

30.

Which option in Excel allows you to merge multiple cells into one?

d) Merge & Center

a) Merge Cells

b) Combine Cells

c) Join Cells

31.

Which option in Excel allows you to apply a border around a selected range of cells?

c) Apply Border

b) Cell Border

a) Border Style

d) Format Border

32.

Which Excel feature is used to calculate the internal rate of return for an investment?

a) IRR

d) NPV

b) FV

c) PV

33.

Which keyboard shortcut is used to delete a selected column in Excel?

a) Ctrl+-

d) Ctrl+Shift+Delete

b) Ctrl+Shift+-

c) Ctrl+Delete

34.

Which function in Excel is used to calculate the cosine of an angle?

b) SIN

c) TAN

a) COS

d) ACOS

35.

Which option in Excel allows you to resize the width of multiple columns to fit the contents?

b) Resize Columns

d) Fit to Contents

c) Adjust Column Width

a) AutoFit Column Width

36.

Which keyboard shortcut is used to save the current workbook in Excel?

b) Ctrl+O

a) Ctrl+S

c) Ctrl+N

d) Ctrl+P

37.

Which keyboard shortcut is used to open the Format Cells dialog box in Excel?

a) Ctrl+1

b) Ctrl+2

c) Ctrl+3

d) Ctrl+4

38.

Which Excel feature is used to calculate the net present value of an investment?

a) NPV

c) PV

b) FV

d) IRR

39.

Which option in Excel allows you to apply a specific number format to a cell?

c) Apply Format

a) Number Format

d) Cell Format

b) Format Cell

40.

Which Excel feature is used to create a chart or graph based on selected data?

d) Insert Chart

a) Chart Wizard

c) Chart Builder

b) Chart Creator

41.

Which option in Excel allows you to apply a specific font color to a cell?

d) Cell Color

b) Text Color

c) Apply Color

a) Font Color

42.

Which option in Excel allows you to split text into separate columns based on a delimiter?

a) Text Split

c) Divide Text

b) Split Cells

d) Separate Text

43.

Which function in Excel is used to calculate the factorial of a number plus 1?

d) FACT+1!

a) FACT

c) FACTORIAL

b) FACT+1

44.

Which function in Excel is used to count the number of cells in a range that meet a specified condition?

a) COUNTIF

c) AVERAGEIF

b) SUMIF

d) COUNTIFS

45.

Which option in Excel allows you to insert a hyperlink to a webpage or file?

c) Add Hyperlink

a) Hyperlink

b) Insert Link

d) Link to

46.

Which function in Excel is used to calculate the average of a range of cells, excluding blank cells?

d) AVERAGEA

b) COUNT

c) SUM

a) AVERAGEIF

47.

Which function in Excel is used to calculate the product of a range of cells?

b) SUM

a) PRODUCT

c) AVERAGE

d) COUNT

48.

Which keyboard shortcut is used to select the entire worksheet in Excel?

d) Shift+Space, then Ctrl+A

b) Ctrl+A

a) Ctrl+Shift+Space

c) Ctrl+Alt+Space

49.

Which function in Excel is used to concatenate multiple text strings into one?

a) CONCATENATE

b) MERGE

d) COMBINE

c) JOIN

50.

Which Excel feature is used to group and summarize data based on specified criteria?

b) Data Table

d) Group Table

a) Pivot Table

c) Summary Table

learningsector21 : Excel MCQ Part – 2

Leave a Reply Cancel reply