AES Excel 2: Fundamentals : Module Test

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

• True

• False

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

• Full

• -10

• 10

• Unknown

If A3=10 and B6=14, what is the result of the logical expression A3=B6?

• False

• True

Which set of data is in descending order?

• horses, ducks, dogs, cats

• 4, 3, 1, 2

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

• apples, oranges, bananas, grapes

What does filtering data in a spreadsheet do?

• Hides data that you do not want to see

• Hides the data you are looking for

• Shows data that did not meet the criteria

• Shows all the data in the spreadsheet

Which of the following is a way to search for a function?

• Browse in the Function Library group

• Click Insert Function and enter a search phrase

• All of the above

What formula would you enter in C3 that combines A3 and B3 to get a result like in C2?

• =CONCAT(B3," ",A3)

• =CONCAT(A3," ",B3)

• =B3,&,&,A3

• =A3,&,&,B3

What does it mean to merge cells?

• Combine 2 or more cells into a single cell.

• Center the contents of the cells.

• Apply a border around a set of cells.

• Split a single cell into 2 or more cells.

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

• The data header must be in a single row.

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

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

• The data header information must be bold.

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

• =MIN(B3:B7)

• =MAX(B3:B7)

• =SUM(B3:B7)

• =AVERAGE(B3:B7)