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

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

a) #DIV/0!

b) #REF!

c) #NAME?

d) #VALUE!

2 / 55

Category: Moderate Level

Which error indicates wrong function name?

a) #VALUE!

b) #REF!

c) #NAME?

d) #NULL!

3 / 55

Category: Moderate Level

Which function is used to combine text from multiple cells?

a) CONCAT

b) JOIN

c) TEXTJOIN

d) a and c

4 / 55

Category: Moderate Level

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

a) MATCH

b) LOOKUP

c) INDEX

d) VLOOKUP

5 / 55

Category: Moderate Level

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

a) COM

b) PUT

c) TER

d) CPU

6 / 55

Category: Moderate Level

What does =TODAY() return?

a) Current time

b) Current date

c) Date & time

d) System date text

7 / 55

Category: Moderate Level

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

a) 2

b) 3

c) 4

d) 5

8 / 55

Category: Moderate Level

Which function returns current date and time?

a) TODAY()

b) NOW()

c) TIME()

d) DATE()

9 / 55

Category: Moderate Level

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

a) Count values

b) Sum values greater than 10

c) Average values

d) Error

10 / 55

Category: Moderate Level

Which Excel feature protects worksheet data?

a) Freeze Pane

b) Lock Cell

c) Protect Sheet

d) Data Validation

11 / 55

Category: Moderate Level

Which function calculates average based on condition?

a) AVERAGE

b) AVG

c) AVERAGEIF

d) MEAN

12 / 55

Category: Moderate Level

What is the use of TEXT function?

a) Convert number to text with format

b) Count text

c) Join text

d) Trim text

13 / 55

Category: Moderate Level

Which shortcut saves the workbook?

a) Ctrl + S

b) Ctrl + A

c) Ctrl + V

d) Ctrl + X

14 / 55

Category: Moderate Level

Which Excel tool creates drop-down lists?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Pivot Table

15 / 55

Category: Moderate Level

Which Excel tool removes duplicate values?

a) Filter

b) Sort

c) Remove Duplicates

d) Conditional Formatting

16 / 55

Category: Moderate Level

Which function is used to find today's weekday?

a) WEEKDAY

b) DAY

c) MONTH

d) DATE

17 / 55

Category: Moderate Level

Which function finds the position of a value?

a) LOOKUP

b) MATCH

c) INDEX

d) FIND

18 / 55

Category: Moderate Level

Which Excel feature restricts data entry?

a) Filter

b) Conditional Formatting

c) Data Validation

d) Protection

19 / 55

Category: Moderate Level

What does CSV stand for?

a) Common Separated Values

b) Comma Separated Values

c) Column Sorted Values

d) Computer Sheet Version

20 / 55

Category: Moderate Level

Which chart is best for showing trends over time?

a) Pie

b) Column

c) Line

d) Area

21 / 55

Category: Moderate Level

Which error appears when dividing by zero?

a) #VALUE!

b) #NULL!

c) #DIV/0!

d) #NUM!

22 / 55

Category: Moderate Level

Which chart shows percentage contribution?

a) Line

b) Bar

c) Pie

d) Scatter

23 / 55

Category: Moderate Level

What will =SUM(5, TRUE) return?

a) 5

b) True

c) Error

d) 6

24 / 55

Category: Moderate Level

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

a) =A1+B1

b) =A1B1

c) =A1/B1

d) =A1-B1

25 / 55

Category: Moderate Level

Which function extracts characters from right side?

a) LEFT

b) MID

c) RIGHT

d) EXTRACT

26 / 55

Category: Moderate Level

Which function searches text case-insensitively?

a) FIND

b) SEARCH

c) LOOKUP

d) MATCH

27 / 55

Category: Moderate Level

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

a) 50

b) 100

c) 100000

d) 15

28 / 55

Category: Moderate Level

What will =ROUND(12.567, 2) return?

a) 12.56

b) 12.57

c) 12.55

d) 13

29 / 55

Category: Moderate Level

Which operator is used for exponentiation?

a) *

b) %

c) ^

d) **

30 / 55

Category: Moderate Level

Which function returns the smallest value?

a) MIN

b) SMALL

c) LOW

d) LEAST

31 / 55

Category: Moderate Level

What is the default file extension of Excel 2016+?

a) .xls

b) .xlsx

c) .csv

d) .xml

32 / 55

Category: Moderate Level

Which Excel feature summarizes large data quickly?

a) Filter

b) Chart

c) Pivot Table

d) Sort

33 / 55

Category: Moderate Level

What does conditional formatting do?

a) Changes data

b) Highlights cells based on rules

c) Filters data

d) Deletes values

34 / 55

Category: Moderate Level

Which function rounds a number down?

a) ROUND

b) ROUNDDOWN

c) FLOOR

d) b and c

35 / 55

Category: Moderate Level

What is a Pivot Table used for?

a) Data entry

b) Data analysis & summarization

c) Chart creation

d) Data validation

36 / 55

Category: Moderate Level

What is the maximum number of worksheets allowed?

a) 255

b) 1024

c) Depends on system memory

d) 100

37 / 55

Category: Moderate Level

Which function converts text to uppercase?

a) LOWER

b) PROPER

c) UPPER

d) CAPS

38 / 55

Category: Moderate Level

Which function returns the current time?

a) NOW()

b) TIME()

c) TODAY()

d) CLOCK()

39 / 55

Category: Moderate Level

Which function finds the maximum value in a range?

a) MAX

b) LARGE

c) HIGH

d) TOP

40 / 55

Category: Moderate Level

What will =LEN("Excel") return?

a) 4

b) 5

c) 6

d) Error

41 / 55

Category: Moderate Level

Which function counts non-empty cells?

a) COUNT

b) COUNTA

c) COUNTBLANK

d) COUNTIF

42 / 55

Category: Moderate Level

Which shortcut opens the Format Cells dialog box?

a) Ctrl + F

b) Ctrl + Shift + F

c) Ctrl + 1

d) Ctrl + Alt + F

43 / 55

Category: Moderate Level

What does =TRIM(" Excel ") return?

a) Excel

b) Excel_

c) _Excel

d) Error

44 / 55

Category: Moderate Level

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

a) TRUE

b) NO

c) YES

d) Error

45 / 55

Category: Moderate Level

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

a) TRUE

b) 0

c) Value_if_false

d) Error

46 / 55

Category: Moderate Level

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

a) COUNT

b) COUNTA

c) COUNTIF

d) COUNTBLANK

47 / 55

Category: Moderate Level

What will =ISNUMBER("Excel") return?

a) TRUE

b) FALSE

c) Error

d) 0

48 / 55

Category: Moderate Level

Which symbol is used to make a cell reference absolute?

a) #

b) $

c) &

d) @

49 / 55

Category: Moderate Level

Which view shows page layout?

a) Normal

b) Page Break

c) Page Layout

d) Print Preview

50 / 55

Category: Moderate Level

Which function is used to lookup values vertically?

a) HLOOKUP

b) VLOOKUP

c) LOOKUP

d) SEARCH

51 / 55

Category: Moderate Level

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

a) 1

b) 2

c) 3

d) Error

52 / 55

Category: Moderate Level

Which feature repeats headers on every printed page?

a) Freeze Pane

b) Print Titles

c) Page Layout

d) Header & Footer

53 / 55

Category: Moderate Level

What is the use of Freeze Panes?

a) Lock formatting

b) Lock rows/columns while scrolling

c) Protect data

d) Filter values

54 / 55

Category: Moderate Level

What will =POWER(2,3) return?

a) 6

b) 8

c) 7

d) 16

55 / 55

Category: Moderate Level

Which Excel feature allows filtering data based on conditions?

a) Sorting

b) Conditional Formatting

c) Filter

d) Data Validation

Your score is

0%

Rate Us!

Thank You !!

BITTU TECH

50+ MS Excel Question Quiz (Level – Intermediate)

Like this:

Related

Prajjwal Singh

Leave a ReplyCancel reply

BITTU TECH

Report a question

Share this:

Like this:

Related

Please Share This Share this content

Prajjwal Singh

You Might Also Like

Learn Excel Fast: 30 Hands-On Projects for 30 Days

MS Office (Excel) Quiz (level – Easy)

MS-Excel Quiz (Level – Easy)

Leave a ReplyCancel reply

Share this content