Module 1-4

If 4/30/2017 and 5/31/2017 are the initial values, what are the next two values AutoFill will insert?

6/31/2017 7/31/2017 The last date of the next two months

What is a conditional format?

A conditional format is a format that changes based on the value entered in the cell.

What is the cell reference for the cell located in the second column and fifth row of a worksheet?

B5

What is the reference for the nonadjacent block of cells B5 through C10 and cells B15 through D20?

B5:C10,B15:D20

What is the range reference for the block of cells C2 though D10?

C2:D10

Describe how to add the workbook filename to the center section of the footer on every page of the printout.

Print screen>Page setup>header/footer tab> click center section and click the filename tab to add it.

What are print titles?

Rows of the worksheet that you want to be printed at the top of each page, not just the first location Page layout -- page setup -- print titles -- rows to repeat at top -- then select

A researcher wants to plot weight versus blood pressure. Should the researcher use a line chart or a scatter chart? Explain why.

Scatter chart. They aren't declaring anything as low or high. Also there are two data series involved.

How would you highlight the top 10 percent values of the range A1:C20?

Select range A1:C20. The quick analysis tool will show in the lower left corner. The formatting category will show buttons for greater than and top 10% conditional formatting rules.

Explain how to use the Quick Analysis tool to calculate a running total of the values in the range D1:D10.

Select range D1:D10 click the quick analysis button in the lower right corner of the select range. Click totals from the list of tools. Click the right scroll arrow to view additional tools and hit Running.

What is the difference between a line chart and a scatter chart?

A line chart is similar to a column chart but uses lines. The data series are plotted against the category values. The categories have a sequential order. Scatter chart has no category values. One series of data values is plotted against another.

You need to reference Cell Q57 in a formula. What is its relative reference? What is its absolute reference? What are the two mixed references?

Relative reference: Q57 Absolute: $Q$57 Two mixed: $Q57 and Q$57

If cell R10 contains the formula =$R1 + R$2, which is then copied to cell S20, what formula is entered in cell S20?

=$R10 + S$2

If cell R10 contains the formula =R1 + R2, which is then copied to cell S20, what formula is entered in cell S20?

=S11+S12

Write the formula to display the current date in the worksheet.

=TODAY()

Write the formula to display a date that is four workdays after the date in cell A5. Do not assume any holidays in your calculation.

=WORKDAY(A5,4)

If cell Q3 is greater than cell Q4, you want to display the text "OK"; otherwise, display the text "RETRY". Write the formula that accomplishes this.

=vlookup(G5, A1:F50, 3, false)

Write the formula to perform an exact match lookup with the lookup value from cell G5 using a vertical lookup table located in the range A1:F50. Return the value from the third column of the table.

=vlookup(G5, A1:F50, 3, false)

What is text data?

Any combination of letters, numbers, and symbols.

What keyboard shortcuts makes the active cell to cell A1?

CTRL-home

How do you insert a manual page break in a worksheet?

Click the first cell below the row where you want to insert a page break. Click a column heading or a row heading. On page layout tab in page setup group, click breaks button and then click insert page break.

Describe two methods of applying the same format to different ranges.Format painter.

Format painter. Will copy the format of the selected area. You click the new cell or cell range you want the format to be copied to. If you click the format painter only once it can only be used once, click twice to make it unlimited use. Paste option. Each time you paste the paste options button appears in the lower-right corner of the pasted cell or range. You click it to open a list of pasting options such as pasting only the format

How do you enter numbers so that excel sees it as text?

Include an apostrophe before the number. ex: '12345

Cell B12 contains the entry May 3, 2017. Why doesn't excel consider this a text entry?

It is stored as a number equal to the number of days between the specified date and January 0, 1900.

What are major tick marks, minor tick marks, and chart gridlines?

Major tick marks-- main units on the chart axis Minor tick marks-- identify the smaller intervals between the major tick marks Chart gridlines-- extend tick marks into chart area

Red is a standard color. What happens to red text when you change the workbook's theme?

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook.

What is a print area?

The range or ranges in a worksheet that you specify to be printed.

How do you auto fit a column to match the longest cell entry?

You double click the line between that column and the next.

What are the 2 types of sheets used in a workbook?

chart sheets and worksheets