1) Numbers can be formatted in a number of ways. An example would be: a) Currency b) Text c) Values d) Formulae 2) Spreadsheet software is used to: a) record and analyse financial information b) store related records in an organsied fashion c) produce word processed business documents d) present information in meetings and events 3) Worksheets can be: a) duplicated b) renamed c) deleted d) all of the above 4) Formulae refers to…. a) text b) charts c) numbers d) calculations 5) Text is used in a spreadsheet to provide… a) Names for columns and rows b) an easier way to read the information c) meaningful and relevant labels to numbers and formulae d) content which is easy to understand 6) From this list, which is NOT an alignment option a) Justified b) Heading c) Left d) Centre 7) Which of the following is a Cell Reference? a) 12D b) $£$ c) D3 d) ?2 8) From the toolbar shown, which area would be used to make changes to the Font? a) 3 b) 4 c) 1 d) 2 e) 5 f) 6 9) Merged and Centred means: a) to move the contents into another document b) merge the contents of several cells together to make one larger cell c) Rotate the contents and centre d) remove the contents 10) Which of the following is an option on the alignment section of the home ribbon? a) Autosum b) Orientation c) Wrap Text d) Font Type 11) The AVERAGE function analyses a range of cells and ….. a) provides a chart of the numbers in the range b) provides the total of the numbers in the range c) provides the mean of the numbers in the range d) provides a summary of the numbers in the range 12) Which of the following will find the total of values contained in a range of cells? a) MAX b) MIN c) SUM d) COUNT 13) The MAX function analyses a range of cells to find… a) The smallest number in the range b) The widest number in the range c) The highest number in the range d) The tallest number in the range 14) Which of the following is NOT a function you need to know how to use for National 5? a) AVERAGE b) COUNT c) LOOKUP d) MAX 15) All functions and formulae in a spreadsheet begin with the following symbol: a) * b) / c) = d) + 16) An IF statement is formed by: a) A logical test and values for true and false b) A sensible test and value if correct or false c) A sensible test and a suitable answer d) A logical statement 17) A named cell is: a) a cell reference eg D4 b) a cell reference containing a formula c) a cell reference which has been given an assigned name d) a cell reference which contains a heading 18) Absolute Cell Refencing provides the same solution as: a) IF Statements b) Logical Tests c) Naming Cells d) Relative Referencing 19) Which of the following is an example of an IF statement? a) =MAX(B3:D3) b) =IF(B4>12,"Resit",) c) =IF(B4>12,"Yes","No") d) =SUM(B4:F4) 20) Which of the following formulae demonstrates Absolute Cell Referencing? a) =B14/12 b) =SUM(B4:F4) c) =B4-(B4*$C$13) d) =B4*C4 21) Which of these examples will display a Percentage increase? a) =B4+(B4*10)% b) =B4*90% c) =B4-(B4*9%) d) =B5/B10 22) Which of the following Names would be at the top of a list if it were sorted in Ascending order? a) McAvoy b) MacAvoy c) MacMillan d) McMillan 23) Which of the following Names would be at the top of a list if it were sorted in Descending order? a) McAvoy b) MacAvoy c) MacMillan d) McMillan 24) Which of the following symbols represents percentage? a) % b) [ c) = d) £ 25) Percentage change is a term used to refer to: a) calculations where you want to show the similiaries between two values b) calculations where you want to show the difference between two values as a % c) show the increase in percentage between two values d) show a value as a percentage 26) Recommended Charts is a option which… a) suggests the most suitable heading for your chart b) suggests the best chart type to use c) provides examples of how your data will look in different chart types d) suggests the best colour scheme for your chart 27) Which Keyboard button do you need to press and hold in order to highlight cells which are non-adjacent? a) Ctrl b) Delete c) Caps Lock d) Alt 28) Which of these charts is a Pie Chart a) b) c) d) 29) Which button would allow me to move the location of my chart onto a separate worksheet? a) Add Chart Element b) Move Chart c) Change Chart Type d) Switch Row/Column 30) Which tab do you need to click on to insert a chart and access the Chart Options a) Chart b) View c) Insert d) Home 31) What is Formulae View? a) This view displays the formulas that were entered to perform calculations b) This view displays the row and column headings c) This view displays the raw data d) This view displays the values 32) When printing Formula View you should include: a) Footer, Gridlines and Row and Column Headings b) Gridlines and Row and Column Headings c) Footer and Gridlines d) Footer and Row and Column Headings 33) When printing Value View you should include: a) Footer, Gridlines and Row and Column Headings b) Gridlines and Row and Column Headings c) Footer and Gridlines d) Footer and Row and Column Headings

N5 Spreadsheets

Εκτύπωση
Ενσωμάτωση

Κατάταξη

Οπτικό στυλ

Επιλογές

Αλλαγή προτύπου

Επαναφορά αυτόματα αποθηκευμένου: ;