Numbers can be formatted in a number of ways. An example would be:, Currency, Text, Values, Formulae, Formulae refers to…., text, charts, numbers, calculations, From this list, which is NOT an alignment option, Justified, Heading, Left, Centre, Which of the following is a Cell Reference?, 12D, $£$, D3, ?2, From the toolbar shown, which area would be used to make changes to the Font?, 3, 4, 1, 2, 5, 6, Merged and Centred means:, to move the contents into another document, merge the contents of several cells together to make one larger cell, Rotate the contents and centre, remove the contents, Which of the following is an option on the alignment section of the home ribbon?, Autosum, Orientation, Wrap Text, Font Type, The AVERAGE function analyses a range of cells and ….., provides a chart of the numbers in the range, provides the total of the numbers in the range, provides the mean of the numbers in the range, provides a summary of the numbers in the range, Which of the following will find the total of values contained in a range of cells?, MAX, MIN, SUM, COUNT, The MAX function analyses a range of cells to find…, The smallest number in the range, The widest number in the range, The highest number in the range, The tallest number in the range, Which of the following is NOT a function you need to know how to use for National 5?, AVERAGE, COUNT, LOOKUP, MAX, All functions and formulae in a spreadsheet begin with the following symbol:, *, /, =, +, An IF statement is formed by:, A logical test and values for true and false, A sensible test and value if correct or false, A sensible test and a suitable answer, A logical statement, A named cell is:, a cell reference eg D4, a cell reference containing a formula, a cell reference which has been given an assigned name, a cell reference which contains a heading, Absolute Cell Refencing provides the same solution as:, IF Statements, Logical Tests, Naming Cells, Relative Referencing, Which of the following is an example of an IF statement?, =MAX(B3:D3), =IF(B4>12,"Resit",), =IF(B4>12,"Yes","No"), =SUM(B4:F4), Which of the following formulae demonstrates Absolute Cell Referencing?, =B14/12, =SUM(B4:F4), =B4-(B4*$C$13), =B4*C4, Which of these examples will display a Percentage increase?, =B4+(B4*10)%, =B4*90%, =B4-(B4*9%), =B5/B10, Percentage change is a term used to refer to:, calculations where you want to show the similiaries between two values, calculations where you want to show the difference between two values as a %, show the increase in percentage between two values, show a value as a percentage, Which of these charts is a Pie Chart, , , , , Which button would allow me to move the location of my chart onto a separate worksheet?, Add Chart Element, Move Chart, Change Chart Type, Switch Row/Column, Which tab do you need to click on to insert a chart and access the Chart Options, Chart, View, Insert, Home, When printing Formula View you should include:, Footer, Gridlines and Row and Column Headings, Gridlines and Row and Column Headings, Footer and Gridlines, Footer and Row and Column Headings, When printing Value View you should include:, Footer, Gridlines and Row and Column Headings, Gridlines and Row and Column Headings, Footer and Gridlines, Footer and Row and Column Headings.

N5 Spreadsheets

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

)
Continue editing: ?