| 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.
Formula palette is used to?
Answer: Option 'B'
Create and edit formulas containing functions
2.
What type of chart will you use to compare performance of sales of two products ?
Answer: Option 'A'
Column Chart
3.
The accounting style shows negative numbers in ?
Answer: Option 'C'
Parentheses
4.
Merge cells option can be applied from?
Answer: Option 'B'
Format Cells dialog box Alignment Tab
5.
Which function is used for creating a data table?
Answer: Option 'B'
Table