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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?