Data Entry and Cell Formatting MCQs

10
Score: 0
Attempted: 0/10
1. Which key is used to edit the contents of an active cell in MS Excel?





2. What happens when you press Enter after entering data in a cell by default?





3. Which type of data is left-aligned by default in Excel cells?





4. Which type of data is right-aligned by default in Excel cells?





5. Which feature allows long text to be displayed on multiple lines within the same cell?





6. Which option is used to combine two or more cells into one?





7. Which option automatically adjusts the column width to fit the entered data?





8. Which shortcut key inserts the current date in a cell?





9. Which shortcut key is used to cancel data entry in a cell?





10. Which option changes the background color of a cell?





11. Which alignment places text in the center of a cell horizontally?





12. Which option is used to rotate text within a cell?





13. Which dialog box provides all cell formatting options?





14. Which shortcut key applies bold formatting to cell contents?





15. Which shortcut key applies italic formatting to cell contents?





16. Which shortcut key applies underline formatting to cell contents?





17. Which option is used to add borders around a cell?





18. Which feature copies formatting from one cell to another?





19. Which alignment option places text at the bottom of a cell vertically?





20. Which option increases the indentation of text inside a cell?





21. Which shortcut key moves the cursor to the next cell on the right?





22. Which feature helps enter a series of data like numbers or days quickly?





23. Which formatting makes text thicker and darker?





24. Which option clears all formatting from selected cells?





25. Which option changes the font type of selected cell data?





26. Which option changes the size of text in a cell?





27. Which option aligns text to the right side of a cell?





28. Which feature displays ###### when column width is insufficient?





29. Which tab contains most data entry and cell formatting tools?





30. What is the default font in MS Excel (modern versions)?





31. Which option is used to change the color of text inside a cell?





32. Which alignment option places text at the top of a cell vertically?





33. Which shortcut key moves the cursor to the cell above?





34. Which option is used to apply a predefined combination of formatting to a cell?





35. Which option allows numbers to be displayed with commas (e.g., 1,000)?





36. Which dialog box allows changing alignment, font, border, and fill together?





37. Which option is used to decrease the number of decimal places shown in a cell?





38. Which shortcut key fills the selected cell with data from the cell above?





39. Which option changes the direction of text inside a cell?





40. Which formatting option places a line below the text in a cell?





41. Which option is used to increase row height manually?





42. Which option clears only the data but keeps formatting intact?





43. Which key is used to confirm data entry and remain in the same cell?





44. Which alignment option spreads text evenly across the width of a cell?





45. Which option applies borders to the outside of selected cells only?





46. Which feature repeats the last data entry action quickly?





47. Which shortcut key opens the Format Cells dialog box?





48. Which option is used to display negative numbers in red color?





49. Which feature allows entering the same data in multiple selected cells at once?





50. Which option removes merged cells and restores them to individual cells?





51. Which option allows text to overflow into adjacent empty cells?





52. Which option hides cell contents without deleting them?





53. Which alignment option places text in the center of a cell vertically?





54. Which option is used to increase the width of a column?





55. Which shortcut key applies strikethrough formatting to selected cells?





56. Which option repeats text automatically while typing similar entries?





57. Which option allows text to be displayed at an angle inside a cell?





58. Which option clears both data and formatting from selected cells?





59. Which alignment option places text at the left side of a cell?





60. Which shortcut key is used to move to the next cell below?





61. Which option displays numbers as currency symbols?





62. Which option is used to apply a thick border around selected cells?





63. Which feature copies only formatting and not data?





64. Which option allows reducing indentation inside a cell?





65. Which shortcut key moves the cursor to the previous cell on the left?





66. Which option displays text with a line through it?





67. Which option increases the number of decimal places displayed?





68. Which feature allows changing row height automatically to fit content?





69. Which option allows text to be aligned to both left and right margins?





70. Which option removes all cell styles from selected cells?





Contents Copyrights Reserved By T4Tutorials