To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
- Which of the following methods cannot be used to enter data in a cell
- How many worksheets can a workbook have?
- How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
- What does COUNTA () function do?
- Each excel file is called a workbook because
- Excel displays the current cell address in the ........
- How can you show or hide the gridlines in Excel Worksheet?
- What is the short cut key to replace a data with another in sheet?
- A typical worksheet has …. Number of columns
- Text formulas:
- The spelling dialog box can be involved by choosing spelling from ________ menu.
- When a row of data is to be converted into columns
- Which of the following is not the correct method of editing the cell content?
- Tab scrolling button
- The Paste Special command lets you copy and paste:
- Which of the following is the oldest spreadsheet package?
- You can use the horizontal and vertical scroll bars to
- MS-EXCEL is based on .........?
- Which command will you choose to convert a column of data into row?
- A __________ is a grid with labeled columns and rows.
- Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
- By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
- How do you rearrange the data in ascending or descending order?
- Which of following is Not one of Excels what-if function?
- Which of the following is not a basic step in creating a worksheet?
- You can use drag-and-drop to embed excel worksheet data in a word document
- In Excel, the Fill Color button on the Formatting toolbar is used for what?
- When a label is too long to fit within a worksheet cell, you typically must
- Which is used to perform what if analysis?
- To create a formula, you can use: