March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Microsoft 77-420 Excel 2013 Exam Practice Test

Page: 1 / 3
Total 30 questions

Excel 2013 Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$40.5  $134.99

PDF Study Guide

  • Product Type: PDF Study Guide
$34.5  $114.99
Question 1

Formula.

Find the maximum homework score for each student.

Cell range E7:E29

Use Function MAX

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

Options:

Question 2

Create a table and modify the table styles.

Cell range B6:F29

Table Style Medium 4

Enable the First Column Style

Options:

Question 3

Rename the title of the chart.

Chart

Text "All Zero Scores"

Options:

Question 4

Create a new named range.

Cell range C7:C29.

Name: "Homework"

Options:

Page: 1 / 3
Total 30 questions