Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. In Excel when integrating Ms-Word and Excel,Word is usually the
a. Server
b. Source
c. Client
d. None
Q. In Excel Charts tips can
a. Show the formatting of a data label
b. Show the name of a data series
c. Show the value of data point
d. Both (B) and (C)
Q. In Excel the Name box
a. Shows the location of the previously active cell
b. Appears t the left of the formula bar
c. Appears below the status bar
d. Appears below the menu bar
Q. In Excel how do you change column width tofit 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
Q. In Excel when you work with large worksheets, you may need to
a. Size the worksheet to fit on the specific number of pages
b. Add and remove page breaks
c. Specify only certain print areas
d. All of above
Q. In Excel you can use the horizontal and vertical scroll bars to
a. Split a worksheet into two panes
b. View different rows and columns
c. Edit the contents of a cell
d. View different worksheets
Q. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
a. Spreadsheet program
b. Database program
c. Word processor program
d. Desktop publisher program
Q. In Excel you can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
a. Standard
b. Formatting
c. Drawing
d. Picture
Q. In Excel to drag a selected range of data to another worksheet in the same workbook, use the
a. Tab key
b. Alt key
c. Shift key
d. Ctrl key
Q. In Excel when creating a vertical page break
a. The active cell must be A1
b. The active cell can be anywhere in the worksheet
c. The active cell must be in row 1
d. The active cell must be in column A
Q. In Excel to activate the previous cell in a pre- selected range, press
a. The Alt key
b. The Tab key
c. The Enter key
d. None of above
Q. In Excel when the formula bar is activated,you can see
a. The Edit Formula button
b. The Cancel button
c. The Enter button
d. All of above
Q. When you print preview a worksheet
a. the entire worksheet is displayed
b. the selected range is displayed
c. the active portion of the worksheet is displayed
d. All of the above
Q. In Excel to access the Go To Special feature, you can press
a. Ctrl + G
b. Ctrl + O
c. Ctrl + Shift + G
d. Ctrl + 1