Microsoft Excel General Knowledge 5

Question 1

Which keyboard shortcut opens the Format Cells dialog box in Excel?

Accepted Answer

Ctrl+1

Answer

Ctrl+1 opens the Format Cells dialog where you can set number formats, alignment, font, borders, and fill.

Question 2

What does the CONCATENATE function (or the & operator) do in Excel?

Accepted Answer

Joins two or more text strings into one

Answer

CONCATENATE (or the & operator) combines multiple text values into a single string, for example =A1&" "&B1.

Question 3

When you sort a table by a column in Excel, what happens to the other columns in the same row?

Accepted Answer

They move together with the sorted column to keep each row's data intact

Answer

Excel sorts entire rows together, so related data in each row stays aligned regardless of which column is sorted.

Question 4

What is the maximum number of columns in a single Excel worksheet?

Accepted Answer

16,384

Answer

Since Excel 2007, worksheets support 16,384 columns (2^14), labeled A through XFD.

Question 5

Which function calculates the average of values that meet a specific condition?

Accepted Answer

AVERAGEIF

Answer

AVERAGEIF calculates the average of cells in a range that meet a single specified criterion.

Excel Practice Test