This essay Questions: Micro soft Excel 2013 : Chapter 1 has a total of 1308 words and 7 pages.
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
Topics Related to Questions: Micro soft Excel 2013 : Chapter 1
Spreadsheet software, Numbers, Point and click, T cell, Microsoft Excel, Spreadsheet
Essays Related to Questions: Micro soft Excel 2013 : Chapter 1
Part A - Excel Spreadsheet Practical Test Part A - Excel Spreadsheet Practical Test The World Famous Web Shopping Experience You are lucky enough to win $2,000,000 dollars in a lottery that allows you to go on a web shopping spree. You can search the Internet for all the things you would love to buy but couldn't because your allowance just wasn't big enough. INSTRUCTIONS 1. Open a new Microsoft Excel document and name it as - Excel Shopping Spree. Email this work to me. 2. In cell A1 write the title of the worksheet: SHOPPING SPREE; bo
Computer GraphicsComputer Graphics IS 490 SPECIAL TOPICS May 6, 1996 Table of Contents Introduction 3 How It Was 3 How It All Began 4 Times Were Changing 6 Industry's First Attempts 7 The Second Wave 10 How the Magic is Made 11 Modeling 12 Animation 13 Rendering 13 Conclusion 15 Bibliography 16 Introduction Hollywood has gone digital, and the old ways of doing things are dying. Animation and special effects created with computers have been embraced by television networks, advertisers, and movie studios alike. Fi
Determining Databases and Data Communications Determining Databases and Data Communications April Page BIS 320 August 3, 2015 Determining Databases and Data Communications Scenario One Marketing assistant of Apple, April Page has been asked to take charge of setting up a booth at the local trade show being held in Charlottesville, Virginia. Organization is one of her strengths along with strategic planning through the use of Microsoft Access. Being she is the only one that needs this data the personal access database is all that is require