Font size
WorksheetsIntroduction to excel 2010
Total questions: 17
Worksheet time: 9mins
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
You can edit a cell by
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
There are 16,384 rows and 1,048,576 columns in a worksheet.
True
False
Two types of data can be entered in an Excel workbook.
False
True
Data entered in a cell appears in Formula bar as well as in active cell.
True
False
The active cell is not bordered with a black outline.
False
True
keyboard shortcut to select entire worksheet is Ctrl+A
False
True
Press (a) key on the keyboard for partial modification of data.
Collection of worksheets
Collection of excel files
Collection of cells
Collection of rows & columns
Collection of spreadsheets
