With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively.
Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success. Instructors, contact your Pearson representative for more information. Text appears to be truncated when the cell is too narrow. Columns need to be widened when this is the case. The Paste Special dialog box offers more options than the Paste menu.
It might be necessary to use the Paste Special command in these cases to keep the formatting. Worksheet Formatting It is important to format the worksheet after entering the data and formulas.
In this section, students will learn how to create a professionally formatted worksheet that makes finding and analyzing data faster and easier. They will use features such as cell styles, alignment options, text wrapping, and indent options and format different types of values.
Text aligns at the left cell margin, and dates and values align at the right cell margin. There are four merge options. Previously merged cells can easily be unmerged. Decimal places in a column of values should be aligned.
If the column label is wide, the values below it appeared too far on the right. To preserve the values aligning at the decimal places, use the Align Right horizontal alignment and click Increase Indent to shift the values over to the left a little for better placement.
Worksheets, Page Setup, and Printing In this section, students will learn to manage their worksheets by copying, moving, and renaming them. After selecting page setup options, you will learn how to print your worksheet. The tab shows in the full color when it is not active, but when the sheet is active, the sheet tab color is a gradient of the selected color. The longer the worksheet name, the fewer the sheet tabs that are visible at the bottom of the workbook window without scrolling. When possible, use the commands in these groups to apply page settings.
To apply page setup options such as margins or a header to multiple worksheets at the same time, select the sheets and choose the Page Setup options to be applied to the selected sheets. Right-click a sheet tab and select Ungroup. The gridlines help you see the cell boundaries, and the headings help you identify what data are in each cell.
Open the Page Setup dialog box, click the Sheet tab, click in the Rows to repeat at the top box, and then select the row s containing column labels. A spreadsheet that contains formulas, functions, values, text, and visual aids. Worksheet 2. A file containing related worksheets. Workbook 3. A range of cells containing values for variables used in formulas. Input area 4. A range of cells containing results based on manipulating the variables.
Output area 5. Identifies the address of the current cell. Name Box 6. Displays the content text, value, date, or formula in the active cell. Formula Far 7. Displays the name of a worksheet within a workbook. The intersection of a column and row. Cell 9. Includes letters, numbers, symbols, and spaces. Text A number that represents a quantity or an amount.
Value Rules that control the sequence in which Excel performs arithmetic operations. Order of operations Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.
Auto Fill A small green square at the bottom-right corner of a cell. Fill handle The horizontal measurement of a column. Column width The vertical measurement of a row. Row height A rectangular group of cells. Range The position of data between the cell margins. Alignment Formatting that enables a label to appear on multiple lines within the current cell.
Wrap text The background color appearing behind data in a cell. Fill color Formula Multiple Choice Answer Key 1. Which step is not part of planning a worksheet design? Enter labels, values, and formulas. You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select? How can you display formulas within the cells instead of the cell results?
What is a fast way to apply several formats at one time? Apply a cell style. Which of the following is not an alignment option?
Fill Color 7. Which of the following characteristics is not applicable to the Accounting Number Format? Dollar sign immediately on the left side of the value 8. You selected and copied worksheet data containing formulas.
However, you want the pasted copy to contain the current formula results rather than formulas. What do you do? Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?
Increase the left and right margins. What should you do if you see pound signs instead of values or results of formulas? Increase the column width. Quick Concept Check Answer Key 1. What are two major advantages of using an electronic spreadsheet instead of a paperbased ledger? Using a calculator to perform calculations and entering results in a paper-based ledger can lead to greater inaccuracies than building formulas in a spreadsheet, especially when a value changes and new results are needed.
In addition, it is easier to make data-entry changes in a spreadsheet over making changes in a paper ledger. What are the visual indicators that a cell is the active cell? The active cell is indicated by a solid green border. In addition, the Name Box displays the active cell name, such as B Upcoming SlideShare.
Like this presentation? Why not share! Embed Size px. Start on. Show related SlideShares at end. WordPress Shortcode. Next SlideShares. Download Now Download to read offline and view in fullscreen. Download Now Download Download to read offline. Kalila Follow. Related Books Free with a 30 day trial from Scribd. Effortless Style June Ambrose. Related Audiobooks Free with a 30 day trial from Scribd.
0コメント