In MS Access, which query type displays summarized data in a spreadsheet-like format with rows and columns? MCQ with Answer and Explanation

In MS Access, which query type displays summarized data in a spreadsheet-like format with rows and columns?
A. Select query
B. Crosstab query
C. Parameter query
D. Action query
Answer: Option B
Solution (By JKSSB Mock Tests)
Crosstab query aggregates data and presents it in a grid with row and column headings.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
Which field type in an MS Access database table is most suitable for storing monetary values and financial transaction amounts to avoid rounding errors?
A. Currency
B. Short Text
C. Calculated
D. Number

Correct Answer: Option A


Explanation:
The Currency data type prevents rounding calculations during financial updates, locking precision values up to 4 decimal places.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, what is the function of the 'Crop' tool?
A. To remove unwanted areas of an image
B. To resize an image
C. To rotate an image
D. To change the brightness of an image

Correct Answer: Option A


Explanation:
Crop removes the outer edges of a picture to focus on a specific area. It does not resize (though cropping changes dimensions), adjust brightness, or rotate.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the 'Draft' view shows the document with:
A. Full formatting and page layout
B. Outline structure
C. Minimal formatting, no page breaks
D. Web page preview

Correct Answer: Option C


Explanation:
Draft view (previously Normal view) shows the document with minimal formatting, does not show headers/footers or page breaks, and uses a continuous layout.

This question belongs to: Computer Microsoft Office