Question 1

Which statement is used to import modules in Python?

Accepted Answer

import

Answer

module

Answer

function

Answer

execute

Question 2

Which data type in Python is used to store a sequence of characters?

Accepted Answer

string

Answer

list

Answer

boolean

Answer

integer

Question 3

Which of the following is a correct way to comment a line of code in Python?

Accepted Answer

# This is a comment

Answer

/* This is a comment */

Answer

// This is a comment

Answer

Question 4

Which of the following is the correct way to print 'Hello, World!' in Python?

Accepted Answer

print('Hello, World!')

Answer

System.out.println('Hello, World!')

Answer

printf('Hello, World!')

Question 5

Which of the following is the correct way to convert a string to an integer in Python?

Accepted Answer

int('123')

Answer

number('123')

Answer

string_to_int('123')

Answer

to_int('123')

Question 6

Which of the following is the correct way to check if two variables are equal in Python?

Accepted Answer

variable1 == variable2

Answer

variable1 = = variable2

Answer

variable1 === variable2

Answer

variable1 = variable2

Question 7

Which of the following is NOT a valid data type in Python?

Accepted Answer

'character'

Answer

'string'

Answer

'boolean'

Answer

'integer'

Question 8

What is the result of the following expression?5 + 3 * 2

Accepted Answer

11

Answer

16

Answer

9

Answer

10

Question 9

What Excel function can be used to add up the values in a range of cells?

Accepted Answer

SUM

Answer

AVERAGE

Answer

COUNT

Answer

MAX

Question 10

Which Excel function can round a number to the nearest whole number?

Accepted Answer

ROUND

Answer

AVERAGE

Answer

SUM

Answer

MAX

Question 11

What Excel function is used to find the highest value in a range of cells?

Accepted Answer

MAX

Answer

MIN

Answer

SUM

Answer

AVERAGE

Question 12

What Excel function can be used to find the average value in a range of cells?

Accepted Answer

AVERAGE

Answer

MAX

Answer

COUNT

Answer

SUM

Question 13

What Excel function can be used to find the smallest value in a range of cells?

Accepted Answer

MIN

Answer

AVERAGE

Answer

SUM

Answer

MAX

Question 14

What function is used to multiply numbers in Excel?

Accepted Answer

PRODUCT

Answer

SUM

Answer

COUNT

Answer

AVE

Question 15

Which of the following is a shortcut key to format cells as currency in Excel?

Accepted Answer

Ctrl+Shift+$

Answer

Ctrl+$

Answer

Ctrl+Alt+$

Answer

Ctrl+Shift+%

Question 16

In Excel, how do you merge and center cells?

Accepted Answer

Click on the 'Merge & Center' button in the 'Alignment' group under the 'Home' tab.

Answer

Right-click on the cells and select 'Merge & Center' from the context menu.

Answer

Use the 'Merge Cells' option in the 'Format' menu.

Answer

Press Ctrl+M on the keyboard.

Question 17

How do you add a border to a cell or range of cells in Excel?

Accepted Answer

Select the cell or range of cells, then click on 'Home' -> 'Borders' -> 'Outside Borders' or 'All Borders'.

Answer

Use the 'Borders' option in the 'Format' menu.

Answer

Press Ctrl+B on the keyboard to add a border to the selected cells.

Answer

Right-click on the cell or range of cells and select 'Add Border' from the context menu.

Question 18

How can you format a number to display a specific number of decimal places in Excel?

Accepted Answer

Use the 'Number' formatting option and specify the desired number of decimal places.

Answer

Use the 'Decimal' formatting option and select the desired number of decimal places.

Answer

Manually type the decimal places after the number in the cell.

Answer

Apply a custom format code to the cell.

Related quizzes

Related quizzes