NEW
Font size
WorksheetsICT Spreadsheet Essentials - Lesson 1 (Part 3)
Total questions: 15
Worksheet time: 12mins
When you insert a column in a spreadsheet, where does the new column appear?
As the first column in the spreadsheet
Immediately to the left of the current selected column
Immediately to the right of the current selected column
As the last column in the spreadsheet
Which row in this spreadsheet has been merged?
Row 1
Row 2
Row 3
Row 4
Yolanda has created a spreadsheet containing student information about her homeroom class. She wants to color-code various parts of the spreadsheet so that the title in Row 1 appears on a blue background, the column headers in Row 2 appear on a pale green background, and the student data appears on a pale yellow background. How can she accomplish this task?
Add the appropriate font color to each section of the spreadsheet that she wants to shade.
Add the appropriate fill color to each section of the spreadsheet that she wants to shade.
Add thick box borders around each section of the spreadsheet that she wants to shade.
Merge the cells that make up each section of the spreadsheet that she wants to shade.
Dora is reviewing her completed spreadsheet and decides she needs to add another column of information between the existing Columns C and D. What is the quickest way for Dora to insert the new column?
Right-click Column C and click the Insert command.
Right-click Column D and click the Insert command.
Drag the right border of Column C until it overlaps Column D.
Drag the right border of Column D until it overlaps Column C.
Tyrell has a spreadsheet consisting of four columns (A, B, C, and D) and 30 rows. He wants to make Row 1 a header row that contains Columns A through D so that he can add a title to describe all the data. How can Tyrell accomplish this?
Merge cells A1:D1.
Merge cells A1:D30.
Select cells A1:D1 and center the title text in cell D1.
Select cells A1:D1 and center the title text in cell A1.
Shannon is trying to make everything on her spreadsheet more compact. There is a lot of empty space in her cells. What is quick way Shannon can resize a whole column to only be as wide as the largest item in that column?
Right-click the column letter in the column header, then specify a width in the dialog box that appears.
Drag the cell's fill handle as far to the right as necessary to completely cover the largest entry in the column.
Double-click the right edge of the column in the column header.
Double-click the cell containing the largest entry in the column.
Carla’s group is working on a spreadsheet of experiment data for her science class. She wants to add a new column of additional data in the middle of the existing eight columns, A through H. Which of the following columns should Carla select to insert the new column in the middle?
Column F
Column C
Column B
Column E
Patricia's partner Alex has shared a spreadsheet he created. On the first row he has given the spreadsheet a title. The title appears in the cell located in the first column even though the spreadsheet is five columns wide. What can Patricia do so that the title appears centered in the first row above the five columns?
Merge cells A1:E5 and center the title text in the merged cell.
Merge cells A1:E1 and center the title text in the merged cell.
Select cells A1:E1 and center the title text in cell A1.
Unmerge cells A1:F1 and center the title text in the cells.
The spreadsheet that Anthony has created contains a great deal of data. The first time he prints the sheet he is disappointed. The lines separating the cells that appear on his screen do not appear on the print out. How can Anthony apply visible lines to his spreadsheet that separate the cells that contain?
Anthony should select all of the cells with data, click the line space button, and choose a line style.
Anthony should select all of the cells with data, click the format painter button, and choose the border style.
Anthony should select the entire spreadsheet, click the borders button, and choose a border style.
Anthony should select all of the cells with data, click the borders button, and then choose a border style.
Ringo is helping Paul re-create a spreadsheet that was handed out by Mrs. Leonard. Paul realizes that he forgot to add a whole column of data. He needs to add the missing column between column E and F. What would Ringo recommend that Paul do?
Right-click column E and click the Insert command.
Double-click the line that separates column E and F and click the Insert command.
Double-click column F and click the Insert command.
Right-click column F and click the Insert command.
Allison and her group have completed the data entry for their spreadsheet project. They are in the process of formatting the data to make it easier to read and understand. The title is located in cell A5. The group has decided to merge cells A3:A7 to attempt to center the title over the data. After the merge, Allison points out that it is not centered and looks bad. Where would the title appear if Allison unmerged the cells in an attempt to fix the title problem?
The text will appear in each of the cells from A3 through A7.
The text will appear in cell A3.
The text will disappear.
The text will appear in cell A5.
Mr. Trumbull has shared a spreadsheet with the class. He has asked the students to shade every other row light grey to make the data easier to read. What should his students do in order to complete this task?
Add the light grey font color to every other row of the spreadsheet.
Add the thick box borders to every other row of the spreadsheet.
Add the light grey fill color to every other row of the spreadsheet.
Use the highlighter in light grey for every other row of the spreadsheet.
Which toolbar button is used to format cell data to a percentage value?
Which toolbar button is used to format cell data to a currency value?
Which tool allows a user to display specific criteria within a cell range?
Fill handle
Filter
Hyperlink
Sort
