Default alignments for text and values - ANS✔✔ Numbers to the right
Text to the left
Truncated text - ANS✔✔ The cell will cut off the word if it overlaps the space provided
Displaying numbers as text - ANS✔✔ Number format box, text (or ' in front of numbers)
Line breaks - ANS✔✔ Start a new line in the same cell (wrap text)
How Excel handles dates - ANS✔✔ Number of days after January 1st, 1900
Paste special/values - ANS✔✔ Specify formatting, only what you want pasted (formatting, text,
values, etc.)
Page setup - ANS✔✔ Page layout, Page setup: A dialog box that includes options to control the
appearance of printed output
Syntax of a function - ANS✔✔ Layout and order of the function (=, function name)
Mixed cell referencing - ANS✔✔ A formula that contains both relative and absolute cell
references
4 ways to edit cells - ANS✔✔ Double click
Click cell then formula bar
Click cell then F2