Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

181

Excel Questions

1 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

2 / 15

2. Which function returns the current date?

A. Lookup

B. VLookup

C. CountIF

D. NOW

3 / 15

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

A. Workbook.xlsx

B. Workbook1.xlsx

C. Worksheet.xlsx

D. Worksheet1.xlsx

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. This is not a function category in Excel.

A. Logical

B. Text

C. Financial

D. Data series

6 / 15

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

A. Accessing

B. Referencing

C. Updating

D. Functioning

7 / 15

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

A. Formula

B. Sorting

C. Filtering

D. Pivot

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

11 / 15

11. Under which Tab, the chart options are available in MS Excel?

A. Data

B. Insert

C. Review

D. View

12 / 15

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

A. Column Labels

B. Report Filter

C. Values

D. Formulas

13 / 15

13. MS-Excel uses the ______ Function when creating a data table

A. Average

B. Count

C. Both of These

D. Table

14 / 15

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

A. CONVERT()

B. TEXT()

C. NUM()

D. CONVERTTEXT()

15 / 15

15. Which function is used to get a date n working days in the future or past?

A. WORKDAY()

B. DAY()

C. WORKDATE()

D. DAYM()

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