Class 10 Exam  >  Class 10 Tests  >  Olympiad Preparation for Class 10  >  Test: MS Access- 2 - Class 10 MCQ Download as PDF

Test: MS Access- 2 - Class 10 MCQ


Test Description

15 Questions MCQ Test Olympiad Preparation for Class 10 - Test: MS Access- 2

Test: MS Access- 2 for Class 10 2024 is part of Olympiad Preparation for Class 10 preparation. The Test: MS Access- 2 questions and answers have been prepared according to the Class 10 exam syllabus.The Test: MS Access- 2 MCQs are made for Class 10 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: MS Access- 2 below.
Solutions of Test: MS Access- 2 questions in English are available as part of our Olympiad Preparation for Class 10 for Class 10 & Test: MS Access- 2 solutions in Hindi for Olympiad Preparation for Class 10 course. Download more important topics, notes, lectures and mock test series for Class 10 Exam by signing up for free. Attempt Test: MS Access- 2 | 15 questions in 30 minutes | Mock test for Class 10 preparation | Free important questions MCQ to study Olympiad Preparation for Class 10 for Class 10 Exam | Download free PDF with solutions
1 Crore+ students have signed up on EduRev. Have you? Download the App
Test: MS Access- 2 - Question 1

To activate the previous cell in a pre-selected range, press

Detailed Solution for Test: MS Access- 2 - Question 1

To activate the previous cell in a pre-selected range, you need to press a specific key. Let's go through each option to find the correct key.
A: The Alt key
- The Alt key is not used to activate the previous cell in a pre-selected range. It has other functionalities in Excel, such as accessing the ribbon menu.
B: The Tab key
- The Tab key is used to move to the next cell in a pre-selected range, not the previous cell. Pressing Tab will move the cursor to the cell on the right.
C: The Enter key
- The Enter key is used to move to the cell below the current cell in a pre-selected range. It does not activate the previous cell.
D: None of these
- This is the correct answer. None of the options provided (Alt key, Tab key, Enter key) are used to activate the previous cell in a pre-selected range.
In conclusion, the correct key to activate the previous cell in a pre-selected range is not listed among the options provided. Therefore, the answer is D: None of these.
Test: MS Access- 2 - Question 2

In a worksheet you can select

Detailed Solution for Test: MS Access- 2 - Question 2
In a worksheet, you can select:
1. The entire worksheet:
- This option allows you to select the entire worksheet, including all the rows and columns.
- It is useful when you want to perform operations or formatting changes on the entire data set.
2. Rows:
- You can select specific rows in a worksheet by clicking on the row number on the left-hand side of the worksheet.
- This allows you to manipulate or format only the selected rows.
- It is helpful when you want to perform actions on a specific set of data in the worksheet.
3. Columns:
- Similarly, you can select specific columns in a worksheet by clicking on the column letter at the top of the worksheet.
- This allows you to work with or format only the selected columns.
- It is useful when you want to perform operations on a specific set of data in a column.
4. (a), (b), and (c):
- This option refers to selecting the entire worksheet, rows, and columns.
- It means you can select all the rows, all the columns, or both together to perform various actions or formatting changes.
In summary, in a worksheet, you have the flexibility to select the entire worksheet, specific rows, specific columns, or a combination of all three options. This allows you to work efficiently and perform actions on the desired data in the worksheet.
Test: MS Access- 2 - Question 3

You can group non-contiguous worksheets with

Detailed Solution for Test: MS Access- 2 - Question 3

To group non-contiguous worksheets in Microsoft Excel, you can use the following method:
1. The Ctrl key and mouse:
- Open Excel and go to the worksheet tab bar at the bottom of the Excel window.
- Hold down the Ctrl key on your keyboard.
- Click on the first worksheet tab that you want to include in the group.
- While holding down the Ctrl key, click on the other worksheet tabs that you want to include in the group. You can select multiple non-contiguous worksheets using this method.
- Release the Ctrl key after selecting all the desired worksheets.
- The selected worksheets will now be grouped together.
Note: When you group non-contiguous worksheets, any actions or changes you make to one worksheet will apply to all the grouped worksheets simultaneously.
It is important to note that the other options mentioned in the question are not the correct methods to group non-contiguous worksheets:
- The group button on the standard toolbar (Option A) is used to group contiguous worksheets, not non-contiguous ones.
- The shift key and the mouse (Option B) is used to select a range of contiguous worksheets, not non-contiguous ones.
- The alt enter key (Option D) is used to insert a line break within a cell, and it is not related to grouping worksheets.
Therefore, the correct answer is Option C: The Ctrl key and mouse.
Test: MS Access- 2 - Question 4

Which of the following setup options can not be set in the page setup dialog box?

Detailed Solution for Test: MS Access- 2 - Question 4
Setup Options in Page Setup Dialog Box:
The page setup dialog box allows users to customize various settings for printing a document. Here are the setup options that can be set in the page setup dialog box:
1. Orientation: Users can specify whether they want the document to be printed in portrait (vertical) or landscape (horizontal) orientation.
2. Margin settings: Users can adjust the margins of the document, controlling the amount of white space around the content.
3. Paper size: Users can select the size of the paper on which they want to print the document, such as A4, Letter, Legal, etc.
4. Headers and footers: Users can choose to include headers and footers on the printed document, which can contain page numbers, document titles, dates, and other information.
5. Scaling: Users can adjust the scaling of the document, allowing them to print the content at a smaller or larger size.
6. Print quality: Users can select the print quality, choosing between options like draft, normal, or high quality.
7. Page order: Users can specify the order in which the pages should be printed, such as from top to bottom or from left to right.
8. Row and column titles: Users can choose to repeat row and column titles on each printed page, ensuring that the headers are visible on every page.
However, there is one setup option that cannot be set in the page setup dialog box:
- Printer selection: The page setup dialog box does not provide an option to select a specific printer. Printer selection is usually done through the print dialog box, where users can choose the printer they want to use.
Therefore, option A: "Printer selection" cannot be set in the page setup dialog box.
Test: MS Access- 2 - Question 5

You need the insert function dialog box. How do you get it?

Detailed Solution for Test: MS Access- 2 - Question 5
How to get the insert function dialog box:
1. Click the insert menu:
- Move your cursor to the top of the Excel window where you can see different menu options.
- Locate and click on the "Insert" menu tab.
2. Click function:
- After clicking the "Insert" menu, a dropdown list will appear.
- Scroll down and click on the "Function" option.
3. Insert function dialog box:
- Once you click on the "Function" option, the insert function dialog box will appear.
- This dialog box allows you to search for and select a specific function that you want to use in your Excel spreadsheet.
Remember, the correct answer to the question is option B: Click the insert menu and then click function. This is the specific sequence of steps you need to follow to access the insert function dialog box in Excel.
Test: MS Access- 2 - Question 6

When you use the fill effects in the format data series dialog box, you cannot

Detailed Solution for Test: MS Access- 2 - Question 6

When using the fill effects in the format data series dialog box, there are certain limitations and restrictions. One of the limitations is that you cannot rotate text on the chart. Let's break down the options and explain them in detail:
A: Rotate text on the chart
- This option is not available when using fill effects in the format data series dialog box. You cannot rotate the text within the chart using this feature.
B: Select a foreground color
- This option is available in the fill effects dialog box. You can select a foreground color for the data series, which affects the color of the data points or bars in the chart.
C: Select a pattern
- This option is also available in the fill effects dialog box. You can choose from various patterns to fill the data series, such as dots, diagonal lines, or crosshatch patterns.
D: Select a background color
- This option is available in the fill effects dialog box. You can select a background color for the data series, which affects the color of the area behind the data points or bars in the chart.
In summary, when using fill effects in the format data series dialog box, you cannot rotate text on the chart. However, you can still select a foreground color, choose a pattern, and select a background color for the data series.
Test: MS Access- 2 - Question 7

Which of the following is not a basic step in creating a worksheet?

Detailed Solution for Test: MS Access- 2 - Question 7
Explanation:
To determine which of the listed options is not a basic step in creating a worksheet, let's analyze each option:
1. Save the workbook: This is a basic step in creating a worksheet as it ensures that any progress made is saved and can be accessed later.
2. Modify the worksheet: Modifying the worksheet is an essential part of creating a worksheet. It involves formatting, adjusting column widths, adding formulas, and making any necessary changes to the layout.
3. Enter text and data: Entering text and data is one of the fundamental steps in creating a worksheet. It involves inputting relevant information into the cells to build the content of the worksheet.
4. Copy the worksheet: Copying the worksheet is not a basic step in creating a worksheet. While it may be useful in certain situations, such as creating a backup or duplicating a template, it is not an essential step in the initial creation process.
Therefore, the correct answer is D: Copy the worksheet.
Test: MS Access- 2 - Question 8

To insert three columns between columns D and E, you would

Detailed Solution for Test: MS Access- 2 - Question 8

To insert three columns between columns D and E, you need to follow these steps:
1. Select column E:
- Click on the column header labeled "E" to select the entire column.
- Typically, you can click on the letter "E" at the top of the spreadsheet to select the column.
2. Insert three columns:
- Right-click on the selected column header.
- From the context menu, choose the "Insert" option.
- This will insert three new blank columns to the left of the selected column (E).
3. Verify the inserted columns:
- Check that the new columns have been inserted correctly by observing the column labels.
- The three new columns should be labeled D, E, and F, respectively.
By following these steps, you have successfully inserted three columns between columns D and E in your spreadsheet.
Test: MS Access- 2 - Question 9

When integrating MS Word and Excel, the Word is usually the

Detailed Solution for Test: MS Access- 2 - Question 9
When integrating MS Word and Excel, the Word is usually the Client

Explanation:



  • Integration: Integration refers to the process of combining or merging two or more software applications to work together.

  • MS Word and Excel: MS Word is a word processing software, while MS Excel is a spreadsheet software.

  • Client-Server Model: In computing, the client-server model is a distributed application structure that partitions tasks or workloads between the providers of a resource or service, called servers, and service requesters, called clients.

  • Integrating MS Word and Excel: When integrating MS Word and Excel, the Word application is usually considered as the client.

  • Functionality: MS Word acts as a client to request data or perform operations on the Excel application, which acts as the server.

  • Examples: Some examples of integrating MS Word and Excel include importing data from Excel into Word for creating reports, generating mail merges using Excel as a data source, or embedding Excel charts or tables within Word documents.

  • Benefits: Integrating Word and Excel allows users to combine the features of both applications to enhance productivity and create more comprehensive documents.


Therefore, the correct answer is C: Client.

Test: MS Access- 2 - Question 10

The Name box

Detailed Solution for Test: MS Access- 2 - Question 10
The Name box in Excel is a useful tool that allows users to easily navigate and reference specific cells or ranges within a worksheet. Here is a detailed explanation of the Name box and its features:
Definition of the Name box:
The Name box is a designated area in Excel where users can see and enter the names of cells or ranges. It is located to the left of the formula bar, making it easily accessible for users to interact with.
Features of the Name box:
1. Shows location of the previously active cell: When a user selects a cell or range, the Name box displays the address of the previously active cell. This is helpful for users to keep track of their current position within the worksheet.
2. Appears at the left of the formula bar: The Name box is positioned to the left of the formula bar in Excel. This placement ensures that users can quickly locate and utilize the Name box while working with formulas and functions.
3. Allows users to enter names for cells or ranges: Users can also manually enter names for cells or ranges directly into the Name box. This feature enables users to create custom names for specific cells or ranges, making it easier to reference them in formulas or data analysis.
4. Provides a dropdown list of named cells or ranges: The Name box includes a dropdown list that displays all the named cells or ranges within the current workbook. Users can select a name from this list to navigate directly to the corresponding cell or range.
5. Facilitates quick navigation within a worksheet: By entering a cell or range name into the Name box, users can instantly move their active cell to the specified location. This feature eliminates the need for manual scrolling and clicking, making navigation more efficient.
In conclusion, the Name box in Excel serves as a valuable tool for navigating, referencing, and managing cells or ranges within a worksheet. Its placement, functionality, and user-friendly features make it an essential component of Excel's interface.
Test: MS Access- 2 - Question 11

When you work with large worksheets, you may need to

Detailed Solution for Test: MS Access- 2 - Question 11
Working with Large Worksheets in Excel
When working with large worksheets in Excel, there are several techniques you can use to manage and optimize your data. These include:
Sizing the Worksheet to Fit on Specific Pages:
- Adjusting the page setup settings to control how your worksheet is printed
- Specifying the number of pages you want your worksheet to fit on
- Ensuring that the data on each page is legible and not cut off
Adding and Removing Page Breaks:
- Inserting manual page breaks to control where your data is split across pages
- Removing unnecessary page breaks to optimize the layout of your worksheet
Specifying Only Certain Print Areas:
- Selecting specific ranges of cells that you want to print
- Defining print areas to exclude unnecessary data
- Printing only the essential information from your worksheet
All of These:
- Utilizing a combination of these techniques to effectively manage large worksheets in Excel
- Sizing the worksheet, adding and removing page breaks, and specifying print areas can all be used together to create an optimized print output.
In conclusion, when working with large worksheets in Excel, it is important to size the worksheet to fit on specific pages, add and remove page breaks as needed, and specify only certain print areas. By utilizing these techniques, you can effectively manage and optimize your data for printing purposes.
Test: MS Access- 2 - Question 12

You can use the horizontal and vertical scroll bars to

Detailed Solution for Test: MS Access- 2 - Question 12
Answer:
The horizontal and vertical scroll bars in a worksheet allow users to navigate and view different rows and columns of data. Here is a detailed explanation of how the scroll bars are used:
1. Split a worksheet into two panes:
- By using the horizontal and vertical scroll bars, you can split a worksheet into two panes. This is particularly useful when you want to view different sections of a large worksheet simultaneously.
2. View different rows and columns:
- The horizontal scroll bar allows you to scroll left and right, enabling you to view different columns of data that are beyond the visible area of the worksheet.
- The vertical scroll bar allows you to scroll up and down, allowing you to view different rows of data that are not immediately visible.
3. Edit the contents of a cell:
- When you click on a cell in a worksheet, the contents of the cell appear in the formula bar. You can use the horizontal scroll bar within the formula bar to edit the contents of the cell if the text exceeds the width of the formula bar.
4. View different worksheets:
- If a workbook contains multiple worksheets, the horizontal scroll bar can be used to navigate between different sheets. You can scroll left or right to switch between worksheets.
In summary, the horizontal and vertical scroll bars in a worksheet are essential tools for navigating and viewing different rows and columns of data, splitting a worksheet into two panes, editing cell contents, and switching between worksheets.
Test: MS Access- 2 - Question 13

You can add an image to a template by clicking the Insert Picture From File button on the ______ Toolbar.

Detailed Solution for Test: MS Access- 2 - Question 13

To add an image to a template in Microsoft Office, follow these steps:
1. Open the template in Microsoft Office.
2. Look for the toolbar with various options and buttons.
3. Locate the Picture button on the toolbar. This button is represented by an icon that looks like a picture or a camera.
4. Click on the Picture button. This will open a dialog box or a file explorer window.
5. In the dialog box or file explorer window, navigate to the location where the image file is stored on your computer.
6. Select the image file by clicking on it once.
7. Click the Insert or Open button in the dialog box or file explorer window to add the image to the template.
8. The image will now be inserted into the template at the current cursor position.
Please note that the specific toolbar name may vary depending on the version of Microsoft Office you are using. However, the Picture button is commonly used and should be available in most versions.
So, the correct answer is D: Picture toolbar.
Test: MS Access- 2 - Question 14

Whill creating a vertical page break,

Detailed Solution for Test: MS Access- 2 - 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.

Test: MS Access- 2 - Question 15

When the formula bar is activated, you can see

Detailed Solution for Test: MS Access- 2 - Question 15
Explanation:
When the formula bar is activated in a spreadsheet program such as Microsoft Excel, you can see several buttons and options that help you edit and manage formulas. The formula bar is the area at the top of the spreadsheet where you can view and edit the contents of a cell.
The correct answer is option D: All of these. When the formula bar is activated, you can see the following:
The Edit Formula button:
- This button allows you to edit the formula in the selected cell. By clicking on this button, you can make changes to the formula and update the cell's calculation.
The Cancel button:
- This button is used to cancel any changes made to the formula in the selected cell. If you have made any modifications but decide not to apply them, you can click on the Cancel button to revert back to the original formula.
The Enter button:
- This button is used to confirm and apply any changes made to the formula in the selected cell. After editing the formula, you can click on the Enter button to save the changes and recalculate the cell's value.
Therefore, when the formula bar is activated, you can see all of these buttons and options, which allow you to edit, cancel, and apply changes to the formulas in your spreadsheet.
11 videos|36 docs|201 tests
Information about Test: MS Access- 2 Page
In this test you can find the Exam questions for Test: MS Access- 2 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: MS Access- 2, EduRev gives you an ample number of Online tests for practice
11 videos|36 docs|201 tests
Download as PDF
Download the FREE EduRev App
Track your progress, build streaks, highlight & save important lessons and more!