50+ MS Excel Question Quiz (Level - Intermediate) >> BittuTech

MS Office

50+ MS-Excel Quiz (Level-Intermediate)

Start Your Learning Journey.

Click on Start Button Now!

Login Form.

NameEmail

1 / 55

Category: Moderate Level

1) Which function rounds a number down?

a) ROUND

b) ROUNDDOWN

c) FLOOR

d) b and c

2 / 55

Category: Moderate Level

2) Which function finds the position of a value?

a) LOOKUP

b) MATCH

c) INDEX

d) FIND

3 / 55

Category: Moderate Level

3) What will =ROUND(12.567, 2) return?

a) 12.56

b) 12.57

c) 12.55

d) 13

4 / 55

Category: Moderate Level

4) What does conditional formatting do?

a) Changes data

b) Highlights cells based on rules

c) Filters data

d) Deletes values

5 / 55

Category: Moderate Level

5) What is the result of =MOD(17,5)?

a) 2

b) 3

c) 4

d) 5

6 / 55

Category: Moderate Level

6) Which function extracts characters from right side?

a) LEFT

b) MID

c) RIGHT

d) EXTRACT

7 / 55

Category: Moderate Level

7) Which error appears when a formula refers to an invalid cell?

a) #DIV/0!

b) #REF!

c) #NAME?

d) #VALUE!

8 / 55

Category: Moderate Level

8) What does the IF function return when the condition is false?

a) TRUE

b) 0

c) Value_if_false

d) Error

9 / 55

Category: Moderate Level

9) Which feature repeats headers on every printed page?

a) Freeze Pane

b) Print Titles

c) Page Layout

d) Header & Footer

10 / 55

Category: Moderate Level

10) Which chart shows percentage contribution?

a) Line

b) Bar

c) Pie

d) Scatter

11 / 55

Category: Moderate Level

11) Which function calculates average based on condition?

a) AVERAGE

b) AVG

c) AVERAGEIF

d) MEAN

12 / 55

Category: Moderate Level

12) What will =SUMIF(A1:A5,">10") do?

a) Count values

b) Sum values greater than 10

c) Average values

d) Error

13 / 55

Category: Moderate Level

13) Which function finds the maximum value in a range?

a) MAX

b) LARGE

c) HIGH

d) TOP

14 / 55

Category: Moderate Level

14) Which Excel tool creates drop-down lists?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Pivot Table

15 / 55

Category: Moderate Level

15) What will =SUM(5, TRUE) return?

a) 5

b) True

c) Error

d) 6

16 / 55

Category: Moderate Level

16) Which error appears when dividing by zero?

a) #VALUE!

b) #NULL!

c) #DIV/0!

d) #NUM!

17 / 55

Category: Moderate Level

17) Which operator is used for exponentiation?

a) *

b) %

c) ^

d) **

18 / 55

Category: Moderate Level

18) Which view shows page layout?

a) Normal

b) Page Break

c) Page Layout

d) Print Preview

19 / 55

Category: Moderate Level

19) Which function is used to count cells that meet a specific condition?

a) COUNT

b) COUNTA

c) COUNTIF

d) COUNTBLANK

20 / 55

Category: Moderate Level

20) If A1 = 10 and B1 = 5, what is the result of =A1^B1?

a) 50

b) 100

c) 100000

d) 15

21 / 55

Category: Moderate Level

21) What is a Pivot Table used for?

a) Data entry

b) Data analysis & summarization

c) Chart creation

d) Data validation

22 / 55

Category: Moderate Level

22) Which Excel tool removes duplicate values?

a) Filter

b) Sort

c) Remove Duplicates

d) Conditional Formatting

23 / 55

Category: Moderate Level

23) Which Excel feature allows filtering data based on conditions?

a) Sorting

b) Conditional Formatting

c) Filter

d) Data Validation

24 / 55

Category: Moderate Level

24) Which function converts text to uppercase?

a) LOWER

b) PROPER

c) UPPER

d) CAPS

25 / 55

Category: Moderate Level

25) Which function returns a value based on row and column number?

a) MATCH

b) LOOKUP

c) INDEX

d) VLOOKUP

26 / 55

Category: Moderate Level

26) Which function counts non-empty cells?

a) COUNT

b) COUNTA

c) COUNTBLANK

d) COUNTIF

27 / 55

Category: Moderate Level

27) Which function is used to combine text from multiple cells?

a) CONCAT

b) JOIN

c) TEXTJOIN

d) a and c

28 / 55

Category: Moderate Level

28) Which function returns current date and time?

a) TODAY()

b) NOW()

c) TIME()

d) DATE()

29 / 55

Category: Moderate Level

29) Which function searches text case-insensitively?

a) FIND

b) SEARCH

c) LOOKUP

d) MATCH

30 / 55

Category: Moderate Level

30) What is the maximum number of worksheets allowed?

a) 255

b) 1024

c) Depends on system memory

d) 100

31 / 55

Category: Moderate Level

31) Which Excel feature restricts data entry?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Protection

32 / 55

Category: Moderate Level

32) What is the default file extension of Excel 2016+?

a) .xls

b) .xlsx

c) .csv

d) .xml

33 / 55

Category: Moderate Level

33) What will =LEN("Excel") return?

a) 4

b) 5

c) 6

d) Error

34 / 55

Category: Moderate Level

34) Which Excel feature summarizes large data quickly?

a) Filter

b) Chart

c) Pivot Table

d) Sort

35 / 55

Category: Moderate Level

35) Which Excel feature protects worksheet data?

a) Freeze Pane

b) Lock Cell

c) Protect Sheet

d) Data Validation

36 / 55

Category: Moderate Level

36) What will =ISNUMBER("Excel") return?

a) TRUE

b) FALSE

c) Error

d) 0

37 / 55

Category: Moderate Level

37) What does =TODAY() return?

a) Current time

b) Current date

c) Date & time

d) System date text

38 / 55

Category: Moderate Level

38) What is the output of =LEFT("COMPUTER", 3)?

a) COM

b) PUT

c) TER

d) CPU

39 / 55

Category: Moderate Level

39) What will =POWER(2,3) return?

a) 6

b) 8

c) 7

d) 16

40 / 55

Category: Moderate Level

40) What is the use of Freeze Panes?

a) Lock formatting

b) Lock rows/columns while scrolling

c) Protect data

d) Filter values

41 / 55

Category: Moderate Level

41) What does CSV stand for?

a) Common Separated Values

b) Comma Separated Values

c) Column Sorted Values

d) Computer Sheet Version

42 / 55

Category: Moderate Level

42) Which chart is best for showing trends over time?

a) Pie

b) Column

c) Line

d) Area

43 / 55

Category: Moderate Level

43) Which function returns the current time?

a) NOW()

b) TIME()

c) TODAY()

d) CLOCK()

44 / 55

Category: Moderate Level

44) Which shortcut opens the Format Cells dialog box?

a) Ctrl + F

b) Ctrl + Shift + F

c) Ctrl + 1

d) Ctrl + Alt + F

45 / 55

Category: Moderate Level

45) Which shortcut saves the workbook?

a) Ctrl + S

b) Ctrl + A

c) Ctrl + V

d) Ctrl + X

46 / 55

Category: Moderate Level

46) Which symbol is used to make a cell reference absolute?

a) #

b) $

c) &

d) @

47 / 55

Category: Moderate Level

47) Which function is used to find today's weekday?

a) WEEKDAY

b) DAY

c) MONTH

d) DATE

48 / 55

Category: Moderate Level

48) What does =IF(10>5,"YES","NO") return?

a) TRUE

b) NO

c) YES

d) Error

49 / 55

Category: Moderate Level

49) Which error indicates wrong function name?

a) #VALUE!

b) #REF!

c) #NAME?

d) #NULL!

50 / 55

Category: Moderate Level

50) Which function returns the smallest value?

a) MIN

b) SMALL

c) LOW

d) LEAST

51 / 55

Category: Moderate Level

51) What will =COUNT("Excel",10,20) return?

a) 1

b) 2

c) 3

d) Error

52 / 55

Category: Moderate Level

52) Which function is used to lookup values vertically?

a) HLOOKUP

b) VLOOKUP

c) LOOKUP

d) SEARCH

53 / 55

Category: Moderate Level

53) To calculate total sales = Quantity × Price, which formula is correct?

a) =A1+B1

b) =A1B1

c) =A1/B1

d) =A1-B1

54 / 55

Category: Moderate Level

54) What does =TRIM(" Excel ") return?

a) Excel

b) Excel_

c) _Excel

d) Error

55 / 55

Category: Moderate Level

55) What is the use of TEXT function?

a) Convert number to text with format

b) Count text

c) Join text

d) Trim text

Your score is

0%

Rate Us!

Thank You !!

BITTU TECH

50+ MS Excel Question Quiz (Level – Intermediate)

Like this:

Prajjwal Singh

Leave a ReplyCancel reply

BITTU TECH

Report a question

Like this:

Please Share This Share this content

Prajjwal Singh

You Might Also Like

Advance Excel Quiz for Beginners

MS Office (Excel) Quiz (level – Easy)

MS-Excel Quiz (Level – Easy)

Leave a ReplyCancel reply

Share this content