Numbers can be formatted in a number of ways. An example would be:, Currency, Text, Values, Formulae, Spreadsheet software is used to:, record and analyse financial information, store related records in an organsied fashion, produce word processed business documents, present information in meetings and events, Worksheets can be:, duplicated, renamed, deleted, all of the above, Formulae refers to…., text, charts, numbers, calculations, Text is used in a spreadsheet to provide…, Names for columns and rows, an easier way to read the information, meaningful and relevant labels to numbers and formulae, content which is easy to understand, 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, Which of the following Names would be at the top of a list if it were sorted in Ascending order?, McAvoy, MacAvoy, MacMillan, McMillan, Which of the following Names would be at the top of a list if it were sorted in Descending order?, McAvoy, MacAvoy, MacMillan, McMillan, Which of the following symbols represents percentage?, %, [, =, £, 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, Recommended Charts is a option which…, suggests the most suitable heading for your chart, suggests the best chart type to use, provides examples of how your data will look in different chart types, suggests the best colour scheme for your chart, Which Keyboard button do you need to press and hold in order to highlight cells which are non-adjacent?, Ctrl, Delete, Caps Lock, Alt, 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, What is Formulae View?, This view displays the formulas that were entered to perform calculations, This view displays the row and column headings, This view displays the raw data, This view displays the values, 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

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?