1) What is the part of the 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 is used for... a) Replicating data b) Column c) Cell d) Bar 4) This cursor shape is used to... a) Merge cells b) Replicate columns c) Resize 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 begin with? a) + b) / c) = d) * 8) Which formatting feature enables a user to join together data in several cells into one larger cell? a) Alignment b) Merge & Centre c) Wrap text d) Cell borders 9) How could 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) Bar chart c) Scatter graph d) Area chart 12) Which of these is the correct formula for an average? a) AVERAGE(A2:A8) b) =AVERAGEA2:A8 c) =AVERAGE(A2:A8) d) =AVERAGE(A2-A8)

Excel Summative Quiz

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?