Figure 4: Formatting Palette Option in Word and ExcelExcel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. Now to access Formatting Palette, choose View Formatting Palette, as shown in Figure 4. Follow these steps to apply a new Theme to a Word document or an Excel spreadsheet in 2008 for Mac: Open an existing Word document or Excel spreadsheet, or create a new one.Next, choose the Customize Ribbon. Step 2 We will get the below dialogue box as shown below. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS.Step 1 Go to the File menu and Choose Option. This includes XLSX, DOCX and PPTX.9 6: Copy and paste formatting and data. Explore the Excel interface. Create a new blank workbook. Step 4 Search for the FORM button, create a new group in the HOME menu.
Create a new blank workbook In Excel, you create and save data in a workbook. Before you begin What you'll learn After completing this tutorial, you'll be able to:Identify user interface elements that you can use to accomplish basic tasks.Microsoft Office for Mac 2011 tutorial: Excel basics1. Methods discussed in this tutorial: the caret , and the POWER function. 21But one thing: On my machine (Excel 2008 Mac), the values in the formula cell. Save a workbook in a new folder. ![]() ![]() Excel Tutorial 2008 How To Move BetweenMove within worksheet cells To enter data, you first need to know how to move between worksheet cells. The active cell has a blue highlight around it.To hide the ribbon while you work, on the right side of the ribbon, clickTo see a tip for a button on the ribbon or toolbar, rest the pointer over the button.Identify the user interface elements that you can use in all workbooks.3. Each cell has an address (for example, cell A1 is the intersection point of column A, and row 1). Each workbook can have multiple worksheets, or "sheets." Cell: The intersection point between a column (A, B, C) and a row (1, 2, 3). Then, under Personal, click Appearance, and select the highlight color that you want. Cell A4 becomes the active cell.In the Reference box, type A1, and then click OK.Notice that cell A1 is now the active cell.To change the color of the highlight around the active cell, on the Apple menu, click System Preferences. Cell C2 becomes the active cell.Press the down arrow key twice, and then press the left arrow key twice. The column heading (B) and row heading (2) appear in dark gray, and a highlight appears around the cell to indicate that it is the active cell.Tip The cell address, or "cell reference," for the active cell (for example, B2) appears in the Name box, located to the left of the formula bar.On your keyboard, press the TAB key once. Let's explore some of the ways that you can move between cells. The key you press determines which cell becomes the active cell.In cell A2, type January, in cell A3, type February, and in cell A4, type March.In cell B2, type 5000, in cell B3, type 10000, and in cell B4, type 15000.Notice that text data appears aligned to the left in cells and numerical data appears aligned to the right.Enter text and numerical data in worksheet cells.5. In cell B1, type North, in cell C1, type East, and in cell D1, type South.Note To commit data to a cell, you can press RETURN, TAB, or any of the arrow keys. Let's enter some basic text and numerical data. To enter data, you simply type in the cell where you want the data to appear. Enter data Data in Excel can be text, numbers, or a combination of the two. Word for mac dots between words removeLet's copy and paste some data and worksheet formatting. The highlight around the cells indicates that they are selected.On the Home tab, under Number, click Currency.Notice that the geographical regions are formatted as bold and centered, and that the numerical data is formatted as currency.To select non-adjacent cells, hold down the ⌘ key, and then click each cell that you want to select.To see additional formatting options, select the cell(s) that you want to format, and then click Format > Cells.To clear a selection, click any worksheet cell.6: Copy and paste formatting and data To save time, rather than reentering and reformatting data, you can copy and paste data, as well as data formatting, into other cells. Move the pointer over cell B1, and when the pointer becomes a white cross, hold down the mouse button and drag across cells B1, C1 and D1. Let's select a range of cells and format the data in the selected cells. To format data, you first have to indicate which data you want to work with by selecting it. For example, you might make the top row of column labels (for example, North, East, and South) appear centered and bold. Click in cell D2, and then click Edit > Paste.Notice that a copy of the numerical data now appears in column C and column D. A copy of the data appears in cells C2, C3, and C4.Tip The keyboard shortcut for the Paste command is ⌘+V. This is a keyboard shortcut, and you will see it written in Help as ⌘+C.Click cell C2, and then click Edit > Paste.
0 Comments
Leave a Reply. |
AuthorDani ArchivesCategories |