Question 71. To move around the tabs at the bottom of a workbook:
a. Right click on desired tab, choose "move or copy", choose where to place it in list
provided
b. Click on desired tab and drag to new location
c. Both are correct
d. None of these
Answer : c
Question 72. The formula =((A2+B5)*5% is valid.
a. True
b. False
Answer : b
Question 73. When you widen a column that results in excess row height, you can eliminate the
excess row height by:
a. Using the shortcut keys Alt-O,R,A
b. Using the Home/Cells/Format/Auto Fit Row Height
c. Double clicking the bottom of the row number box
d. All of these
Answer : d
Question 74. How do you change all positive numbers in a sheet to negatives?
a. Type everything again with a -sign
b. Write-1 anywhere in the sheet, copy it, select the data to change, Paste Special, select
Multiply
c. Delete the numbers and reenter
d. Select-and Press Enter
Answer : b
Question 75. The process of identifying specific rows and columns so that certain column and rows
are always visible on the screen is called?
a. Attaching
b. Fixing
c. Freezing
d. Holding
e. Selecting
Answer : c
Question 76. Which function copies data from a row into a column or vice versa?
a. Rows
b. Index
c. Transpose
d. Hyperlink
Answer : c
Question 77. 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. Both of these
d. None of these
Answer : c
Question 78. Double-clicking column separators will do what?
a. Adjust number alignment
b. Hide Columns
c. Automatically adjust column width
d. Delete both columns
e. Create and additional column in between the two columns
Answer : c
Question 79. In a Excel spreadsheet, It's possible to select multiple non-adjacent ranges of
cells.
a. True. We select the first block of cells and then we use the CTRL key + selecting the other
blocks.
b. False. It's not possible to select multiple non adjacent ranges of cells, in Excel.
c. True. We select the first block of cells and then we use the SHIFT key + selecting the
other blocks.
Answer : a
Question 80. In the Find and Replace function it is NOT possible to replace what you've searched
for with an alternative at the same time.
a. True
b. False
Answer : b