Excel Certification Practice test

To format the table so that every row is shaded you need to go to:

• Click on the table and go to the Design Tab

• Design Tab

• Data

• Page Lay out

What is an advantage, if any, to using cell references instead of just typing in values?

• It will automatically create a sparkline in the next cell
• It will allow you to format your spreadsheet quicker
• If the cell is changed, your formula will automatically update
• There is no advantage

Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is quick way for her to do this? 

• Conditional Formatting
• Page Layout
• Quick Format
• Cell Alignment

Juan is the director of a summer camp. This spreadsheet contains campers’ names, information, and their counselors.

Which two features will help him sort the list by counselor, and then print out a list containing only the campers’ and counselors’ names?

• Sort and Track Changes

• Format and Hide Columns

• Custom Sorting and Formatting

• Custom Sorting and Hide Columns

Maria wanted to find the average of all of her grades, but can not get her function work. Her spreadsheet is below. What error is Min making?

• She has the incorrect arguments

• She has the wrong function name

• She is missing an equal sign at the beginning of her formula

• The colon should be replaced with a dash (-)

Gloria wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?

• =(C3+C5+C9)/3

• =SUM(C2:C10)

• =AVERAGE(C2:C10)

• =(C3+C5+C9)

To have Excel remove any duplicate records that have the same ID#, which value(s) should be checked?

• ID# only

• ID# and Last Name

• ID # and Last Name and First Name

• No values should contain a check mark

Which sort option would showing increasing values or alphabetical order?

• Ascending

• Descending

What functions checks if a condition is met and returns one value if True or another value if False?

• SUMIF

• COUNTIF

• IF

• AVERAGEIF

To import a file into Excel go to:

• Insert tab -> Object

• Data tab -> From Text/CSV

• Insert tab

• Data tab -> From Other Sources