IM-1

Q1. _______ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

A. cell references

B. conditional formatting

C. Excel tables

D. pivot tables

Q2. Which of the following is a logical function?

A. Average

B. If

C. Sumproduct

D. Pivot

Q3. A _______________ helps automate repetitive tasks in Excel by recording your steps

A. Formula

B. Macro

C. Process

D. Solver

Q4. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you press _____ key:

A. Erase

B. Escape

C. Enter

D. Edit Formula

Q5. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Hold titles command on the edit menu

C. Freeze panes command on the window menu

D. Split command on the window menu

Q6. The total number of columns in a worksheet?

A. 26

B. 256

C. 12,834

D. 16,384

Q7. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

A. CTRL + F

B. ALT + 1

C. CTRL + SHIFT + F

D. CTRL + 1

Q8. The currently selected cell address is displayed in ____

A. Name Box

B. Formula Bar

C. Both A and B

D. None of the above

Q9. Which keyboard shortcut is used to apply 'Wrap Text' on the selected text?

A. Ctrl + H + W

B. Alt + W + H

C. Alt + H + W

D. Alt + W

Q10. Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel?

A. Orientation

B. Text Layout

C. Text Flip

D. Cell Orientation