In MS Access, to sort records in ascending order in a query, use: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, to sort records in ascending order in a query, use:

A. Ascending order in the Sort row of the query design grid

B. Group By

C. ORDER BY ASC in SQL

D. Both A and B

Answer: Option D

Solution (By JKSSB Mock Tests)

Both design grid sort and SQL ORDER BY ASC work.

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 Excel, which function is used to calculate the slope of a linear regression line?

A. INTERCEPT

B. SLOPE

C. LINEST

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SLOPE, INTERCEPT, and LINEST can all be used for linear regression analysis (LINEST returns array).

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to perform a vertical lookup with approximate match?

A. XLOOKUP

B. INDEX MATCH

C. VLOOKUP(lookup_value, table_array, col_index, TRUE)

D. HLOOKUP

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VLOOKUP with TRUE (or omitted) performs approximate match.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

How do you insert a comment in MS Word?

A. Use Insert tab -> Comment

B. Press Ctrl + M

C. Select text, go to Review tab -> New Comment

D. Right-click and choose 'Insert Note'

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Review tab contains New Comment. Ctrl + M increases indent.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs