1.
In the screenshot above, which rectangle is around the part the user must click on to combine the cells highlighted so that they may act as one cell for the title.
Correct Answer
A. Dark Blue Square
Explanation
The Dark Blue Square is around the Merge & Center button, which combines highlighted cells to become one cell. The Yellow Square is around Wrap Text which makes text visible in one cell by expanding the row. The Red Square is around the font face and font size section. The Light Blue Square is around the Number Format section. The Green Square is around the alignment section.
2.
In Excel, if you want a cell to represent currency you must always type the $ symbol yourself inside the cell.
Correct Answer
B. False
Explanation
In Excel, you can change the format of a cell to make a cell automatically format numbers inside it as currency.
3.
Which of the following are types of Cell Formatting that excel features?
Correct Answer(s)
A. General
B. Number
C. Currency
D. Accounting
Explanation
General is the default Cell Formatting in cells in Excel, it does not apply any type of special formatting.
The Number format automatically adds decimals to all numbers. (Ex: 1 turns into 1.00)
The Currency and Accounting formats are very similar, they both automatically apply the $ sign to the cell and convert the number into cash amounts. (Ex: 1 becomes $1.00 or $ 1.00 depending on which is selected)
There is no Finance format, however, one could create one by making a custom format.
4.
To add a line below an entire cell, one must apply what to the cell?
Correct Answer
B. Bottom Border
Explanation
Underline will only line the text inside a cell.
Bottom border will add a line border below an entire cell.
There is no such thing as Important Border in Excel.
Top Border will add a border on top of a cell.
Thick Box Border adds a thick border around the entire cell.
5.
When dealing with how the text/font appears in a spreadsheet, we are talking about:
Correct Answer
A. Content Formatting
Explanation
Content Formatting refers to the formatting done to the content of the spreadsheets. In other words, in refers to the different types of formatting that can be applied to the text in a cell, including Bold, Italicize, Underline, Currency Formatting, Highlighting, etc...
General Formatting is a specific cell format that does nothing to a cell. (This is the default format for cells)
Structural Formatting refers to the way the spreadsheet in formatted. In other words, how the rows and columns are formatted.
There is no Auto-Fill Formatting, but there is an auto-fill feature.
6.
The default format for text inside cells is Number, which applies no special formatting to a cell.
Correct Answer
B. False
Explanation
The default format for text inside cells is General, which applies no special formatting to a cell.
Number adds the decimal values to a whole number. Example: 1 becomes 1.00
7.
It is not possible to resize a row.
Correct Answer
A. False, it is possible to resize a row.
Explanation
Rows may be re-sized easily by simply dragging the line below a row.
8.
What is the shortcut for italicizing text?
Correct Answer
A. CTRL + i
Explanation
CTRL + i will italicize font.
CTRL + b will bold font.
CTRL + u will underline font.
9.
When we are talking about the formatting of columns and rows, we are referring to what type of formatting.
Correct Answer
C. Structural Formatting
Explanation
Structural formatting refers to the formatting of columns and rows in a document or spreadsheet. It involves adjusting the width and height of columns and rows, merging or splitting cells, and applying borders and gridlines to create a well-organized and visually appealing layout. This type of formatting helps in structuring and organizing the data, making it easier to read and understand.