In MS Access, a select query that groups records and calculates sums, averages, etc., uses: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, a select query that groups records and calculates sums, averages, etc., uses:

A. Show row

B. Sort row

C. Totals (Group By) row

D. Criteria row

Answer: Option C

Solution (By JKSSB Mock Tests)

Clicking the Totals button (Σ) adds the Total row for grouping and aggregating.

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 Excel, what does the 'CONCATENATE' function do?

A. Splits text into separate columns

B. Joins two or more text strings into one

C. Converts text to uppercase

D. Compares two text strings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CONCATENATE combines multiple text strings into a single string. In newer versions, CONCAT or TEXTJOIN are also used.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values?

A. Inner Join

B. Left Outer Join

C. Full Cross Join

D. Right Outer Join

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Left Outer Join includes all records from the left table (Table A) and matching rows from the right table (Table B). If no match exists, NULL values appear on the right side.

This question belongs to: Computer Microsoft Office

Question #3

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

A. Counts the words in the document

B. Translates selected text

C. Provides synonyms and antonyms for a selected word

D. Checks the grammar of the document

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs