Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

184

Excel Questions

1 / 15

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

A. true

B. false

2 / 15

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

3 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

4 / 15

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

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

5 / 15

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

A. true

B. false

6 / 15

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

7 / 15

7. What function displays row data in a column or column data in a row?

A. Hyperlink

B. Index

C. Transpose

D. Rows

8 / 15

8. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu

A. Edit

B. Format

C. Tools

D. All of the above

9 / 15

9. Which is not a Text function in MS Excel?

A. CODE()

B. CLEAN()

C. CHAR()

D. DB()

10 / 15

10. In ______ tab you will find AutoSum button.

A. Formatting tab

B. Formulas tab

C. Standard tab

D. Clipboard tab

11 / 15

11. Which function is used to trap and handle errors?

A. IFERROR()

B. ERROR()

C. IFNA()

D. IFTRAP()

12 / 15

12. A function inside other function is called

A. Nested Function

B. Round Function

C. Inner Function

D. None of the above

13 / 15

13. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

A. CTRL + F

B. ALT + 1

C. CTRL + SHIFT + F

D. CTRL + 1

14 / 15

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

15 / 15

15. When you insert an Excel file into a Word document, the data are

A. Hyperlinked

B. Placed in a word table

C. Linked

D. Embedded

Your score is

The average score is 42%

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