In MS Access, a 'query' object is used to: MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, a 'query' object is used to:

A. Print formatted output

B. Store data

C. Automate repetitive tasks

D. Retrieve, filter, and perform calculations on data from tables

Answer: Option D

Solution (By JKSSB Mock Tests)

Queries manipulate data.

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, to quickly copy a formula down to adjacent cells, double-click:

A. The fill handle of the cell

B. The column header

C. The cell border

D. The formula bar

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Double-clicking the fill handle copies the formula down as far as contiguous data in the adjacent column.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key sequence to center-align a paragraph block in MS Word?

A. Ctrl + E

B. Ctrl + Alt + C

C. Ctrl + J

D. Ctrl + C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + E is the standard keyboard shortcut used to apply center alignment to text or paragraphs in MS Word.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which of the following formulas calculates the monthly payment for a loan of ₹5,00,000 at 10% annual interest for 5 years?

A. =PV(10%/12, 5*12, -500000)

B. =PMT(10%, 5, 500000)

C. =FV(10%, 5, 500000)

D. =PMT(10%/12, 5*12, -500000)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PMT requires rate per period, total periods, present value. Monthly rate is 10%/12, periods 60, PV -500000.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs