Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
111. In Excell cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
- B1-G10
- B1:G10
- B1;G10
- B1:G10
112. In Excel advantage of using a spreadsheet is
- Calculations can be done automatically.
- Changing data automatically updates calculations
- More flexibility
- All of the above
113. In Excel intersection of a row and column is called:
- Cata
- A field
- A cell
- An equation.
114. There are three types of data found in a sperad sheet
- data, words, numbers
- Equations, data, numbers
- words, numbers, labels
- numbers formulas, labels
115. In Excel to select a column the easiest method is to
- Double click any cell in the column
- Drag from the top cell in the colum to the last cell in the column
- Click the column heading
- Click the column label
116. In Excel if you press............. the cell accepts your typing as its contents.
- Enter
- Ctrl + Enter
- Tab
- Insert
117. In Excel to view a cell comment
- Click the edit comment command on the insert menu
- Click the display comment command on the window menu
- Position the mouse pointer over the cell
- Click the comment command on the view menu
118. In Excel when you want to insert a black imbedded excel object in a word document you can
- Click the object command on the insert menu
- Click the office links button on the standard toolbar
- Click the create worksheet button on the formatting toolbar
- Click the import excel command on the file menu
119. In Excel to save a workbook, you
- Click the save button on the standard toolbar from the menu
- Press Ctrl + F5
- Click Save on the Windows Start button
- Select Edit>Save
120. In Excel you can edit a cell by
- Clicking the formula button
- Double clicking the cell to edit it in-place
- Selecting Edit>Edit Cell from the menu
- None of above