1. Which of the
following is the second step in creating a macro?
(a) Start recording
(b) Using your mouse or keyboard, perform the task you want to automate
(c) Assign a keyboard shortcut to the macro
(d) Give the macro a name
(e) None of these
Ans : (c)
2. The spelling tool
is placed on………….
(a) Standard
(b) Formatting
(c) Drawing
(d) Reviewing
(e) None of these
Ans : (a)
3. If you need a text
to show vertically in a cell. How will you achieve this?
(a) Choose Vertical on Text alignment in Format Cells dialog box
(b) Choose 90 Degrees in Orientation of Format Cells dialog box
(c) Choose Distributed from the Vertical drop down list of Format Cells dialog box
(d) Choose Center across Selection from Horizontal combo box in Format Cells dialog box
(e) None of these
Ans : (b)
4. Can you set 0.5
inch left indentation for a cell in Excel?
(a) Excel does not have indentation feature
(b) You can specify indentation only if you turn the rulers on
(c) Indentation can be set from Format Cells dialog box
(d) The indentation can be specified only when printing
(e) None of these
Ans : (c)
5. You can
automatically adjust the size of text in a cell if they do not fit in width by
:
(a) Double clicking on the right border of column header
(b) From Format choose Columns and then Auto fit selection
(c) From Format Cells dialog box mark shrink to fit check box
(d) All of these
(e) None of these
Ans : (c)
6. Formatting a cell
in Currency, you can specify
(a) Decimal Places
(b) Currency Symbol
(c) Country name
(d) Both (a) and (b)
(e) None of these
Ans : (d)
7. Formatting a cell
in Number format you can’t set
(a) Decimal Places
(b) Use 1000 separator
(c) Negative numbers
(d) Currency Symbol
(e) None of these
Ans : (d)
8. What is entered by
the function = today ( ) ?
(a) The date value for the day according to system clock
(b) The time value according to system clock
(c) Today’s date as Text format
(d) All of these
(e) None of these
Ans : (a)
9. Which function
will you use to enter current time in a worksheet cell?
(a) = today( )
(b) = now ( )
(c) = time ( )
(d) = current Time ( )
(e) None of these
Ans : (b)
10. Special category
of Number tab in Format cells dialog box can be used to apply formats like :
(a) Zip Code
(b) Phone Number
(c) Postal Address
(d) Both (a) and (b)
(e) None of these
Ans : (d)
11. Merge cells
option can be applied from :
(a) Format Cells dialog box Alignment Tab
(b) Formatting toolbar
(c) Formatting Cells
(d) All of these
(e) None of these
Ans : (a)
12. Pre-mde sheet
formats like Simple, Classic, Accounting, Colorful etc. can be applied from:
(a) from Format > Cells
(b) from Format > Auto format
(c) from Table > Auto format
(d) All of these
(e) None of these
Ans : (b)
13. Which of the
following format you can decide to apply or not in AutoFormat dialog box?
(a) Number format
(b) Border format
(c) Font format
(d) All of these
(e) None of these
Ans : (d)
14. How can you
remove borders applied in cells?
(a) Choose None on Border tab of Format cells
(b) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
(c) Choose remove on Border tab of Format cells
(d) Both (a) and (b)
(e) None of these
Ans : (d)
15. Where can you set
the shedding color for a range of cells in Excel?
(a) Choose required color form Patterns tab of Format Cells dialog box
(b) Choose required color on Fill color tool in Formatting toolbar
(c) Choose required color on Fill Color tool in Drawing toolbar
(d) All of these
(e) None of these
Ans : (d)
16. You can set Page
Border in Excel from:
(a) From Border tab in Format Cells dialog box
(b) From Border tool in Formatting toolbar
(c) From Line Style tool in Drawing toolbar
(d) You cannot set page border in Excel
(e) None of these
Ans : (d)
17. When all the
numbers between 0 and 100 in a range should be displayed in Red Color, apply :
(a) use = if ( ) function to format the required numbers red
(b) Apply Conditional Formatting Command on Format Menu
(c) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
(d) All of these
(e) None of these
Ans : (b)
18. You can check the
conditions against…….. when applying conditional formatting :
(a) Cell value
(b) Formula
(c) Alignment
(d) Both (a) and (b)
(e) None of these
Ans : (d)
19. Which of the
following is not true regarding Conditional Formatting?
(a) You can add more than one condition to check
(b) You can set condition to look for Bold and apply Italics on them.
(c) You can apply Font, border and pattern formats that meets the specified conditions
(d) You can delete any condition from Conditional Formatting dialog box if it is not required
(e) None of these
Ans : (b)
20. Which of the following
is invalid statement?
(a) Sheet tabs can be colored
(b) Some picture can be applied as a background of a sheet
(b) You can set the column width automatically fit the amount of text
(c) The width of a row and be specified manually or fit automatically
(d) None of these
Ans : (d)
21. What function
displays row data in a column or column data in a row?
(a) Hyperlink
(b) Index
(c) Transpose
(d) Rows
(e) None of these
Ans : (c)
22. When you insert
an Excel file into a word document, the data are :
(a) Hyperlinked
(b) Placed in a word table
(c) Linked
(d) Embedded
(e) None of these
Ans : (d)
23. Except for
the……….function, a formula with a logical function shows the word “TRUE” or
“FALSE” as a result :
(a) IF
(b) AND
(c) OR
(d) NOT
(e) None of these
Ans : (a)
24. Macros are “run”
or executed from the …………..menu.
(a) Insert
(b) Format
(c) Tools
(d) Data
(e) None of these
Ans : (c)
25. You can open the
consolidate dialog box byt choosing consolidate from the…….menu.
(a) Insert
(b) Format
(c) Tools
(d) Data
(e) None of these
Ans : (d)
No comments:
Post a Comment