WGU D388 excel Questions with 100%
complete solutions graded A+
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."
Percentage (data type) - correct answer ✔✔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 answer ✔✔general
worksheet - correct answer ✔✔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 answer ✔✔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, when you share work you have done in a spreadsheet with a colleague,
you will send him or her a copy of your workbook file.
paste values - correct answer ✔✔this only copies over the value not the format of the previous
cell. so if one cell has a currency data cell with $25.00 as its data, it will only copy 25.
formulas - correct answer ✔✔calculations performed in a spreadsheet
expression - correct answer ✔✔calculation prescribed by the formula
Dynamic formulas - correct answer ✔✔respond to changes in other cells in the worksheet
complete solutions graded A+
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."
Percentage (data type) - correct answer ✔✔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 answer ✔✔general
worksheet - correct answer ✔✔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 answer ✔✔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, when you share work you have done in a spreadsheet with a colleague,
you will send him or her a copy of your workbook file.
paste values - correct answer ✔✔this only copies over the value not the format of the previous
cell. so if one cell has a currency data cell with $25.00 as its data, it will only copy 25.
formulas - correct answer ✔✔calculations performed in a spreadsheet
expression - correct answer ✔✔calculation prescribed by the formula
Dynamic formulas - correct answer ✔✔respond to changes in other cells in the worksheet
