Basic Microsoft Excel

Welcome to your Basic Microsoft Excel

Name

Email

1.

What is the keyboard shortcut for copying selected cells in Excel?

Deselect Answer

Ctrl+C

Ctrl+X

Ctrl+V

Ctrl+P

2.

In Excel, which function is used to add up a range of cells?

Deselect Answer

=SUM()

=AVERAGE()

=COUNT()

=MAX()

3.

What does the term "cell reference" in Excel mean?

Deselect Answer

The name of a worksheet

The address of a cell

The content of a cell

The style applied to a cell

4.

Which Excel feature is used to filter data in a table?

Deselect Answer

Sort

PivotTable

Filter

Group

5.

What is the purpose of the CONCATENATE function in Excel?

Deselect Answer

To merge cells

To add cells

To concatenate text from multiple cells

To split cells

6.

Which function can be used to find the highest value in a range of cells?

Deselect Answer

=MAX()

=MIN()

=AVERAGE()

=SUM()

7.

What does the term "cell formatting" refer to in Excel?

Deselect Answer

Changing the font colour

Adjusting the cell size

Applying a number format

All of the above

8.

How can you freeze panes in Excel?

Deselect Answer

Right-click on the row or column header and select “Freeze Panes”

Use the keyboard shortcut Ctrl+Alt+F

Go to the View tab and click on “Freeze Panes”

Both a and c

9.

What function is used to count the number of cells containing numerical data in a range?

Deselect Answer

=SUM()

=COUNT()

=AVERAGE()

=MAX()

10.

What does the term "relative cell reference" mean in Excel?

Deselect Answer

The address of a cell that doesn’t change when copied to another cell

The address of a cell that changes based on its location

The formula used for conditional formatting

The cell containing the highest value in a range

11.

Which keyboard shortcut is used to paste special in Excel?

Deselect Answer

Ctrl+P

Ctrl+V

Ctrl+Alt+P

Ctrl+Alt+V

12.

What does the function =IF(A1>10, "Yes", "No") do in Excel?

Deselect Answer

Adds the values in cells A1 and 10

Concatenates the text “Yes” and “No”

Checks if the value in cell A1 is greater than 10 and returns “Yes” if true, “No” if false

Multiplies the values in cells A1, “Yes”, and “No”

13.

Which chart type is best suited for showing the relationship between two variables in Excel?

Deselect Answer

Pie Chart

Line Chart

Bar Chart

Scatter Plot

14.

What is the purpose of the VLOOKUP function in Excel?

Deselect Answer

To vertically align text in a cell

To search for a value in a table and return a corresponding value

To view a large worksheet

To validate data in a cell

15.

How can you protect a worksheet in Excel from unauthorized editing?

Deselect Answer

Password protect the worksheet

Hide the worksheet

Lock individual cells

All of the above

16.

What does the COUNTIF function in Excel do?

Deselect Answer

Counts the number of cells in a range that meet a specific condition

Adds up the values in a range

Multiplies the values in a range

Averages the values in a range

17.

Which Excel feature is used to create visual representations of data from a worksheet?

Deselect Answer

Data Validation

PivotTable

Sparklines

Goal Seek

18.

What is the purpose of the CONCAT function in Excel?

Deselect Answer

To concatenate text from multiple cells

To add cells

To find the highest value in a range

To filter data in a table

19.

How can you insert a new worksheet in Excel?

Deselect Answer

Right-click on a worksheet tab and select “Insert”

Go to the Home tab and click on “Insert Sheet”

Use the keyboard shortcut Ctrl+N

Both a and b

20.

What is the purpose of the IFERROR function in Excel?

Deselect Answer

To return an error value if a condition is met

To hide errors in a worksheet

To display an error message

To check for errors in a formula

Please fill in the comment box below.

Leave a Reply Cancel reply