NEW
Font size
WorksheetsComputer- Excel Lesson1-4
Total questions: 55
Worksheet time: 56mins
The following shrtcut key combination will allow you to Open, Close and create a New workbook, respectively:
Pressing Alt + O to Open, Alt + C to Close, Alt + N for New.
Pressing Control + O for Open, Control + C for Close, Control + N for New.
Pressing Control + O for Open, Control + W for Close, Control + N for New.
None of the above options are correct.
To move to the previous worksheet, press
Alt + PgUp
Ctrl + PgUp
Ctrl + PgDn
Shift + Tab
To move to the next worksheet press
Crtl+PgUp
Ctrl+PgDn
Shift+Tab
Ctrl+Tab
What is the shortcut key to save a workbook?
Ctrl+Enter
Ctrl+Shift+S
Alt+S
Ctrl+S
If you press_______, the cell accepts your typing as its contents
Enter
Ctrl+Enter
Tab
Insert
Which command should you use if you want to save your wook with a different file name?
Save
Save as
Save info
As Sav
Study the screenshot below. How would you go about renaming in the third wordsheet tab currently labelled Sheet3 ?
Left-click the tab and type the new name directly on the worksheet tab.
Right-click the tab type the new name directly on the worksheet tab.
Right-click the tab and select Rename from the menu list. Type the New name on the worksheet tab.
All of the above options are correct.
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
View different worksheets
Study the screenshot above. What is the name and purpose of the area circled in yellow?
These are called the name tabs or worksheet tabs. They open separate worksheets.
These are called the work tabs or row labels. They open separate workbooks.
These are called worksheet tabs or sheet tabs. They open up separate worksheets within the same workbook.
These are called tabs or section breaks. They open up separate areas within the same worksheet.
Study the screenshot above. Which of the options below best identifies the area circled in yellow?
This is the Number Bar.
These are Row Headings or Labels.
These are Line Numbers.
These are Numeric Labels.
In the screenshot above, what is the correct term for the block that is circled in yellow?
It is called a cell.
It is called an Excel box.
It is called a Cell Area.
It is called an Active Cell.
What is the area circled in yellow in the screenshot above called?
It is called the Name Box.
It is called the Active Cell.
It is called the Status Bar.
It is called the Formula Bar.
Study the screenshot above. What are the alphabetical row of letters circled in yellow above, known as?
They are known as Column Letters.
They are known as Excel Letters.
They are known as Column Headings or Labels.
These are known as Alphabetical Labels.
Study the screenshot above. The box circled in yellow is known as:
The Excel Name Box.
The Active Cell.
The Formula Bar.
The Status Bar.
In the screenshot above, what is the area circled in yellow known as?
The Windows Bar.
The Status Bar.
The Information Bar.
The Commands Bar.
In the screenshot above, what is the area circled in yellow known as?
This is the Workbook Name.
This is the Worksheet Name.
This is the Tab Name.
This is the Workbook File Type.
What is the area circled in yellow in the screenshot above, known as?
This is the Ribbon.
This is the Backstage Area.
This is the Menu Bar.
This is the Function Button Bar.
The Backstage Area is where you save your workbook, change workbook options, view workbook properties, access Excel templates and many other essential functions. Which of the labelled and circled areas in the screenshot above will give you access to the Backstage area?
The area circled and labelled A.
The area circled and labelled B.
The area circled and labelled C.
The area circled and labelled D.
Which of the following shortcut key to edit the selected cell?
F3
F8
F4
F2
The number of rows in a worksheet are
36500
65536
256
64536
Which of the folllowing component displays the contents of active cell?
Name Box
Formula Bar
Menu Bar
Status Bar
Which of the following component shortcut to copy the selected cell?
Ctrl+X
Ctrl+V
Ctrl+C
None of above
Which of the following component shortcut to cut the selected cell?
Ctrl+X
Ctrl+V
Ctrl+C
None of above
Which of the following component shortcut to paste the selected cell?
Ctrl+V
Ctrl+X
Ctrl+C
None of above
The Software which contains rows and columns is called______.
Database
Drawing
Spreadsheet
Word processing
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of above
Give me an example of cell address
1315
118
33A
A22
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
The autofill feature
Extends a sequential series of data
Automatically adds range of cell values
Applies a boarder around the selected cells
All of the above
You can use the format painter multiple times before you turn it off by
You can use the format painter only one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button.
Pressing the Alt key and clicking the format painter button
To quickly move back to the first cell of your worksheet (usually A1), which shortcut combination would you use?
Ctrl+Up Arrow Key.
Ctrl+Page Up.
Ctrl+Home.
Ctrl+Space.
What is the purpose of the Page Up and Page Down keys?
They do not have a purpose in Excel.
It moves the visible sheet up a paper size or down a paper size.
It moves to the next worksheet and back again.
It moves the visible screen up or down.
If you quickly want to undo or redo an action in Excel, which shortcut keys would you use?
Ctrl+z and Ctrl+y
Ctrl+u and Ctrl+r
Ctrl+un and Ctrl+re
All of the above shortcut keys will work.
When entering data in Excel it may be inconvenient to have to use the mouse to move to the left or right through cells in a row. Which shortcut key combination could you use to move to the left or right through cells in a row?
Tab and Shift+Tab or the right and left arrows
Enter and Shift+Enter or the right and left arrows
Ctrl+l and Ctrl+r or the right and left arrows
All of the above options are correct.
f you wanted to reformat your entire worksheet, for example to change the font, which shortcut key combination could you use to quickly select the whole worksheet?
Ctrl+Shift+Spacebar
Ctrl+a
Shift+a
Alt+a
The Spreadsheet contains:
columns
rows
row and columns
None of above
Excel is_____.
Graphic program
Word Processor
Presentation
Spreadsheet
The intersection of row and column is called a______.
dataset
cell
data
set
The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is _____.
C1:10H
C1:H10
C1:H-10
C1:H:10
The name box appears at the ______________.
left formula bar
right of the formula bar
below the status bar
below the menu bar
Which shortcut key combination allows you to quickly select multiple adjacent groups of cells?
Alt+Arrow Keys
Ctrl+a
Ctrl+Arrow Keys
Ctrl+Shift+Arrow Keys
Study the screenshot of a worksheet below this question. The selected cells are the ones containing the heading “My Candy Shop Sales”.
How can you quickly select only the data set that belongs to this heading (i.e. all the cells that contain data)?
By pressing Ctrl+Shift+End
By pressing Ctrl+Shift+a
By pressing Shift+Down Arrow
All of the above options are correct.
The ability to quickly move from the end of a row back to the first cell in a row, especially in a worksheet where rows span several columns. Which of the following shortcut keys will allow you to do this?
Ctrl+b and Ctr+h
Ctrl+Home and Ctrl+End
The Home key
None of the above options are correct.
Study the screenshot below this question. Which shortcut key combinations would you use to quickly select the column or the row that the selected cell (E11) is situated in?
Shift+Space and Ctrl+Space
Ctrl+Shift+Space and Ctrl+Space
Ctrl+Shift and Ctrl+Space
Ctrl+a and Ctrl+Shift+a
To insert three columns between columns D and E you would
Select column D
Select column E
Select columns E, F and G.
Select columns D,E, and F.
How do you insert a row?
Right-click the row heading when you want to insert the new row and select Insect 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 Insect Row button on the standard toolbar
All of the above
How do you change column width to fit the contents?
single-click boundary to the left to the column heading
double-click boundary to the right of the column heading
press Alt and single click anywhere in the column
all of the above
Selecting the Column G & H then choose Insert->Columns. What will happen?
2 Columns will be inserted after Column F
2 Columns will be inserted after Column G
2 Columns will be inserted after Column H
2 Columns will be inserted after Column I
Pressing "DELETE" key from a keyboard will clear
Text Only.
Format Only.
Contents Only.
Both Contents and Format.
Selecting the row 5 & 6&7 then choose Insert->Row.What will happen?
3 Rows will be inserted after Row 4
3 Rows will be inserted after Row 5
2 Rows will be inserted after Row 6
2 Rows will be inserted after Row 7
To insect two rows between row2 and 3 you would
Select row2
Select row3
Select row2 and 3
all above are correct
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
Long text can be broken down into many lines within a cell. You can press
In a worksheet you can select
Entire worksheet
Rows
Columns
All of the above
You want to insert column, you must
Click the Insert common on Home tab>>Click the Insert Sheet Columns
Click the Insert common on Insert tab>>Click the Insert Sheet Columns
Click the Add common on Home tab>>Click the Insert Sheet Columns
Click the Add common on Insert tab>>Click the Insert Sheet Columns
