Excel 2: Fundamentals Test Review

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

When would you use conditional formatting on a cell?

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

• You want to hide the contents of a column

• You want to highlight negative numbers by using red text

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

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

• Summations

• Format

• Cell

• Formulas

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

• A

• B

• C

• D

Which set of data is in descending order?

• 4, 3, 1, 2

• apples, oranges, bananas, grapes

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

• horses, ducks, dogs, cats

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

• Cut and Paste

• AutoFill

• Spelling Checker

• Find and Replace

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

• =AVERAGE(B3:B7)

• =SUM(B3:B7)

• =MIN(B3:B7)

• =MAX(B3:B7)

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

• Text

• General

• Currency

• Date

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

• True

• False

Which of these formulas uses absolute cell references?

• =F18+F19/2

• =5*10+20

• =D5+F3

• =$A$10/100