Microsoft Excel Test P9

  1. Question 1. To close (turn off) the open workbook, please indicate how in the ways below do not respond to this?
    1. Go to the File menu, select Close
    2. Go to the File menu, select Exit
    3. Go to the File menu, select Quit
    4. Click on the close icon (x) in the upper right corner of the window
  2. Question 2. In MS Excel, if you want to ask the program for help about something, you choose one of the following items
    1. Go to the Help menu, select Microsoft Excel Help
    2. Go to the Help menu, select About Microsoft Excel
    3. Go to the Tools menu, select Help
    4. Go to the Edit menu, select Guide
  3. Question 3. To select non-contiguous areas in the spreadsheet, which key should you use?
    1. Alt
    2. Shift
    3. Ctrl and Shift
    4. Ctrl
  4. Question 4. You have blackened a row in Excel. Which of the following commands allows you to insert a row in the position above the selected row.
    1. Go to the Insert menu, select Rows
    2. Go to the Insert menu, select Cells
    3. Go to the Insert menu, select Columns
    4. Go to the Insert menu, select Object
  5. Question 5. To select all cells on the worksheet with the key combination:
    1. Press Ctrl + A
    2. Press Ctrl + All
    3. Press Ctrl + Alt + Space
    4. Both first and third ways are fine
  6. Question 6. If the competitor has a score of 5 or more, the competitor is classified as a Achievement, otherwise if the score is less than 5, he / she will not be ranked. In your opinion, which of the following formulas correctly represents this (Assuming that cell G6 contains test scores)?
    1. = IF (G6> = 5, "Reach") ELSE ("Failed")
    2. IF (G6 <5, "Failure", "Pass")
    3. IF (G6 = <5, "Reach", "Failed")
    4. IF (G6> 5, "Reach", "Failed")
  7. Question 7. Which of the following statements is correct:
    1. Spreadsheets can have up to 256 columns. The columns are ordered by letters A, B, C, . Z, AA, AB, AC .
    2. Spreadsheets can be up to 512 columns. The columns are numbered sequentially numbered from A, B, ., Y, Z, AA, AB, AC .
    3. The spreadsheet consists of 24 columns and 10 lines, of which 24 columns correspond to 24 letters and 10 lines are 10 existing values
    4. The spreadsheet has only 24 columns. The columns are numbered from A, B, ., Y, Z
  8. Question 8. Which of the following values ​​will be entered for cell D8 when you click on the right corner under cell D7 and drag down the boxes D8, D9, D10 to apply the same formula of cell D7:
    Microsoft Excel Test P9 Picture 1
    1. 200
    2. 240
    3. 144
    4. 0
  9. Question 9. Know that salary = basic salary * coefficient. To calculate each person's salary, you must enter the formula in cell D7
    Microsoft Excel Test P9 Picture 2
    1. = C7 * D3
    2. = $ C7 * D3
    3. = C7 * $ D $ 3
    4. = $ C $ 7 * $ D $ 3
  10. Question 10. To quickly see the "excellent" graders you black out the entire area containing the data you need to see and then use which of the following tools:
    1. Go to the Tools menu, select Quick view, select the "excellent" level.
    2. Go to the Data menu, select Validation
    3. Go to View menu, select "excellent" level
    4. Go to the Data menu, select Filter - Autofilter
5 ★ | 1 Vote

May be interested

  • 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.
  • Microsoft Excel Test P7Microsoft Excel Test P7
    proficiency in using excel and mastering excel tips will greatly help your promotion or study. in the article below, network administrator will help you add knowledge about this topic through multiple choice questions.
  • Microsoft Excel Test P14Microsoft Excel Test P14
    excel is a spreadsheet program that is extremely useful for people who work as an office or a teacher. to help you gain more useful knowledge, in the following quiz network administrator has edited very interesting questions to help you expand your knowledge. let's try it together.
  • 5 useful Microsoft Excel formulas for calculating taxes5 useful Microsoft Excel formulas for calculating taxes
    you can spend big money to hire an experienced accountant handles this, or make use of excel power immediately to arrange things in order. here are five recipes that can make your life 'breathable' than in 'season' tax.
  • Summary of expensive shortcuts in Microsoft ExcelSummary of expensive shortcuts in Microsoft Excel
    in the work, especially when you have to perform many calculations, the formula in microsoft excel documents, the use of the mouse is strictly tortuous. not wrong, because when you master the formulas, shortcut keys on excel, using the keyboard will be fast and convenient a lot.
  • Z.TEST function - The function returns one-sided value of the z test in ExcelZ.TEST function - The function returns one-sided value of the z test in Excel
    z.test: the function returns the one-sided p value of the z test. support functions from excel 2010 onwards. syntax: z.test (array, x, [sigma])
  • Excel computer test - Part 3Excel computer test - Part 3
    after the second part of the excel test, the network administrator will continue to send you the 3rd part of the quiz series on this topic. let's work together to test your knowledge.
  • T.TEST function - The function returns the probability associated with Student's t-Test in ExcelT.TEST function - The function returns the probability associated with Student's t-Test in Excel
    t.test: the function returns the probability associated with student's t-test. support functions from excel 2010 onwards. syntax: t.test (array1, array2, tails, type)