Question 1

Which of the following is a basic data type in Python?

Accepted Answer

Integer

Answer

Dictionary

Answer

List

Answer

Tuple

Question 2

What is the correct way to declare a variable in Python?

Accepted Answer

a = 10

Answer

a := 10

Answer

variable = 10

Answer

10 = a

Question 3

What is the output of the following code?print(2 + 3 * 4 - 6)

Accepted Answer

8

Answer

9

Answer

14

Answer

5

Question 4

What is the output of the following code?print('Hello, ' + 'World!')

Accepted Answer

Hello, World!

Answer

World, Hello!

Answer

Hello World!

Answer

Hello World

Question 5

What is the correct syntax to print 'Hello, World!' in Python?

Accepted Answer

print('Hello, World!')

Answer

print('Hello', 'World!')

Answer

print('Hello + World!')

Answer

print('Hello', World!')

Question 6

What does the 'range()' function return in Python?

Accepted Answer

A sequence of numbers

Answer

A random number

Answer

The sum of numbers

Answer

A string of characters

Question 7

What function in Excel is used to calculate the sum of a range of cells?

Accepted Answer

SUM

Answer

AVERAGE

Answer

COUNT

Answer

IFERROR

Question 8

Which Excel function is used to find the largest value in a range of cells?

Accepted Answer

MAX

Answer

COUNT

Answer

MIN

Answer

SUM

Question 9

How do you insert a new worksheet in Excel?

Accepted Answer

Right-click on a sheet tab and select 'Insert'

Answer

Go to the 'File' menu and select 'New Worksheet'

Answer

Double-click on a sheet tab and select 'Insert'

Answer

Use the shortcut key 'Ctrl+Shift+I'

Question 10

Which Excel function is used to find the highest value that is less than or equal to a given criteria?

Accepted Answer

VLOOKUP

Answer

COUNTIF

Answer

AVERAGEIF

Answer

INDEX

Question 11

How can you merge cells in Excel?

Accepted Answer

Select the cells you want to merge and click on the 'Merge & Center' button in the 'Alignment' group on the 'Home' tab.

Answer

Right-click on the cells you want to merge and select 'Merge Cells' from the context menu.

Answer

Select the cells you want to merge and click on the 'Wrap Text' button in the 'Alignment' group on the 'Home' tab.

Answer

Press Ctrl + M after selecting the cells you want to merge.

Question 12

How can you change the font size in Excel?

Accepted Answer

Select the cells you want to change the font size for and use the 'Font Size' drop-down list in the 'Font' group on the 'Home' tab.

Answer

Press Ctrl + F and select the cells you want to change the font size for.

Answer

Select the cells you want to change the font size for and use the 'Bold' button in the 'Font' group on the 'Home' tab.

Answer

Right-click on the cells you want to change the font size for and select 'Font Size' from the context menu.

Question 13

What is the shortcut key to format cells as bold in Excel?

Accepted Answer

Ctrl + B

Answer

Ctrl + I

Answer

Ctrl + A

Answer

Ctrl + U

Question 14

How can you add cell borders in Excel?

Accepted Answer

Select the cells you want to add borders to and click on the 'Borders' button in the 'Font' group on the 'Home' tab.

Answer

Select the cells you want to add borders to and click on the 'Fill Color' button in the 'Font' group on the 'Home' tab.

Answer

Press Ctrl + Shift + B after selecting the cells you want to add borders to.

Answer

Right-click on the cells you want to add borders to and select 'Borders' from the context menu.

Question 15

How can you apply conditional formatting to a range of cells in Excel?

Accepted Answer

Select the range of cells you want to apply the conditional formatting to, and click on the 'Conditional Formatting' button in the 'Styles' group on the 'Home' tab.

Answer

Right-click on the range of cells you want to apply the conditional formatting to and select 'Conditional Formatting' from the context menu.

Answer

Press Ctrl + Shift + C after selecting the range of cells you want to apply the conditional formatting to.

Answer

Select the range of cells you want to apply the conditional formatting to and click on the 'Sort & Filter' button in the 'Editing' group on the 'Home' tab.

Question 16

How can you adjust the column width in Excel?

Accepted Answer

Place the cursor on the right edge of the column header, click and drag to adjust the width.

Answer

Right-click on the column header and select 'Adjust Column Width' from the context menu.

Answer

Press Ctrl + W after selecting the column you want to adjust the width for.

Answer

Select the column you want to adjust the width for and click on the 'Wrap Text' button in the 'Alignment' group on the 'Home' tab.

Question 17

How can you apply a currency format to a range of cells in Excel?

Accepted Answer

Select the range of cells you want to apply the currency format to and click on the 'Number Format' drop-down list in the 'Number' group on the 'Home' tab. Then, select the 'Currency' option.

Answer

Right-click on the range of cells you want to apply the currency format to and select 'Currency Format' from the context menu.

Answer

Select the range of cells you want to apply the currency format to and click on the 'Bold' button in the 'Font' group on the 'Home' tab.

Answer

Press Ctrl + C after selecting the range of cells you want to apply the currency format to.

Question 18

How can you apply a strikethrough format to a cell in Excel?

Accepted Answer

Select the cell you want to apply the strikethrough format to and click on the 'Strikethrough' button in the 'Font' group on the 'Home' tab.

Answer

Press Ctrl + S after selecting the cell you want to apply the strikethrough format to.

Answer

Select the cell you want to apply the strikethrough format to and click on the 'Bold' button in the 'Font' group on the 'Home' tab.

Answer

Right-click on the cell you want to apply the strikethrough format to and select 'Strikethrough' from the context menu.

Question 19

How can you apply a fill color to a cell in Excel?

Accepted Answer

Select the cell you want to apply a fill color to and click on the 'Fill Color' button in the 'Font' group on the 'Home' tab.

Answer

Select the cell you want to apply a fill color to and click on the 'Borders' button in the 'Font' group on the 'Home' tab.

Answer

Press Ctrl + F after selecting the cell you want to apply a fill color to.

Answer

Right-click on the cell you want to apply a fill color to and select 'Fill Color' from the context menu.

Related quizzes

Related quizzes