Excel Test 1

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

=DAY(A1)

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

=MONTH(F5)

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of the these formulas can she use to do so?

=ROUND(A5,2)

Which of the following is not a date function?

AND

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

AVERAGE

In the formula =B6*$B$2, which of the following describe $B$2?

Absolute cell reference

Which of the following lets you extend any data pattern involving dates, time, numbers, or text?

AutoFill Options Button

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

AutoFit resizes the column to the widest cell entry

If you need to determine how many cells in a range are NOT blank, use the ______ function.

COUNTA

To select nonadjacent cells or ranges on a worksheet, you can press and hold...

CTRL

While working in Page Layout View, how can you enter your name so it appears in the lower-right corner of the printout?

Click the footer section on the right and type your name

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Edit the conditional formatting rule

When you copy a formula fro A10 to cell B10, what happens to the cell references in the formula?

Excel changes the cell references in the copied formula to reflect the new location of the formula.

A student types the formula = 'YEAR (TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the persons age.

False

If you want to paste values and number formatting only, click the paste number button that appears below the pasted cell.

False

When you COPY cell contents, the data is removed from its original location and placed on the clipboard.

False

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

Fill handle

To copy a cells formatting to another cell, which of the following can you use?

Format Painter

Myra does not want a worksheet of sensitive data to be available to other users, but she does want to use its data in formulas in another worksheets. What can she do?

Hide the worksheet

Which of the following conditional format options can you use to highlight the top 10 values in a range of cells?

Highlight Cell Rules

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

Home

You can create conditional cell formats using either the Home tab or the...

Quick Analysis Tool

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

SUM

Which of the following statements is true about COUNT formula?

The COUNT function returns the number of cells in a range that contains numeric data.

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

The Undo button on the QuickAccess tool bar.

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

The formula =SUM(A6:A10)

In the following formula: =IF(A1 = "YES", "DONE", "RESTART"), what happens if A1 = 100?

The formula returns the text "NO, RESTART"

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

Type the formula including the function Click the AutoSum Button Click the AutoSum arrow Copy and paste a cell containing a function

Which of the following are true about entering a function using the Insert Function dialog box?

You can select a function you've recently used. You don't need to type an equal sign to begin the formula. You can search for a function that meets your needs.

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

a column

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

argument

Alba wants to use a watermark image as the background of her worksheet. She goes to the Page Setup group on the Page Layout tab. What lotion should she click to begin choosing the image file to use as a watermark?

background

When you copy a formula that contains an absolute reference to a new location, the reference ____.

does not change

You receive a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is...

hidden

To paste copied cell contents with values only, not including format, which of the following can you use?

paste option button paste special