What is the shortcut to refresh a PivotTable in Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the shortcut to refresh a PivotTable in Excel?

A. F5

B. Ctrl + Alt + F5

C. Alt + F5

D. Ctrl + F5

Answer: Option C

Solution (By JKSSB Mock Tests)

Alt+F5 refreshes PivotTable. Also right-click -> Refresh.

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 MS Word, which of the following is not a feature of the 'Mail Merge'?

A. Spreadsheets

B. Envelopes

C. Labels

D. Letters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Mail Merge can create letters, labels, envelopes, and emails. Spreadsheets are data sources, not output.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to calculate the arithmetic mean of a set of numbers?

A. AVERAGEA

B. AVERAGE

C. MODE

D. MEDIAN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
AVERAGE is the arithmetic mean. AVERAGEA includes logical values, MEDIAN is middle value, MODE is most frequent.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, what is the maximum number of fields in a table?

A. 256

B. 64

C. 255

D. 1,000

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
An Access table can have up to 255 fields.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs