77-420 Exam Questions

Formula. Find the average of each student's homework scores. Cell range C2:C29. Use Function AVERAGE Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec...

Formula. Count the number of 0 homework scores for each student. Cell range F7:F29.

Create a new named range. Cell range C7:C29. Name: "Homework".

Hide columns: Column A and Columns O through R.

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

Sort and Filter Apply a sort and a filter to the table. Cell range B6:F29 Sort Column Zero Scores Order Largest to Smallest Filter Hide students ids with no zero scores.

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.

Find the maximum homework score for each student using the MAX function. For Number 1, use the maximum homework score for each student on the "Section 3" worksheet.

Find the average score of all student IDs without a zero homework score using the AVERAGEIF function. The Range is F7-F29, Criteria is "0", and Average_range is "Homework".

Add a worksheet After other worksheets Rename "Section 5"

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

Apply a style to the chart. Chart. Chart Styles Style 7

Create a hyperlink to another worksheet. Cell A2 Cell reference "A3" Sheet reference "Section 3" worksheet.

Rename the title of the chart. Chart. Text "All Zero Scores"

Add conditional formatting. Color Scales: Green -White-Red Color Scale Midpoint: Percentile, "70" Maximum: Number, "25"

Insert a row. Directly below current row 1.

Modify the cell format to date. Cell range C2:S2

Configure page layout options. Cell range B3:S25. Set Print Area. Enable the Gridlines Print option.

Apply a cell style Cell range A2:S2 Style 40% - Accent3

Insert the instructor's name for column B. Cell B5. Use Function RIGHT Text: B2 Absolute reference Num_chars: "16"

Modify the cell alignment settings. Cell range B3:B25 Horizontal: Right (Indent)

Modify the document property. MathTracker.xlsx Subject "Homework"

Insert a picture. To the right of the data File source Books.jpg

Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1: "Students with no " Text2: Header of column F Absolute Reference

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, ...12-Dec"

Crop the picture. Books.jpg. Crop to Shape Snip Same Side Corner Rectangle.

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

Modify the text in the title. Cell A1. Text "Math 1080 - Section 3 Assignments"

Insert data from a text file. Cell A1. File source Autumn.txt Tab-delimited

Change the color theme. MathTracker.xlsx

Sandra has created a report in Excel 2013. Her manager needs that report in tab detailed text format. Sandra has to export the report in the required format. Which option will she...

You are creating a report in Excel 2013. You have recently created a similar report that can help you in creating the current report. You want to display a list of the last twenty...

Sasha has created a worksheet using Excel 2013. She needs to print the worksheet. She wants to print top two rows in each page. Which of the following steps will she take to accomp...

You create a report in Excel 2013. You need to display the Save & Send panel in the Backstage View where you can send the current workbook as an e-mail attachment, save it in a new...

You are working on a report on Microsoft Excel 2013 for your organization. You need to link to a cell to a Web page that displays some graphical reports of the past accounting year...

You work as a Sales Manager for Net World Inc. You are creating a sales report in Microsoft Excel 2013. You want to create the report while keeping an eye on how it will look in pr...

Martha works as an Office Assistant for Tech Perfect Inc. She uses Microsoft Excel 2013 for working on a report. She wants to add a picture as a background in her Excel worksheet....

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell: VLOOKUP(12, A2:C10, 3, FALSE ) Which o...

Which of the following features of Office 2013 houses options to configure options that affect the document as a whole or the application itself?