Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
131. In Excel you can activate a cell by
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- all of the above
132. In Excel Text formulas
- Replace cell references
- Return ASCI values of characters
- Concatenate and manipulate text
- Show formula error value
133. In Excel how do you insert a row ?
- Right-click the row heading where you want to insert the new row and select insert from the shortcut menu
- Select the row heading where you want to insert the new row and select edit >Row from the menu
- Select the row heading where you want to insert the new row and click the insert Row button on the standard toolbar
- All of the above
134. In Excel the following is not a basic step in creating a worksheet
- Save workbook
- Modifly the worksheet
- Enter text and data
- Copy the worksheet
135. In Excel how do you select an entire column?
- Select Edit > Select > Column from the menu
- Click the column heading letter
- Hold down the shift key as you click anywhere in the column.
- Hood down the Ctrl key as you click anywhere in the column
136. In Excel how can you print three copies of a workbook ?
- select File > properties form the menu and type 3 in the Copies to print text box.
- Select file > Print from the menu and type 3 in the Number of copies text box.
- Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made
- press Ctrl + P 3
137. In Excel to create a formula, you first
- Select the cell you want to place the formula into
- Type the equals sign (=) to tell Excel that you're about to enter a formula
- Enter the formula using any input values and the appropriate mathematical operators that make up your formula
- Choose the new command from the file menu
138. In Excel to center worksheet titles across a range of cells, you must
- Select the cells containing the title text plus the range over which the title text is to be centered
- Widen the columns
- Select the cells containing the title text is to be enfettered
- Format the cells with the comma style
139. In Excel how do you delete a column ?
- Select the column heading you want to delete and select the Delete Row button on the standard toolbar
- Select the column heading you want to delete and select insert delete from the menu
- Select the row heading you want to delete and select Edit>Delete from the menu
- jRight click the column heading you want to delete and select delete from the shortcut menu
140. In Excel how can you find specific information in a list ?
- Select Tools > Finder from the menu
- Click the Find button on the standard toolbar
- Select Insert > Find from the menu
- Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button