BUS 1350 – Final Exam, 2026 – Comprehensive review and practice material
Tabs/Contextual Tabs - correct answer ✔✔
Purposes of the Alt Key - correct answer ✔✔ Hold down the Alt key when resizing an element in
order for it to snap to grids.
Uses of the CTRL and shift keys - correct answer ✔✔
Autofill - correct answer ✔✔ A feature that allows you to quickly apply the contents of one cell
to another cell or range of cells selected.
Flash Fill - correct answer ✔✔ Enters text based on patterns it finds in the data
Fill Series - correct answer ✔✔
Fill Handle - correct answer ✔✔ A small square in the lower, right corner of a selected cell or
range of cells. Used mainly to copy data to adjacent cells. Eventually appears as a bolded plus
sign.
Autofill Options - correct answer ✔✔ Button that allows you to copy values with or without
formatting, or the format only
Display formulas (Alt +) or through the ribbon - correct answer ✔✔ Displays the formula in each
cell instead of the value
Numeric formats - correct answer ✔✔ Always right aligned. Can be monetary values, dates, etc.
, Date formats - correct answer ✔✔ Right aligned. Can be changed to include many different
ways of putting a date value.
Alignment/Orientation - correct answer ✔✔ Defines where on the cell the text appears. Left,
Right, Center. Top, Bottom, Middle. Orientation refers to if the text is aligned vertically or
horizontally.
Merge and Center - correct answer ✔✔ A feature that enables you to automatically combine
cells and center the contents of the original far left cell in the new cell.
Wrap Text - correct answer ✔✔ To move data to a new line when the cell is not wide enough to
display all the contents.
Rotating Text - correct answer ✔✔ Allows you to change the angle of the text. Found in the
Alignment Group.
Conditional Formatting - correct answer ✔✔ An Excel feature that enables you to specify how
cells that meet one or more given conditions should be displayed.
Data Bars - correct answer ✔✔ A type of conditional formatting that creates filled background
bars reflecting the relative value stored in each of the formatted cells.
Highlighting Cells - correct answer ✔✔ Can highlight cells based on certain rules. (Text that's
greater than, less than, equal to, contains, duplicate values)
Top/Bottom Conditional Formatting - correct answer ✔✔ Allows you to highlight values based
on if they're in the top 10, bottom 10, top 10%, above averages (etc..). Can be any number or
percent set the format.
Tabs/Contextual Tabs - correct answer ✔✔
Purposes of the Alt Key - correct answer ✔✔ Hold down the Alt key when resizing an element in
order for it to snap to grids.
Uses of the CTRL and shift keys - correct answer ✔✔
Autofill - correct answer ✔✔ A feature that allows you to quickly apply the contents of one cell
to another cell or range of cells selected.
Flash Fill - correct answer ✔✔ Enters text based on patterns it finds in the data
Fill Series - correct answer ✔✔
Fill Handle - correct answer ✔✔ A small square in the lower, right corner of a selected cell or
range of cells. Used mainly to copy data to adjacent cells. Eventually appears as a bolded plus
sign.
Autofill Options - correct answer ✔✔ Button that allows you to copy values with or without
formatting, or the format only
Display formulas (Alt +) or through the ribbon - correct answer ✔✔ Displays the formula in each
cell instead of the value
Numeric formats - correct answer ✔✔ Always right aligned. Can be monetary values, dates, etc.
, Date formats - correct answer ✔✔ Right aligned. Can be changed to include many different
ways of putting a date value.
Alignment/Orientation - correct answer ✔✔ Defines where on the cell the text appears. Left,
Right, Center. Top, Bottom, Middle. Orientation refers to if the text is aligned vertically or
horizontally.
Merge and Center - correct answer ✔✔ A feature that enables you to automatically combine
cells and center the contents of the original far left cell in the new cell.
Wrap Text - correct answer ✔✔ To move data to a new line when the cell is not wide enough to
display all the contents.
Rotating Text - correct answer ✔✔ Allows you to change the angle of the text. Found in the
Alignment Group.
Conditional Formatting - correct answer ✔✔ An Excel feature that enables you to specify how
cells that meet one or more given conditions should be displayed.
Data Bars - correct answer ✔✔ A type of conditional formatting that creates filled background
bars reflecting the relative value stored in each of the formatted cells.
Highlighting Cells - correct answer ✔✔ Can highlight cells based on certain rules. (Text that's
greater than, less than, equal to, contains, duplicate values)
Top/Bottom Conditional Formatting - correct answer ✔✔ Allows you to highlight values based
on if they're in the top 10, bottom 10, top 10%, above averages (etc..). Can be any number or
percent set the format.
