WorksheetsFUNDAMENTAL QUIZ 6
Total questions: 30
Worksheet time: 15mins
What is the main difference between MS Word and MS Excel?
MS Word is used for word processing while MS Excel is used for data analysis
MS Word is a spreadsheet software while MS Excel is a presentation software
MS Word is used for data analysis while MS Excel is used for word processing
MS Word is a presentation software while MS Excel is a spreadsheet software
Which command is used to undo changes in MS Excel?
Cut
Redo
Paste
Copy
What does the 'Font Size' drop-down in MS Excel allow you to do?
Adjust the character size
Apply bold formatting
Change the font color
Change the font style
What does the 'Borders' button with drop-down in MS Excel allow you to do?
Apply a number format
Change the font color
Change the background color
Apply a border to the current selection
Which command in MS Excel is used to align text to the top of the cell?
Middle Align
Bottom Align
Top Align
Orientation
What does the 'Fill Color' button with drop-down in MS Excel allow you to do?
Change the font style
Apply a color to the background of the current selection
Increase the font size
Apply bold formatting
Which command in MS Excel is used to add one decimal place to the current selection?
Percent Style
Comma Style
Increase Decimal
Decrease Decimal
What does the 'Conditional Formatting' drop-down in MS Excel provide access to?
Number formats
Inserting charts
Cell styles
Conditional formatting commands
Which command in MS Excel is used to insert a table style to the current selection?
Format as Table
Recommended Charts
Insert
Cell Styles
What does the 'Recommended Charts' drop-down in MS Excel display?
List of customised pivot tables
List of available fonts
List of recommended charts
List of available colors
Which command in MS Excel is used to create a win/loss chart within a single cell?
Win/Loss
Slicer
Line
Column
What does the 'Link' button with drop-down in MS Excel allow you to do?
Insert a hyperlink
Insert an embedded object
Insert a textbox
Insert a note into the active cell
Which command in MS Excel is used to change the overall look and feel of the workbook?
Themes
Effects
Fonts
Colors
What does the 'Margins' drop-down in MS Excel allow you to do?
Select from different paper sizes
Switch between Portrait and Landscape
Set the print area
Choose from built-in margin settings
Which command in MS Excel is used to bring the selected object forward one level?
Send Backward
Align
Group
Bring Forward
Which command in MS Excel is used to merge cells?
Merge Cells
Split Cells
Combine Cells
Join Cells
Which command in MS Excel is used to freeze panes?
Lock Panes
Freeze Panes
Fix Panes
Secure Panes
What does the 'Sort & Filter' button with drop-down in MS Excel allow you to do?
Apply conditional formatting
Sort and filter data
Insert charts
Change font color
Which command in MS Excel is used to insert a new worksheet?
Insert Sheet
New Sheet
Add Sheet
Worksheet
What does the 'AutoSum' button in MS Excel allow you to do?
Apply a sum formula to the selected cells
Change the font color
Insert a new row
Apply conditional formatting
Which command in MS Excel is used to format numbers as currency?
Currency Format
Number Format
Decimal Format
Money Format
What does the 'Data Validation' feature in MS Excel allow you to do?
Apply custom formatting to cells
Validate data entry based on specific criteria
Insert a new column
Apply conditional formatting
Which command in MS Excel is used to remove duplicates from a selected range?
Remove Duplicates
Filter Data
Sort A to Z
Clear Contents
What does the 'Subtotal' feature in MS Excel allow you to do?
Calculate the average of selected cells
Apply conditional formatting
Insert a new row
Calculate subtotals for a range of data
What does the 'Format Painter' button in MS Excel allow you to do?
Copy formatting from one place and apply it to another
Change the font size
Insert a new row
Apply conditional formatting
Which command in MS Excel is used to insert a comment in a cell?
Insert Comment
Add Note
Comment Cell
Cell Note
What does the 'Data Bars' option in MS Excel provide?
Insert data bars in cells based on cell values
Change font color
Apply conditional formatting
Insert charts
What does the 'Conditional Formatting' drop-down in MS Excel provide access to?
Number formats
Inserting charts
Cell styles
Conditional formatting commands
Which command in MS Excel is used to insert a comment in a cell?
Insert Comment
Add Note
Comment Cell
Cell Note
What does the 'Subtotal' feature in MS Excel allow you to do?
Calculate the average of selected cells
Apply conditional formatting
Insert a new row
Calculate subtotals for a range of data
