Question 1

It is the intersection of a column and a row.

Accepted Answer

Cell

Question 2

Shortcut key for opening a new workbook.

Accepted Answer

CTRL + N

Answer

CTRL + O

Answer

CTRL + S

Answer

CTRL + W

Question 3

Shortcut key for closing a document.

Accepted Answer

CTRL + W

Answer

CTRL + C

Answer

CTRL + L

Answer

CTRL + S

Question 4

Shortcut key for opening an existing document.

Accepted Answer

CTRL + O

Answer

CTRL + W

Answer

CTRL + C

Answer

CTRL + S

Question 5

It is always refers to a cell in a specific location.

Accepted Answer

Absolute Cell Reference

Answer

Relative Cell Reference

Answer

Mixed Cell Reference

Question 6

It is based on the relative position of the cell.

Accepted Answer

Relative Cell Reference

Answer

Absolute Cell Reference

Answer

Mixed Cell Reference

Question 7

A computer program used to create electronic spreadsheets.

Accepted Answer

Microsoft Excel

Question 8

What is the syntax of IF function?

Accepted Answer

=IF (LOGICAL TEXT, VALUE IF TRUE, VALUE IF FALSE)

Answer

IF (LOGIC TEXT, VALUE IF FALSE, VALUE IF TRUE)

Answer

IF (LOGICAL TEXT, VALUE IF TRUE, VLUE IF FALSE)

Question 9

A graphical control element in the form of a set of toolbars placed on several tabs.

Accepted Answer

Ribbon

Question 10

This function is used to convert text from capital to small.

Accepted Answer

Lower Function

Answer

Proper Function

Answer

Upper Function

Related quizzes