Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. In Excel To select several cells or ranges that are not touching each other, you would… while selecting
a. hold down the Ctrl key
b. hold down the Shift key
c. hold down the Alt key
d. hold down Ctrl + Shift key
Q. In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button
a. nothing will print because some cells with data have been omitted
b. only the cells with gray background will print
c. the whole sheet will print
d. only the cells with white background will print
Q. In Excel constant is another name for this type of data
a. number
b. equation
c. formula
d. description
Q. In Excel the view that puts a blue a blue line around each page that would be printed is the
a. Print Preview
b. Normal View
c. Page Break Preview
d. Split View
Q. In Excel AutoCalculate will quickly add selected cells if you
a. right click on the status bar and select Sum
b. click the AutoCalculate button on the toolbar
c. use the key combination Ctrl+$
d. double click the selection
Q. In Excel the cell labeled F5 refers to
a. row F column 5
b. column F row 5
c. function available in cells
d. function key F4
Q. In Excel when you are typing an equation into a cell the first thing that must be entered is
a. the first cell referenced
b. parenthesis
c. quotation marks
d. an equal sign
Q. In Excel using the AutoSum button will replace in the selected cell
a. the sum of values in the cell’s column
b. nothing until you select a range of cells
c. the sum of the cell’s row unless you change the range
d. a formula which will add values in the range Excel guesses you want to add
Q. In Excel Book1 is an example of how … are numbered and named during each work session
a. Active cell
b. Formula bar
c. Menu bar
d. Name box
Q. In Excel the following displays the contents of the active cell
a. Active cell
b. Formula bar
c. Menu bar
d. Name box
Q. In Excel Graphics objects on a chart are used to
a. Add emphasis to chart data
b. Add interest to a chart
c. Help explain the chart data
d. All the above
Q. In Excel to select a column the easiest method 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 to select an individual data marker or data label, you must
a. Double click the data series
b. Right click selected marker
c. Click once to select the series markers or labels and click the desired marker or label again
d. Double click the marker or label
Q. In Excel to delete and embedded object, first
a. Double click the object
b. Select the object by clicking it
c. Press the Shift + Delete keys
d. Select it and then press Delete key
Q. This type of software contains rows and columns.
a. Drawing
b. Spreadsheet
c. Database
d. Word processing