Only show me the Answers. No steps.

QUESTION 51

The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel.?

	a.	?Detailed Paste
	b.	?Paste Cells
	c.	?Paste Options
	d.	Paste Special?

1.5 points

QUESTION 52

In Microsoft Excel 2016, some styles are based on the workbook's current _____.?

	a.	?data
	b.	?theme
	c.	?number format
	d.	?reference

1.5 points

QUESTION 53

Which of the following is true of borders in Excel??

	a.	?You can specify the thickness of and the number of lines in borders.
	b.	?You must specify if borders must be printed or not.
	c.	?Borders and gridlines are the same in Excel.
	d.	?Borders are the lines that divide the columns and rows on a worksheet.

1.5 points

QUESTION 54

Which of the following functions is used to calculate the day of the week from the date value??

	a.	?WEEKDAY(day, month, year)
	b.	?WEEKDAY(return-type,)
	c.	?WEEKDAY(MM/DD/YY )
	d.	?WEEKDAY(date[,return_type])

1.5 points

QUESTION 55

Which of the following statements is true of hiding rows and columns in an Excel sheet??

	a.	?You need to use the command Show Cells to unhide them.
	b.	?You can apply Flash Fill to hidden columns.
	c.	?It does not affect the other formulas in the workbook.
	d.	?The order of the columns or rows remains consecutive.

1.5 points

QUESTION 56

Flash Fill is a function in Microsoft Excel used to enter formulas with multiple calculations.?

True

False

1.5 points

QUESTION 57

You can tell rows or columns are hidden in an Excel sheet when:

	a.	?the numbers or letters are no longer consecutive.
	b.	?content is suggested based on patterns in the data.
	c.	?all the data points are clearly visible.
	d.	?a single border demarcation appears between them.

1.5 points

QUESTION 58

A text argument can be included in an IF function by enclosing it in quotation marks.?

True

False

1.5 points

QUESTION 59

In a pie chart, each pie slice always represents _____.?

	a.	?one-fourth of a data series value
	b.	?one data series value
	c.	?the entire data source
	d.	?20% of the sum of the data series values

1.5 points

QUESTION 60

In Microsoft Excel charts, which of the following is a function of leader lines??

	a.	?They extend the values of the major or minor units across the plot area of a chart.
	b.	?They connect each data label to its corresponding data marker.
	c.	?They provide gridlines to an Excel user to convert a 2-D chart to a 3-D chart.
	d.	?They help to display an entire chart within a single cell.

1.5 points

QUESTION 61

Column charts are used only when there is one data series.?

True

False