Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q131
In Excel you can activate a cell by
  • A Pressing the Tab key
  • B Clicking the cell
  • C Pressing an arrow key
  • D all of the above
Answer: Option D
Q132
In Excel  Text formulas
  • A Replace cell references
  • B Return ASCI values of characters
  • C Concatenate and manipulate text
  • D Show formula error value
Answer: Option C
Q133
In Excel how do you insert a row ?
  • A Right-click the row heading where you want to insert the new row and select insert from the shortcut menu
  • B Select the row heading where you want to insert the new row and select edit >Row from the menu
  • C Select the row heading where you want to insert the new row and click the insert Row button on the standard toolbar
  • D All of the above
Answer: Option A
Q134
In Excel the following is not a basic step in creating a worksheet
  • A Save workbook
  • B Modifly the worksheet
  • C Enter text and data
  • D Copy the worksheet
Answer: Option D
Q135
In Excel how do you select an entire column?
  • A Select Edit > Select > Column from the menu
  • B Click the column heading letter
  • C Hold down the shift key as you click anywhere in the column.
  • D Hood down the Ctrl key as you click anywhere in the column
Answer: Option A
Q136
In Excel how can you print three copies of a workbook ?
  • A select File > properties form the menu and type 3 in the Copies to print text box.
  • B Select file > Print from the menu and type 3 in the Number of copies text box.
  • C Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made
  • D press Ctrl + P 3
Answer: Option B
Q137
In Excel to create a formula, you first
  • A Select the cell you want to place the formula into
  • B Type the equals sign (=) to tell Excel that you're about to enter a formula
  • C Enter the formula using any input values and the appropriate mathematical operators that make up your formula
  • D Choose the new command from the file menu
Answer: Option A
Q138
In Excel to center worksheet titles across a range of cells, you must
  • A Select the cells containing the title text plus the range over which the title text is to be centered
  • B Widen the columns
  • C Select the cells containing the title text is to be enfettered
  • D Format the cells with the comma style
Answer: Option A
Q139
In Excel how do you delete a column ?
  • A Select the column heading you want to delete and select the Delete Row button on the standard toolbar
  • B Select the column heading you want to delete and select insert delete from the menu
  • C Select the row heading you want to delete and select Edit>Delete from the menu
  • D jRight click the column heading you want to delete and select delete from the shortcut menu
Answer: Option D
Q140
In Excel how can you find specific information in a list ?
  • A Select Tools > Finder from the menu
  • B Click the Find button on the standard toolbar
  • C Select Insert > Find from the menu
  • D Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer: Option D

📚 More from Computer Science & Engineering(CSE)

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Computer Science & Engineering(CSE)
Back to Computer Science & Engineering(CSE)
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test