Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

174

Excel Questions

1 / 15

1. How can you remove borders applied in cells?

A. Choose None on Border tab of Format cells

B. Open the list on Border tool in Formatting toolbar then choose first tool

C. Both of above

D. None

2 / 15

2. Which of the following is NOT a box in the PivotTable Fields List?

A. Column Labels

B. Report Filter

C. Values

D. Formulas

3 / 15

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

4 / 15

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

5 / 15

5. Excel is a ____ program developed by Microsoft.

A. Spreadsheet

B. Document

C. Data management

D. All of the above

6 / 15

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

7 / 15

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

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

8 / 15

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

A. true

B. false

9 / 15

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

10 / 15

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

A. Functions

B. References

C. Formulas

D. Constants

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 display the Format Cells dialog box in MS Excel?

A. CTRL + F

B. ALT + 1

C. CTRL + SHIFT + F

D. CTRL + 1

13 / 15

13. The total number of rows in a worksheet?

A. Unlimited

B. 65,535

C. 1,048,576

D. 1,068,576

14 / 15

14. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

A. true

B. false

15 / 15

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

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