Table of Contents
This article presents Microsoft Excel Test P15 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.
Understanding Microsoft Excel Test P15
- Question 1. In Excel worksheet, In cell A2 type in formula = MA30,10,65.5, then get the result in cell A2:
- 5
- 30
- 65
- 110
- Question 2. In Excel, in cell A2 the value is "Tinhoc"; In cell C2, type in formula = A2, the result in C2 is:
- #Value
- TINHOC
- News
- Tinhoc
- Question 3. In Excel spreadsheet, to filter the data automatically, after selecting the block to be filtered, we do:
- Format - Filter - AutoFilter
- Insert - Filter- Auto Filter
- Data- Filter- AutoFilter
- View - Filter - AutoFilter
- Question 4. In the Excel spreadsheet, which of the following functions allows the sum of numerical values to satisfy a given condition?
- SUM
- COUNTIF
- COUNT
- SUMIF
- Question 5. In Excel spreadsheet, to insert a column into the worksheet, we execute:
- Table - Insert Columns
- Format- Cells- Insert Columns
- Table- Inser Cells
- Insert - Column
- Question 6. When working with Excel, it is possible to move from one sheet to another using the keys or key combinations:
- Page Up; Page Down
- Ctrl - Page Up; Ctrl - Page Down
- Both sentences are true
- Both sentences are wrong
- Question 7. In Excel, which of the SUMIF function syntax is correct?
- SumIf (range, criteria, [sum_range])
- SumIf (criteria, range, [sum_range])
- SumIf (range)
- SumIf (range, criteria)
- Question 8. In Excel, assume that cell A1 of the worksheet is capped on October 15, 1970. What is the function result = MONTH (A1)?
- VALUE #?
- 15
- ten
- 20
- Question 9. In Excel, which COUNTIF function syntax is correct?
- COUNTIF (ranger, criteria)
- COUNTIF (criteria, range)
- COUNTIF (criteria, range, col_index_num)
- COUNTIF (range, criteria, col_index_num)
- Question 10. Excel window is of type:
- Application window
- Document window
- Folder window
- All answers above
FAQ
What is the main point of Microsoft Excel Test P15?
In Excel worksheet, In cell A2 type in formula = MA30,10,65.5, then get the result in cell A2: 5 30 65 110 Question 2. In Excel, in cell A2 the value is "Tinhoc"; In cell C2, type in formula = A2, the result in C2 is: #Value TINHOC News Tinhoc Question 3.
Why is Microsoft Excel Test P15 important?
Microsoft Excel Test P15 matters because it can affect how readers understand, choose, use, or respond to the subject discussed in the article.
What should readers verify about Microsoft Excel Test P15?
Check the date, product or software version, compatibility, and any current guidance before acting, especially when technology, security, health, or pricing is involved.
Reader Comments 0
Sign in with email or Google to join the discussion.