D388 excel Exam actual questions and CORRECT answers

D388 excel Exam actual questions and
CORRECT answers
Formatting - CORRECT ANSWER Changing the appearance of the data ana cells in a
worksheet



Range of cells - CORRECT ANSWER Is a consecutive block of cells arranged in a
row, a column, or a combo of both. To specify a range of cells you specify The upper range
followed by the ":" character. And then the lower right cell in the range
Ex:

B1:B4 —-> refers to b1,b2,b3,b4

A2:C2-> a2, b2, c2



Number (data type) - CORRECT ANSWER Used to define any type of number and
can be configured to display the number in standardized ways, such as with a fixed number of
decimal places.



Currency (data type) - CORRECT ANSWER Used to define a number as money;
currency values will be displayed with a monetary symbol (such as a dollar sign) appropriate
for the currency described and two decimal places. Currency data can be configured to
highlight negative numbers in specific ways (such as using a red font).



Accounting (data type) - CORRECT ANSWER Used to define a number as money; the
accounting data type has fewer options than the currency type. The accounting data type
displays data with a currency symbol and two decimal places.



Date (data type) - CORRECT ANSWER Used to display the number in a cell as a date;
the date data type has several display options, such as "12/18/1973" or "Tuesday, December
18, 1973."



Time (data type) - CORRECT ANSWER Used to display the contents of a cell as a
specific time of day, such as "11:35 AM."