1) What is the part of a spreadsheet that is referred to by a letter? a) Row b) Column c) Cell d) Bar 2) What is the part of the spreadsheet that is referred to by a number? a) Row b) Column c) Cell d) Bar 3) A Fill Handle can be used for a) Replicating data b) Merging Cells c) Resizing Columns d) Splitting Cells 4) What is this symbol used for a) Replicating data b) Merging Cells c) Resizing Columns d) Splitting Cells 5) Arranging data in a column in order from largest to smallest is called a) Editing b) Formatting c) Sorting d) Filtering 6) Which feature would you use to display data in a column according to specified criteria? a) Replicating b) Filtering c) Sorting d) Formatting 7) Which symbol must all formulas in a spreadsheet begin with? a) + b) / c) = d) * 8) Which formatting feature enables a user to join together cells into one larger cell? a) Alignment b) Wrap Text c) Cell borders d) Merge & Centre 9) How would you format this chart to make it easier to understand? a) Label the axis b) Delete the legend c) Insert gridlines d) Add a title 10) How would you format this chart to make it easier to understand? a) Remove the border b) Include a legend c) Change the colours d) Insert gridlines 11) Which type of chart would be the most appropriate to show the scores for these students? a) Line graph b) Scatter graph c) Bar chart d) Area chart

Excel Formative Assessment

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?