Spreadsheet program that allows you to store, organize, and analyze information. While you may think Spreadshe are only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Spreadsheets makes it easy to work with different types of data.
1 / 18
volgende
Slide 1: Tekstslide
Computing ICTFurther Education (Key Stage 5)
In deze les zitten 18 slides, met interactieve quizzen en tekstslides.
Lesduur is: 30 min
Onderdelen in deze les
Spreadsheet program that allows you to store, organize, and analyze information. While you may think Spreadshe are only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Spreadsheets makes it easy to work with different types of data.
Slide 1 - Tekstslide
LESSON OUTCOMES
Open Excel program
Open an Excel Workbook
Understand the function of the Ribbon Tabs
Access The backstage View
Create Quick Access Commands
Slide 2 - Tekstslide
Slide 3 - Tekstslide
Slide 4 - Tekstslide
Slide 5 - Tekstslide
Get Started
The procedures in the next will work for all recent versions of Microsoft Excel, including Excel 2019, Excel 2016, and Office 365. There may be some slight differences, but for the most part these versions are similar. However, if you're using an earlier version, you may
want to refer to one of our other Excel tutorials instead
Excel uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.
Each tab will have one or more groups.
Some groups will have an arrow you can click for more options
.Click a tab to see more commands.
Slide 8 - Tekstslide
The Excel Ribbon
Home Tab
In general, the home tab is a tab or button in an application or web page that returns you to the home section. 2. In Microsoft Office, the Home tab is the default tab in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and other Microsoft Office products.
The Excel Ribbon
The Excel Ribbon Groups Excel Commands into sets of Tabs that enable simple method of acceessing commands
The Page Layout Tab
This tab lets you define the page layout for your file, including the page size, size of the page margins, and the positioning of the systems on each page.
Insert Tab
The Insert tab contains various items that you may want to insert into a document. These items include such things as tables, word art, hyperlinks, symbols, charts, signature line, date & time, shapes, header, footer, text boxes, links, boxes, equations and so on.
The Print Area Tab
This tab lets you define define the Print Area and add headers and footers .
The Data Tab
We use Data tab for the large amount of data.It is useful to import the data by connecting with the server, and we can import data automatically from web, MS Access etc. And sort & filter are very helpful options we have in Excel; it makes easy to read vast data.
The FormulaS Tab
The Formula tab is used to insert functions, define names, create name ranges, review formulas. In ribbon, Formulas tab has very important and most useful functions to make dynamic reports. Insert Function
Slide 9 - Tekstslide
The Quick Access Toolbar
Located just above the Ribbon, the Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.
To add commands to the Quick Access Toolbar:
Click the drop-down arrow to the right of the Quick Access Toolbar.
Select the command you want to add from the drop-down menu. To choose from additional commands, select More Commands.
The command will be added to the Quick Access Toolbar.
Slide 10 - Tekstslide
Worksheet Views
Excel has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.
Normal view is the default view for all worksheets in Excel.
Page Layout view displays how your worksheets will appear when printed. You can also add headers and footers in this view.
Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.
Slide 11 - Tekstslide
The Backstage View
Backstage view gives you various options for saving, opening a file, printing, and sharing your workbooks.
Click the File tab on Click the buttons in the interactive below to learn more about using Backstage view.
the Ribbon. Backstage view will appear.
Click the buttons in the interactive below to learn more about using Backstage view.
Slide 12 - Tekstslide
What is purpose of the Quick Access Bar
A
Provide Custom Commands
B
Provide Access to backstage
C
Identify The Selected Row
D
Change The Worksheet View
Slide 13 - Quizvraag
It is possible to create a border on only one side of a cell.
A
True
B
False
Slide 14 - Quizvraag
What are the horizontal sections of an Excel worksheet
A
Columns
B
Rows
C
Cells
D
Squares
Slide 15 - Quizvraag
How Do access the Backstage view
Slide 16 - Open vraag
Challenge
Open Excel.
Click Blank Workbook to open a new spreadsheet.
Using the Customize Quick Access Toolbar, click to add New, Quick Print, and Spelling.
In the Tell me bar, type the word Colour. Hover over Fill Colour and choose yellow. This will fill a cell with the colour yellow.
Change the worksheet view to the Page Layout option.
When you're finished, your screen should look like this:
Change the Ribbon Display Options back to Show Tabs and Commands.
Use The snipping tool to take a screen shot of the completed workbook
Slide 17 - Tekstslide
Upload the workbook you saved as part of the challenge
Wij gebruiken cookies om jouw gebruikerservaring te verbeteren en persoonlijke content aan te bieden. Door gebruik te maken van LessonUp ga je akkoord met ons cookiebeleid.