Font size
WorksheetsQUIZ (PART I) - BSCE 1G (1)
Total questions: 41
Worksheet time: 23mins
What file formats can be imported into Excel?
.txt
.csv
.docx
Both a and b
What shortcut is used to find data in a workbook?
CTRL + H
CTRL + F
ALT + F4
CTRL + Z
Which tab allows you to insert hyperlinks in Excel?
Page Layout
Insert
Data
View
Where can you adjust row height and column width?
View tab
Page Layout tab
Home tab
File tab
The Quick Access Toolbar can be customized through:
File > Options
Home > Editing
Insert > Links
View > Freeze Panes
How do you freeze the top row of a worksheet?
View > Freeze Panes > Freeze Top Row
Insert > Freeze
Data > Freeze
Page Layout > Freeze Top Row
Which option allows modifying headers and footers?
Insert > Links
View > Page Break Preview
Data > Outline
Page Layout > Page Setup
Which tab contains workbook view options?
Home
Data
View
Review
Where can you inspect a workbook for issues?
File > Print
File > Info > Check for Issues
View > Workbook Views
Page Layout > Print Area
What shortcut allows saving a workbook in an alternative format?
F12
CTRL + S
ALT + F4
SHIFT + F3
What tool allows navigating named cells?
Go To
Find & Replace
Sort & Filter
Flash Fill
Where do you modify basic workbook properties?
Data > Validation
View > Workbook Views
File > Info
Insert > Object
Which view mode is used to display formulas?
Page Layout
Print Preview
Normal
Formula Auditing Group > Show Formulas
Which group contains the "Find & Replace" feature?
Editing
Insert
Page Setup
View
How do you switch between open workbooks in Excel using the ribbon?
View > Freeze Panes
View > Switch Windows
File > Open > Recent
Home > Editing > Find & Select
Where can you configure print settings?
Home
File > Print
Insert
Data
How do you remove a hyperlink while keeping the text?
Right-click > Remove Hyperlink
Delete the cell
Use the Find & Replace feature
Change the font color manually
Which option allows you to display and modify workbook content in different views?
View > Workbook Views
Home > Format
File > Save As
Insert > Tables
What option allows setting a print area?
File > Save As
View > Workbook Views
Page Layout > Print Area > Set Print Area
Insert > Illustrations
What is the shortcut for inserting a link?
CTRL + L
CTRL + K
CTRL + H
ALT + F3
Which option is used to paste only the values from copied data in Excel?
Paste > Keep Source Formatting
Paste > Transpose
Paste > Merge Formatting
Paste > Paste Special > Values
What is the keyboard shortcut to open the Paste Special dialog box?
Ctrl + V
Ctrl + Alt + V
Ctrl + Shift + V
Alt + V
Which feature automatically fills data based on a detected pattern?
AutoSum
Flash Fill
Data Validation
Conditional Formatting
How do you quickly insert a new row in Excel?
Ctrl + "-" (Numpad)
Alt + "+"
Ctrl + "+" (Numpad)
Shift + "+"
What happens when you merge cells in Excel?
Only the top-left cell's content is kept
All cell contents are combined
The cells are split into multiple columns
The formatting is cleared
Which tool copies formatting from one cell to another?
Format Cells
Format Painter
Cell Styles
Clear Formats
How do you wrap text in a cell?
Home > Number Group > Wrap Text
Home > Number Group > Wrap Text
Home > Font Group > Wrap Text
Home > Alignment Group > Wrap Text
Which shortcut opens the Format Cells dialog box?
Ctrl + 1
Ctrl + 2
Alt + 1
Shift + F1
What does the "Clear Formats" option do?
Deletes cell content
Removes only number formatting
Removes all formatting (bold, colors, borders, etc.)
Merges cells
Which tab contains the "Cell Styles" option?
Insert
Data
Home
Review
Which alignment option allows text to be displayed at an angle?
Wrap Text
Merge & Center
Indent
Orientation
What is the default number format in Excel?
Currency
Percentage
General
Text
How do you apply a border to a cell?
Insert > Borders
Home > Font Group > Borders
Home > Alignment Group > Borders
Page Layout > Borders
Which option is used to increase or decrease decimal places?
Home > Number Group > Increase/Decrease Decimal
Home > Font Group > Decimal
Data > Decimal Places
Format Cells > Alignment
What does the "Merge & Center" option do?
Combines cells and centers content
Splits merged cells
Aligns text to the left
Adds a background color
Which feature allows you to apply predefined formatting styles?
Format Painter
Cell Styles
Conditional Formatting
Data Validation
How do you unmerge cells?
Home > Alignment Group > Unmerge Cells
Right-click > Unmerge
Data > Unmerge
Format Cells > Unmerge
Which option indents text inside a cell?
Home > Alignment Group > Increase Indent
Home > Font Group > Indent
Insert > Indent
Page Layout > Indent
What is the purpose of the "Format Cells" dialog box?
Only to change font size
To insert new cells
To delete cells
To apply advanced formatting (number, alignment, borders, etc.)
Which key combination deletes a selected row?
Ctrl + "+"
Ctrl + "-"
Alt + "-"
Shift + "-"
What did you learn from the Microsoft Excel topics I discussed? Which topics were the most helpful, and what areas still need more clarification or improvement?
