Enjoy these Software Big Brain quizzes we've created for you, helping to test the Software knowledge you have.
Question 1
How can I select an entire worksheet in Excel?
Click the grey square between the header of Column A and Row 1
Right click on the first cell in the worksheet and choose Select All
Click into cell A1, hold down the Ctrl and Shift keys and press End
Choose Select Worksheet from the File menu
Question 2
How can I select non-adjacent columns in Excel?
Click on the first column header, hold down the Shift key and click on each additional header
Right click on each column header and choose select
Click on the first column header, hold down the Ctrl key and click on each additional header
Select Non-adjacent from the Edit menu and click each column header once
Question 3
How can I select a column of data (not the entire column - just the data) in Excel?
Click in the top cell, hold down the Ctrl and Shift keys and press the down arrow key
Click anywhere in the data, hold down the Shift key and press the down arrow key
Move the cursor over the bottom edge of the first cell (the cursor will change to a white arrow) and double click
Click in the top cell, hold down the Ctrl key and click in the last cell
Question 4
How can I select an entire table of data in an Excel worksheet?
Click in the first cell, hold down the Ctrl and Shift keys and press the End key
Double click in the last cell of your table
Right click on any cell and choose Select Data
Click anywhere within the data, hold down the Ctrl key and press * (on the numeric keypad)
Microsoft will tell you that the correct solution is Answer 1 (Ctrl, Shift End), however this solution is not reliable and will sometimes include other cells outside of your table.
Ctrl * is the simplest and most reliable method of selecting a table of data.
Question 5
How can I select rows 1,2,3,4 and 5 in Excel?
Select the first cell in each row, right click and choose Select Rows
Click on the header of the first row, hold down the Alt key and click on the header of the last row
Click on the header of the first row, hold down the Shift key and click on the header of the last row
Select any cell in the first row, hold down the Shift key and click on any cell in the last row
Question 6
How can I select more than one worksheet in Excel?
Right click on a sheet name tab, choose Select Sheets and then click on each additional sheet name tab
Click on the first sheet name tab and drag across to the last sheet name tab
Click on the first sheet name tab, hold down the Shift key and click on the last sheet name tab
Click on the first sheet name tab, hold down the Alt key and click on the last sheet name tab
