Excel 2: Fundamentals

Which of the following is NOT necessary for organizing data to make it easier to sort?

• There must be a blank row and column between the data and other information

• The data header information must be bold

• The data header must be in a single row

• The data you want to sort must be continuous without blank rows or columns.

If D3=30 and D4=20, what is the result of the function =IF(D4<D3, D3-D4, "FULL")?

• Full

• Unknown

• 10

• -10

When would you use conditional formatting on a cell?

• You want to use a formula and function to sum the values in a column.

• You want to change the font for every cell in the spreadsheet

• You want to highlight negative numbers by using red text

• You want to hide the contents of a column

What term refers to mathematical equations used in Excel to perform calculations?

• Format

• Formulas

• Cell

• Summations

Where would you click to change a cell format to text?

• A

• B

• C

• D

Which set of data is in descending order?

• apples, oranges, bananas, grapes

• 4/1/2018, 4/1/2017, 3/29/2017, 6/18/2018

• 4, 3, 1, 2

• horses, ducks, dogs, cats

You want to enter a series of dates down a column. What would be the best tool for the job?

• Spelling Checker

• Cut and Paste

• AutoFill

• Find and Replace

What function would you use to find the least expensive item?

• =AVERAGE(B3:B7)

• =MIN(B3:B7)

• =MAX(B3:B7)

• =SUM(B3:B7)

Which of these number formats would you want to apply to a cell showing the total sales for the month?

• General

• Currency

• Text

• Date

Microsoft Excel can use Headers and Footers, just like Microsoft Word.

• True

• False