1
A file in Excel that contains one or more worksheets, used to organize data.
Workbook
A single spreadsheet within a workbook where you enter data, formulas, and perform calculations.
Worksheet
The intersection of a row and a column in a worksheet, used to enter data or formulas.
Cell
A selection of two or more cells, identified by the cell references of the upper-left and lower-right corners (e.g., A1:B3).
Range
A mathematical expression used to perform calculations, starting with an equal sign (e.g., =A1+B1).
Formula
Which function finds the highest value in a range?
a) MAX
b) MIN
c) SUM
d) AVERAGE
a) MAX
A predefined formula that simplifies complex calculations, such as SUM, AVERAGE, or IF.
Function
A feature that automatically fills adjacent cells with data based on patterns in existing cells.
AutoFill
A feature that allows you to organize data in ascending or descending order based on one or more columns.
Sort
A feature that applies specific formatting to cells based on the values they contain.
Conditional Formatting
A graphical representation of data, such as bar, pie, line, or scatter charts.
Chart
Which of the following functions is used to count cells with numbers in a range?
a) COUNTIF
b) COUNTA
c) COUNT
d) SUMIF
c) COUNT
A small square at the bottom-right corner of a selected cell, used to copy data or formulas to adjacent cells.
Fill Handle
A feature that adjusts cell content so it wraps to multiple lines within a single cell.
Wrap Text
1. What is the default file extension for Excel 2016?
a) .xls
b) .xlsx
c) .csv
d) .xml
b) .xlsx
2. How do you start a formula in Excel?
a) With a colon
b) With an equal sign
c) With a period
d) With a comma
b) With an equal sign
3. What does the shortcut Ctrl + Z do in Excel?
a) Undo
b) Redo
c) Save
d) Open
a) Undo
Which function returns the smallest number in a range?
a) MAX
b) MIN
c) AVERAGE
d) MEDIAN
b) MIN
4. Which key combination is used to copy selected text or cells?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + Z
d) Ctrl + V
b) Ctrl + C
6. Which function is used to calculate the sum of a range of values?
a) MAX
b) MIN
c) SUM
d) COUNT
c) SUM
7. What does the Fill Handle do?
a) Copies cell contents to adjacent cells
b) Prints the worksheet
c) Adjusts the font size
d) Saves the worksheet
a) Copies cell contents to adjacent cells
9. What is the shortcut to save a workbook?
a) Ctrl + S
b) Ctrl + Z
c) Ctrl + X
d) Ctrl + A
a) Ctrl + S
10. Which function is used to calculate the average of a range?
a) SUM
b) MAX
c) AVERAGE
d) COUNT
c) AVERAGE
What does the formula =A1+B1 do?
a) Subtracts B1 from A1
b) Multiplies A1 by B1
c) Adds A1 and B1
d) Divides A1 by B1
c. Adds A1 and B1
11. Which key combination is used to bold text in Excel 2016?
a) Ctrl + B
b) Ctrl + U
c) Ctrl + I
d) Ctrl + A
a) Ctrl + B
12. Which feature allows you to apply specific formatting based on the value of a cell?
a) Conditional Formatting
b) Data Validation
c) Find and Replace
d) Goal Seek
a) Conditional Formatting
13. How can you merge multiple cells into one?
a) Format Cells
b) Merge & Center
c) Wrap Text
d) Conditional Formatting
b) Merge & Center
14. How can you apply a background color to a cell?
a) Insert → Background
b) Home → Font Color
c) Home → Fill Color
d) View → Background
c) Home → Fill Color
15. Which feature allows you to adjust the width of a column automatically to fit the contents?
a) Wrap Text
b) AutoFit Column Width
c) Format Painter
d) Text Direction
b) AutoFit Column Width
What is the result of the formula =5^2 in Excel?
a) 10
b) 7
c) 52
d) 25
d) 25