You can use the I-beam pointer to copy cell contents into adjacent cells.

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer. He can do so by clicking on Page Layout > Save As > (Enter name in) File name box > Save As type list > PDF > Minimum Size (publishing online) > Options > OK > Save.

You can edit cell contents in the Formula bar or in the cell itself.

When you enter a value in a worksheet cell, it is automatically left-aligned.

To fit all worksheet content on one page, you can set page scaling in Backstage view.

You can use the DELETE key to clear cell contents.

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

To customize the status bar, right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.

To insert an equation, click on the Object in the Text group on the Insert tab, then click Microsoft Equation 3.0 in the Object type box, and then click OK.

To print worksheet contents across the length of a page, you can use portrait orientation.

To print a worksheet, you begin by going to Backstage view.

The Comma Style format adds a comma and a dollar sign to a cell value.

A predesigned combination of formats, such as font size and color, is called a cell default.

To enter a typed number into a cell, you can press Tab or Backspace.

To find the largest value in a cell range, use the MIN function.

To combine multiple cells into one and center its content, you change the cells' style.

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

To change the color of cell content, you use the ________ color list arrow.

Which of the following functions would you use to calculate the arithmetic mean of a price list?

To print more than one copy of your worksheet, which tab would you go to?

Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?

To see a preview of how a pasted value will look, which of the following would you use?

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

In the formula =SUM(A6:A9), which of the following best describes A6?

Where can you see a preview of how your worksheet will look when printed, including headers?

The default worksheet text is ______-point Calibri.

A ______ refers to a collection of characters with a similar, specific design.

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X?

Which of the following tabs lets you set worksheet print options?

How many actions does the Undo button let you reverse?

When you double-click a cell's right column border, which of the following occurs?

To return cell contents to its default font and style, you can use the ______ command.

When you cut or copy a cell, it is cut or copied to which of the following?

To select a single worksheet cell so you can work with it, which of the following would you do?

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Which of the following functions inserts the total of a range?

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Which of the following lets you search for a function or select one from a category?

To apply a cell style, you would use the Cell Styles command on the ____ tab.

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?

To print your worksheet at its actual size, which of the following would you select?

When you underline cell content, you are using ____.

Which of the following lets you edit the contents of a cell?

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Which of the following is a built-in formula that helps you perform complex calculations?

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

On which tab and button are document properties located for editing?

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

To combine multiple cells into one combined cell, which of the following do you use?

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Which of the following can you use to insert a formula using a function?