Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. In Excel to open an existing workbook, you can click the Open button on the …… toolbar.
a. Drawing
b. Formatting
c. Forms
d. Standard
Q. In Excel you can activate a cell by
a. Pressing the Tab key
b. Clicking the cell
c. Pressing an arrow key
d. All of above
Q. In Excel the following setup options cannot be set in the page setup dialog box?
a. Printer selection
b. Vertical or horizontal placement
c. Orientation
d. Row and column titles
Q. In Excel term refers to a specific set of values saved with the workbook
a. Range
b. Scenario
c. Trend line
d. What-if analysis
Q. In Excel got functions? No? You need the insert function dialog box. How do you get it?
a. Right click a cell and then click insert
b. Click the insert menu and then click function
c. Type = in a cell
d. All of the above
Q. In Excel when you use the fill effects in the format data series dialog box, you cannot
a. Rotate text on the chart
b. Select a fore ground color
c. Select a pattern
d. Select a background color
Q. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
a. Rows and column
b. Headings
c. Speed
d. None
Q. In Excel the following is not a basic step increating a worksheet
a. Save the workbook
b. Modify the worksheet
c. Enter text and data
d. Copy the worksheet
Q. In Excel what does SUMIF function do?
a. Adds up cell values based on a condition
b. Adds all the numbers in a range of cells
c. Returns a subtotal in a list or database
d. All of above
Q. In Excel you can insert labels for
a. All the data markers on a chart
b. A data series
c. A selected data marker
d. All of the above
Q. In Excel Tab scrolling buttons
a. Allow you to view a different worksheet
b. Allow you to view additional worksheet row down
c. Allow you to view additional worksheet columns to the right
d. Allow you to view additional sheet tabs
Q. In Excel to open the Format Cells dialog box, press
a. Alt + 1
b. Ctrl + 1
c. Ctrl + Shift + 1
d. F1
Q. In Excel you can add a hyperlink to your worksheet by pressing
a. Alt + K
b. Ctrl + H
c. Ctrl + K
d. Ctrl + Shift + K
Q. In Excel to move to the previous worksheet, press
a. Alt + PgUp
b. Ctrl + PgUp
c. Ctrl + PgDn
d. Shift + Tab