NEW
Font size
WorksheetsMS Excel MCQs – PITS Module
Total questions: 40
Worksheet time: 20mins
What is the primary purpose of a spreadsheet?
Storing images and graphics
Organizing, analyzing, and calculating data
Sending emails
Designing presentations
In Excel, a workbook can contain:
Only one worksheet
Only charts
Multiple worksheets
Only formulas
Which tab contains the Font group where you can change text color, size, and style?
Insert
View
Data
Home
What is the intersection of a row and a column called?
Cell
Range
Tab
Sheet
Which of the following is NOT a valid method of entering data in Excel?
In an active cell
In the title bar
In the formula bar
Double-clicking the cell
What key do you press to move to the next cell on the right when entering data?
Enter
Ctrl
Tab
Esc
To create a new workbook, which menu option should you click first?
Insert
Data
File
View
Which of the following actions is performed by the “Undo” button?
Saves the document
Repeats last action
Reverts the most recent change
Exits Excel
To select an entire row in Excel, what should you click?
The column header
The row number
The status bar
The formula bar
Where do you click to insert new rows or columns?
Editing group
Formula tab
Cells group on the Home tab
Review tab
Which of the following allows Excel to automatically adjust the row height or column width to fit content?
Wrap Text
AutoFit
Merge Cells
Format Painter
Which tool do you use to find and replace text in a worksheet?
Sort & Filter
Find & Select
Review tab
Page Layout
Which tab is used to insert SmartArt in Excel?
File
Data
Insert
Review
What group allows you to change picture brightness and contrast?
Format > Size
Format > Adjust
Format > Picture Style
Format > Orientation
What is the function of the "Merge & Center" button?
Combines rows and adds bold formatting
Combines cells and aligns text to left
Combines cells and centers the content
Deletes cells
Which group on the Home tab is used to add borders to cells?
Styles
Font
Number
Editing
Which dialog box allows advanced formatting such as number types, alignment, and fill?
Format Cells
Font Settings
Page Layout
Macro Editor
What tool allows you to rotate text vertically in a cell?
Text Wrap
Orientation
Merge
Shrink Text
Which tab group allows you to insert a hyperlink?
Insert tab
Home tab
Review tab
View tab
To change a worksheet tab’s color, you should:
Use the Fill tool
Use the Page Layout tab
Click Format > Tab Color
Use Find & Replace
To delete a worksheet, which action should you perform?
Select cells and press Delete
Use Format > Clear Sheet
Home > Cells > Delete > Delete Sheet
Press Ctrl+Z
Which group on the Home tab contains the "Hide & Unhide" option?
Alignment
Editing
Cells
Font
What happens when you right-click a worksheet tab and choose “Move or Copy”?
It deletes the worksheet
It renames the worksheet
It allows moving or copying to another location
It opens a formula editor
What happens when Excel does not recognize an entry?
It gives an error
It aligns the text to the left
It skips the cell
It auto-corrects the text
Which of the following is NOT a component of the Ribbon in Excel?
Home
View
Insert
Browser
Which file format allows you to reuse a spreadsheet as a blueprint for future sheets?
.xls
.docx
.pptx
.xlt or template
Which tab contains the commands to align text top, middle, or bottom within a cell?
View
Data
Home
Insert
What are the four choices for merging cells in Excel?
Top, Bottom, Center, Left
Merge & Center, Merge Across, Merge Cells, Unmerge Cells
Merge Rows, Merge Columns, Split Cells, Wrap Text
Combine Cells, Merge Cells, AutoFit, Split Cells
To access external data or connect to other sources, which tab should you use?
Data
Home
View
File
Which of these is NOT a function of Excel mentioned in your lecture?
Coding with VBA
Creating pivot charts
Browsing the internet
Automating tasks
Which tab in the Ribbon allows you to access tools like Zoom and Window arrangement?
Home
Insert
View
Review
To apply a border around a cell, which dropdown should you use?
Cell Styles
Fill Color
Font
Borders
What is the function of the 'SmartArt' tool in Excel?
To draw shapes manually
To create organizational or flow diagrams
To write macros
To insert charts
Which group of options is NOT part of the Format tab for editing pictures?
Adjust
Picture Style
Text Wrapping
Size
How can you rename a worksheet tab?
Double-click the tab
Use Format > Rename
Right-click the tab and select Rename
All of the above
Which keyboard action will immediately remove the last change made in Excel?
Ctrl + Y
Ctrl + S
Ctrl + Z
Ctrl + X
What happens when you use “Merge Across”?
Merges cells vertically
Merges cells across columns without centering
Merges and centers across all rows
Merges text with formulas
Where can you change the font size and style for cell content?
Review tab
Page Layout tab
Font group under Home tab
Insert tab
What happens when you apply the AutoFit Column Width option?
Column resizes to a fixed size
Column disappears
Column width adjusts based on longest content
Text is wrapped within the cell
Which option allows you to search for specific content and replace it within the worksheet?
AutoFill
Find & Replace
Lookup Wizard
Conditional Formatting
