You can prepare effectively for Class 10 Olympiad Preparation for Class 10 with this dedicated MCQ Practice Test (available with solutions) on the important topic of "Test: MS Access- 2". These 15 questions have been designed by the experts with the latest curriculum of Class 10 2026, to help you master the concept.
Test Highlights:
Sign up on EduRev for free to attempt this test and track your preparation progress.
Detailed Solution: Question 1
Detailed Solution: Question 2
Detailed Solution: Question 3
Which of the following setup options can not be set in the page setup dialog box?
Detailed Solution: Question 4
Detailed Solution: Question 5
When you use the fill effects in the format data series dialog box, you cannot
Detailed Solution: Question 6
Which of the following is not a basic step in creating a worksheet?
Detailed Solution: Question 7
Detailed Solution: Question 8
Detailed Solution: Question 9
Explanation:
Therefore, the correct answer is C: Client.
Detailed Solution: Question 10
Detailed Solution: Question 11
Detailed Solution: Question 12
You can add an image to a template by clicking the Insert Picture From File button on the ______ Toolbar.
Detailed Solution: Question 13
Detailed Solution: Question 14
Creating a Vertical Page Break
Answer: C
When creating a vertical page break in Excel, the active cell must be in row 1. This means that the active cell must be located within the first row of the worksheet.
Explanation:
The active cell refers to the cell that is currently selected or highlighted in Excel.
A vertical page break is used to specify where a new page should begin when printing a worksheet.
To create a vertical page break, the active cell must be in row 1, as specified in option C.
Here are the details for each option:
Option A: The active cell must be A1
This option is incorrect because the active cell does not need to be specifically A1 when creating a vertical page break.
Option B: The active cell can be anywhere in the worksheet
This option is incorrect because the active cell must be in row 1, not anywhere in the worksheet.
Option C: The active cell must be in row 1
This option is correct. When creating a vertical page break, the active cell must be located within the first row of the worksheet.
Option D: The active cell must be in column A
This option is incorrect. While the active cell must be in row 1, it does not need to be in column A specifically.
Overall, when creating a vertical page break in Excel, it is important to have the active cell in row 1 as stated in option C. This ensures that the page break is correctly applied to the worksheet when printing.
Detailed Solution: Question 15
70 videos|236 docs|187 tests |
70 videos|236 docs|187 tests |