this toolbar contains buttons to allow you to perform the basic operations such as opening and...

8/3/2019 This Toolbar Contains Buttons to Allow You to Perform the Basic Operations Such as Opening and Closing Workbooks

1/8

Standard toolbar contains buttons to allow you to perform the basic

operations such as opening and closing workbooks, moving and printing

data.

New - Creates a new empty workbook with a given number of

worksheets. Alternatively (File > New). (Ctrl + N)

Open - Displays the (File > Open) dialog box to open existing

workbooks. (Ctrl + O).

Save - Saves the active workbook. Displays the (File > Save As) dialog

box the first time a workbook is saved. (Ctrl + S).

Permission - (Added in 2003). Used in conjunction with Windows

Rights Management services.

E-mail - Emails the active workbook or active worksheet.

Search - (Removed in 2003). Finds files, Web pages, and Outlook items

based on the search criteria you enter.

Print - Prints the active worksheet. There is NO prompt. (Ctrl + P).

Print Preview - Displays the (File > Print Preview) dialog box.

Spelling - Displays the (Tools > Spelling) dialog box. (F7).

Research - (Added in 2003). Opens the Research task pane allowing you

to access online information.

Cut - Cuts the current selection to the clipboard. (Ctrl + X).

Copy - Copies the current selection to the clipboard. (Ctrl + C).

Paste - Pastes the entry from the clipboard. (Ctrl + V). The Paste

Options smart tag provides quick access to some of the Paste Special

options.

Format Painter - Copies the format from a cell or range allowing it to

be pasted elsewhere.

Undo - Undoes the last 16 actions you performed. (Ctrl + Z).

Redo - Redoes the last 16 actions you performed.

Insert Hyperlink - Displays the (Insert > Hyperlink) dialog box. (Ctrl +

K).

AutoSum - Inserts the SUM() function.


2/8

Sort Ascending - Sorts data alphabetically from A to Z and numerically

from the lowest number to the highest. Holding down Shift will toggle to

a Descending sort.

Sort Descending - Sorts the data alphabetically from Z to A and

numerically from the highest number to the lowest. Holding down Shift

will toggle to an Ascending sort

Chart Wizard - Displays the (Insert > Chart) dialog box.

Drawing - Toggles the display of the Drawing toolbar.

Zoom - Adjusts the size that the worksheet appears on the screen.

Microsoft Excel Help - Displays the (Help > Microsoft Excel Help)

dialog box. (F1).


3/8

Format toolbar contains buttons and drop-down boxes to allow you to

format the contents of the cells.

Font - Provides a list of all the available fonts (based on your current

printer selection).

Font Size - Lets you adjust the character size (based on your current

font selection).

Bold - Toggles bold on the current selection.

Italic - Toggles italics on the current selection.

Underline - Toggles underline on the current selection.

Align Left - Aligns data to the left edge of the cell.

Centre - Aligns data in the middle of the cell.

Align Right - Aligns data to the right edge of the cell.

Merge and Centre - Combines 2 or more adjacent cells to create a single

cell.

Currency Style - Applies the currency format "#,##0.00".

Percent Style - Displays the number as a percentage by applying the

format "0%".Comma Style - Adds a comma and two decimal places to the number by

applying the format "#,##0.00".

Increase Decimal - Adds one decimal place from the number.

Decrease Decimal - Removes one decimal place from the number.

Decrease Indent - Decreases the indent by 1 or removes the indent

completely.

Increase Indent - Increases the indent by 1.

Borders - Applies a border to the current selection.

Fill Colour - Applies a colour to the background of the current

selection. This is actually a tear off toolbar.

Font Colour - Changes the colour of the font of the current selection.

This is actually a tear off toolbar.


4/8

The Drawing toolbar

This entire toolbar could become a floating window by double-clicking on the control bar at the

far left end of this toolbar. That gives the following window, which can be placed anywhere onthe screen:

This toolbar can be restored to its original position by clicking in the gray bar at the top anddragging it back to the top of the screen. Push the top of the window up to the bottom of themenu bar.

Function of commonly used buttons

A pull down menu withseveral

drawing options

Changes the pointer to a

selection arrow

Rotates the selected

object to any degree

A pull down menu with

several libraries of shapes

Draws a line where you

click and drag. Hold theShift key down to make

the line straight

Inserts a line with an

arrowhead where you

click and drag

Draws a rectangle whereyou click and drag. Hold

down Shift to draw asquare

Draws an oval where youclick and drag. Hold

down Shift to draw acircle


5/8

Draws a text box where

you click and drag

Create text effects with

Word Art

Add, modify, or removefill color from a selected

object

Add, modify, or removeline color

Formats the selected text

with the color you click

Changes the thickness of

lines

Selects dash style for

dashed lines

Select arrow style;placement and shape of

arrowhead

A pull down menu offers

shadow choices

Add 3-d effects to

rectangles or ovals

Carefully review the function of each of the buttons above. When you think that you are familiar

with each of the buttons take the short quiz below. (The Drawing toolbar has been included as areference)

This quiz is available without the table above

A B C D

1

Instead of striking the underline key fifteentimes, you plan to draw a single line by

clicking and dragging.

Which button do you select?

2You have drawn a line, and now want to

change the color of the selected line.Which button do you select?

3 The last line you drew had an arrowhead atthe wrong end. You want to change the


6/8

arrowhead to the other end of the line.Which button do you select?

4You created an object in a worksheet and

you want to tilt it at an angle.Which button do you select?

5

You have drawn a rectangle around a

selection of cells and want to change it to adashed line.


6

The heading of a worksheet is just plain textand you would rather create special effects

with text.Which button do you select?

7

You are going to draw a perfect circle on

your worksheet by holding down the shiftkey, clicking and dragging.


y Toolbar Standar

Berfungsi untuk membuat file baru, membuka file baru, menyimpan, mencetak dokumen, dansebagainya. Berikut fungsi dari masing-masing icon pada toolbar standar


7/8

1. New : Membuat file baru dengan menampilkan buku kerja baru2. Open : Membuka file yang sudah pernah disimpan

3. Save : Menyimpan file atau dokumen4. E-mail : mengirim dokumen melalui email

5. Search : mencari text atau data pada lembar kerja

6.

Print : Mencetak dokumen ke printer7. Print Preview : Menampilkan hasil pengetikan kelayar monitor8. Spelling : Melakukan koreksi terhadap ejaan bahasa

9. Cut : Memotong teks ataupun object10.Copy : mengopi teks atau object

11.Paste : Menempatkan hasil potongan(cut) atau kopian12.Format Painter : Mengopi format painter (bentuk pewarnaan)

13.Undo : Membatalkan perintah terakhir14.Redo : Mengulangi kembali perintah akibat pembatalan

15.Insert Hyperlink : Menyisipkan link16.Auto sum : Fungsi penjumlahan data secara otomatis

17.

Sort Ascending : Mengurutkan data dari yang kecil ke besar18.Sort Descending: Mengurutkan data dari yang besar ke kecil

19.Chart wizard : Membuat grafik dengan panduan excel20.Drawing : Mengaktifkan/menyembunyikan toolbar drawing

21.Zoom : memperbesar/memperkecil tampilan lembar kerja

y Toolbar formatting

Toolbar yang berfungsi untuk mengatur format pada teks atau data yang terdapat pada lembar

kerja. Berikut fungsi dari icon2 pada toolbar formating

1. Font : Menentukan jenis font yang digunakan2. Font Size : Menentukan ukuran font

3. Bold : Menebalkan teks4. Italic : Memiringkan teks

5. Underline : Menggaris bawahi teks6. Left : Perataan kiri teks

7. Center : Perataan tengah teks8. Right : Perataan kanan teks

9. Merge & Center : Menggabungkan sel dan mengetengahkan teks10.Currency Style : Mengaktifkan format angka(mata uang)

11.Percent Style : Mengaktifkan format persen.12.Comma Style : Mengaktifkan pemisah angka

13.Increase Decimal : Menambah angka desimal di belakang14.Decrease Decimal : Mengurangi angka desimal di belakang

15.Increase Indent : Menambah indentasi16.Decrease Indent : Menambah indentasi

17.Borders : Membuat format garis


8/8

18.Fill Color : Membuat warna background19.Font Color : Membuat warna font

y

Toolbar Drawing

Toolbar Drawing digunakan untuk membuat dan menggambar object dalam lembar kerjamicrosoft Excel.

1. Select Object : Memilih object

2. AutoShapes : Terdiri atas ikon-ikon untuk untuk menggambar suatuobjek

3. Line : membuat garis4. Arrow : membuat garis dengan anak panah

5. Rectangle : Membuat atau persegi panjang

6.

Oval : Membuat lingkaran dan elips7. Text Box : membuat kotak yang dapat diisi dengan teks8. Insert Word Art : menyisipkan seni teks

9. Insert diagram : menyisipkan diagram10.Insert clip art : menyisipkan object gambar clip art

11.Insert Picture : menyisipkan file gambar12.Fill Color : membuat warna background pada sel/range

13.Line color : memberi warna pada object garis14.Font color : membuat warna pada font

15.Line Style : Memilih model garis16.Dash Style : memilih model garis putus-putus

17.

Arrow kay : membuat anak panah pada object garis18.Shadow Style : membuat model bayangan pada objek

19.3-D Style : membuat model 3 dimensi pada objek gambar

this toolbar contains buttons to allow you to perform the basic operations such as opening and...

Documents