QUIZ#4 EXCEL DATA TYPES

It is used to represent amount or quantity.

It can be a combination of letters, numbers, and special characters.

It is a particular day, month, or year that represents an event.

It can be used in computations.

It is the key combination that places the cell pointer on its current position after inputting the data.

This is the technique that allows you to type and move the insertion point. (To input data into the cell)

• Click on the cell, Type the text, and Press the Enter key

• Press the Enter key, Click on the cell, and Type the text

• Type the text, Press the Enter key, and Click on the cell

• Click on the Formula bar, Click on the cell, and Press the Enter key

The key combination that is used to apply word wrapping inside the cell.

• Alt + Enter

• Alt + Space

• Alt + Drag

• Alt + Backspace

The Excel does not recognized dates before ___________.

• January 1, 1561

• January 1, 1696

• January 1, 1991

• January 1, 1990

The Date values can be entered by typing the name of the month followed by _______, a comma, and the year.

• number

• dates

• symbol

• time

Data are categorized as _____________________.

• text and number

• text and dates

• text and values

• date and time