Advanced Excel MCQs Questions and Answers Pdf

 

1. Which one is not a function in ms excel?

A. TRIM

B. AVERAGE

C. COUNT

D. CLEAR

Answer: D. CLEAR

2. Free online version of MS excel is known as ________?

A. Office 365

B. Excel Mobile

C. Word Mobile

D. Excel for the web

Answer: D. Excel for the web

3. Microsoft Excel 2019 has column limit of __________?

A. 12684

B. 14684

C. 16384

D. 18634

Answer: C. 16384

3. Microsoft Excel has cell limit of __________?

A. 17170069184

B. 17170669184

C. 17170869184

D. 17170569154

Answer: C. 17170869184

4. Which function is used to combine multiple text strings into a single string?

A) SUM

B) AVERAGE

C) MERGE

D) CONCATENATE

Answer: D) CONCATENATE

 5. What does the NOW() function return?

A) Current date

B) Current time

C) Current date and time

D) None of the above

Answer: C) Current date and time

6. The TODAY() function returns___________?

A) Current time

B) Current date

C) Current date and time

D) None of the above

Answer: B) Current date

 7. The MONTH() function extracts___________?

A) The day of the month

B) The month of the year

C) The year

D) None of the above

Answer: B) The month of the year

8. The LEFT() function extracts characters from the___________?

A) Right side of a text string

B) Left side of a text string

C) Middle of a text string

D) None of the above

Answer: B) Left side of a text string

 9. The RIGHT() function extracts characters from the___________?

A) Right side of a text string

B) Left side of a text string

C) Middle of a text string

D) None of the above

Answer: A) Right side of a text string

10. The ROMAN() function converts a number to___________?

A) A decimal number

B) A binary number

C) A Roman numeral

D) A hexadecimal number

Answer: C) A Roman numeral

11. Which function counts the number of cells in a range that contain numbers?

A) COUNTA

B) COUNTBLANK

C) LEN

D) COUNT

Answer: D) COUNT

12. Which function counts the number of cells in a range that contain numbers?

A) COUNTA

B) COUNTBLANK

C) LEN

D) SUM

Answer: D) SUM

13. Which function counts the number of empty cells in a range?

A) COUNT

B) COUNTA

C) SUM

D) COUNTBLANK

Answer: D) COUNTBLANK

Click here for more 

The Microsoft Excel MCQs Marathon: How Far Can You G?

MS Word MCQs: 40+ Important Multiple Choices 

14. Which function returns the length of a text string?

A) COUNT

B) COUNTA

C) COUNTBLANK

D) LEN

Answer: D) LEN

15. Which function converts text to uppercase?

A) LOWER

B) PROPER

C) TRIM

D) UPPER

Answer: D) UPPER

16. Which function converts text to lowercase?

A) UPPER

B) PROPER

C) TRIM

D) LOWER

Answer: D) LOWER

17. Which function capitalizes the first letter of each word in a text string?

A) UPPER

B) LOWER

C) TRIM

D) PROPER

Answer: D) PROPER

18. MS Excel stands for_________?

A) Microsoft Excess

B) Micromax Excel

C) Management Excel

D) Microsoft Excel

Answer: D) Microsoft Excel

18. Microsoft Excel is a spreadsheet developed by Microsoft for _________?

A) Android

B) IOS

C) Linux

D) All of these

Answer: D) All of these

20. When was the first version of MS Excel released?

A) 1987

B) 1991

C) 1995

D) 1985

Answer: D) 1985

21. The first cell in the Excel sheet label as __________?

A) A2

B) A3

C) A0

D) A1

Answer: D) A1

22. What is the shortcut key to hide the entire row?

A) Ctrl + H

B) Ctrl + R

C) Ctr

l + 0

D) Ctrl + 9

Answer: D) Ctrl + 9

23. What is the shortcut key to hide the entire column?

A) Ctrl+ 9

B) Ctrl + 0

C) Ctrl + R

D) Ctrl + H

Answer: B) Ctrl + 0

If you want to get Pdf file send your Email ID.