Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

183

Excel Questions

1 / 15

1. The total number of columns in a worksheet?

A. 26

B. 256

C. 12,834

D. 16,384

2 / 15

2. The NOW function calculates the difference in days between two dates.

A. true

B. false

3 / 15

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

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

4 / 15

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

A. Accessing

B. Referencing

C. Updating

D. Functioning

5 / 15

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

A. CONVERT()

B. TEXT()

C. NUM()

D. CONVERTTEXT()

6 / 15

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

7 / 15

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

8 / 15

8. Press _____ to bring up search box.

A. Shift + F3

B. Shift + F4

C. Shift + F5

D. Shift + F6

9 / 15

9. ____ appear at the bottom of the Excel window.

A. Title bar

B. Formula bar

C. Work sheet tabs

D. Name box

10 / 15

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

A. FIND()

B. INDEX()

C. SEARCH()

D. STRINGSEARCH()

11 / 15

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

12 / 15

12. Excel is a ____ program developed by Microsoft.

A. Spreadsheet

B. Document

C. Data management

D. All of the above

13 / 15

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

14 / 15

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

15 / 15

15. What is the collection of worksheets called?

A. Ledger

B. Book

C. Testbook

D. Workbook

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