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

What is the shortcut to refresh a PivotTable in Excel?
A. F5
B. Alt + F5
C. Ctrl + Alt + F5
D. Ctrl + F5
Answer: Option B
Solution (By JKSSB Mock Tests)
Alt+F5 refreshes PivotTable. Also right-click -> Refresh.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
Which MS Excel tool lets you import raw text file lines and split them across multiple distinct worksheet columns using a delimiter like a comma or tab?
A. Data Validation
B. Merge Cells
C. Text to Columns
D. Flash Fill

Correct Answer: Option C


Explanation:
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns using defined delimiters or fixed character widths.

This question belongs to: Computer Microsoft Office
Question #2
In Access, which of the following is a valid way to set a primary key?
A. Both A and B
B. Set in Datasheet View
C. Use the Primary Key button in Design View
D. Right-click the field in Design View and select Primary Key

Correct Answer: Option A


Explanation:
You can set primary key by right-clicking or clicking the Primary Key button in Design View.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the feature that automatically creates a border when you type three hyphens and press Enter is:
A. AutoFormat As You Type
B. Smart Lookup
C. AutoCorrect
D. Quick Styles

Correct Answer: Option A


Explanation:
Typing three hyphens, underscores, or equal signs and Enter triggers automatic border creation.

This question belongs to: Computer Microsoft Office