If you need a text to show vertically in a cell. How will you achieve this?
Answer: B
Correct answer: Choose 90 Degrees in Orientation of Format Cells dialog box
Setting the orientation to 90 degrees rotates the text so it reads bottom to top. The Vertical setting on the same tab governs where text sits between the top and bottom of the cell, which is a different thing.
Please log in or register to report this question.
Can you set 0.5 inch left indentation for a cell in Excel?
Answer: C
Correct answer: Indentation can be set from Format Cells dialog box
Excel does have indentation: it is on the Alignment tab of Format Cells, and there are also increase and decrease indent buttons on the toolbar.
Please log in or register to report this question.
You can automatically adjust the size of text in a cell if they do not fit in width by
Answer: C
Correct answer: From Format Cells dialog box mark Shrink to fit check box
Shrink to fit reduces the displayed font size until the text fits the column, leaving the column width alone. Autofit does the opposite - it changes the column to suit the text.
Please log in or register to report this question.
Formatting a cell in Currency, you can specify
Answer: C
Correct answer: Both of above
The Currency format lets you choose how many decimal places to show and which currency symbol to prefix, as well as how negatives are displayed.
Please log in or register to report this question.
Formatting a cell in Number format you can’t set
Answer: D
Correct answer: Currency Symbol
The Number category offers decimal places, the thousands separator and the treatment of negative numbers. A currency symbol is what distinguishes the Currency and Accounting categories from it.
Please log in or register to report this question.
What is entered by the function =today()
Answer: A
Correct answer: The date value for the day according to system clock
TODAY() returns the current date as a date value, taken from the system clock and recalculated whenever the sheet is. NOW() returns the date with the time as well.
Please log in or register to report this question.
Which function will you use to enter current time in a woksheet cell?
Answer: B
Correct answer: =now()
NOW() returns the current date and time; TODAY() returns the date alone. Formatting the cell as time then displays only the time part.
Please log in or register to report this question.
Special category of Number tab in Format Cells dialog box can be used to apply formats like
Answer: C
Correct answer: Both of above
The Special category holds formats for values that are strings of digits rather than quantities - postal codes, telephone numbers, social security numbers - so that leading zeros and separators are preserved.
Please log in or register to report this question.
Merge cells option can be applied from
Answer: A
Correct answer: Format Cells dialog box Alignment Tab
Merge cells is a check box on the Alignment tab. The Formatting toolbar's Merge and Center button does the same thing and centres the result, which is why the dialog is the general answer.
Please log in or register to report this question.
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from
Answer: B
Correct answer: from Format >> Autoformat
AutoFormat applies a ready-made combination of number formats, borders, fonts, patterns and column widths to a selected range.
Please log in or register to report this question.
