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.
With which of the following all formulas in excel starts ?
Answer: Option 'D'
=
2.
On an excel sheet the active cell in indicated by ?
Answer: Option 'C'
A dark wide border
3.
What term describes explanatory text attached to a cell ?
Answer: Option 'C'
Comments
Basic Computer Knowledge Quiz
4.
How we can view a cell comment ?
Answer: Option 'A'
position the mouse pointer over the cell
5.
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
6.
The default style for new data keyed in a new workbook is ?
Answer: Option 'A'
Normal
7.
If you press ___, the cell accepts your typing as its contents ?
Answer: Option 'B'
8.
Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?
Answer: Option 'A'
F11
9.
A value used in a formula that does not change is called a ?
Answer: Option 'A'
Constant
10.
Formula palette is used to ?
Answer: Option 'B'
create and edit formulas containing functions
11.
A Spreadsheet contains ?
Answer: Option 'C'
rows and columns
12.
To open an existing workbook, click the Open button on the ___ toolbar ?
Answer: Option 'B'
Standard
Basic Computer Knowledge Quiz
13.
Which among following is not associated with spelling dialogue box ?
Answer: Option 'A'
Edit
14.
what term describes a background that appears as a grainy, non smooth surface ?
Answer: Option 'B'
Gradient
15.
Which among following is associated with excel ?
Answer: Option 'B'
Spreadsheet
16.
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 ?
Answer: Option 'B'
17.
You can convert existing Excel worksheet data and charts to HTML document by using the ?
Answer: Option 'B'
Internet Assistant Wizard
18.
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?
Answer: Option 'A'
Pivot Table Report
19.
What function displays row data in a column or column data in a row ?
Answer: Option 'D'
Transpose
Basic Computer Knowledge Quiz
20.
Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
Answer: Option 'C'
IF