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. Totals (Group By) row

C. Criteria row

D. Sort row

Answer: Option B

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

Share Report

Which view in PowerPoint displays thumbnails of all slides for easy rearrangement?

A. Slide Sorter view

B. Notes Page view

C. Normal view

D. Reading view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Sorter view shows miniature slides, allowing reordering. Normal view is for editing, Reading view for presentation preview.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the maximum file size for a Word document?

A. No limit

B. 32 MB for text only, 512 MB with images (but practically no hard limit)

C. 1 GB

D. 2 GB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Word document maximum size is 32 MB for text, but can be larger with images; however, official limit is 32 MB of text.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following is NOT found on the Slide Show tab in PowerPoint?

A. From Beginning

B. Rehearse Timings

C. Set Up Slide Show

D. Custom Animation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Custom Animation is on the Animations tab.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs