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

Question

Share Report Error

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

A. Action query

B. Crosstab query

C. Select query

D. Parameter query

Answer: Option B

Solution (By JKSSB Mock Tests)

Crosstab query aggregates data and presents it in a grid with row and column headings.

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

In MS Word, what does the 'Thesaurus' feature do?

A. Counts the words in the document

B. Provides synonyms and antonyms for a selected word

C. Checks the grammar of the document

D. Translates selected text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Thesaurus (Shift+F7) offers synonyms/antonyms.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, what is the result of the formula =LEFT(Microsoft,3)?

A. Soft

B. Microsoft

C. Mic

D. Micro

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
LEFT extracts a specified number of characters from the left side of a text string. LEFT(Microsoft,3) returns Mic.

This question belongs to: Computer Microsoft Office

Question #3

To insert a row above the selected row in Excel, press:

A. All of these

B. Ctrl + Shift + + (plus)

C. Ctrl + +

D. Alt + I, R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
All these shortcuts can insert a row when a row is selected.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs