Certbus > Microsoft > MOS > 77-420 > 77-420 Online Practice Questions and Answers

77-420 Online Practice Questions and Answers

Questions 4

Modify the text in the title.

Cell A1.

Text "Math 1080 - Section 3 Assignments"

Browse 30 Q&As
Questions 5

Insert data from a text file.

Cell A1.

File source Autumn.txt

Tab-delimited

Browse 30 Q&As
Questions 6

Rename a table. Cell range B6:F29 Name: "Overview"

Browse 30 Q&As
Questions 7

Rename the title of the chart.

Chart

Text "All Zero Scores"

Browse 30 Q&As
Questions 8

Apply a style to the chart.

Chart.

Chart Styles Style 7

Browse 30 Q&As
Questions 9

Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows Horizontal Axis Labels: "IDs" column in table Series 1: "Zero Scores" column in table.

Browse 30 Q&As
Questions 10

Insert the instructor's name for column B.

Cell B5.

Use Function RIGHT

Text: B2

Absolute reference

Num_chars: "16"

Browse 30 Q&As
Questions 11

Add conditional formatting.

Color Scales: Green –White-Red Color Scale

Midpoint: Percentile, "70"

Maximum: Number, "25"

Browse 30 Q&As
Questions 12

Formula Find the average score of all student ids without a zero homework score. Cell L2 Use Function AVERAGEIF Range F7:F29 Criteria: "0" Average_range: "Homework"

Browse 30 Q&As
Questions 13

Formula.

Find the minimum homework score for each student.

Cell range D7:D29

Number 1: minimum homework score for each student on "Section 3" worksheet.

Browse 30 Q&As
Questions 14

Hide columns.

Column A.

Columns O through R.

Browse 30 Q&As
Questions 15

Crop the picture.

Books.jpg

Crop to Shape Snip Same Side Corner Rectangle.

Browse 30 Q&As
Questions 16

Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style

Browse 30 Q&As
Questions 17

Add a header and the date for each of the columns (assignments) in the range.

Cell B2.

Text "Date".

Cell Range C2: S2

Text: "22-Aug, 29-Aug,

Browse 30 Q&As
Questions 18

Change the color theme. MathTracker.xlsx Slipstream

Browse 30 Q&As
Exam Code: 77-420
Exam Name: Excel 2013
Last Update: Mar 17, 2024
Questions: 30 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99