MS Excel MCQs

A. Pmt

B. Average

C. Max

D. Sum

A. Towards the bottom right corner

B. Towards the bottom left corner

C. Towards the top right corner

D. Towards the top left corner

A. Copy the cells in row, select the same number of cells in row and paste

B. Copy the cells in column then choose Paste Special, then click Transpose and OK

C. Copy the cells then go to 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 Paste Special, mark Transpose check box and click OK

A. You can search for bold and replace with italics

B. You can decide whether to look for the whole word or not

C. You can search in formula too

D. You can search by rows or columns or sheets

A. Standard Formulas

B. Array Formula

C. Complex Formulas

D. Smart Formula

A. Format cells containing numbers

B. Create and edit formula containing functions

C. Enter assumptions data

D. Copy a range of cells

A. Apostrophe ( ‘ )

B. Exclamation ( ! )

C. Hash ( # )

D. Tilde ( ~ )

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

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

A. Shows the name of workbook currently working on

B. Shows the name of worksheet currently working on

C. Shows the name of cell or range currently working on

D. None of above