What is Microsoft Excel primarily used for?
A
Word processing B
Creating presentations C
Spreadsheet calculations D
Email management
Analysis & Theory
Excel is mainly used for spreadsheet calculations, data analysis, and charting.
Which of the following is the default file extension of Excel 2016 and later?
A
.xls B
.xlsx C
.docx D
.csv
Analysis & Theory
Excel 2016 and later versions save files by default with the `.xlsx` extension.
Which of the following is a **cell reference** in Excel?
A
A1 B
1A C
A-1 D
RowA1
Analysis & Theory
Cell references in Excel are labeled with column letters and row numbers like `A1`.
What does the **AutoSum (Σ)** feature do?
A
Subtract values B
Multiplies values C
Automatically adds a range of numbers D
Sorts the data
Analysis & Theory
AutoSum adds all numbers in a selected range automatically.
Which symbol is used to start a formula in Excel?
A
# B
@ C
= D
$
Analysis & Theory
Formulas in Excel always start with an `=` sign.
Which function returns the **largest** value in a set of values?
A
MIN() B
LARGE() C
MAX() D
BIGGEST()
Analysis & Theory
`MAX()` returns the highest value in a range.
Which tab contains the **Sort & Filter** options in Excel?
A
Insert B
Page Layout C
Formulas D
Data
Analysis & Theory
The 'Data' tab contains tools like Sort, Filter, and Data Validation.
What is a **Workbook** in Excel?
A
A single cell B
A collection of cells C
A single worksheet D
A collection of worksheets
Analysis & Theory
A workbook is a file containing one or more worksheets.
Which shortcut is used to save a file in Excel?
A
Ctrl + C B
Ctrl + V C
Ctrl + S D
Ctrl + X
Analysis & Theory
`Ctrl + S` is the shortcut to save the workbook.
What does the **Merge & Center** option do in Excel?
A
Centers the text in the page B
Merges multiple cells into one and centers the content C
Deletes merged cells D
Splits one cell into multiple
Analysis & Theory
`Merge & Center` combines selected cells and centers the text in the new cell.