Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
171. In Excel what does SUMIF function do ?
- Adds up cell values based on a c ondition
- Adds all the numbers in a range of cells
- Returns a subtotal in a list or database
- All of above
172. In Excel you can insert labels for
- All the data markers on a chart
- A data series
- A selected data marker
- All of the above
173. In Excel Tab scrolling buttons
- Allow you to view a different worksheet
- Allow you to view additional worksheet row down
- Allow you to view additional worksheet columns to the right
- Allow you to view additional sheet tabs
175. In Excel to open the Format Cells dialog box, press
- Alt + 1
- Ctrl + 1
- Ctrl + Sjoft + 1
- F1
176. In Excel you can add a hyperlink to your worksheet by pressing
- Alt + K
- Ctrl + H
- Ctrl + K
- Ctrl + Shift + K
177. In Excel to move to the previous worksheet, press
- Alt + PgUp
- Ctrl + PgUp
- Ctrl + PgDn
- Shift + Tab
178. In Excel you can select a single range of cells by
- Clicking the upper-left cell in group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
- Pressing the Ctrl key while dragging over the desired cells
- Pressing the Shift key and an arrow key
- Dragging over the desired cells
179. In Excel which of these will not select all the cells in a document ?
- Clicking three times with the right mouse button in the spreadsheet
- Using the Edit Select all menu
- Pressing Ctrl + A on the keyboard
- Pressing Ctrl + A on the keyboard
180. In Excel you can use the formula palette to
- Format cells containing numbers
- Create and edit formulas containing functions
- Enter assumptions data
- Copy a range of cells