Home › Quizzes › Microsoft Excel

Microsoft Excel

This test contains useful questions related to Microsoft Excel. This test is useful for CS/IT students and other competitive aspirants.

18 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

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
Question 2 Multiple Choice (Single Answer)

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
Question 3 Multiple Choice (Single Answer)

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
Question 4 Multiple Choice (Single Answer)

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
Question 5 Multiple Choice (Single Answer)

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.
Question 6 Multiple Choice (Single Answer)

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

  1. Author
  2. Comments
  3. Title
  4. Status
  5. Version
Question 7 Multiple Choice (Single Answer)

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
Question 8 Multiple Choice (Single Answer)

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.
Question 9 Multiple Choice (Single Answer)

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
Question 10 Multiple Choice (Single Answer)

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.
Question 11 Multiple Choice (Single Answer)

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.
Question 12 Multiple Choice (Single Answer)

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
Question 13 Multiple Choice (Single Answer)

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
Question 14 Multiple Choice (Single Answer)

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

  1. View
  2. Review
  3. Data
  4. Insert
  5. Home
Question 15 Multiple Choice (Single Answer)

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
Question 16 Multiple Choice (Single Answer)

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.
Question 17 Multiple Choice (Single Answer)

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
Question 18 Multiple Choice (Single Answer)

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
← Back to Quizzes