April 16, 2020
221. Which of the following Excel screen components can NOT be turned on or off? a. Formula Bar
b. Status Bar
c. Tool Bar
d. None of above
222. What happens when you press Ctrl + X after selecting some cells in Excel?
a. The cell content of selected cells disappear from cell and stored in
clipboard
b. The cells selected are marked for cutting
c. The selected cells are deleted and the cells are shifted left
d. The selected cells are deleted and cells are shifted up
223. Which of the following option is not available in Paste Special dialog box? a. Add
b. Subtract
c. Divide
d. SQRT
224. Which command will you choose to convert a column of data into row?
a. Cut and Paste
b. Edit >> Paste Special >> Transpose
c. Both of above
d. None of above
225. It is acceptable to let long text flow into adjacent cells on a worksheet when
a. data will be entered in the adjecent cells
b. no data will be entered in the adjacent cells
c. there is no suitable abbrevition for the text
d. there is not time to format the text
226. Which of the cell pointer indicates you that you can make selection?
a. Doctor’s symbol (Big Plus)
b. small thin plus icon
c. Mouse Pointer with anchor at the tip
d. None of above
227. Which of the cell pointer indicates that you can fill series?
a. Doctor’s symbol (Big Plus)
b. small thin plus icon
c. Mouse Pointer with anchor at the tip
d. None of above
b. Status Bar
c. Tool Bar
d. None of above
222. What happens when you press Ctrl + X after selecting some cells in Excel?
a. The cell content of selected cells disappear from cell and stored in
clipboard
b. The cells selected are marked for cutting
c. The selected cells are deleted and the cells are shifted left
d. The selected cells are deleted and cells are shifted up
223. Which of the following option is not available in Paste Special dialog box? a. Add
b. Subtract
c. Divide
d. SQRT
224. Which command will you choose to convert a column of data into row?
a. Cut and Paste
b. Edit >> Paste Special >> Transpose
c. Both of above
d. None of above
225. It is acceptable to let long text flow into adjacent cells on a worksheet when
a. data will be entered in the adjecent cells
b. no data will be entered in the adjacent cells
c. there is no suitable abbrevition for the text
d. there is not time to format the text
226. Which of the cell pointer indicates you that you can make selection?
a. Doctor’s symbol (Big Plus)
b. small thin plus icon
c. Mouse Pointer with anchor at the tip
d. None of above
227. Which of the cell pointer indicates that you can fill series?
a. Doctor’s symbol (Big Plus)
b. small thin plus icon
c. Mouse Pointer with anchor at the tip
d. None of above
228. Which of the cell pointer indicate that you can move the content to other cell?
a. Doctor’s symbol (Big Plus)
b. small thin plus icon
c. Mouse Pointer with anchor at the tip
d. None of above
229. You can auto fit the width of column by
a. double clicking on the column name on column header
b. Double click on the cell pointer in worksheet
c. Double clicking on column right border on column header
d. Double clicking on the column left border of column header
230. Long text can be broken down into many lines within a cell.
You can do this through
a. Wrap Text in Format >> Cells
b. Justify in Edit >> Cells
c. Text Wrapping in Format >> Cells, Layout tab
d. All of above
231. MS Excel provides the default value for step in Fill Series dialog box
a. 0
b. 1
c. 5
d. 10
232. When a row of data is to be converted into columns
a. Copy the cells in row, select the same number of cells in row and paste
b. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
c. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
d. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
233. Ctrl + D shortcut key in Excel will
a. Open the font dialog box
b. Apply double underline for the active cell
c. Fill down in the selection
d. None of above
234. The short cut key Ctrl + R is used in Excel to
a. Right align the content of cell
b. Remove the cell contents of selected cells
c. Fill the selection with active cells to the right
d. None of above
235. The command Edit >> Fill Across Worksheet is active only when
a. One sheet is selected
b. When many sheets are selected
c. When no sheet is selected
d. None of above
a. Doctor’s symbol (Big Plus)
b. small thin plus icon
c. Mouse Pointer with anchor at the tip
d. None of above
229. You can auto fit the width of column by
a. double clicking on the column name on column header
b. Double click on the cell pointer in worksheet
c. Double clicking on column right border on column header
d. Double clicking on the column left border of column header
230. Long text can be broken down into many lines within a cell.
You can do this through
a. Wrap Text in Format >> Cells
b. Justify in Edit >> Cells
c. Text Wrapping in Format >> Cells, Layout tab
d. All of above
231. MS Excel provides the default value for step in Fill Series dialog box
a. 0
b. 1
c. 5
d. 10
232. When a row of data is to be converted into columns
a. Copy the cells in row, select the same number of cells in row and paste
b. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
c. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
d. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
233. Ctrl + D shortcut key in Excel will
a. Open the font dialog box
b. Apply double underline for the active cell
c. Fill down in the selection
d. None of above
234. The short cut key Ctrl + R is used in Excel to
a. Right align the content of cell
b. Remove the cell contents of selected cells
c. Fill the selection with active cells to the right
d. None of above
235. The command Edit >> Fill Across Worksheet is active only when
a. One sheet is selected
b. When many sheets are selected
c. When no sheet is selected
d. None of above
236. Which of the following series type is not valid for Fill Series dialog box?
a. Linear
b. Growth
c. Autofill
d. Time
237. Which of the following you can paste selectively using Paste Special command?
a. Validation
b. Formats
c. Formulas
d. All of above
b. Growth
c. Autofill
d. Time
237. Which of the following you can paste selectively using Paste Special command?
a. Validation
b. Formats
c. Formulas
d. All of above
238. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? a. Square
b. Percentage
c. Goal Seek
d. Divide
239. Edit >> Delete command
a. Deletes the content of a cell
b. Deletes Formats of cell
c. Deletes the comment of cell
d. Deletes selected cells
240. To remove the content of selected cells you must issue ______ command
a. Edit >> Delete
b. Edit >> Clear >> Contents
c. Edit >> Clear >> All
d. Data >> Delete
Answers:
221 - d
222 - b
223 - d
224 - b
225 - b
226 - a
227 - b
228 - c
229 - c
230 - a
231 - b
232 - d
233 - c
234 - c
235 - b
236 - d
237 - d
238 - d
239 - d
240 - b
b. Percentage
c. Goal Seek
d. Divide
239. Edit >> Delete command
a. Deletes the content of a cell
b. Deletes Formats of cell
c. Deletes the comment of cell
d. Deletes selected cells
240. To remove the content of selected cells you must issue ______ command
a. Edit >> Delete
b. Edit >> Clear >> Contents
c. Edit >> Clear >> All
d. Data >> Delete
Answers:
221 - d
222 - b
223 - d
224 - b
225 - b
226 - a
227 - b
228 - c
229 - c
230 - a
231 - b
232 - d
233 - c
234 - c
235 - b
236 - d
237 - d
238 - d
239 - d
240 - b
0 comments:
Post a Comment