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 shortcut saves the workbook?

a) Ctrl + S

b) Ctrl + A

c) Ctrl + V

d) Ctrl + X

2 / 55

Category: Moderate Level

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

a) Count values

b) Sum values greater than 10

c) Average values

d) Error

3 / 55

Category: Moderate Level

3) What does =TODAY() return?

a) Current time

b) Current date

c) Date & time

d) System date text

4 / 55

Category: Moderate Level

4) What is the maximum number of worksheets allowed?

a) 255

b) 1024

c) Depends on system memory

d) 100

5 / 55

Category: Moderate Level

5) Which error appears when dividing by zero?

a) #VALUE!

b) #NULL!

c) #DIV/0!

d) #NUM!

6 / 55

Category: Moderate Level

6) Which shortcut opens the Format Cells dialog box?

a) Ctrl + F

b) Ctrl + Shift + F

c) Ctrl + 1

d) Ctrl + Alt + F

7 / 55

Category: Moderate Level

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

a) CONCAT

b) JOIN

c) TEXTJOIN

d) a and c

8 / 55

Category: Moderate Level

8) Which function rounds a number down?

a) ROUND

b) ROUNDDOWN

c) FLOOR

d) b and c

9 / 55

Category: Moderate Level

9) Which Excel tool removes duplicate values?

a) Filter

b) Sort

c) Remove Duplicates

d) Conditional Formatting

10 / 55

Category: Moderate Level

10) What does conditional formatting do?

a) Changes data

b) Highlights cells based on rules

c) Filters data

d) Deletes values

11 / 55

Category: Moderate Level

11) Which operator is used for exponentiation?

a) *

b) %

c) ^

d) **

12 / 55

Category: Moderate Level

12) Which function returns the smallest value?

a) MIN

b) SMALL

c) LOW

d) LEAST

13 / 55

Category: Moderate Level

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

a) 4

b) 5

c) 6

d) Error

14 / 55

Category: Moderate Level

14) Which function counts non-empty cells?

a) COUNT

b) COUNTA

c) COUNTBLANK

d) COUNTIF

15 / 55

Category: Moderate Level

15) Which chart shows percentage contribution?

a) Line

b) Bar

c) Pie

d) Scatter

16 / 55

Category: Moderate Level

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

a) 5

b) True

c) Error

d) 6

17 / 55

Category: Moderate Level

17) Which Excel feature summarizes large data quickly?

a) Filter

b) Chart

c) Pivot Table

d) Sort

18 / 55

Category: Moderate Level

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

a) COUNT

b) COUNTA

c) COUNTIF

d) COUNTBLANK

19 / 55

Category: Moderate Level

19) Which function searches text case-insensitively?

a) FIND

b) SEARCH

c) LOOKUP

d) MATCH

20 / 55

Category: Moderate Level

20) What is the use of Freeze Panes?

a) Lock formatting

b) Lock rows/columns while scrolling

c) Protect data

d) Filter values

21 / 55

Category: Moderate Level

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

a) 2

b) 3

c) 4

d) 5

22 / 55

Category: Moderate Level

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

a) COM

b) PUT

c) TER

d) CPU

23 / 55

Category: Moderate Level

23) Which function calculates average based on condition?

a) AVERAGE

b) AVG

c) AVERAGEIF

d) MEAN

24 / 55

Category: Moderate Level

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

a) .xls

b) .xlsx

c) .csv

d) .xml

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 view shows page layout?

a) Normal

b) Page Break

c) Page Layout

d) Print Preview

27 / 55

Category: Moderate Level

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

a) Sorting

b) Conditional Formatting

c) Filter

d) Data Validation

28 / 55

Category: Moderate Level

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

a) 1

b) 2

c) 3

d) Error

29 / 55

Category: Moderate Level

29) Which error indicates wrong function name?

a) #VALUE!

b) #REF!

c) #NAME?

d) #NULL!

30 / 55

Category: Moderate Level

30) Which Excel feature protects worksheet data?

a) Freeze Pane

b) Lock Cell

c) Protect Sheet

d) Data Validation

31 / 55

Category: Moderate Level

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

a) 6

b) 8

c) 7

d) 16

32 / 55

Category: Moderate Level

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

a) TRUE

b) NO

c) YES

d) Error

33 / 55

Category: Moderate Level

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

a) =A1+B1

b) =A1B1

c) =A1/B1

d) =A1-B1

34 / 55

Category: Moderate Level

34) Which function converts text to uppercase?

a) LOWER

b) PROPER

c) UPPER

d) CAPS

35 / 55

Category: Moderate Level

35) Which function extracts characters from right side?

a) LEFT

b) MID

c) RIGHT

d) EXTRACT

36 / 55

Category: Moderate Level

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

a) 12.56

b) 12.57

c) 12.55

d) 13

37 / 55

Category: Moderate Level

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

a) WEEKDAY

b) DAY

c) MONTH

d) DATE

38 / 55

Category: Moderate Level

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

a) TRUE

b) 0

c) Value_if_false

d) Error

39 / 55

Category: Moderate Level

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

a) TRUE

b) FALSE

c) Error

d) 0

40 / 55

Category: Moderate Level

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

a) #DIV/0!

b) #REF!

c) #NAME?

d) #VALUE!

41 / 55

Category: Moderate Level

41) Which Excel feature restricts data entry?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Protection

42 / 55

Category: Moderate Level

42) What does CSV stand for?

a) Common Separated Values

b) Comma Separated Values

c) Column Sorted Values

d) Computer Sheet Version

43 / 55

Category: Moderate Level

43) Which function returns current date and time?

a) TODAY()

b) NOW()

c) TIME()

d) DATE()

44 / 55

Category: Moderate Level

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

a) #

b) $

c) &

d) @

45 / 55

Category: Moderate Level

45) Which function returns the current time?

a) NOW()

b) TIME()

c) TODAY()

d) CLOCK()

46 / 55

Category: Moderate Level

46) What is the use of TEXT function?

a) Convert number to text with format

b) Count text

c) Join text

d) Trim text

47 / 55

Category: Moderate Level

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

a) Pie

b) Column

c) Line

d) Area

48 / 55

Category: Moderate Level

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

a) 50

b) 100

c) 100000

d) 15

49 / 55

Category: Moderate Level

49) Which function is used to lookup values vertically?

a) HLOOKUP

b) VLOOKUP

c) LOOKUP

d) SEARCH

50 / 55

Category: Moderate Level

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

a) Excel

b) Excel_

c) _Excel

d) Error

51 / 55

Category: Moderate Level

51) Which feature repeats headers on every printed page?

a) Freeze Pane

b) Print Titles

c) Page Layout

d) Header & Footer

52 / 55

Category: Moderate Level

52) Which function finds the position of a value?

a) LOOKUP

b) MATCH

c) INDEX

d) FIND

53 / 55

Category: Moderate Level

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

a) MAX

b) LARGE

c) HIGH

d) TOP

54 / 55

Category: Moderate Level

54) Which Excel tool creates drop-down lists?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Pivot Table

55 / 55

Category: Moderate Level

55) What is a Pivot Table used for?

a) Data entry

b) Data analysis & summarization

c) Chart creation

d) Data validation

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 Office (Excel) Quiz (level – Easy)

Advance Excel Quiz for Beginners

MS-Excel Quiz (Level – Easy)

Leave a ReplyCancel reply

Share this content