Microsoft Excel Test P14

This article presents Microsoft Excel Test P14 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Microsoft Excel Test P14

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