Microsoft Excel Test P15
Tests on excel help you test your basic knowledge. Please try your knowledge with the following questions that the Network Administrator has edited.
 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

5 ★  1 Vote
You should read it
Maybe you are interested
Learn about Phind: The app that answers questions about coding with the power of AI
24 basic level C++ programming interview questions and answers
20 intermediate level C++ programming interview questions and answers
15 expertlevel C++ programming interview questions and answers
Answering questions about the reasons for using a keyboard wrist rest
How to add branches or nested questions in Google Forms