BUS 1350 Final Exam Questions with Correct Answers 100% Verified by Experts| 2025/2026
Latest Update
Tabs Eight areas of activity on the Ribbon that contain groups or collections of related office
commands.
Contextual tabs A tab that is only active when a particular object is selected on the
worksheet
Dialog box launcher A small arrow in the lower-right corner of the group.
Purpose of the Alt Key 1. Modifies other keystrokes
2. Snap to grid
3. Allows you to use the keyboard to issue commands rather than using the touchpad or mouse
Uses of the copy and shift keys ??
Cell Addresses a combination of column letter and a row number that identifies a cell on a
worksheet
fill handle The black square in the lower-right corner of the active cell or range that you drag
over the cells you want to fill. Purpose is to copy.
Ranges the part of the Excel window containing buttons you click to execute Excel
commands
Named ranges Use a name for cell referencing. Treated as an absolute cell reference.
name box Located below the ribbon at the left end of the formula bar. When a user types a
cell location into this box and presses Enter, the insertion point moves to that cell.
,Formula Bar area of Excel used to type formula
Naming Worksheets At bottom of page, double-click name and rename
Moving around and navigation in a worksheet 1. Home- Ctrl + Home or A1
2. Enter - down one row
3. Shift + enter - up one row
4. Tab - one column to right
5. Shift + tab - one column to the left
6. Ctrl + Enter - enter and stay on current cell
Default alignment for text left
Default alignment for values right
###### displayed when column is not wide enough to show data
Scientific notation in Excel automatically converts numbers more than 15 digits as a
precision limit
Truncated Text when one cells contents continue through the next cell to the right if it is
empty; shortens text if values in the next column
How do you display numbers as text in Excel? use an apostrophe '
Line breaks (Excel) Alt + Enter
, How does Excel handles dates? Date is a number corresponding to the number of days since
Jan 1, 1900. Full days are whole numbers and partial days are fractions. Recognizes dates in
standard date formats.
Merge cells To combine two or more cells (a range) into one. Doesn't horizontally center cell
contents.
Wrap text increases row height to display additional new lines added in the cell (button
located on home tab in alignment group)
How to wrap text 1. Home tab > alignment group > wrap text
2. avoid text truncation
3. Hard return > Alt + Enter
Theme located under design tab on home ribbon
autofill extends a formula or a pattern of data values into a selected range and is often
faster than copying and pasting (two actions). Create a series of numbers, dates, or text based
on patterns.
Autofit fits columns to contain all text; double click between columns
AutoComplete excel tries to anticipate remaining characters by displaying text that begins
with the same letters as a previous entry made in the same columns; helps make entering
repetitive text easier and reduces data entry errors.
rotating text a feature that is useful to make the headings go up and down or diagonally.
Located in home tab under alignment
Latest Update
Tabs Eight areas of activity on the Ribbon that contain groups or collections of related office
commands.
Contextual tabs A tab that is only active when a particular object is selected on the
worksheet
Dialog box launcher A small arrow in the lower-right corner of the group.
Purpose of the Alt Key 1. Modifies other keystrokes
2. Snap to grid
3. Allows you to use the keyboard to issue commands rather than using the touchpad or mouse
Uses of the copy and shift keys ??
Cell Addresses a combination of column letter and a row number that identifies a cell on a
worksheet
fill handle The black square in the lower-right corner of the active cell or range that you drag
over the cells you want to fill. Purpose is to copy.
Ranges the part of the Excel window containing buttons you click to execute Excel
commands
Named ranges Use a name for cell referencing. Treated as an absolute cell reference.
name box Located below the ribbon at the left end of the formula bar. When a user types a
cell location into this box and presses Enter, the insertion point moves to that cell.
,Formula Bar area of Excel used to type formula
Naming Worksheets At bottom of page, double-click name and rename
Moving around and navigation in a worksheet 1. Home- Ctrl + Home or A1
2. Enter - down one row
3. Shift + enter - up one row
4. Tab - one column to right
5. Shift + tab - one column to the left
6. Ctrl + Enter - enter and stay on current cell
Default alignment for text left
Default alignment for values right
###### displayed when column is not wide enough to show data
Scientific notation in Excel automatically converts numbers more than 15 digits as a
precision limit
Truncated Text when one cells contents continue through the next cell to the right if it is
empty; shortens text if values in the next column
How do you display numbers as text in Excel? use an apostrophe '
Line breaks (Excel) Alt + Enter
, How does Excel handles dates? Date is a number corresponding to the number of days since
Jan 1, 1900. Full days are whole numbers and partial days are fractions. Recognizes dates in
standard date formats.
Merge cells To combine two or more cells (a range) into one. Doesn't horizontally center cell
contents.
Wrap text increases row height to display additional new lines added in the cell (button
located on home tab in alignment group)
How to wrap text 1. Home tab > alignment group > wrap text
2. avoid text truncation
3. Hard return > Alt + Enter
Theme located under design tab on home ribbon
autofill extends a formula or a pattern of data values into a selected range and is often
faster than copying and pasting (two actions). Create a series of numbers, dates, or text based
on patterns.
Autofit fits columns to contain all text; double click between columns
AutoComplete excel tries to anticipate remaining characters by displaying text that begins
with the same letters as a previous entry made in the same columns; helps make entering
repetitive text easier and reduces data entry errors.
rotating text a feature that is useful to make the headings go up and down or diagonally.
Located in home tab under alignment
