Creating Sections in a Spreadsheet Table
28 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Home Ribbon: All tools to do with text formatting, for example, making text bold, changing fonts, and the most common tools for text ______

alignment

Insert Ribbon: All tools to do with inserting photos, graphics, tables, charts, sounds, movies, etc. You can also insert equations, videos, audio, word art and ______ using this ribbon.

smart art

Design Ribbon: All tools to do with the look of your slide, eg, the slide ______

background

Transitions Ribbon: All tools to add ______ to show as slides change from one to the next.

<p>effects</p> Signup and view all the answers

Animations Ribbon: All tools to add slide transitions and adding effects to text boxes, images and ______.

<p>headings</p> Signup and view all the answers

Creating a New Presentation: PowerPoint has a wealth of templates and themes for all sorts of different types of presentations. When you start PowerPoint, you’ll see a whole list of templates you can choose from. You can search for templates for the presentation you are creating. To do this, use the search field at the top of the ______.

<p>screen</p> Signup and view all the answers

It would make our spreadsheet easier to read if we divided the table into ______; player name can be one section, scores can be the second section, total, average and fee can be the third section.

<p>sections</p> Signup and view all the answers

We can divide the table with a thicker ______.

<p>line</p> Signup and view all the answers

First, highlight the total, average and fee paid columns, because this is one ______.

<p>section</p> Signup and view all the answers

Right click, select ‘format cells’.From the dialog box, under the style section, select the size of your ______, circled above in blue.

<p>line</p> Signup and view all the answers

Under the ‘border section’, select the left line and the right line, circled in red above, to apply the border to these ______.

<p>edges</p> Signup and view all the answers

You can quickly apply borders using the borders icon on the home ribbon.This allows you to apply common border ______.

<p>presets</p> Signup and view all the answers

To begin creating our presentation, for this example double click on the ‘mesh’ ______.

<p>template</p> Signup and view all the answers

This will open up a ______ presentation with this template for you to add your content.

<p>blank</p> Signup and view all the answers

Let’s begin by adding the title to our first ______.

<p>slide</p> Signup and view all the answers

On your slide, click where it says ‘click to add ______’.

<p>title</p> Signup and view all the answers

The easiest way to add an image to your slide, is to first find the image in your pictures library from file ______.

<p>explorer</p> Signup and view all the answers

To continue building our presentation we need additional slides to show our ______.

<p>information</p> Signup and view all the answers

If you have more than one attachment on the email, click ‘save attachments’ instead; this will save all of the files to your PC in one go. From the dialog box that appears, select the folder you want to ______ your attachments in.

<p>save</p> Signup and view all the answers

In this example, I’m going to save the attachment in the documents folder on my PC. Previewing Attachments With most documents and images, Outlook can show you a preview of the document. To see a preview of the document, click on the file icon in the reading pane. If Outlook recognises the file, you’ll see a preview of the file’s contents. In this example, the PowerPoint ______.

<p>presentation</p> Signup and view all the answers

Scroll down the file if you need to. Click ‘back to message’ to close the ______.

<p>preview</p> Signup and view all the answers

Dealing with Junk Mail If you have been using the internet you will no doubt have received junk mail in the past. Mail advertising products from unknown senders that you wonder how they got your email address. Outlook has a junk mail filter. It is good practice to enable this filter as suspicious emails used for phishing personal details, etc. To enable the filter click ‘junk’ from the home ribbon In the dialog box that pops up select ‘low: move the most obvious junk email to the junk email folder’ Also select ‘disable links…’ and ‘warn about suspicious domains…’. This helps to filter out emails sent from ______ etc.

<p>scammers</p> Signup and view all the answers

All ______ these emails will be filtered into your junk mail box instead of your inbox.

<p>167</p> Signup and view all the answers

To add up a row, click on the cell you want the total to appear in. In this example, I have created a column for totals, and I want the total for the first player to appear in cell T2, circled below in the illustration. Next, add the auto sum function. Youll find this on your home ribbon. Click on the auto sum icon. Youll notice, the auto sum function has highlighted the row I want to add up. Press the enter key on your keyboard to execute the function. Now replicate the function to fill the rest of the column by dragging the handle down, as shown below.

<p>Fill in the blank</p> Signup and view all the answers

Drag it down to fill the rest of the column.

<p>Execute</p> Signup and view all the answers

Drag it down to fill the rest of the column.

<p>Replicate</p> Signup and view all the answers

Drag it down to fill the rest of the column.

<p>Average</p> Signup and view all the answers

Drag it down to fill the rest of the column.

<p>Select</p> Signup and view all the answers

More Like This

4. Frequency and Contingency Tables
24 questions
Excel Tables Formatting
6 questions
Excel Tables Formatting
6 questions
Use Quizgecko on...
Browser
Browser