Download MS Excel Questions Answers MCQ MS Excel Questions Answers MCQ Practice Set PDF
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 ?
A) Comma
B) Normal
C) Currency
D) Percent
3)A value used in a formula that does not change is called a ?
A) Constant
B) Cell address
C) Varaible
D) Static
4)what term describes a background that appears as a grainy, non smooth surface ?
A) Pattern
B) Gradient
C) Texture
D) Velvet
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 ?
A) Format
B) Home
C) Insert
D) Tools
7)You can check the conditions against ____ when applying conditional formatting ?
A) Cell Value
B) Formula
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 ?
A) Sum
B) Table
C) Add
D) Count