BOS Excel Test Review Questions with
Complete Answers Latest Update 2025
Formula Bar - ✔✔A command line above the worksheet where text, numbers, and formulas
are entered into a worksheet.
name box - ✔✔Displays the cell reference of the active cell. Located at the top of the worksheet.
Spreadsheet - ✔✔A document that stores data in a grid of horizontal rows and vertical columns.
/ (the Forwardslash) - ✔✔In an Excel Formula, it means to divide.
* (the asterisk) (Shift the number 8 key) - ✔✔In an Excel formula, it means to multiply.
Sort - ✔✔Putting data in order
Filter - ✔✔Sorting for items by specific criteria
Max - ✔✔the largest number; =MAX(A2:A6)
, Min - ✔✔The lowest number; =MIN(F14:F55)
AutoFill - ✔✔Completes previously typed words when you begin to repeat the typing
Column Chart - ✔✔Displays vertical bars going across the chart, with the values axis being
displayed on the left side of the chart.
Pie Chart - ✔✔Displays a circle that is divided into sectors which shows a percentage of a whole.
Bar Chart - ✔✔Displays horizontal bars going down the chart with the values axis on the bottom
of the chart.
Line Chart - ✔✔Displays information as a series of data points called 'markers' connected by
straight line segments.
Active Cell - ✔✔The selected cell in Excel, marked by a thick border
Formula - ✔✔An expression which performs a calculation.
AutoSum - ✔✔A function that automatically identifies and adds ranges of cells in your worksheet.
Fill Down - ✔✔A feature that allows you to copy information in an active cell to another cell or
range of cells selected vertically.
Fill Right - ✔✔A feature that allows you to copy information in an active cell to another cell or range
of cells you have selected horizontally.
Function - ✔✔An item that allows you to select a formula that you wish to apply to data in
your worksheet.
Complete Answers Latest Update 2025
Formula Bar - ✔✔A command line above the worksheet where text, numbers, and formulas
are entered into a worksheet.
name box - ✔✔Displays the cell reference of the active cell. Located at the top of the worksheet.
Spreadsheet - ✔✔A document that stores data in a grid of horizontal rows and vertical columns.
/ (the Forwardslash) - ✔✔In an Excel Formula, it means to divide.
* (the asterisk) (Shift the number 8 key) - ✔✔In an Excel formula, it means to multiply.
Sort - ✔✔Putting data in order
Filter - ✔✔Sorting for items by specific criteria
Max - ✔✔the largest number; =MAX(A2:A6)
, Min - ✔✔The lowest number; =MIN(F14:F55)
AutoFill - ✔✔Completes previously typed words when you begin to repeat the typing
Column Chart - ✔✔Displays vertical bars going across the chart, with the values axis being
displayed on the left side of the chart.
Pie Chart - ✔✔Displays a circle that is divided into sectors which shows a percentage of a whole.
Bar Chart - ✔✔Displays horizontal bars going down the chart with the values axis on the bottom
of the chart.
Line Chart - ✔✔Displays information as a series of data points called 'markers' connected by
straight line segments.
Active Cell - ✔✔The selected cell in Excel, marked by a thick border
Formula - ✔✔An expression which performs a calculation.
AutoSum - ✔✔A function that automatically identifies and adds ranges of cells in your worksheet.
Fill Down - ✔✔A feature that allows you to copy information in an active cell to another cell or
range of cells selected vertically.
Fill Right - ✔✔A feature that allows you to copy information in an active cell to another cell or range
of cells you have selected horizontally.
Function - ✔✔An item that allows you to select a formula that you wish to apply to data in
your worksheet.
