0

Microsoft Excel

Description: This test contains useful questions related to Microsoft Excel. This test is useful for CS/IT students and other competitive aspirants.
Number of Questions: 18
Created by:
Tags: computer cs gate microsoft office excel Microsoft Excel
Attempted 0/18 Correct 0 Score 0

Which of the following techniques is not used to send the document to other people in Microsoft Excel?

  1. Email

  2. Bluetooth

  3. Internet Fax

  4. Infrared

  5. None of the above


Correct Option: D
Explanation:

The Infrared option is not available in Microsoft Excel to send the document to other people.

Which of the following is an XML based format to save the document?

  1. Excel workbook

  2. Binary workbook

  3. Macro-enabled workbook

  4. Excel 97-2003 workbook

  5. None of the above


Correct Option: C
Explanation:

Macro-enabled workbook option is used to save the document in XML enabled and macro-enabled file format.

Which of the following is not an option to save a document in Microsoft Excel?

  1. Excel workbook

  2. Binary workbook

  3. Macro-enabled work book

  4. Excel 97-2003 workbook

  5. Excel template


Correct Option: E
Explanation:

Excel template option is not present to save a document.

Which of the following is not an option to prepare the document for distribution in Microsoft Excel?

  1. Inspect the document

  2. Encrypt document

  3. Digital signature

  4. Run compatibility checker

  5. Print the document


Correct Option: E
Explanation:

Print the document is not present while preparing the document for distribution.

Which of the following is incorrect about creating document workspace?

  1. It is used to send share the copy of the document.

  2. The local copy of the document will be synchronised with server.

  3. Multiple users can change and use the same document.

  4. A new site can be created in this approach.

  5. It is the default format to save the document.


Correct Option: E
Explanation:

Document workspace is not an option to save the document.

Which of the following option is not present in document properties in Microsoft Excel?

  1. Author

  2. Comments

  3. Title

  4. Status

  5. Version


Correct Option: E
Explanation:

Document version option is not present in document properties.

Which of the following content is not present in document inspection process in Microsoft Excel?

  1. Custom XML data

  2. Memory space

  3. Comments and annotations

  4. Headers and footers

  5. Document properties and personal information


Correct Option: B
Explanation:

Memory space taken by the document is not inspected in document inspection process.

Which of the following is correct about ‘Consolidate’ item in Microsoft Excel?

  1. To prevent invalid data being entered into cell.

  2. To delete duplicate rows from the sheet.

  3. To separate the contents of one Excel into separate columns.

  4. To combine values of multiple ranges into one new range.

  5. To check the values in the cells.


Correct Option: D
Explanation:

Consolidate option is used to combine the values of multiple ranges into a new range.

Which one of the following charts cannot be inserted in the worksheet in Microsoft Excel?

  1. Column chart

  2. Line chart

  3. Pie chart

  4. Area chart

  5. Row chart


Correct Option: E
Explanation:

Row chart is not available in Microsoft excel.

Which of the following is the wrong statement about the table in Microsoft Excel?

  1. It manages the data.

  2. It sorts the data.

  3. It filters the data.

  4. It formats the data.

  5. It copies the data.


Correct Option: E
Explanation:

Table analyses, manages, sorts and formats the data but does not copy the data.

Which of the following is correct about the Pivot table in Microsoft Excel?

  1. It is used to check the table margin.

  2. It checks the user identity.

  3. It summarizes the data in the worksheet.

  4. It modifies the data in the worksheet.

  5. It deletes the data in the worksheet.


Correct Option: C
Explanation:

Pivot table is used to arrange and summarize the complicated data.

Which of the following is an incorrect way to import external data in the worksheet?

  1. From Access

  2. From Web

  3. From Text

  4. From PDF

  5. From SQL Server


Correct Option: D
Explanation:

The external data cannot be imported from PDF.

Which of the following is the correct representation of the columns in the Excel worksheet?

  1. Letters

  2. Numbers

  3. Roman numbers

  4. Special characters

  5. None of the above


Correct Option: B
Explanation:

The columns in the excel worksheet are represented by the numbers.

Which of the following tabs has the save workspace option in Microsoft Excel?

  1. View

  2. Review

  3. Data

  4. Insert

  5. Home


Correct Option: A
Explanation:

The view tab contains the options like save workspace and switch windows.

Which of the following is the wrong option about freezing panes in Microsoft Excel?

  1. To keep rows visible and rest of the sheet scrollable

  2. To keep column visible and rest of the sheet scrollable

  3. To freeze top row

  4. To freeze last row

  5. To freeze first column


Correct Option: D
Explanation:

Freezing panes have the option to freeze the topmost row and first table and it does not freeze the last row.

Which of the following is an incorrect statement about shared workbook?

  1. The workbook can be saved in the networking location.

  2. The workbook can be opened by the multiple users.

  3. The tables in the workbook can be shared.

  4. The workbook can be updated in the shared environment.

  5. The shared workbook can be used by specified list of users.


Correct Option: C
Explanation:

The tables in shared workbook cannot be shared.

Which of the following tabs has an option to delete the duplicate rows from the worksheet in Microsoft Excel?

  1. Data tools

  2. Sort and Filter

  3. Review

  4. Insert

  5. View


Correct Option: A
Explanation:

Duplicate rows can be deleted in the worksheet by using data tools tab.

Which of the following is/are the correct ways to protect the workbook in Microsoft excel?

  1. It does not allow anyone to read and change the document

  2. To specify a list of users and the permissions for them to access the document

  3. To change log-on credentials

  4. To prevent the change in the structure of workbook

  5. All of the above


Correct Option: E
Explanation:

All of the first four options are the correct ways to protect the workbook in Microsoft excel.

- Hide questions