In Excel, to insert a chart sheet (chart on a separate sheet), press: MCQ with Answer and Explanation

In Excel, to insert a chart sheet (chart on a separate sheet), press:
A. Alt + F1
B. Shift + F11
C. Ctrl + F11
D. F11
Answer: Option D
Solution (By JKSSB Mock Tests)
F11 creates a chart on a new chart sheet. Alt+F1 embeds chart in the same sheet.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, what field property constraint must be activated to ensure that users cannot leave a specific field blank when entering a new data record?
A. Input Mask properties
B. Validation Rule
C. Required
D. Indexed field size

Correct Answer: Option C


Explanation:
Setting the 'Required' field property to 'Yes' enforces a data validation constraint that prevents a record from being saved if that specific field is left blank or null.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, which clause in SQL is used to specify the table from which to retrieve data?
A. FROM
B. WHERE
C. INTO
D. SELECT

Correct Answer: Option A


Explanation:
FROM clause specifies table.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, which function is used to calculate the future value of a lump sum?
A. PV
B. FV
C. NPER
D. PMT

Correct Answer: Option B


Explanation:
FV can calculate future value of a lump sum (if PMT=0).

This question belongs to: Computer Microsoft Office