BUS 1350 Final Exam| Baylor BUS 1350 Final Exam Questions with Correct Answers 100%
Verified by Experts| 2025/2026 Latest Update
Tabs/Contextual Tabs
Purposes of the Alt Key Hold down the Alt key when resizing an element in order for it to
snap to grids.
Uses of the CTRL and shift keys
Autofill A feature that allows you to quickly apply the contents of one cell to another cell or
range of cells selected.
Flash Fill Enters text based on patterns it finds in the data
Fill Series
Fill Handle 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 Button that allows you to copy values with or without formatting, or the
format only
Display formulas (Alt +) or through the ribbon Displays the formula in each cell instead of
the value
Numeric formats Always right aligned. Can be monetary values, dates, etc.
Date formats Right aligned. Can be changed to include many different ways of putting a date
value.
, Alignment/Orientation 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 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 To move data to a new line when the cell is not wide enough to display all the
contents.
Rotating Text Allows you to change the angle of the text. Found in the Alignment Group.
Conditional Formatting An Excel feature that enables you to specify how cells that meet one
or more given conditions should be displayed.
Data Bars A type of conditional formatting that creates filled background bars reflecting the
relative value stored in each of the formatted cells.
Highlighting Cells Can highlight cells based on certain rules. (Text that's greater than, less
than, equal to, contains, duplicate values)
Top/Bottom Conditional Formatting 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.
Cell Styles A combination of a font, text color, cell color, and other font attributes applied to
a single cell. Cell Styles are called Quick Styles in other Office programs.
Borders & Fill Options
Verified by Experts| 2025/2026 Latest Update
Tabs/Contextual Tabs
Purposes of the Alt Key Hold down the Alt key when resizing an element in order for it to
snap to grids.
Uses of the CTRL and shift keys
Autofill A feature that allows you to quickly apply the contents of one cell to another cell or
range of cells selected.
Flash Fill Enters text based on patterns it finds in the data
Fill Series
Fill Handle 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 Button that allows you to copy values with or without formatting, or the
format only
Display formulas (Alt +) or through the ribbon Displays the formula in each cell instead of
the value
Numeric formats Always right aligned. Can be monetary values, dates, etc.
Date formats Right aligned. Can be changed to include many different ways of putting a date
value.
, Alignment/Orientation 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 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 To move data to a new line when the cell is not wide enough to display all the
contents.
Rotating Text Allows you to change the angle of the text. Found in the Alignment Group.
Conditional Formatting An Excel feature that enables you to specify how cells that meet one
or more given conditions should be displayed.
Data Bars A type of conditional formatting that creates filled background bars reflecting the
relative value stored in each of the formatted cells.
Highlighting Cells Can highlight cells based on certain rules. (Text that's greater than, less
than, equal to, contains, duplicate values)
Top/Bottom Conditional Formatting 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.
Cell Styles A combination of a font, text color, cell color, and other font attributes applied to
a single cell. Cell Styles are called Quick Styles in other Office programs.
Borders & Fill Options
