MS Excel MCQs

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

A. Apostrophe ( ‘ )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

A. Hyperlinked placed in a word table

B. Linked

C. Embedded

D. Use the word menu bar and toolbars

A. Deletes the content of a cell

B. Deletes Formats of cell

C. Deletes the comment of cell

D. Deletes selected cells