In MS Access, a query that groups data and calculates sums, averages, or counts is known as: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, a query that groups data and calculates sums, averages, or counts is known as:

A. Totals query

B. Parameter query

C. Select query

D. Crosstab query

Answer: Option A

Solution (By JKSSB Mock Tests)

A Totals query (using Group By, Sum, Avg, etc.) aggregates data. Crosstab query also aggregates but in a cross-tab format.

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

What is the keyboard shortcut to right-align a selected paragraph or text line in MS Word?

A. Ctrl + J

B. Ctrl + E

C. Ctrl + L

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + R is the standard shortcut to apply a right-alignment format to selected text blocks in MS Word.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What will be the result of the MS Excel formula =AVERAGE(10, 20, 30) if entered into a modern worksheet?

A. #VALUE!

B. 15

C. 30

D. 20

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
When passed directly as individual arguments inside a formula, numeric strings are parsed into numbers. Thus, (10 + 20 + 30) / 3 = 20.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to open the 'Font' dialog box in MS Excel?

A. Ctrl + D

B. Ctrl + F

C. Ctrl + 1

D. Ctrl + Shift + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In Excel, Ctrl+1 opens Format Cells, not Font specifically. Ctrl+Shift+F opens the Format Cells dialog with the Font tab active. Ctrl+D fills down. Ctrl+F is Find. So Ctrl+Shift+F is correct for Font.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs