.png)
What is the file extension for Microsoft Excel workbooks?
a) .xls
b) .xlsx
c) .docx
d) .pptx
In Excel, which function is used for summing a range of cells?
a) =SUM()
b) =AVERAGE()
c) =COUNT()
d) =MAX()
How can you freeze the top row in Excel so that it remains visible while scrolling?
a) Freeze Panes
b) Split Cells
c) Lock Rows
d) Hide Rows
What does the "VLOOKUP" function in Excel stand for?
a) Vertical Lookup
b) Variable Lookup
c) Value Lookup
d) Vague Lookup
How do you create a chart in Microsoft Excel?
a) Insert > Chart
b) Format > Chart
c) Home > Chart
d) Chart > Create
What does the term "cell reference" mean in Excel?
a) A unique identifier for each cell
b) The content of a cell
c) The color of a cell
d) The location of a cell in the worksheet
Which Excel feature allows you to add up numbers in a selected range instantly?
a) AutoSum
b) QuickTotal
c) SumItUp
d) EasyAdd
What is the purpose of the "IF" function in Excel?
a) To insert images
b) To perform conditional logic
c) To create hyperlinks
d) To calculate percentages
How can you merge cells in Excel?
a) Home > Merge & Center
b) Format > Merge Cells
c) Insert > Merge
d) Cell > Combine
In Excel, which keyboard shortcut is used to paste values only (without formatting)?
a) Ctrl + V
b) Ctrl + Alt + V
c) Ctrl + Shift + V
d) Ctrl + C
What is the purpose of the "PivotTable" feature in Excel?
a) To create custom charts
b) To analyze and summarize data
c) To format cells
d) To import external data
How can you add a new sheet in an Excel workbook?
a) Ctrl + N
b) Home > New Sheet
c) Insert > Sheet
d) File > New > Sheet
What does the function "COUNTIF" do in Excel?
a) Counts the total number of cells in a range
b) Counts the number of cells with specific criteria
c) Counts the average of a range
d) Counts the sum of a range
What does the term "cell formatting" refer to in Excel?
a) Changing the font color
b) Adjusting the cell size
c) Applying styles to a cell
d) All of the above
How can you sort data alphabetically in Excel?
a) Data > Sort A to Z
b) Home > Alphabetical Sort
c) Format > Sort
d) Sort > Ascending
What is the purpose of the "SUMIF" function in Excel?
a) To sum a range based on a condition
b) To count cells with specific criteria
c) To calculate the average of a range
d) To find the maximum value in a range
How can you create a dropdown list in Excel?
a) Data > Dropdown
b) Format > List
c) Data > Data Validation
d) Insert > Dropdown
What is the keyboard shortcut for saving an Excel workbook?
a) Ctrl + S
b) Ctrl + Shift + S
c) Ctrl + Save
d) Alt + S
How can you protect a worksheet in Excel from unwanted changes?
a) Format > Protect Sheet
b) Home > Protect Workbook
c) Insert > Protect
d) File > Protect
In Excel, what does the "COUNTBLANK" function do?
a) Counts the number of non-empty cells in a range
b) Counts the total number of cells in a range
c) Counts the number of empty cells in a range
d) Counts the average of a range
all shortcut keys for "Microsoft PowerPoint
all shortcut keys for "Microsoft excel
Answers: 1. b) 2. a) 3. a) 4. a) 5. a) 6. d) 7. a) 8. b) 9. a) 10. b) 11. b) 12. c) 13. b) 14. d) 15. a) 16. a) 17. c) 18. a) 19. a) 20. c)
Quiz
Microsoft Excel Explorer Quiz 📊🔍
Microsoft Word Wizardry Quiz 📝✨
Microsoft PowerPoint Prodigy Quiz 🎤🖥️
Disclaimer: This quiz is for educational purposes only. The answers are based on general knowledge and may vary in specific Excel versions.
Source: Microsoft Excel Support