HomeTech infoQuiz technology

Microsoft Excel Test P14

  1. Question 1. To always choose to print a certain area in the Excel spreadsheet we need to manipulate?
    1. Black out the area to print, then go to File / Print Area, select Set Print Area
    2. Go to File / Print, select OK
    3. Both ways are correct
    4. Both ways are wrong
  2. Question 2. When doing hidden cell grid attribute in Excel spreadsheet, we need?
    1. Go to Format / Row, select Hide
    2. Go to Tool / Option, on the View tab, uncheck the Gridlines item in Window Options
    3. Do not have this feature
    4. Both a and b are correct
  3. Question 3. When we want to repeat the column header on each printed page, we need to do it?
    1. Go to File / Page Setup, Select the Sheet tab, check the Row and Column headings section
    2. In Excel, the default is always available when the title is repeated
    3. A and B are wrong
    4. Both a and b are correct
  4. Question 4. To hide any column on the Excel worksheet, select the column to hide, then?
    1. Right-click on the selected column to hide, click Hide
    2. Go to Format / Column, select Hide
    3. Both a and b are correct
    4. A and B are wrong
  5. Question 5. When typing the calculation formula in Excel, if it is correct, it will produce the result of that calculation when printing the paper. So to print the formulas I just hit?
    1. Remove the equal sign "=" at the beginning of each calculation
    2. Go to Tool / Options, select the View tab, check the Formulas item in Windows Options
    3. A and B are wrong
    4. Both a and b are correct
  6. Question 6. To set the automatic saving mode on Excel when a problem occurs, we need
    1. Go to File / Save to save
    2. Go to Tool / Options, select the Save tab, check the Save AutoRecover info every box, then enter the auto-save minutes
    3. Both a and b are correct
    4. A and B are wrong
  7. Question 7. Excel documents after being saved by default in My Document. So to change the default location when saving it?
    1. Go to Tool / Options, select the General tab, change the new path to the Default file location entry
    2. Go to File / Save As, select the location to save
    3. A and B are wrong
    4. Both a and b are correct
  8. Question 8. When entering FIle / Page Setup, what do we choose for the Margins tab?
    1. Paper size when printing
    2. Orient the print paper
    3. Align the paragraph margins to print
    4. All is wrong
  9. Question 9. When entering Format / Cells, what is the Border card effect?
    1. Adjust the font for the paragraph
    2. Create a border for the spreadsheet to select
    3. Color correction for text
    4. All is wrong
  10. Question 10. What effect does Ctrl + F command in Excel have?
    1. Search for a certain string
    2. Replace this string with another character
    3. Delete the characters you just found
    4. All right
4 ★ | 2 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)
  • 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.
  • 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