Excel Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

179

Excel Questions

1 / 15

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

2 / 15

2. What is the correct value of the function? =ROUND (1.2345,2)

A. 1.24

B. 1.23

C. 1. 25

D. 2

3 / 15

3. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

A. CTRL + F

B. ALT + 1

C. CTRL + SHIFT + F

D. CTRL + 1

4 / 15

4. What function displays row data in a column or column data in a row?

A. Hyperlink

B. Index

C. Transpose

D. Rows

5 / 15

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

A. CTRL + =

B. ALT + =

C. ALT + S

D. CTRL + ALT + =

6 / 15

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

A. Slide presentation

B. Spreadsheet

C. Text document

D. Database

7 / 15

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

8 / 15

8. The total number of columns in a worksheet?

A. 26

B. 256

C. 12,834

D. 16,384

9 / 15

9. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

A. Table Styles

B. Stylish Cells

C. Format as Table

D. Cells as Table

10 / 15

10. Shortcut key CTRL + D is used to ____.

A. Open font dialog box

B. Open format cells dialog box

C. Shift current cell's value in the right cell

D. Fill down in the selection

11 / 15

11. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

A. Lookup

B. VLookup

C. NOW

D. CountIF

12 / 15

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

A. Data

B. Insert

C. Review

D. View

13 / 15

13. In ______ tab you will find AutoSum button.

A. Formatting tab

B. Formulas tab

C. Standard tab

D. Clipboard tab

14 / 15

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

A. true

B. false

15 / 15

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

A. DATE()

B. DATEDIF()

C. DATEVALUE()

D. CURDATE()

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