MS EXCEL QUIZ

Which function returns the lowest number in a range?

What is the correct formula to multiply the values in cells A1 and B1?

If your data is structured horizontally, which function should you use instead of VLOOKUP?

What file extension is used for Excel 2010 and later versions?

Which feature allows text to be displayed on multiple lines within a cell?

What is the quickest way to apply bold formatting to selected text in Excel?

What formula calculates the average of numbers in cells A1 to A5?

Which of the following is NOT an Excel feature?

What is the primary purpose of Scenario Manager?

What function would you use to count numeric values in a range?

What function finds the highest value in a given range?

What is Microsoft Excel primarily used for?

In VLOOKUP(1001, A2:D10, 3, FALSE), what does FALSE indicate?

What does the IF function do?

Which function counts the number of cells that meet a condition?

How do you change the background color of a cell?

How do you apply borders to a selected range of cells?

What symbol must all formulas start with in Excel?

Which of the following aligns text to the center of a cell?

How do you adjust column width automatically to fit content?

Which shortcut key is used to save an Excel file?

In Excel, rows are labeled with:

What feature allows you to copy formulas across multiple cells?

Which function is used to add a range of numbers?

Which function looks up and returns a value from another column?

In the formula =VLOOKUP(1001, A2:D10, 3, FALSE), what does "3" indicate?

What feature allows you to change the appearance of numbers, such as adding a currency symbol or percentage sign?

How do you merge multiple cells in Excel?

How do you find the sum of sales greater than 30,000?

To insert a new row in Excel, you should: