HomeTech infoQuiz technology

Microsoft Excel test - Part 4

  1. Question 1. In Microsoft Excel, in cell C5, the formula = $ A $ 2 * $ B $ 3, when copying to cell D6, the D6 formula has the formula:
    1. = $ A $ 2 * $ B $ 3
    2. = $ A $ 3 * $ B $ 4
    3. = $ B $ 2 * $ C $ 3
    4. = $ B $ 3 * $ C $ 4
  2. Question 2. In Microsoft Excel, in cell E7, the formula = C $ 3- $ D4, when copied to cell H11, the cell H11 has the formula:
    1. = F $ 8 - $ G8
    2. = F $ 3 - $ D8
    3. = C $ 8- $ G4
    4. = C $ 3- $ D4
  3. Question 3. To select contiguous areas in the worksheet, which key do you need to use the mouse with?
    1. Ctrl and Shift
    2. Alt
    3. Ctrl
    4. Shift
  4. Question 4. In Microsoft Excel spreadsheet, to filter the data automatically, after selecting the block to be filtered, we do:
    1. Format -> Filter -> AutoFilter
    2. Insert -> Filter -> AutoFilter
    3. Data -> Filter -> AutoFilter
    4. View -> Filter -> AutoFilter
  5. Question 5. In Microsoft Excel, suppose that cell A1 has data: 3> 5. The statement in cell B5 is: = A1 has the result:

    1. 3> 5
    2. False
    3. True
    4. False
  6. Question 6. In Microsoft Excel, cell D2 has the formula "= B1 + C1", when copied to cell E2, cell E2 has the formula:
    1. = C2 + D2
    2. = C1 + C2
    3. = B1 + D1
    4. = C1 + D1
  7. Question 7. In Excel, which COUNTIF function syntax is correct?
    1. COUNTIF (range, criteria, col_index_num)
    2. COUNTIF (range, criteria)
    3. COUNTIF (criteria, range, col_index_num)
    4. COUNTIF (criteria, range)
  8. Question 8. In Microsoft Excel, the statement = MAX (7,5,2,9,3,1, -7) has the result:
    1. first
    2. -7
    3. 9
    4. 19
  9. Question 9. To sum the cells from A1 to A7, which of the following is correct?
    1. = SUM (A1): SUM (A7)
    2. = SUM (A1 - A7)
    3. = SUM (A1: A7)
    4. = SUM (A1); SUM (A7)
  10. Question 10. In Excel, what type of text can you display in a cell?
    1. Tilting
    2. Horizontal
    3. Vertical
    4. All 3 types above
3.5 ★ | 2 Vote
quizzesinformatics testssoftwareexcelbasic knowledge

You should read it

May be interested

  • Microsoft Excel Test P15Microsoft 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.
  • Microsoft Excel Test P9Microsoft Excel Test P9
    the following network administrator will send you to read multiple choice questions about excel, invite you to test your knowledge. the set of questions consists of 10 sentences, 4 answers each to choose from.
  • Test of technology terminology - Part 11Test of technology terminology - Part 11
    in today's article, tipsmake.com introduces you to the next part of the technological termination test series. i wish you successfully completed the test!
  • How to Download Microsoft ExcelHow to Download Microsoft Excel
    this wikihow teaches you how to download microsoft excel onto your computer, smartphone, or tablet. while microsoft excel for computers can only be downloaded as part of the microsoft office bundle, you can download excel by itself for...
  • eQuiz - VB.NET testing test - Part 2eQuiz - VB.NET testing test - Part 2
    in the previous article, i showed you the first part of the vb.net test. and this time, we will continue with part 2 of this popular quiz series on programming languages, the whole test will have 15 questions with unlimited response time.
  • Test Microsoft Excel P13Test Microsoft Excel P13
    in this article, network administrators will continue to learn about excel software through extremely interesting multiple-choice questions below. try to see how many questions you will make.
  • F.TEST function - The function returns the result of the F - test in ExcelF.TEST function - The function returns the result of the F - test in Excel
    f.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
  • Microsoft Excel Test P11Microsoft Excel Test P11
    the excel 2010 interface changes very little compared to excel 2007 with the rearrangement of some on-screen components and the return of the file pane instead of the confusing office button. here, the network administrator will join readers to learn about new features in excel 2010 through the multiple choice questions below.
  • Link download Microsoft Excel 2019Link download Microsoft Excel 2019
    microsoft excel is a software program created by microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.
  • Microsoft Excel P12 testMicrosoft Excel P12 test
    the quiz on excel with many interesting questions will give you useful knowledge around this topic. the question set consists of 10 questions with 4 answers to choose from.

Quiz technology