TEST III CGS 1060 EXAM 2025
QUESTIONS AND ANSWERS
A cell reference to cells by their fixed position in a worksheet; an absolute cell reference
remains the same when the formula is copied. - ANS Absolute cell reference
In a formula, the address of a cell based on the relative positions of the cell that contains the
formula and the cell referred to in the formula. - ANS Relative cell reference
The area along the bottom of a chart that identifies the categories of data; also referred to as
the x-axis. - ANS Category axis
A command associated with the currently selected or active object; often activated by right-
clicking a screen term - ANS Context sensitive
An equation that Performs mathematical calculations on values in a worksheet. -
ANS Formula
An element in the Excel window that displays the value or formula contained in the active cell;
here you can also enter or edit values or formulas. - ANS Formulas bar
A predefined formula- a formula that Excel has already built for you- that performs calculations
by using specific values in a particular order. - ANS Function
The position of text between the margins (left and right). - ANS Alignment
Copyright ©2025 THEBRIGHT ALL RIGHTS RESERVED 1
,A command that joins selected cells in an Excel worksheet into one larger - ANS Merge &
center
A - ANS The ________ displays the current cell mode, the page number, and the zoom
buttons.
A) status bar
B) Quick Access Toolbar
C) ribbon
D) Formula Bar
A - ANS The ________ include(s) the minimize, close, and restore buttons.
A) application-level buttons
B) Ribbon Display Options buttons
C) worksheet grid area
D) Sheet tab scrolling buttons
C - ANS The ________ displays the columns and rows that intersect to form the worksheet's
A) Name box
B) Quick Access Toolbar
C) worksheet grid area
D) Formula Bar
A - ANS A text value in Excel is also referred to as a ________.
A) label
B) constant
Copyright ©2025 THEBRIGHT ALL RIGHTS RESERVED 2
, C) formula
D) cell address
C - ANS The most commonly used values in a worksheet are ________.
A) text values and time values
B) date values and time values
C) text values and number values
D) date values and labels
A - ANS When you type data in a cell and press Enter, what cell becomes the active cell?
A) The cell below
B) The cell above
C) The insertion point does not move.
D) The cell to the right
C - ANS A cell address is also referred to as a(n) ________.
A) label
B) value
C) cell reference
D) active cell
C - ANS When you type text in a cell it is ________.
A) right-aligned
B) fully justified
Copyright ©2025 THEBRIGHT ALL RIGHTS RESERVED 3
QUESTIONS AND ANSWERS
A cell reference to cells by their fixed position in a worksheet; an absolute cell reference
remains the same when the formula is copied. - ANS Absolute cell reference
In a formula, the address of a cell based on the relative positions of the cell that contains the
formula and the cell referred to in the formula. - ANS Relative cell reference
The area along the bottom of a chart that identifies the categories of data; also referred to as
the x-axis. - ANS Category axis
A command associated with the currently selected or active object; often activated by right-
clicking a screen term - ANS Context sensitive
An equation that Performs mathematical calculations on values in a worksheet. -
ANS Formula
An element in the Excel window that displays the value or formula contained in the active cell;
here you can also enter or edit values or formulas. - ANS Formulas bar
A predefined formula- a formula that Excel has already built for you- that performs calculations
by using specific values in a particular order. - ANS Function
The position of text between the margins (left and right). - ANS Alignment
Copyright ©2025 THEBRIGHT ALL RIGHTS RESERVED 1
,A command that joins selected cells in an Excel worksheet into one larger - ANS Merge &
center
A - ANS The ________ displays the current cell mode, the page number, and the zoom
buttons.
A) status bar
B) Quick Access Toolbar
C) ribbon
D) Formula Bar
A - ANS The ________ include(s) the minimize, close, and restore buttons.
A) application-level buttons
B) Ribbon Display Options buttons
C) worksheet grid area
D) Sheet tab scrolling buttons
C - ANS The ________ displays the columns and rows that intersect to form the worksheet's
A) Name box
B) Quick Access Toolbar
C) worksheet grid area
D) Formula Bar
A - ANS A text value in Excel is also referred to as a ________.
A) label
B) constant
Copyright ©2025 THEBRIGHT ALL RIGHTS RESERVED 2
, C) formula
D) cell address
C - ANS The most commonly used values in a worksheet are ________.
A) text values and time values
B) date values and time values
C) text values and number values
D) date values and labels
A - ANS When you type data in a cell and press Enter, what cell becomes the active cell?
A) The cell below
B) The cell above
C) The insertion point does not move.
D) The cell to the right
C - ANS A cell address is also referred to as a(n) ________.
A) label
B) value
C) cell reference
D) active cell
C - ANS When you type text in a cell it is ________.
A) right-aligned
B) fully justified
Copyright ©2025 THEBRIGHT ALL RIGHTS RESERVED 3
