Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
151. In Excel AutoCalculate will quickly add selected cells if you
- right click on the status bar and select Sum
- Click the Auto Calculate button on the toolbar
- use the key combination Ctrl + $
- double click the selection
152. In Excel the cell labeled F5 refers to
- row F column 5
- Column F row 5
- Function available in cells
- function key F4
153. In Excel when you are typing an equation into a cell the first thing that must be entered is
- The first cell referenced
- Parenthesis
- Quotation marks
- an equal sign
154. In Excel using the Auto Sum button will replace in the selected cell
- the sum of values in the cell's column
- nothing until you select a range of cells
- the sum of the cell's row unless you change the range
- a formula which will add values in the range Excel guesses you want to add
155. In Excel book 1 is an example of how .......are numbered and named during each work session
- Active cell
- Formula bar
- Menu bar
- Name box
156. In Excel the following displays the contents of the active cell
- Active cell
- Formula bar
- Menu bar
- Name box
157. In Excel Graphics objects on a chart are used to
- Add emphasis to chart data
- Add interest to a chart
- Help explain the chart data
- All the above
158. In Excel to select a column the easiest method is to
- Doube click any cell in the column
- Drag from the top cell in the column to the last cell in the column
- Click the column heading
- Click the column label
159. In Excel to select an individual data marker or data label, you must
- Double clik the data series
- Right click selected marker
- Click once to select the series markers r labels and click the desired marker or label again
- Double click the marker or label
160. In Excel to delete and embedded object, first
- Double click the object
- Select the object by clicking it
- Press the Shift + Delete keys
- Select it and then press Delete key