Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

179

Excel Questions

1 / 15

1. Steps for protecting a sheet by password in MS Excel?

A. Under the Review Tab, Click on Protect Current Sheet

B. Under Insert Tab, Click on Protect Sheet

C. Under Data Tab, Click on Protect Sheet

D. Under the Review Tab, Click on Protect Sheet

2 / 15

2. IF Statement can be written to carry out an action

A. true

B. false

3 / 15

3. A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

4 / 15

4. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

A. Lookup

B. VLookup

C. NOW

D. CountIF

5 / 15

5. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

A. OR

B. AND

C. IF

D. ANDIF

6 / 15

6. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”?

A. Count

B. CountA

C. IF

D. SUM

7 / 15

7. What function will result in the total number of entries in the cell range B5 to B14

A. Count

B. MAX

C. MIN

D. SUM

8 / 15

8. Which function is used to remove extra spaces from the text in MS Excel?

A. REMOVE()

B. TRIM()

C. TRUNC()

D. All of the above

9 / 15

9. An array is a systematic arrangement of similar objects, usually in rows and columns.

A. true

B. false

10 / 15

10. The total number of rows in a worksheet?

A. Unlimited

B. 65,535

C. 1,048,576

D. 1,068,576

11 / 15

11. You can select the current Column in MS-Excel Worksheet by pressing?

A. Ctrl + Space bar

B. F8 + arrow key

C. Shift + arrow key

D. Shift + Space bar

12 / 15

12. How can we provide a dynamic range in ‘data Source’ of pivot tables?

A. Create a Named range using Offset function

B. Base the pivot table using the Named range created in Step 1

C. Both A and B

D. None

13 / 15

13. Which function is used to get the location of text in a string in MS Excel?

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

14 / 15

14. What is the keyboard shortcut to switch between open Excel windows?

A. CTRL + TAB

B. ALT + TAB

C. CTRL + ALT + TAB

D. None of the above

15 / 15

15. Which bar show the used formula of selected active cell?

A. Formula bar

B. Ribbon

C. Menu bar

D. Scroll bar

Your score is

The average score is 43%

By WordPress Quiz plugin

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Shubhranshu Shekhar

Shubhranshu Shekhar is a coding instructor, mentor, and founder of VSIT Delhi with 20+ years of teaching experience (since 2004). He has guided many students who are now working in multinational companies and specializes in Full Stack Development, Python, Digital Marketing, and Data Analytics.

Related Posts