BUS 1350 EXAM 3 TEST PAPER FULL SOLUTION QUESTIONS AND CORRECT ANSWERS GRADED A+

BUS 1350 EXAM 3 TEST PAPER FULL
SOLUTION QUESTIONS AND CORRECT
ANSWERS GRADED A+

●● Purposes of the Alt Key
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
Answer:


●● Autofill
Answer: A feature that allows you to quickly apply the contents of one
cell to another cell or range of cells selected.


●● Flash Fill
Answer: Enters text based on patterns it finds in the data


●● Fill Series
Answer:


●● 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.


●● Autofill Options
Answer: Button that allows you to copy values with or without
formatting, or the format only


●● Display formulas (Alt +) or through the ribbon
Answer: Displays the formula in each cell instead of the value


●● Numeric formats
Answer: Always right aligned. Can be monetary values, dates, etc.


●● Date formats
Answer: Right aligned. Can be changed to include many different ways
of putting a date value.


●● 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.


●● Merge and Center