Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

176

Excel Questions

1 / 15

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

A. true

B. false

2 / 15

2. What function will result in the total number of entries in the cell range B5 to B14

A. Count

B. MAX

C. MIN

D. SUM

3 / 15

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

A. true

B. false

4 / 15

4. What is the collection of worksheets called?

A. Ledger

B. Book

C. Testbook

D. Workbook

5 / 15

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

6 / 15

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

7 / 15

7. Excel is a ____ program developed by Microsoft.

A. Spreadsheet

B. Document

C. Data management

D. All of the above

8 / 15

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

A. Title bar

B. Formula bar

C. Work sheet tabs

D. Name box

9 / 15

9. Which bar show the used formula of selected active cell?

A. Formula bar

B. Ribbon

C. Menu bar

D. Scroll bar

10 / 15

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

A. msxcl

B. xcl

C. xlsx

D. xlsm

11 / 15

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

A. Formula

B. Sorting

C. Filtering

D. Pivot

12 / 15

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

13 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

14 / 15

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

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

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