Quiz de Excel bien EZ

What is the most direct way to remove a hyperlink in a cell?

• Insert > Link > Picture

• Home > Format Cells

• Insert > Link > Insert Link

• Insert > Link > Remove Link

Which option automatically adjusts the width of a column?

• Home > Wrap Text

• Home > Format > AutoFit Column Width

• Home > Format > Column Width

• Format > Manual Column Width

Which formula uses a column and row absolute reference?

• =A1*B1

• =$A$1*B1

• =A$1*$B1

• =A1*$B1

What does Auto Fill do with the cell “Monday”?

• Fills with formulas

• Fills with the word “Monday” repeatedly

• Fills with “Monday, Tuesday, Wednesday…”

• Does nothing automatically

To convert the text in a cell to lowercase, which function is used?

• MIN()

• SMALL()

• LOWER()

• LCASE()

Which format option applies a money format to a number?

• Text Format

• Time format

• Accounting Format

• Percentage Style

What does =SUMIF(A1:A10, "X", B2:B10) do?

• Add the values in column B if the cells in column A are marked with an X.

• Adds values in column A from row 1 to 10

• Returns the highest value

• Calculates the average

Which function returns the highest number in a range?

• HIGH()

• MAX()

• VALUE()

• • BIG()

Which function checks a condition and returns a value based on TRUE or FALSE?

• AND

• IF

• OR

• TEST

What is the correct way to add commands like New, Email, and Fill Color to the Quick Access Toolbar in Excel?

• Quick Access > Quick Acess Toolbar > Customize Toolbar

• File > Options > Quick Access Toolbar

• Home > Format > Toolbar Options

• Insert > Customize Ribbon