271. Getting data from a cell located in a different sheet is called ________
A. Accessing
B. Referencing
C. Updating
D. Functioning
✅ The correct answer is option B.
MS Office
272. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value
B. Cell comments
C. Formatting options
D. The resulting values of a formula instead of the actual formula
✅ The correct answer is option D.
273. An Excel Workbook is a collection of ________
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
✅ The correct answer is option D.
274. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A. Right click on Sheet Tab of third sheet and choose Delete from the context menu
B. Click on Sheet 3 and from Edit menu choose Delete
C. Both of above
D. None of above
✅ The correct answer is option A.
275. Ctrl + D shortcut key in Excel will
A. Open the font dialog box
B. Apply double underline for the active cell
C. Fill down in the selection
D. None of above
✅ The correct answer is option C.
276. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
A. Server
B. Source
C. Client
D. None of the above
✅ The correct answer is option C.
277. Which of the following is not the correct method of editing the cell content?
A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
✅ The correct answer is option A.
278. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
✅ The correct answer is option D.
279. Which of the following series type is not valid for Fill Series dialog box?
A. Linear
B. Growth
C. Autofill
D. Time
✅ The correct answer is option D.
280. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A. Square
B. Percentage
C. Goal Seek
D. Divide
✅ The correct answer is option D.