Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

179

Excel Questions

1 / 15

1. Which symbol is used to specify the fixed columns or rows in the formula?

A. =

B. *

C. $

D. %

2 / 15

2. 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

3 / 15

3. 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

4 / 15

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

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

5 / 15

5. 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

6 / 15

6. What is the correct value of the function? =ROUND (1.2345,2)

A. 1.24

B. 1.23

C. 1. 25

D. 2

7 / 15

7. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

A. Table Styles

B. Stylish Cells

C. Format as Table

D. Cells as Table

8 / 15

8. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?

A. Shift + F9

B. Shift + F10

C. Shift + F12

D. Shift + F11

9 / 15

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

A. true

B. false

10 / 15

10. Which function is used to create a date with year, month, and day?

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

11 / 15

11. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?

A. OR

B. AND

C. IF

D. ANDIF

12 / 15

12. A features that displays only the data in column (s) according to specified criteria

A. Formula

B. Sorting

C. Filtering

D. Pivot

13 / 15

13. Which programming language is used to write a Macro in MS Excel?

A. C

B. C++

C. Java

D. Visual Basic

14 / 15

14. Which feature is used to wrap extra-long text into multiple lines in MS Excel?

A. Word Wrap

B. Letter Wrap

C. Text Wrap

D. Wrap Text

15 / 15

15. 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

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