1) You are making a
sales performance report in Excel which you would like to present to the top management. Some of the column
headings are too large and look out of place
in their cells. You decide to display the headings as slanted text to save
space. How is this achieved?
(b) By
altering the Text Orientation on the Alignment tab
2) What Function does
the ‘Compare Side by Side With’ command on the window menu perform?
(b) It allows you to scroll through two or more workbooks simultaneously
(b) It allows you to scroll through two or more workbooks simultaneously
3) State Whether True or false.
(a) True
4) You have recorded a macro. By mistake you
recorded an action in it which you do not want. How will you remove the
unwanted action without having to record the whole macro again?
(d) by opening the macro in the Visual Basic
Editor and then removing the actions
which are not required
5) You have entered text in a cell which is
too big for the cell. You want the text to appear in multiple lines inside the
same cell. What will you do?
(b) Use the wrap txt option in the Format->Cells>Alignment Menu
(b) Use the wrap txt option in the Format->Cells>Alignment Menu
6) Which of the
following Date and Time function you will use to return the serial number of
the last day of the month before or after a specified number of months?
(b) EOMONTH
7) The figure shows the
AutoFit Selection menu option. What function does it perform?
(c) It automatically resizes the column height and width to the
minimum necessary to fit the contents of the selected cell
8) You start Microsoft
Excel and you do not want it to automatically run a macro upon starting. What
will you do?
(b) Hold down the CTRL key during startup
9) Which of the
following errors appears when an invalid argument is passed while converting a
number from one number system to another system?
(a)#N/A
10) The figure shows a
view of the Standard Toolbar. What function is performed by the button marked
by the letter 'A'?
(c) It is used to add a hyperlink
11) You select the row
headings 10, 11 and 12 and then choose the menu option Insert->Rows. What
will happen?
(c) 3 new rows will be inserted after row 9
12) You define a print
area in your worksheet, but later you select a smaller range of cells to print
and then click Selection under the menu File->Print->Print
What->Selection. What will happen?
(b) The selected area will be printed
13) This question is
based upon the figure shown bellow
The figure shows an Excel
worksheet. What does the read triangle in C2 signify?
(d) There is a comment associated with the cell
14) You would like to
restrict the values that can be entered into a cell so that only whole numbers
between 1 and 100 can be entered. Which option in the menu allows you to
accomplish this?
(a) The Settings tab under the menu
Data->Validation
15) You have entered 4/6
as data in a cell without applying any formats to it. By default, Excel will
treat this data entry as a:
(b) Date
16) What should you add
before a fraction to avoid entering it as a date, e.g. 1/3, in Excel?
(e) zero space
17) Which of the
following functions would return a value of 8?
(b) rounddown(8,4999,0) and (c) round(8,4999,0)
18) What will be the
output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied
to the data series given below?
B1:27
B2:22
B3:28
B4:21
(c) 0
B2:22
B3:28
B4:21
(c) 0
19) How does the
AutoComplete feature in Excel help you save time?
(a) It automatically completes abbreviated words
20) This question is based
upon the figure shown below
(c) It displays when the current document was last
modified
21) You have created a
worksheet which consists a confidential data. You want that these values,
although present in the worksheet, should remain hidden and as a result the
cells containing this data should appear blank in the worksheet. Which method
will help you do this?
(b) Select the cells, open the Window menu and
click on Hide
22) There is a workbook
names Sales.xls which has a worksheet named Quarterly. The worksheet contains
the quarterly sales figures for the company in cells A3 to A6. Now you want to
create a formula in a different workbook that reads the quarterly sales figures
and adds them up while the Sales workbook is open. Which of the following is
the correct formula to do this?
(c) =SUM([Sales.xls]Quarterly!A3:A6)
23) When you clear the
contents from a cell, the formatting of the cell is also lost.
(b) FALSE
24) Which of the
following function you will use to find the highest number in a series of
numbers?
(a) MAX(B1:B3)
25) This question is
based upon the figure bellow
What does
the purple triangle at the bottom right corner of the cell signify?
(c) Smart Tag
26) What value is
displayed if the formula =2+"$9.00" is entered into a cell?
(b) 11
27) The figure show the
Text to Column menu option. What function does it perform?
(a) It allows you to add comma separated text into
various cells automatically
28) State Whether True or false.
When
using Document Workspaces, you cannot work directly on the Document Workspace
copy, but you can work on your own copy which you can update periodically with
changes that have been saved to the copy on the Document Workspace site.
(a) TRUE
29) The
figure shows the calculation tab under the Tools->options menu. The
option under Calcula tion has been
checked as Automatic. What does this mean?
30) Which
of the following statements regarding the QUARTILE function is not true?
(d) The function MEDIAN(array) and
QUARTILEarray,2) will return different values when applied to the same array.
31) When
using the VLOOKUP function, the error #REF! will appear in a cell if
_______________
(b) The col_index_num argument is greater than the
number of columns in table_array
32) The
figure shows an Excel worksheet. If you want to freeze the row showing the
months (row 1) and the column showing the products (column A), what should you
do?
(c) Select the cell A1 and click on Freeze Panes
under the menu Window->Freeze Panes
33) Which of
the following statements is true if the cell B1 contains the formula =$A$1
(b) There is an absolute reference to cell A1 so
that the formula =$A$1 can be copied to other cells without changing the
reference to A1
34) The
figure shows a view of the Drawing Toolbar. What function is performed by the
button marked by the letter 'X' ?
(a) It inserts a Diagram or Organization Chart in the worksheet
35) AutoFilter
drop-downs are automatically added in the header row of a list when the list is
created.
(a) TRUE
36) Suppose
the value in cell A1 is John and B1 is Smith then which of the following
function you will use to get John_Smith in Cell C1?
(b) = A1&”_”&B1
37) Which of
the following statement is true if the author has created the content with
restricted permissions using IRM
(a) Prevent an unauthorized recipient from accessing e-mail content,
including attachments.
(b) Prevent restricted e-mail content from being copied by using the
Print Screen feature in Microsoft
Windows
38) What does
the NOW() function returns?
(a) Returns the serial number of the current date and time
39) Which of
the following shortcuts can be used to insert a new line in the same cell?
(c) Alt+Enter
40) Which of
the following options would be used if you need to insert a 77889867810070809
number in a cell?
(d) Apply the Text Format to empty cells, and then type the numbers