You are making a sales performance report in Excel which you would like to prese
ID: 3586802 • Letter: Y
Question
You are making a sales performance report in Excel which you would like to present to the top management. Some of the column headings are too large and look out of place in their cells. You decide to display the headings as slanted text to save space. How is this achieved? a. By selecting Italics on the Font tab b. By altering the Text Orientation on the Alignment c. By selecting Subscript on the Font tab d. By choosing the merge cells option . The default alignment for text data in a merged group of Excel cells is a. Right-aligned b. Center-aligned c. Random alignment is used. d. Left-aligned 3. What is conditional formatting used for? Applies a distinctive built-in format to a selected range of cells in the worksheet a. b. It can format a cell depending upon the font of the cell can format a cell depending upon the size of content in the cell c. d. It can format a cell depending upon values of the content in the cell To denote absolute cell referencing in a formula (say cell K8), the formula must include: 4. a. %KY68 b. SK$8 c. K8 d. abs(K8)Explanation / Answer
1. Answer b . To display the headings as the slanted text to save the space , the text orientation must be altered in the alignment tab by entering a degree value or by dragging the indicator to the angle that is required . A positive angle between 30 to 60 degrees is usually used to align the data because it fits well in the column headings .
2. Answer b. In the merged group of excel cells the text data is center aligned , On clicking "Merge and Center" the horizontal data is center aligned.
3. Answer d. The conditional formatting is a tool which is used to format the cells , The formatting is done depending upon the values of the content in the cell or by depending upon the value of the formula , If the value of the cell is satisfied the condition is formatted .
4. Answer b. The absolute cell referencing in a formula must include $K$8 for cell K8 , The absolute referencing consists of dollor sign , In this $K$8 the column and row does not change when they are copied .
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.