Microsoft Excel Test P11

This article presents Microsoft Excel Test P11 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Microsoft Excel Test P11

• Question 1. In MS Excel 2010, how to delete the data in the currently selected cells?
  • At the Home tab, select the Delete button in the Cells group.
  • Right-select and select the Clear Contents command.
  • Right-select the currently selected area, select the Delete command.
  • Press BackSpace key
• Question 2. In MS Excel 2010, how do we delete the currently selected rows?
  • Press the Delete key
  • At the Home tab, select the Delete button in the Cell group, select Delete Sheet Rows.
  • Right-select the selected line, Clear Contents.
  • All of the above are correct
• Question 3. In MS Excel 2010, when setting up the formula in cell A3 of Sheet 1 but want to refer to the data in cell B3 in Sheet2 and multiply by 1000, the correct formula is:
  • Sheet1! B3 * 1000
  • B3! Sheet2 * 1000
  • Sheet2! B3 * 1000
  • B3 * 1000
• Question 4. The set of spreadsheets in an Excel file is called one.
  • Document
  • Presentation
  • Sheet
  • Book
• Question 5. In MS Excel 2010, which key combination is used to replace the File operation, select Save.
  • Ctrl-O
  • Ctrl-P
  • Ctrl-S
  • Ctrl-N
• Question 6. In MS Excel 2010, when using the SUM function, can we.
  • Do not use any parameters?
  • Use up to one parameter
  • Use up to two parameters
  • Use up to 255 parameters
• Question 7. In MS Excel 2010, the OR function is a logical function. Function gives true (true) value when.
  • There are at least two conditional expressions of functions that are valid.
  • Just a certain conditional expression of the function is valid.
  • All conditional expressions of functions must be valid.
  • All conditional expressions of functions have a wrong value.
• Question 8. A file is created by. will default to XLSX.
  • Microsoft Word 2010
  • Microsoft Excel 2010
  • Microsoft PowerPoint 2010
  • Microsoft Excel 2003
• Question 9. In MS Excel, which of the following values is interpreted as string data?
  • 0001
  • -567
  • 1000
• Question 10. In MS Excel 2010, suppose that in cell H9 contains the value 167900. In cell G9 we set up the formula. to give the result of 168000.
  • = MOD (H9; 1000)
  • = ROUND (H9; 3)
  • = ROUND (H9; -3)
  • = INT (H9)