Excel quiz questions

Excel interview questions

1.
Which key do you press to group two or more nonadjacent worksheets?
1. CTRL.
2. SHIFT
3. ALT
Answer
2.
To add a new row, click a cell in the row immediately above where you want the new row.
1. True
2. False
Answer
3.
###### means:
1. You've entered a number wrong
2. You've misspelled something.
3. The cell is not wide enough.
Answer
4.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
1. True
2. False
Answer
5.
How do you change column width to fit the contents?
1. Single-click the boundary to the left of the column heading.
2. Double-click the boundary to the right of the column heading.
3. Press ALT and single-click anywhere in the column
4. None of above
Answer
6.
Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
1. Click the Paste button on the Standard toolbar.
2. Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
3. Click the arrow on the Paste button on the Standard toolbar, then click Values
Answer
7.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
1. Click Subtotals on the Data menu
2. View the sum in the formula bar
3. Click the AutoSum button on the Standard toolbar, then press ENTER
Answer