01. What role has the " Compare Side by Side with " command on the window menu perform?
Answer: It allows you to scroll through two or more books at the same time
02. Which of the following functions would return a value of 8 ?
Answer: round ( 8.4999,0 )
03. What will be the output of the function IF ( ISNA ( MODE ( B1 : B4 ) ) , 0, MODE ( B1 : B4 ) ) when applied to the data series given below ?
B1: 27
B2: 22
B3 : 28
B4: 21
Replies: 0
04. How can you select all the blank cells in your worksheet ?
Answer: Choose blank in the > Edit- Go To -> Special menu option
The question is based on the figure shown
05. The figure shows a view of the Standard Toolbar . What function is performed by the button marked by the letter Y?
Answer: The sum of the values of selected cells
06. You have entered an essay in a cell that is too large for the cell. You want the text to appear on multiple lines within the same cell. What do you do?
Answer: Use the settings in the txt - > Format Cells > Alignment Menu
07. Which of the following errors appears when an invalid argument passed while converting a number from one number system to another system?
Answer: # N / A
08. Suppose the value in cell A1 is John and B1 is Smith then which of the following functions to be used for John_Smith in cell C1 ?
A: = A1 & " _" & B1
09. Which of the following date and time function to use to return the serial number of the last day of the month before or after a certain number of months?
Answer: EOMONTH
10 . Which of the following shortcuts can be used to insert a new line in the same cell ?
Answer: Alt + Enter
11. Which of the following functions to be used to find the highest number in a series of numbers ?
Answer: MAX ( B1 : B3 )
12. State whether true or false.
Answer: True
13. This question is based on the figure below
What does the purple triangle in the lower right corner of the cell mean?
Ans : Smart Tag
14. You have created a worksheet which consists of a set of confidential data. You want 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 . What method will help you do this?
Answer: Select the cells , open the Window menu and click Hide
15. This question is based on the figure shown below
The figure shows an Excel spreadsheet . What does the triangle read in C2 means ?
Answer: There is a comment associated with the cell
16. You select the row headings 10, 11 and 12 and then choose the menu option Insert - > Rows . What will happen?
Answer: 3 new rows are inserted after row 9
17. The figure shows the calculation tab in Tools- > Options. The option under the calculation is tested as automatic. What does this mean?
Answer:
18. Which of the following statements regarding the function QUARTILE not?
Answer: The median function (array ) and QUARTILEarray , 2) returns different values when applied to the same array .
19. You entered a 4/6 as data in a cell without applying any formats to it. By default , Excel will treat this data entry as:
Answer: Date
20 . This question is based on the figure shown below
What will be the value in cell C2 as shown in the figure, when we use the formula = A2 + B2 ?
Ans : 120
21. What is the quickest way to select all columns in a spreadsheet?
Ans: Click on the gray rectangle in the upper left corner of the spreadsheet in the column headings and row headings meet
22. What does the NOW ( ) returns ?
Answer: Returns the serial number of the current date and time
23. A smart tag will be removed from a cell whenナナナナナナ.
Answer: The cell data is changed or deleted
24. You want to restrict the values that can be introduced into a cell so that only integers between 1 and 100 can be entered. What menu option allows you to accomplish this?
Answer: The settings tab in the menu Data> Validation
25 . What should be added before to avoid a fraction as a date, eg . Third , in Excel ?
Answer:
26. Start Microsoft Excel and do not want to run a macro automatically at startup. What do you do?
Answer: Hold down the CTRL key during startup
27. How does the AutoComplete feature in Excel help you save time ?
Answer: It automatically completes abbreviated words
28. The figure shows a view of the Standard Toolbar . What function is performed by the button marked with the letter Z ?
Answer: It copies the formatting properties from one cell to another
29.The figure shows the AutoFit menu selection . What do they do ?
Ans :: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell
30. The figure shows a view of the Standard Toolbar . What function is performed by the button marked by the letter A
Answer: It is used to add a hyperlink
31. Which of the following would be used if necessary insert a 77889867810070809 number in a cell ?
Answer: Apply the Text Format to empty cells , and then type the numbers
32 . What is the quickest way to select all columns in a spreadsheet?
Ans: Click on the gray rectangle in the upper left corner of the spreadsheet in the column headings and row headings meet
33 . Suppose the value in cell A1 is John and B1 is Smith then which of the following functions to be used to get the John_Smith in cell C1 ?
Answer: A_B
34 . How can you select all the blank cells in your worksheet ?
Answer: This must be done manually, as it is not automated through any built-in function
35 . The figure shows an Excel spreadsheet . If you want to F the row showing the months ( row 1 ) and the column showing the products (column A) , what to do ?
Answer: Select the cell A1 and click on Freeze Panes on the Window menu Panes - > Freeze
36 . Which of the following functions would return a value of 8 ?
Answer: b and c
37 . You select the row headings 10, 11 and 12 and then choose the menu option Insert - > Rows . What will happen?
Answer: 3 new rows are inserted after row 9
38 . The figure shows a view of the Drawing toolbar . What function is performed by the button marked by the letter X ?
Answer: It inserts a Diagram or Organization Chart in the worksheet
39.When with Document Workspaces , you can 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 site area documents.
Answer: TRUE
40 . You have created a worksheet that contains confidential data. You want 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 . What method will help you do this?
Answer: Select the cells , open the Window menu and click Hide
41 . Which of the following date and time functions that you will use to return the serial number of the last day of the month before or after a certain number of months?
Answer: DATEVALUE
42 . The figure shows a view of the Standard Toolbar . What function is performed by the button marked by the letter Y?
Answer: Add up the values of the selected cells
43.Which of the following errors appears when an invalid argument passed while converting a number from one number system to another system?
Answer: # N / A
44 . Which of the following functions to be used to find the highest number in a series of numbers ?
Answer: MAX ( B1 : B3 )
45 . You entered a 4/6 as data in a cell without applying any formats to it. By default , Excel will treat this data entry as:
Answer: Date]
46 . What will be the output of the function IF ( ISNA ( MODE ( B1 : B4 ) ) , 0, MODE ( B1 : B4 ) ) when applied to the data series given below ?
Answer: # N / A
47 . AutoFilter dropdown automatically added to the header row of the list when the list is created .
Answer: TRUE
48 . What does the NOW ( ) returns ?
Answer: Returns the serial number of the current date and time
49 . What tools are shown in Figure ?
Answer: the Forms toolbar
50 . Deleting the contents of a cell , you also lose the cell formatting .
Answer: FALSE
51 . We define a print area worksheet , but later you select a smaller range of cells to print and then click Selection in the File - > Print - > Selection. What will happen?
Answer: b
52 . figure shows a view of the Standard Toolbar . What function is performed by the button marked by the letter "Z "?
Answer: It copies the formatting properties from one cell to another
53 . The arithmetic multiplication operator is represented by which of the following symbols
Answer: *
54 . You can select the current row by pressing
Answer: Shift + Spacebar
55 . Donelp doing this?
Answer: Select the cells , open the Window menu and click Hide
56 . The figure shows a view of the Standard Toolbar . What function is performed by the button marked with the letter Y
Answer: Add up the values of the selected cells
57 . We define a print area worksheet , but later you select a smaller range of cells to print and then click Selection in the File - > Print - > Print What - > Selection. What will happen?
Response : The selected area will be printed
58 . By default , how text is aligned horizontally within a cell in Excel ?
Answer: flush left
59 . When the handle is used to quickly fill AutoFill a range of cells with the same data or consecutively , cells need not be contiguous , so long as they are within the same sheet.
Answer: False
60 . When you click the AutoSum button , Excel looks first in a series of numbers above the active cell.
Answer: True
61 . A relative cell reference changes when a formula is copied or moved to other places.
Answer: True
62 . If you change cell entries , the formula automatically calculate values and insert the result in the cell containing the formula.
Answer: True
62 . The Merge button on the Formatting toolbar merge selected cells and right align the data within the cells.
Answer: False
63 . To move the insertion point to the next cell , press :
Answer: Enter
64 . Through the range A3 G3 must be typed as:
Answer: A3 : G3
65 . A document created in Excel is known as a
Answer: Book
67 . Use this lever to automatically insert the month in the series, January:
Answer: Fill
68 . Which of these operators are in the correct order of operations ?
Answer: ^ , *, -
69 . If the entered text does not fit in a cell , Excel displays # # # # # to indicate that the text is too long
Answer: True
70 . By default , the data of a cell is focused
Answer: False
71 . When you add a new row in a spreadsheet Excel , by default , this row is inserted just below the active cell.
Answer: True
72 . To insert a row , click Insert and then Rows
Answer: True
73 . Divide option causes the sheet is divided into two windowpanes .
Answer: False
74 . A column is inserted immediately to the left of the column that contains the active cell unless decided otherwise
Answer: True
75 . To delete a specific cell, and the text within it , make the active cell and then
Answer : Click on Edit and then click Delete
76 . Which of the following is an absolute cell reference
Answer: $ B3
77 . To select non-adjacent cells , columns or rows, you must
Answer: hold down the Ctrl key while clicking on the column header row or specific cells
78 . When you copy the selected cells to a new location , place your mouse over any border around the selected cells , until it becomes a ( a)
Answer: arrow pointer
79 . When data are linked , a change made in a cell is automatically linked to other cells in the link.
Answer: True
80 . The selected cells and cell content can be moved or copied into a spreadsheet, but not between worksheets.
Answer: False
81 . Time in a cell in Excel is stored as a decimal fraction representing a portion of the day
Answer: True
82 . The PMT function is used to calculate your loan payment based on a variable interest rate , payment and time period .
Answer: False
83 . Division lines that appear on the worksheet is printed as shown .
Answer: False
84 . The FV function is used to calculate the future value of an investment based on periodic , constant payment of the interest rate
Answer: True
85 . To apply page numbers to a spreadsheet page , the option in the dialog box to choose Page Setup
Re: Header / Footer
86 . If a function is included in an argument inside a function , which is called a
Answer: nested function
87 . If you want to row and column headings for printing that tab click the Settings dialog page ?
Re: Header / Footer
88 . A new workbook initially contains this amount of leaf
Answer: Three
89 . An Excel workbook saved in HTML format allows users of Internet or intranet to access the data in the book, even if you do not have Excel installed
Answer: True
90 . Once the table is created , the data can only be changed in a graph is on the same worksheet as the changed cells
Answer: False
91 . Certain elements of chart automatically inserted in a chart created by the Chart Wizard includes a chart legend labels for the X axis and Y axis , and a chart title
Answer: False
92 . You can double- click a chart element to display the dialog box format.
Answer: True
93 . You can resize an image using white sizing handles .
Answer: True
94 . To make the image taller or shorter , use medium size driver on the left or right of the image.
Answer: False
95 . Which of the following is not a tab in the Options dialog box chart?
Answer: Patterns
96 . This table is the default table
Answer: Column Chart
97.Which of the following shows the contents of the active cell ?
Answer: Formula Bar
98 . A spreadsheet is an individual page or tab in the workbook.
Answer: True
99 . Cell format can be copied from one cell to another using the
Answer: Format Painter
No comments:
Post a Comment