GW_E3_F/502/0168_SS_BASICS_L1

• Computing ICT
• Further Education (Key Stage 5)

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.

LESSON OUTCOMES

• Open Excel program
• Open an Excel Workbook
• Understand the function of the Ribbon Tabs
•  Access The backstage View
•  Create Quick Access Commands 

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

Get Started with Excel Tutorial

Home is a Tab on the Ribbon.

1. True
2. False

The Ribbon

1. 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.
2. Each tab will have one or more groups.
3. Some groups will have an arrow you can click for more options
4. .Click a tab to see more commands.

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

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:

1. Click the drop-down arrow to the right of the Quick Access Toolbar.
2. Select the command you want to add from the drop-down menu. To choose from additional commands, select More Commands.
3. The command will be added to the Quick Access Toolbar.

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.

1. Normal view is the default view for all worksheets in Excel.
2. Page Layout view displays how your worksheets will appear when printed. You can also add headers and footers in this view.
3. Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.

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.
  

What is purpose of the Quick Access Bar

1. Provide Custom Commands
2. Provide Access to backstage
3. Identify The Selected Row
4. Change The Worksheet View

It is possible to create a border on only one side of a cell.

1. True
2. False

What are the horizontal sections of an Excel worksheet

1. Columns
2. Rows
3. Cells
4. Squares

How Do access the Backstage view

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

Upload the workbook you saved as part of the challenge