Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

175

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. What is the collection of worksheets called?

A. Ledger

B. Book

C. Testbook

D. Workbook

3 / 15

3. Shortcut key CTRL + D is used to ____.

A. Open font dialog box

B. Open format cells dialog box

C. Shift current cell's value in the right cell

D. Fill down in the selection

4 / 15

4. You can select the current row in MS-Excel Worksheet by pressing?

A. Ctrl + Space bar

B. F8 + arrow key

C. Shift + arrow key

D. Shift + Space bar

5 / 15

5. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

A. Styling

B. Conditional Formatting

C. Compare Formatting

D. Special Formatting

6 / 15

6. Excel is a program that is used to prepare a

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

7 / 15

7. The intersection of a column and a row in a worksheet is called ____.

A. Box

B. Cell

C. Range

D. Page Break

8 / 15

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

A. true

B. false

9 / 15

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

A. OR

B. AND

C. IF

D. ANDIF

10 / 15

10. The ____ function is used to convert to text in a number format in MS Excel.

A. CONVERT()

B. TEXT()

C. NUM()

D. CONVERTTEXT()

11 / 15

11. Which function will you use to enter current date and time in a worksheet cell?

A. =today()

B. =now()

C. =time()

D. =currentTime()

12 / 15

12. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?

A. Only 1

B. Only 2

C. None of 1 and 2

D. Both 1 and 2

13 / 15

13. Excel is a ____ program developed by Microsoft.

A. Spreadsheet

B. Document

C. Data management

D. All of the above

14 / 15

14. Under which tab and in which function group will you find the option to insert a Pivot Table?

A. Under the Insert tab in the Tables group

B. Under the Formulas tab in the Data Analysis group

C. In the Data group in the Pivot Tables group

D. In the Data group in the Tables group

15 / 15

15. The total number of columns in a worksheet?

A. 26

B. 256

C. 12,834

D. 16,384

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