HomeTech infoQuiz technology

Microsoft Excel Test P11

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

You should read it

May be interested

  • 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)
  • 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)

Quiz technology