Shortcut Keys | Description | |
---|---|---|
F2 | Edit the selected cell. | |
F5 | Go to a specific e.g., C6 | |
F7 | Spell chech selected text and/or document. | |
F11 | Create chart. | |
Ctrl + Shift + ; | Enter the current time. | |
Ctrl + ; | Enter the current date. | |
Alt + Shift + F1 | Insert new worksheet. | |
Shift + F3 | Open the Excel formula window. | |
Shift + F5 | Bring up search box. | |
Ctrl + A | Select all contents of the worksheet. | |
Ctrl + B | Bold highlighted selection. | |
Ctrl + I | Italic highlighted selection. | |
Ctrl + K | Insert link. | |
Ctrl + U | Underline highlighted selection. | |
Ctrl + 5 | Strike through highlighted selection. | |
Ctrl + P | Bring up the print dialog box to begin printing. | |
Ctrl + Z | Undo last action. | |
Ctrl + F9 | Minimise current workbook. | |
Ctrl + F10 | Maximise currently selected workbook. | |
Ctrl + F6 | Switch between open workbooks/windows. | |
Ctrl + Page up | Move between Excwl worksheets in the same Excel document. | |
Ctrl + Page down | Move between Excwl worksheets in the same Excel document. | |
Ctrl + Tab | Move between two or more open Excel files. | |
Alt + = | Create a formula to sum all of the above cells. | |
Ctrl + ' | Insert the value of the above cell into cell currently selected. | |
Ctrl + Shift + ! | Format number in comma format. | |
Ctrl + Shift + $ | Format number in currency format. | |
Ctrl + Shift + # | Format number in date format. | |
Ctrl + Shift + % | Format number in percentage format. | |
Ctrl + Shift + @ | Format number in time format. | |
Ctrl + Arrow key | Move to next section of text. | |
Ctrl + Space | Select entire column. | |
Shift + Space | Select entire row. |
1.
Statistical calculations and preparation of tables and graphs can be done using
Answer: Option 'B'
Excel
2.
The intersection of row and column is called a ?
Answer: Option 'B'
cell
3.
The basic unit of a worksheet into which you enter data in Excel is called a
Answer: Option 'A'
column
4.
You can convert existing Excel worksheet data and charts to HTML document by using the?
Answer: Option 'D'
Internet Assistant Wizard
5.
Protection and the Protect Sheet options can be selected from ?
Answer: Option 'B'
6.
In Excel, Rows are labelled as ________.
Answer: Option 'B'
1,2,3 etc
7.
What type of chart will you use to compare performance of sales of two products ?
Answer: Option 'A'
Column Chart
8.
3-D reference in a formula?
Answer: Option 'A'
Spans worksheets
9.
It is a collection of data that is stored electronically as a series of records in a table.
Answer: Option 'C'
database
10.
Style sheet formats can be applied from ?
Answer: Option 'B'
Format >> Autoformat
11.
Which of these will not select all the cells in a document ?
Answer: Option 'C'
Clicking three times with the right mouse button in the spreadsheet
12.
Formula palette is used to?
Answer: Option 'B'
Create and edit formulas containing functions
13.
What type of chart will you use to compare performance of two employees in the year 2016 ?
Answer: Option 'B'
Line Chart
14.
Which among following wildcard characters are recognized by excel ?
Answer: Option 'C'
* and ?
15.
what term describes a background that appears as a grainy, non smooth surface?
Answer: Option 'B'
Gradient
16.
A features that displays only the data in column (s) according to specified criteria
Answer: Option 'B'
Filtering
17.
How will you graphically represent expenditure in different departments ?
Answer: Option 'C'
Pie Chart
18.
Which among following is associated with excel ?
Answer: Option 'B'
Spreadsheet
19.
Which function calculates your monthly mortage payment ?
Answer: Option 'C'
PMT
20.
The name box appears at the ?
Answer: Option 'A'
left of the formula bar