Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
211. In Excel how do you change column width to fit the contents >
- Single-click the boundary to the left to the column heading
- Double click the boundary to the right of the column heading
- Press Alt and single click anywhere in the column
- All of above
212. In Excel when you work with large worksheets, you may need to
- Size the worksheet to fit on the specific number of pages
- Add and remove page breaks
- Specify only certain print areas
- All of above
213. In excel Hyperlinks cannot be
- Special shapes like stars and banners
- Drawing objects like rectangles ovals
- Pictures
- All can be hyperlink
214. In excel you can use the horizontal and vertica scroll bars to
- Split a worksheet into two panes
- View different rows and columns
- Edit the contents of a cell
- View different worksheets
215. 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.
- Spreadsheet program
- Database program
- Wordprocessor program
- Desktop publisher program
216. In Excel you can add an image t template by cliking the Insert Picture from File button on the ......... Toolbar
- Standard
- Formatting
- Drawing
- Picture
217. In Excel to drag a selected range of data to another worksheet in the same workbook,l use the
- Tab key
- Alt key
- Shift key
- Ctrl key
218. In Excel when creating a vertical page break
- The active cell must be A1
- The active cell can be anywhere in the worksheet
- The active cell must be row 1
- The Active cell must be in column A
219. In Excel to activate the previous cell in preselected range, press
- The Alt Key
- the Tab key
- The Enter key
- None of above
220. In Excel when the formula bar is activated you can use
- The edit formula button
- the Cancel button
- the Enter button
- all of above