Excel Certification Practice test

Front

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

Back

Click on the table and go to the Design Tab

Front

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

Back

If the cell is changed, your formula will automatically update.

Front

Petra wants to highlight all of her failing grades in red. What is a quick way for her to do this? Options: Conditional Formatting, Page Layout, Quick Format, Cell Alignment

Back

Conditional Formatting

Front

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

Back

Custom Sorting and Hide Columns

Front

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?

Back

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

Front

Gloria wanted to find the total amount of vanilla cakes ordered. Which formula should she use? Options: =(C3+C5+C9)/3, =SUM(C2:C10), =AVERAGE(C2:C10), =(C3+C5+C9)

Back

=(C3+C5+C9)

Front

To have Excel remove any duplicate records that have the same ID#, which value(s) should be checked? Options: ID# only, ID# and Last Name, ID # and Last Name and First Name, No values should contain a check mark

Back

ID# only

Front

Which sort option would showing increasing values or alphabetical order?

Back

Ascending

Front

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

Back

IF

Front

To import a file into Excel go to:

Back

Data tab -> From Text/CSV