Download MS Excel Questions Answers MCQ MS Excel Questions Answers MCQ Practice Set PDF
Microsoft Excel is a powerful and versatile spreadsheet software that has become an essential tool in various fields, from business and finance to education and research. Proficiency in Excel is a valuable skill that can greatly enhance productivity and decision-making. One effective way to test and improve your Excel knowledge is through Multiple Choice Questions (MCQ). In this article, we will delve into a range of Excel-related MCQs and provide detailed answers to help you understand and master this indispensable software.
1)On an excel sheet the active cell in indicated by ?
A) A dotted border
B) A dark wide border
C)A blinking border
D) By italic text
2)The default style for new data keyed in a new workbook is ?
3)A value used in a formula that does not change is called a ?
B) Cell address
4)what term describes a background that appears as a grainy, non smooth surface ?
5)You can convert existing Excel worksheet data and charts to HTML document by using the ?
A) Internet Assistant Wizard
B) Intranet Wizard
C) Import Wizard
D) Export Wizard
6)Macros can be executed from the which of the following menu ?
7)You can check the conditions against ____ when applying conditional formatting ?
A) Cell Value
C) Both of above
D) None of above
8)How is data organized in a spreadsheet ?
A) Rows and columns
B) Layers and planes
C) Lines and spaces
D) Height and width
9) How do you change column width to fit the contents ?
A) Single-click the boundary to the left to the column heading
B) Double click the boundary to the right of the column heading
C) Press Alt and single click anywhere in the column
D) All of above
10)Which function is used for creating a data table ?