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

 You are making a sales performance report in Excel which you

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!