BUS 1350 FINAL EXAM UPDATED ACTUAL QUESTIONS
AND CORRECT ANSWERS
Question:
1. Tabs/Contextual Tabs
Answer:
Question:
2. Purposes of the Alt Key
Answer:
Hold down the Alt key when resizing an element in order for it to snap to grids.
Question:
3. Uses of the CTRL and shift keys
Answer:
Question:
4. Autofill
Answer:
A feature that allows you to quickly apply the contents of one cell to another cell
or range of cells selected.
Question:
5. Flash Fill
Answer:
Enters text based on patterns it finds in the data
Question:
6. Fill Series
Answer:
Question:
7. Fill Handle
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.
, Question:
8. Autofill Options
Answer:
Button that allows you to copy values with or without formatting, or the format
only
Question:
9. Display formulas (Alt +) or through the ribbon
Answer:
Displays the formula in each cell instead of the value
Question:
10. Numeric formats
Answer:
Always right aligned. Can be monetary values, dates, etc.
Question:
11. Date formats
Answer:
Right aligned. Can be changed to include many different ways of putting a date
value.
Question:
12. Alignment/Orientation
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.
Question:
13. Merge and Center
Answer:
A feature that enables you to automatically combine cells and center the contents
of the original far left cell in the new cell.
Question:
14. Wrap Text
Answer:
To move data to a new line when the cell is not wide enough to display all the
contents.
AND CORRECT ANSWERS
Question:
1. Tabs/Contextual Tabs
Answer:
Question:
2. Purposes of the Alt Key
Answer:
Hold down the Alt key when resizing an element in order for it to snap to grids.
Question:
3. Uses of the CTRL and shift keys
Answer:
Question:
4. Autofill
Answer:
A feature that allows you to quickly apply the contents of one cell to another cell
or range of cells selected.
Question:
5. Flash Fill
Answer:
Enters text based on patterns it finds in the data
Question:
6. Fill Series
Answer:
Question:
7. Fill Handle
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.
, Question:
8. Autofill Options
Answer:
Button that allows you to copy values with or without formatting, or the format
only
Question:
9. Display formulas (Alt +) or through the ribbon
Answer:
Displays the formula in each cell instead of the value
Question:
10. Numeric formats
Answer:
Always right aligned. Can be monetary values, dates, etc.
Question:
11. Date formats
Answer:
Right aligned. Can be changed to include many different ways of putting a date
value.
Question:
12. Alignment/Orientation
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.
Question:
13. Merge and Center
Answer:
A feature that enables you to automatically combine cells and center the contents
of the original far left cell in the new cell.
Question:
14. Wrap Text
Answer:
To move data to a new line when the cell is not wide enough to display all the
contents.
