21.
Macros can be executed from the which of the following menu ?
- Format
- Home
- Insert
- Tools
22.
Protection and the Protect Sheet options can be selected from ?
Tools
23.
Which of the following is not a valid Zoom percentage in Excel ?
- 10
- 100
- 300
- 500
24.
You can check the conditions against ____ when applying conditional formatting
?
- Cell Value
- Formula
- Both of above
- None of above
25.
How can we set Page Border in Excel ?
You can
not set page border in Excel
26.
Which function calculates your monthly mortage payment ?
PMT
27.
Which types of charts can excel produce ?
Bar
charts, line graphs and pie charts
28.
How is data organized in a spreadsheet ?
Rows and
columns
29.
VLOOKUP function used to ?
Finds
related records
30.
Gridlines may be turned off for display but turned on for printing.
True
31.
How do you change column width to fit the contents ?
Double
click the boundary to the right of the column heading
32.
To insert three columns between columns A and B you would
Select B
33.
To drag a selected range of data to another worksheet in the same workbook, use
the ?
Ctrl key
34.
You can activate a cell by ?
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- All of above
35.
A function inside another function is known as ?
Nested
function
36.
What excel feature can you use if you want to work with one record at a time ?
Data Form
37.
Which function is used for creating a data table ?
Table
38.
The accounting style shows negative numbers in ?
Parentheses
39.
3-D reference in a formula ?
Spans
worksheets
40.
Auto calculate feature provides a quick way to view the results of an
arithmetic operation on a range of cells.
