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 is used to combine text from multiple cells?

a) CONCAT

b) JOIN

c) TEXTJOIN

d) a and c

2 / 55

Category: Moderate Level

2) Which function returns current date and time?

a) TODAY()

b) NOW()

c) TIME()

d) DATE()

3 / 55

Category: Moderate Level

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

a) 6

b) 8

c) 7

d) 16

4 / 55

Category: Moderate Level

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

a) TRUE

b) 0

c) Value_if_false

d) Error

5 / 55

Category: Moderate Level

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

a) Sorting

b) Conditional Formatting

c) Filter

d) Data Validation

6 / 55

Category: Moderate Level

6) What is the use of Freeze Panes?

a) Lock formatting

b) Lock rows/columns while scrolling

c) Protect data

d) Filter values

7 / 55

Category: Moderate Level

7) Which chart shows percentage contribution?

a) Line

b) Bar

c) Pie

d) Scatter

8 / 55

Category: Moderate Level

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

a) 50

b) 100

c) 100000

d) 15

9 / 55

Category: Moderate Level

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

a) 1

b) 2

c) 3

d) Error

10 / 55

Category: Moderate Level

10) What does =TODAY() return?

a) Current time

b) Current date

c) Date & time

d) System date text

11 / 55

Category: Moderate Level

11) Which function returns the current time?

a) NOW()

b) TIME()

c) TODAY()

d) CLOCK()

12 / 55

Category: Moderate Level

12) Which error indicates wrong function name?

a) #VALUE!

b) #REF!

c) #NAME?

d) #NULL!

13 / 55

Category: Moderate Level

13) Which function is used to lookup values vertically?

a) HLOOKUP

b) VLOOKUP

c) LOOKUP

d) SEARCH

14 / 55

Category: Moderate Level

14) What is the maximum number of worksheets allowed?

a) 255

b) 1024

c) Depends on system memory

d) 100

15 / 55

Category: Moderate Level

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

a) WEEKDAY

b) DAY

c) MONTH

d) DATE

16 / 55

Category: Moderate Level

16) Which Excel feature protects worksheet data?

a) Freeze Pane

b) Lock Cell

c) Protect Sheet

d) Data Validation

17 / 55

Category: Moderate Level

17) Which Excel tool removes duplicate values?

a) Filter

b) Sort

c) Remove Duplicates

d) Conditional Formatting

18 / 55

Category: Moderate Level

18) Which operator is used for exponentiation?

a) *

b) %

c) ^

d) **

19 / 55

Category: Moderate Level

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

a) 2

b) 3

c) 4

d) 5

20 / 55

Category: Moderate Level

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

a) Count values

b) Sum values greater than 10

c) Average values

d) Error

21 / 55

Category: Moderate Level

21) Which function returns the smallest value?

a) MIN

b) SMALL

c) LOW

d) LEAST

22 / 55

Category: Moderate Level

22) Which function searches text case-insensitively?

a) FIND

b) SEARCH

c) LOOKUP

d) MATCH

23 / 55

Category: Moderate Level

23) What is the use of TEXT function?

a) Convert number to text with format

b) Count text

c) Join text

d) Trim text

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) What does =TRIM(" Excel ") return?

a) Excel

b) Excel_

c) _Excel

d) Error

26 / 55

Category: Moderate Level

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

a) Pie

b) Column

c) Line

d) Area

27 / 55

Category: Moderate Level

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

a) MATCH

b) LOOKUP

c) INDEX

d) VLOOKUP

28 / 55

Category: Moderate Level

28) What does conditional formatting do?

a) Changes data

b) Highlights cells based on rules

c) Filters data

d) Deletes values

29 / 55

Category: Moderate Level

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

a) 5

b) True

c) Error

d) 6

30 / 55

Category: Moderate Level

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

a) 4

b) 5

c) 6

d) Error

31 / 55

Category: Moderate Level

31) Which Excel feature summarizes large data quickly?

a) Filter

b) Chart

c) Pivot Table

d) Sort

32 / 55

Category: Moderate Level

32) Which function finds the position of a value?

a) LOOKUP

b) MATCH

c) INDEX

d) FIND

33 / 55

Category: Moderate Level

33) Which function calculates average based on condition?

a) AVERAGE

b) AVG

c) AVERAGEIF

d) MEAN

34 / 55

Category: Moderate Level

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

a) .xls

b) .xlsx

c) .csv

d) .xml

35 / 55

Category: Moderate Level

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

a) 12.56

b) 12.57

c) 12.55

d) 13

36 / 55

Category: Moderate Level

36) Which feature repeats headers on every printed page?

a) Freeze Pane

b) Print Titles

c) Page Layout

d) Header & Footer

37 / 55

Category: Moderate Level

37) Which error appears when dividing by zero?

a) #VALUE!

b) #NULL!

c) #DIV/0!

d) #NUM!

38 / 55

Category: Moderate Level

38) What does CSV stand for?

a) Common Separated Values

b) Comma Separated Values

c) Column Sorted Values

d) Computer Sheet Version

39 / 55

Category: Moderate Level

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

a) MAX

b) LARGE

c) HIGH

d) TOP

40 / 55

Category: Moderate Level

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

a) #

b) $

c) &

d) @

41 / 55

Category: Moderate Level

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

a) #DIV/0!

b) #REF!

c) #NAME?

d) #VALUE!

42 / 55

Category: Moderate Level

42) Which function counts non-empty cells?

a) COUNT

b) COUNTA

c) COUNTBLANK

d) COUNTIF

43 / 55

Category: Moderate Level

43) Which shortcut opens the Format Cells dialog box?

a) Ctrl + F

b) Ctrl + Shift + F

c) Ctrl + 1

d) Ctrl + Alt + F

44 / 55

Category: Moderate Level

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

a) TRUE

b) NO

c) YES

d) Error

45 / 55

Category: Moderate Level

45) Which view shows page layout?

a) Normal

b) Page Break

c) Page Layout

d) Print Preview

46 / 55

Category: Moderate Level

46) Which function extracts characters from right side?

a) LEFT

b) MID

c) RIGHT

d) EXTRACT

47 / 55

Category: Moderate Level

47) Which shortcut saves the workbook?

a) Ctrl + S

b) Ctrl + A

c) Ctrl + V

d) Ctrl + X

48 / 55

Category: Moderate Level

48) Which Excel tool creates drop-down lists?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Pivot Table

49 / 55

Category: Moderate Level

49) Which Excel feature restricts data entry?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Protection

50 / 55

Category: Moderate Level

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

a) =A1+B1

b) =A1B1

c) =A1/B1

d) =A1-B1

51 / 55

Category: Moderate Level

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

a) TRUE

b) FALSE

c) Error

d) 0

52 / 55

Category: Moderate Level

52) What is a Pivot Table used for?

a) Data entry

b) Data analysis & summarization

c) Chart creation

d) Data validation

53 / 55

Category: Moderate Level

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

a) COUNT

b) COUNTA

c) COUNTIF

d) COUNTBLANK

54 / 55

Category: Moderate Level

54) Which function rounds a number down?

a) ROUND

b) ROUNDDOWN

c) FLOOR

d) b and c

55 / 55

Category: Moderate Level

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

a) COM

b) PUT

c) TER

d) CPU

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

MS-Excel Quiz (Level – Easy)

Advance Excel Quiz for Beginners

MS Office (Excel) Quiz (level – Easy)

Leave a ReplyCancel reply

Share this content