Excel Introduction

Before you can enter data in an empty cell you must double click on the cell.

false

Which tool should we use to help keep headings visible when we scroll through a large workbook?

freeze panes

Which tool was used here to produce the view below?

page layout view

Excel is an example of what type of software?

spreadsheet software

When changing the theme on any worksheet in a workbook, all sheets will be affected

True

Which of the following will Excel recognize as a date?

05 Sept 16, 05/09/2016

Which of the statements below are correct regarding Excel's behavior when you enter data into an empty cell?

any text entered is automatically aligned on the left; any number entered is automatically aligned on the right.

The color settings in Cell Styles on the Home tab can only be changed by selecting preset Excel themes

False

To add borders to a large block of data just select one cell in the data set.

False

What are banded rows and how can we create them?

banded rows alternate in colors to improve readability of spreadsheets, they can be set up by manually filling the background of one row and then select that row and the next one with no fill, now you use the format painter and drag those rows in which you want to see the banded rows.

What is one of the main purposes of the fill handle that we have demonstrated?

to automatically create a series based on existing data

What can we use Conditional Formatting for?

to discover and visualize behavior of data - especially in large sets, to automatically highlight cells when certain conditions are met, to identify trends, variances and similarities in a range of data

The tools on the far right of the status bar (at the bottom of the screen) allow you to

toggle between different view options; set a specific zoom percentage

How do you switch between different workbooks inside Excel?

click on the view tab and select this tool

What does your mouse cursor need to look like in order to activate the fill handle?

a bold, black plus sign

What is the difference between a page header and a heading on your worksheet? (One or more answers are possible - partial credit will be awarded)

a page header automatically appears on every single printed page and excel needs to be setup manually to repeat column headings, page headers allow us to add important meta information in addition to the contents of a worksheet

After entering data into a cell, which option(s) will move your cursor into the next cell underneath your active cell?

click the mouse pointer into the cell underneath; press enter

Once you copy and paste a chart into a different worksheet, the chart will no longer update automatically whenever its data changes

false

Which of the following formats does the Format Painter copy?

font size, font type, borders, cell background fill, number format, text alignment

How can you center the print selection horizontally on your page for printing?

go to the page layout tab, click on the icon below and then center your data on the page through the option custom margins

Sean wants to move his chart to a new worksheet 'Charts' in his workbook. What are his options?

he can select the chart, then navigate to the charts tools and use the move chart tool, he can select the chart and then use the Cut and Paste command, he can right-click the chart and then select 'Move Chart' from the context menu

Sean wants to change some details about his Header and he remembers that he needs to make those changes in the Design tab. He is looking at his ribbon but can't find the tab. Can you help him?

he needs to click into the Header row in order to activate the Design tab

What can Excel do when you manually adjust a page break?

it can change the scale of that page, it can change the appearance of the page break, it can change the number of columns on that page

What is the purpose of the Page Layout view?

it shows us how the data will look on a printed page

What happens when you select a section of your spreadsheet, click this drop-down and select the first option?

it will clear everything from that entire selection

Clicking on the file takes you to the backstage view, from here you can

open a file, create a blank workbook, close a file, set up excel options

Which view option do you need to select in order to edit the Header or Footer section of your worksheet?

page layout view

My Ribbon has disappeared - how can I get it back?

right-click on one of the tabs and untick collapse the ribbon, double click on any of the ribbon tabs

You can insert a column on the left of an existing column by ... (One or more answers are possible — partial credit will be awarded)

right-clicking on the column header and selecting Insert, On the Home tab, selecting Insert, then Insert Sheet Columns

What happens when you select a chart in Excel?

the Sort & Filter tools on the Home tab are greyed out, the Chart Tools appear above the Ribbon, sizing-any data that the chart is based on is selected

What is the main difference between the Accounting and the Currency number format in Excel?

the main difference is that in the accounting format, the currency symbol is left aligned, away from the number.

In order to create a chart sheet, you need to:

use the move charts tool and place your selected chart into a new sheet

Where do you find the tool that lets you insert a Page Break?

navigate to the page layout tab and click on breaks

The formula =Sheet1!A2*A2 tells Excel to:

multiply the value in A2 in Sheet1 by the value in A2 in the current sheet

Where do you find the Chart tools?

navigate to the insert tab and locate the charts group

Which of the following is NOT part of the Ribbon?

tools

In order to use values in other worksheets in a calculation, you must first copy them into the worksheet containing the calculation.

False

When creating a chart, it is best to select your data and headers first

True

When you reference cells on other sheets in a calculation you can use relative references to copy that formula to other cells.

True

Which of the following are key, modifiable elements of a chart?

chart title, chart area, legend, plot area

Choosing a different theme will override all previous formatting

False

The text entered into a cell doesn't fit and part of it is cut off. Which of the following will make all of the text visible without affecting the layout of your report?

click on wrap text

In order to apply conditional formatting to a worksheet, you can click into any cell.

False

Take a look at the screenshot below. Sean needed to separate the first names from Column C. This would normally take quite a long time but he managed to fill Column D within seconds. How did he do that?

Sean typed "Christopher" into cell D2, then he dragged the fill handle to D7, he changed the tool option to Flash Fill.

To clear the contents of a cell without affecting the surrounding cells, single click on the cell and...

click delete on the home tab in the ribbon; press the delete key on your keyboard

How do you remove borders while minimizing changes to the data? (If you are unsure - head on over to Excel and experiment before you answer the question)

click on the cell(s), go to borders and choose No Borders

You are working on one of your worksheets. Which of the following options will open up the Print Preview area?

click on the file tab in the ribbon to access the Backstage, here you click on Print

Sean's worksheet is very wide as it has 20 columns, and he would like to reduce the number of pages over which the printout will span. Which of the following options are likely to help Sean achieve this?

he can narrow the print margins, he can change the page layout from portrait to landscape orientation

You need to sort a large and rather untidy data set that you just received from a different department. It contains entries such as dates, numbers and text. Before you use the Sort tool, what should you do first? (One or more answers are possible - partial credit will be awarded)

make sure that the number format for each of the columns is consistent, e.g. Currency, Accounting, Percentage, add headers to the data set

Before we can manually change the custom scaling, we must:

set page width to automatic

Which Border option should we use to get the following result:

top and double bottom border

Sean has used the 'Move Chart' tool to move one his charts to one of the other worksheets. He then realizes that he moved the chart to the wrong worksheet. Not to worry, a quick CTRL+Z to undo the move - except, nothing is happening. What is going on?

when using the move charts tool, the undo function does not work

Sean has inserted a chart and formatted it very nicely according to his company's requirements. However, he discovers that he missed out one of the quarters. Is it still possible for him to change the data range the chart refers to? (One or more answers are possible - partial credit will be awarded)

yes, click on the Select Data button in the Data group under the Design tab to extend or reduce the data range; yes, he can select the chart to activate the range selection in his dat and then he can then use the sizing handles to adjust the data range that is visualized in the chart

How do you activate the fill functionality?

you hover over the small square in the bottom right-hand corner of your active cell until you see the thick black cross, then click and drag; you select a range of cells and click on the down arrow icon in the Home tab