Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

175

Excel Questions

1 / 15

1. Which function will you use to enter current date and time in a worksheet cell?

A. =today()

B. =now()

C. =time()

D. =currentTime()

2 / 15

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

3 / 15

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

A. true

B. false

4 / 15

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

5 / 15

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

A. Workbook.xlsx

B. Workbook1.xlsx

C. Worksheet.xlsx

D. Worksheet1.xlsx

6 / 15

6. Which of the following is an example of text in a spreadsheet?

A. 2763

B. Sales 1994 1995

C. =A1+A2+A3

D. .=sum (A1+A2+A3)

7 / 15

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

A. Column Labels

B. Report Filter

C. Values

D. Formulas

8 / 15

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

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

9 / 15

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

10 / 15

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

A. Name Box

B. Formula Bar

C. Both A and B

D. None of the above

11 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

12 / 15

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

13 / 15

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

14 / 15

14. What is the keyboard shortcut to insert a SUM formula in MS Excel?

A. CTRL + =

B. ALT + =

C. ALT + S

D. CTRL + ALT + =

15 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

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