77-420 Exam Questions
39 real 77-420 exam questions with expert-verified answers and explanations. Page 1 of 1.
- Question #1
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...
- Question #2
Formula. Count the number of 0 homework scores for each student. Cell range F7:F29.
- Question #3
Create a new named range. Cell range C7:C29. Name: "Homework".
- Question #4
Hide columns: Column A and Columns O through R.
- Question #5
Rename a table. Cell range B6:F29 Name: "Overview"
- Question #6
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.
- Question #7
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.
- Question #8
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.
- Question #9
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".
- Question #10
Add a worksheet After other worksheets Rename "Section 5"
- Question #11
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
- Question #12
Apply a style to the chart. Chart. Chart Styles Style 7
- Question #13
Create a hyperlink to another worksheet. Cell A2 Cell reference "A3" Sheet reference "Section 3" worksheet.
- Question #14
Rename the title of the chart. Chart. Text "All Zero Scores"
- Question #15
Add conditional formatting. Color Scales: Green -White-Red Color Scale Midpoint: Percentile, "70" Maximum: Number, "25"
- Question #16
Insert a row. Directly below current row 1.
- Question #17
Modify the cell format to date. Cell range C2:S2
- Question #18
Configure page layout options. Cell range B3:S25. Set Print Area. Enable the Gridlines Print option.
- Question #19
Apply a cell style Cell range A2:S2 Style 40% - Accent3
- Question #20
Insert the instructor's name for column B. Cell B5. Use Function RIGHT Text: B2 Absolute reference Num_chars: "16"
- Question #21
Modify the cell alignment settings. Cell range B3:B25 Horizontal: Right (Indent)
- Question #22
Modify the document property. MathTracker.xlsx Subject "Homework"
- Question #23
Insert a picture. To the right of the data File source Books.jpg
- Question #24
Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1: "Students with no " Text2: Header of column F Absolute Reference
- Question #25
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"
- Question #26
Crop the picture. Books.jpg. Crop to Shape Snip Same Side Corner Rectangle.
- Question #27
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.
- Question #28
Modify the text in the title. Cell A1. Text "Math 1080 - Section 3 Assignments"
- Question #29
Insert data from a text file. Cell A1. File source Autumn.txt Tab-delimited
- Question #30
Change the color theme. MathTracker.xlsx
- Question #31
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...
- Question #32
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...
- Question #33
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...
- Question #34
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...
- Question #35
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...
- Question #36
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...
- Question #37
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....
- Question #38
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...
- Question #39
Which of the following features of Office 2013 houses options to configure options that affect the document as a whole or the application itself?