D388 excel exam questions with answers

D388 excel exam questions with answers || || || || ||




Formatting - CORRECT ANSWERS ✔✔Changing the appearance of the data
|| || || || || || || || || ||



ana cells in a worksheet
|| || || ||




Range of cells - CORRECT ANSWERS ✔✔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 ANSWERS ✔✔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 ANSWERS ✔✔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 ANSWERS ✔✔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 ANSWERS ✔✔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 ANSWERS ✔✔Used to display the contents of a
|| || || || || || || || || || || ||



cell as a specific time of day, such as "11:35 AM."
|| || || || || || || || || || ||




Percentage (data type) - CORRECT ANSWERS ✔✔used to display the || || || || || || || || || ||



contents of a cell as a percent; the percentage data type is displayed with the
|| || || || || || || || || || || || || || ||



% symbol. ||




default data type in excel - CORRECT ANSWERS ✔✔general
|| || || || || || || ||




worksheet - CORRECT ANSWERS ✔✔A collection of cells arranged in the
|| || || || || || || || || || ||



form of a table that contains the actual data and calculations.
|| || || || || || || || || ||




contains the data you are examining. A worksheet will also include the
|| || || || || || || || || || || || ||



analyses you have done on this data. The data on a worksheet is organized as
|| || || || || || || || || || || || || || ||



a collection of cells.
|| || ||




workbook - CORRECT ANSWERS ✔✔is an Excel file that stores all the
|| || || || || || || || || || || ||



information, previous calculations, and analyses that you may have already || || || || || || || || || ||



completed. A workbook can be stored locally on your computer, or it can be
|| || || || || || || || || || || || || ||



saved in an online cloud location, such as Microsoft OneDrive. Generally,
|| || || || || || || || || || ||