Questions: Mic ro so ft Exce l 2 013 : Cha pte r 1

1. Why does the appearance of the formula bar change when you start to type an entry?
Excel displays the title in the formula bar and in cell A1. When you begin typing a cell entry, two buttons in the formulas bar turn from gray to colored: the Cancel button and the Enter button .

2. Why does the entered text appear in three cells?

When the text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. If the adjacent cells contains data, Excel would hide the overflow characters in the formula bar whenever that cell is the active cell.

3. What happens when I tap or click the Enter box?
When you click enter the cell will go down, if you click the check mark then the cursor will stay in the same cell.
4. What is the vertical line in cell A1?
The text in cell A1 is followed by the insertion point. The insertion point is a blinking vertical line that indicates where the next typed character will appear.
5. Why is the RIGHT ARROW key used to complete the entry in the cell?
Simply because it is faster.
6. Why is the text left-aligned in the cells?
Because it isn’t numerals.

7. Do I need to enter dollar signs, commas, or trailing ze ros for the amounts?
8. Why are the numbers right-aligned?
Because they are numerals and not text,

9. What if my screen displays a Sum me nu?

10. How does Excel know which cells to sum?
When you enter the SUM function using he Auto Sum button, Excel automatically selects what it considers to be your choice of the range to sum. When proposing the range to sum, Excel first looks for a range of cells with numbers above the active cell and then to the left.
11. What is the purpose of the Sum arrow?
If you click the dropdown bar of the Auto sum button, Excel displays a list of often used functions from which you can choose from. Such as, the average, number of items, max and min value.
12. Why is my fill handle not a black square?
If you are using a touch screen, the fill handle appears as a black and white rectangle with a blue down arrow in it.

13. What is the purpose of the ‘Auto Fill Options’ button?

14. How does Excel create unique totals for each row?
If each cell in a selected range is next to a row of numbers, Excel assigns the S UM function to each cell when you tap or click the S um button.

15. What occurs on the worksheet as I enter the formula?
The equal sign (=) preceding b6–b17 in the formula alerts Excel that you are entering a formula or function and not text. Because the most common error when entering a formula is to reference the wrong cell in a formula, Excel colors the borders of the cells referenced in the fo rmula. The coloring helps in the reviewing process to ensure the cell references are correct. The minus sign (–) following b6 in the formula is the arithmetic operator that directs Excel to perform the subtraction operation.

16. Can I use live preview on a touch screen?
Live preview is not available on a touch screen.

17. Why do several items in the Font group on the ribbon change?

18. What if a cell already includes a bold style?
If the active cell is already bold the Excel displays the Bold button with a darker gray background.
19. How do I re move the bold style from a cell?
Clicking the Bold button a second time removes that style.
20. Can I assign a font size that is not in the Font S ize gallery?
Yes. An alternative to clicking a font size in the front size is list is to select the values in the font size box, type the desired font size, and then press the return key.
21. Which colors does Excel make available in the Font Color galle ry?
You can choose from more than 60 colors in the font gallery.
22. Why does the Font Color button change after I select the new font color?
Excel changes the font color button to the chosen color.
23. What if a cell in the range B1:N1 contains data?
For the “Merge & Center” b utton (HOME tab | Alignment