Select which one of the following is the range of cells used to create the chart shown in the image shown., A1:C1 and A6:C6, A3:A7 and C3:C6, A3:A6 and C3:C6, A3:A7 and B3:B6, Select which one of the following describes the editing feature shown in the image, used to quickly and efficiently create the sequence of months., Replicating, Copying and pasting the contents of one slide to the rest, Pasting, Dragging, What is the name given to the chart type shown in the image?, Pie, Column, Line, Bar, Select which one of the following is the appropriate name for the part of the spreadsheet circled in the image shown., Row, Column, Formula, Cell, Select which one of the following is the appropriate name for the part of the spreadsheet circled in the image shown., Column, Row, Cell, Formula, When creating a bar chart, why is it important to label both of the axes?, So the reader knows the title of the chart, So the reader knows what each colour in the chart represents, Bar charts don't have axes and so don't need axis labels, So the reader knows what each axis of the chart is measuring, Why might you choose to display spreadsheet information in a chart rather than as the values in cells?, A chart is easy to edit, A chart is more colourful, A chart is easier to read at a glance, A chart can be printed the cells cannot, The spreadsheet shown is a class list. Select which one of the following a teacher must do when a new student enters her class., Create a new spreadsheet, Insert a new column into her spreadsheet, Insert a new row into her spreadsheet, Delete a pupil from her spreadsheet, Using the spreadsheet shown, select which one of the following would be the most efficient formula to correctly calculate the total number of fans attending the match., =B2+B3+B4+B5, =TOTAL(B2:B5), =SUM(B2:B5), =A2+A3+A4+A5, Tony uses the formula =(A3+A4+A5)/3, in the spreadsheet shown, to calculate his average mark in his last three science tests. Why would Tony be better to make use of the AVE function rather than using his current formula?, If he uses his current formula, the spreadsheet will not automatically update the average if Tony changes one of his marks, Tony is less likely to make a mistake using the AVE function, The AVE function will give Tony the correct answer, =(A3+A4+A5)/3 will not, =(A3+A4+A5)/3 is more efficient, Select which one of the following gives an advantage of sharing a spreadsheet via a cloud service., Your data is safe from cyber criminals, Commercial cloud storage systems are always free to use, Using cloud storage will result in using less of a smartphone's data allowance, You can access the spreadsheet from any device with an internet connection, Select which one of the following is an advantage of sharing a spreadsheet via a cloud service., You can allow other users to view and edit the spreadsheet, Use of cloud storage is always free no matter how much storage you use, The cloud is secure from cyber criminals, Use of cloud storage does not use up bandwidth, Select which one of the following is a disadvantage of sharing a spreadsheet via a cloud service., You can only access the spreadsheet from the device that you used to upload it, Environmental concerns that cloud storage is not as environmentally friendly as using local storage, Spreadsheets take up a lot of storage and will be expensive to upload onto a cloud service, Data security and privacy concerns about trusting a cloud service with your data, For the spreadsheet shown, select which one of the following is the formula that should be entered into cell D4., =B4+C4, =12*6.5, =B2*C4, =B4*C4, Select which one of the following options describes how the numbers, in the spreadsheet shown, have been formatted., Percentage, Fraction, Time, Currency, When Frieda, a new employee, starts doing 5 hours per week, a row with this information is inserted into the spreadsheet shown. What will happen to the Total Hours amount?, The formula used to calculate the Total Hours would need to be changed, The SUM function will automatically recalculate to the answer 100, The total hours would remain the same, The user would have to type 100 into the cell containing the Total Hours

Web Apps: Spreadsheets html

Visual style

Show all

Activity settings

Leaderboard

AI Enhanced: This activity contains content generated by AI. Learn more.

Switch template

Continue editing: ?