Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

177

Excel Questions

1 / 15

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

2 / 15

2. _____ are equations that perform calculations on values in your worksheet.

A. Functions

B. References

C. Formulas

D. Constants

3 / 15

3. In MS Excel, ‘Merge and Center’ is used to ____.

A. Combine and centre the content of the selected cell

B. Combine and centre the content of the current row

C. Concatenate the text of the two cells and returns the text

D. None of the above

4 / 15

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

5 / 15

5. Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?

A. Workbook Statistics

B. Statistics

C. Excel Statistics

D. Workbook Analysis

6 / 15

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

7 / 15

7. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

A. CountIF

B. NOW

C. Lookup

D. VLookup

8 / 15

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

9 / 15

9. In ______ tab you will find AutoSum button.

A. Formatting tab

B. Formulas tab

C. Standard tab

D. Clipboard tab

10 / 15

10. A function inside other function is called

A. Nested Function

B. Round Function

C. Inner Function

D. None of the above

11 / 15

11. This is not a function category in Excel.

A. Logical

B. Text

C. Financial

D. Data series

12 / 15

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

13 / 15

13. Getting data from a cell located in a different worksheet is called?

A. Accessing

B. Referencing

C. Updating

D. Functioning

14 / 15

14. Which function is used to get days, months, or years between two dates?

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

15 / 15

15. What is the default file name of Microsoft Excel file?

A. Workbook.xlsx

B. Workbook1.xlsx

C. Worksheet.xlsx

D. Worksheet1.xlsx

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