Yash Computer Education

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

MS-Excel Set -1

1. Which tab on the Ribbon do you click to open the Excel backstage view?

1 point

a) Home

b) Insert

c) File

d) Data

Clear selection

2. What is the keyboard shortcut to save a workbook in Excel ?

1 point

a) Ctrl + N

b) Ctrl + S

c) Ctrl + P

d) Ctrl + W

Clear selection

3. Which feature would you use to create a duplicate of the selected cell's content in Excel ?

1 point

a) Cut

b) Copy

c) Paste

d) Format Painter

Clear selection

4. In Excel, how do you apply a predefined set of formatting choices?

1 point

a) Themes

b) Styles

c) Templates

d) Layouts

Clear selection

5. Which function key is used to open the Help dialog box in Excel ?

1 point

a) F1

b) F2

c) F3

d) F4

Clear selection

6. Which feature in Excel allows you to quickly find and replace text?

1 point

a) Find

b) Replace

c) Go To

d) Spelling & Grammar

Clear selection

7. What is the purpose of the 'Track Changes' feature in Excel ?

1 point

a) To highlight formatting changes

b) To keep a record of text changes

c) To correct grammatical errors

d) To track changes made by different users

Clear selection

8. Which tool in Excel 2016 can be used to create a pivot table?

1 point

a) Review

b) References

c) Data

d) Insert

Clear selection

9. In Excel, which view is best for preparing a worksheet for printing?

1 point

a) Normal

b) Page Layout

c) Page Break Preview

d) Custom Views

Clear selection

10. What does the 'Format Painter' tool do in Excel ?

1 point

a) It copies the format of the selected cell and applies it to other cells.

b) It changes the font style.

c) It saves the workbook.

d) It checks the spelling.

Clear selection

11. Which command is used to open an existing workbook in Excel ?

1 point

a) Open

b) New

c) Save As

d) Close

Clear selection

12. What is the default file extension for Excel 2016 workbooks?

1 point

a) .xls

b) .txt

c) .pdf

d) .xlsx

Clear selection

13. In Excel, what is the maximum number of rows in a worksheet?

1 point

a) 65,536

b) 104,8576

c) 1,048,576

d) 1,048,576

Clear selection

14. Which option allows you to create a new sheet in Excel ?

1 point

a) Right-click the sheet tab and select Insert

b) Click the New Sheet button (+) next to the sheet tabs

c) Home tab, Insert button

d) File tab, New option

Clear selection

15. What does the 'Page Layout' tab contain?

1 point

a) Options for margins, orientation, size, columns, etc.

b) Options for themes and styles

c) Tools for editing the workbook

d) Commands for inserting pictures and shapes

Clear selection

16. How can you create a chart in Excel ?

1 point

a) Using the Insert tab

b) Using the Design tab

c) Using the Home tab

d) Using the View tab

Clear selection

17. What is the shortcut for selecting all the cells in a worksheet?

1 point

a) Ctrl + A

b) Ctrl + C

c) Ctrl + D

d) Ctrl + F

Clear selection

18. Which option is used to display the gridlines in Excel?

1 point

a) View tab, Gridlines checkbox

b) Home tab, Gridlines checkbox

c) Insert tab, Gridlines checkbox

d) Page Layout tab, Gridlines checkbox

Clear selection

19. What is the use of the 'Sort & Filter' feature?

1 point

a) To arrange the data in ascending or descending order

b) To correct spelling errors

c) To change the font size

d) To track changes made to the workbook

Clear selection

20. Which command is used to close a workbook in Excel ?

1 point

a) Close

b) Exit

c) Quit

d) End

Clear selection

Submit

Clear form

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Forms