Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. In Excel two common wildcard characters that Excel recognizes are
a. * and ?
b. < and >
c. ^ and /
d. + and -
Q. In Excel to add two cells (A1 and A2) together you use the following formula
a. =A1 + A2
b. =Add(A1+A2)
c. =together(A1:A2)
d. A1 plus A2
Q. In Excel on an excel sheet the active cell in indicated by
a. A dark wide boarder
b. A dotted border
c. A blinking border
d. None of above
Q. In Excel on an Excel sheet the active cell inindicated by
a. A dark wide border
b. A dotted border
c. A blinking border
d. None of above
Q. In Excel using the F11 shortcut key to create a chart on chart sheet creates
a. A default chart
b. A 2-dimensional column chart
c. A 2-dimensional bar chart
d. A 3-dimensional line chart
Q. In Excel you can print
a. A range of cells by range name
b. An entire worksheet
c. A single worksheet
d. All of the above
Q. In Excel you can create only a horizontal page break by first selecting
a. A row below the row where you want the page break to occure
b. A cell in row 1
c. A cell in column A
d. (A) and (C)
Q. In Excel you can create hyperlinks from the Excel workbook to
a. A webpage on company internet
b. A web page on the internet
c. Other Office application documents
d. All
Q. In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
a. B1-G10
b. B1.G10
c. B1;G10
d. B1:G10*
Q. In Excel advantage of using a spreadsheet is
a. calculations can be done automatically.
b. changing data automatically updates calculations
c. more flexibility
d. all of the above
Q. In Excel intersection of a row and column is called :
a. Cata
b. A field.
c. A cell
d. An equation.
Q. There are three types of data found in a spreadsheet
a. data, words, numbers
b. equations, data, numbers
c. words, numbers, labels
d. numbers formulas, labels
Q. In Excel to select a column the easiestmethod is to
a. Double click any cell in the column
b. Drag from the top cell in the column to the last cell in the column
c. Click the column heading
d. Click the column label
Q. In Excel if you press ……, the cell accepts your typing as its contents.
a. Enter
b. Ctrl+Enter
c. Tab
d. Insert