Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

174

Excel Questions

1 / 15

1. Statistical calculations and preparation of tables and graphs can be done using

A. Adobe Photoshop

B. Excel

C. Notepad

D. Power Point

2 / 15

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

A. WORKDAY()

B. DAY()

C. WORKDATE()

D. DAYM()

3 / 15

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

A. Column Labels

B. Report Filter

C. Values

D. Formulas

4 / 15

4. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”?

A. Count

B. CountA

C. IF

D. SUM

5 / 15

5. What is the correct syntax of IF() function?

A. =IF (logical_test, {[value_if_true]}, {[value_if_flse]})

B. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

C. =IF (logical_test: [value_if_true], [value_if_false])

D. =IF (logical_test, [value_if_true], [value_if_false])

6 / 15

6. This is not a function category in Excel.

A. Logical

B. Text

C. Financial

D. Data series

7 / 15

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

8 / 15

8. What is the keyboard shortcut to switch between open Excel windows?

A. CTRL + TAB

B. ALT + TAB

C. CTRL + ALT + TAB

D. None of the above

9 / 15

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

10 / 15

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

A. Formula

B. Sorting

C. Filtering

D. Pivot

11 / 15

11. What is the extension of a Microsoft Excel file?

A. msxcl

B. xcl

C. xlsx

D. xlsm

12 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

13 / 15

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

14 / 15

14. Press _____ to bring up search box.

A. Shift + F3

B. Shift + F4

C. Shift + F5

D. Shift + F6

15 / 15

15. The currently selected cell address is displayed in ____.

A. Name Box

B. Formula Bar

C. Both A and B

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