MS Office MCQs

[Q.1] Refer the image:

If we have to copy a formula (located in B2 cell), for multiplying the Quantity values in the row header (located in column 1) and Price values in the column header (Located in Row1), both horizontally and vertically from by using click-and-drag upto column I and row 7, to populate sales revenue values in the table, the formula has to be written as:

(A) =$A2*B$1 (B) =$A$2*B1 (C) =A2*$B$1 (D) =$A$2*$B$1 (E) =A2*B1

Ans: (A) =$A2*B$1

[Q.2] MS Excel file can NOT be directly exported as ______

A. PDF B. TXT C. PPT D. CSV

Ans: (C) PPT

[Q.3] What type of chart is useful for showing trends or changes over time?

(a) Pie Chart (b) Column Chart (c) Line Chart (d) Dot Graph

Ans: (c) Line Chart

[Q.4] What type of chart is useful for comparing parts of a whole ?

A.Pie Chart B.Column Chart C.Line Chart D.Dot Graph

Ans : (A) Pie Chart

[Q.5] How will you graphically represent expenditure in different departments as a proportion of total expenditure of the organization?

A.Column Chart B.Line Chart C.Pie Chart D.Dot Chart

Ans: (C) Pie Chart

[Q.6] What type of chart is useful for comparing values over categories ?

(A)Pie Chart (B) Column Chart (C) Line Chart (D) Dot Graph

Ans: (B) Column Chart