Microsoft Excel Mcqs with Answers for Test Preparation

Which Operation can’t be performed by Queue?

A. Insertion
B. Deletion
C. Retrieving
D. Traversing

What is the purpose of the Ribbon in Excel?

A) To manage file locations
B) To organize and provide quick access to commands and tools
C) To display data in graphical format
D) To filter data in a worksheet

Which part of the Ribbon provides access to frequently used commands like Save, Undo, and Redo?

A) Home Tab
B) Quick Access Toolbar
C) Formula Bar
D) Status Bar

How can you customize the Quick Access Toolbar?

A) By right-clicking on the Ribbon and selecting “Customize Quick Access Toolbar”
B) By clicking on the “File” tab and choosing “Options”
C) By using the “Insert” tab
D) By selecting the “View” tab and adjusting settings

Which Ribbon tab would you use to access features like Conditional Formatting and Data Validation?

A) Home
B) Data
C) Review
D) View

What does the “Home” tab on the Ribbon primarily contain?

A) Commands for managing workbook files
B) Tools for data analysis and chart creation
C) Basic formatting and editing commands
D) Options for setting up page layout and printing

See also  Ideology of Pakistan MCQs with Answers

Which tab would you use to insert charts, pictures, and shapes?

A) Data
B) Home
C) Insert
D) Review

How can you quickly access tools that are not visible on the Ribbon by default?

A) By searching in the “Tell Me” box
B) By using the “Data” tab
C) By right-clicking on the worksheet
D) By going to the “View” tab

What is the “Ribbon Display Options” button used for?

A) To close the Ribbon completely
B) To minimize the Ribbon and show only the tab names
C) To customize the appearance of the Ribbon
D) To add new tabs to the Ribbon

Which area of the Ribbon allows you to group related commands together?

A) Commands
B) Groups
C) Panels
D) Sections

What feature allows you to add or remove commands from the Ribbon?

A) Ribbon Customization
B) Quick Access Toolbar
C) File Options
D) Command Manage

Which type of data cannot be sorted using the Sort feature in Excel?

a) Text
b) Numbers
c) Dates
d) Images

Pages ( 12 of 15 ): « Previous1 ... 11 12 13 ... 15Next »

Leave a Comment