Excel Basic Quiz - Learn DA-DS Course in Hindi

QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

Excel Basic Quiz

Fill out the form to attempt test.

1 / 25

Question 1 of 25:

1. What does the "SUM" function in Excel do?

Adds all the numbers in a range

Subtracts numbers in a range

Multiplies numbers in a range

Divides numbers in a range

2 / 25

Question 2 of 25:

2. What is the shortcut key to save an Excel workbook?

Ctrl + P

Ctrl + S

Ctrl + A

Ctrl + Z

3 / 25

Question 3 of 25:

3. Which of the following is the correct way to reference cell B2 in another worksheet named "Data"?

=Data!B2

=B2!Data

Data!B2

B2(Data)

4 / 25

Question 4 of 25:

4. In Excel, what is the default file extension for a workbook?

.xlsm

.xls

.xlsx

.csv

5 / 25

Question 5 of 25:

5. Which formula is used to find the average of a range of numbers?

=AVERAGE()

=MEDIAN()

=SUM()

=COUNT()

6 / 25

Question 6 of 25:

6. How do you adjust the width of a column in Excel?

Right-click on the column and select "AutoFit"

Drag the column border

Double-click on the column header

All of the above

7 / 25

Question 7 of 25:

7. What is the maximum number of rows available in an Excel worksheet (Excel 2016 and later)?

65,536

1,048,576

100,000

500,000

8 / 25

Question 8 of 25:

8. Which of the following Excel functions returns the highest value from a range of numbers?

=MIN()

=AVERAGE()

=MAX()

=MEDIAN()

9 / 25

Question 9 of 25:

9. What does the "COUNT" function do in Excel?

Counts the number of cells with text

Counts the number of cells that contain numbers

Counts the number of non-empty cells

Counts the total number of cells

10 / 25

Question 10 of 25:

10. How can you merge two or more cells in Excel?

Right-click and select "Merge Cells"

Use the shortcut Ctrl + M

Click on "Merge & Center" in the Home tab

Both a and c

11 / 25

Question 11 of 25:

11. What is the function used to find the number of characters in a text string?

=LEN()

=TEXT()

=COUNT()

=CHAR()

12 / 25

Question 12 of 25:

12. How do you freeze the top row in Excel?

Go to View → Freeze Panes → Freeze Top Row

Go to Home → Freeze Row

Right-click on the row and select "Freeze"

Go to Insert → Freeze Panes

13 / 25

Question 13 of 25:

13. What type of chart would you use to show proportions of a whole in Excel?

Column chart

Line chart

Pie chart

Scatter chart

14 / 25

Question 14 of 25:

14. In Excel, which of the following represents a cell range from A1 to D10?

A1-D10

A1:D10

A1;D10

A1,D10

15 / 25

Question 15 of 25:

15. How can you add a new worksheet to an Excel workbook?

Right-click on a worksheet tab and select "Insert"

Click on the "+" button next to the worksheet tabs

Use the keyboard shortcut Ctrl + N

Both a and b

16 / 25

Question 16 of 25:

16. Which of the following is NOT a valid Excel function?

=VLOOKUP()

=HLOOKUP()

LOST()

=RANDBETWEEN()

17 / 25

Question 17 of 25:

17. Which of the following is the correct way to enter a formula in Excel?

Type "Formula"

Start with an equal sign (=)

Use parentheses only

Use a colon (:)

18 / 25

Question 18 of 25:

18. How can you remove a filter in Excel?

Click "Clear Filter" from the dropdown arrow

Go to the Data tab and click "Clear"

Use the keyboard shortcut Ctrl + Shift + L

All of the above

19 / 25

Question 19 of 25:

19. What does the "PMT" function calculate in Excel?

The total payment for a loan

The principal payment on a loan

The monthly payment on a loan

The interest payment on a loan

20 / 25

Question 20 of 25:

20. Which of the following is the shortcut key to bold the text in Excel?

Ctrl + B

Ctrl + I

Ctrl + U

Ctrl + D

21 / 25

Question 21 of 25:

21. How do you open the "Find and Replace" dialog box in Excel?

Ctrl + F

Ctrl + R

Ctrl + H

Both a and c

22 / 25

Question 22 of 25:

22. What is the purpose of the "Wrap Text" feature in Excel?

It adjusts the row height automatically

It makes text visible in one cell without cutting off

It changes text color to fit the cell

It merges text from different cells

23 / 25

Question 23 of 25:

23. What does the "Conditional Formatting" feature in Excel allow you to do?

Automatically change the format of cells based on certain conditions

Change the color of the entire workbook

Modify formulas in cells

Organize sheets alphabetically

24 / 25

Question 24 of 25:

24. What is the purpose of the "SUMIF" function in Excel?

To sum values based on multiple conditions

To sum values based on a single condition

To find the average of values

To count the number of cells

25 / 25

Question 25 of 25:

25. Which key do you press to enter a formula in Excel after typing it?

Tab

Space

Enter

Your score is