Microsoft 77-420 - Excel 2013 Exam
Page: 2 / 6
Total 30 questions
Question #6 (Topic: Topic 1)
Modify the cell alignment settings.
Cell range B3:B25
Horizontal: Right (Indent)
Cell range B3:B25
Horizontal: Right (Indent)
Answer: Use the following steps to complete this task in explanation:
Question #7 (Topic: Topic 1)
Add conditional formatting.
Color Scales: Green â€"White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Color Scales: Green â€"White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Answer: Use the following steps to complete this task in explanation:
Question #8 (Topic: Topic 1)
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
Answer: Use the following steps to complete this task in explanation:
Question #9 (Topic: Topic 1)
Hide columns.
Column A.
Columns O through R.
Column A.
Columns O through R.
Answer: Use the following steps to complete this task in explanation:
Question #10 (Topic: Topic 1)
Insert a picture.
To the right of the data
[1]
To the right of the data
[1]
Answer: Use the following steps to complete this task in explanation:
