MS Excel MCQs

A. Number format

B. Border format

C. Font format

D. All of above

A. Click the edit comment command on the insert menu

B. Click the display comment command on the window menu

C. Position the mouse pointer over the cell

D. Click the comment command on the view menu

A. With the copy, paste and cut commands on the edit menu

B. With commands on the shortcut menu

C. With buttons on the standard toolbars

D. All of the above

A. Use =if() function to format the required numbers red

B. Apply Conditional Formatting command on Format menu

C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

D. All of above

A. Accessing

B. Referencing

C. Updating

D. Functioning

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and Charts

A. !A!1

B. $A$1

C. #a#1

D. A1

A. $

B. *

C. %

D. &

A. Review > Window

B. View > Window > Split

C. Window > Split

D. View > Split