In MS Access, what does a 'Crosstab query' do? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what does a 'Crosstab query' do?

A. Aggregates data and displays it with row and column headings (like a pivot)

B. Prompts for input

C. Deletes records based on criteria

D. Creates a new table

Answer: Option A

Solution (By JKSSB Mock Tests)

Crosstab query cross-tabulates data.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

In MS Word, which of the following is not a type of tab stop?

A. Center

B. Left

C. Justify

D. Right

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Word tab stops include Left, Center, Right, Decimal, and Bar. Justify is a text alignment option, not a tab stop.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function returns the year from a date?

A. MONTH()

B. YEARFRAC()

C. DAY()

D. YEAR()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
YEAR(serial_number) returns year.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, which feature allows you to create a list of captions for figures, tables, and equations?

A. Table of Figures

B. Index

C. Table of Contents

D. Bibliography

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Figures generates a list of figures based on captions. Captions are inserted for figures.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs