Linkedin Microsoft Excel Assessment Cevapları

Soru 1: When using Goal Seek, you can find a target result by varying _ at most.

• one input
• two inputs
• three inputs
• four inputs

Soru 2: Which two functions check for the presence of numerical or nonnumerical characters in cells?

• ISVALUE AND ISNUMBER
• ISNUMBER and ISALPHA
• ISNUMBER and ISTEXT
• ISVALUE and ISTEXT

Soru 3: If you drag the fill handle (lower-right corner) of cell A2 downward into cells A3, A4, and A5, what contents will appear in those cells?

• Jan, Jan, Jan
• Feb, Mar, blank cell
• Feb, Mar, Apr
• FEB, MAB, APR

Soru 4: If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?

• the death of chivalry
• The death of Chivalry
• THE DEATH OF CHIVALRY
• The Death Of Chivalry

Soru 5: If the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?

• Sort by the data in Column E.
• Format the data in Column D.
• Sort by the data in Column D.
• Format the data in Column E.

Soru 6: When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?

• Alt+F4 (Windows) or Option+F4 (Mac)
• The F4 (Windows) or Command+T (Mac)
• Ctrl+Shift+4 (Windows) or Command+Shift+4 (Mac)
• Alt+Shift+4 (Windows) or Option+Shift+4 (Mac)

Soru 7: You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?

• Add an image of the chart to a comment.
• Add a hyperlink to another worksheet that displays a chart when clicked.
• Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.
• Add an image of the chart to the worksheet.

Soru 8: What is the best way to activate the Excel Help system?

• Right-click anywhere and select Help.
• Press F10.
• all of these answers.
• Press F1 or click the Help tab in the ribbon.

Soru 9: Which format will display the value 27,500,000 as 27.5?

• ##,###,,
• ###.0,,
• 999.9,,
• ###,###.0,

Soru 10: Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

• Double-click the vertical boundary between columns C and D.
• Right-click column C and select Best-Fit.
• Double-click column C.
• Right-click column C, select Format Cells, and then select Best-Fit.

Soru 11: A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

• Use the ROUND() function.
• Click the Decrease Decimal button twice.
• In the cells group on the Home tab, click Format > Format Cells. Then cick the Alignment tab and select Right Indent.
• Click the Decrease Decimal button once.

Soru 12: In the image below, which option(s) can you select so that the appropriate field headers appear in cells A4 and B3 instead of the terms Row Labels and Column Labels, respectively?

• Show in Tabular Form
• Show in Compact Form
• Show in Compact For or Show in Outline Form
• Show in Tabular Form or Show in Outline Form

Soru 13: The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?

• The AutoSum formulas refer to the column to the left of their cells.
• The AutoSum formulas include the year at the top of each column in the calculation.
• The AutoSum formulas exclude the bottom row of data.
• The AutoSum formulas include their own cells, creating a circular reference.

Soru 14: Which function returns the largest value in the range H2:H30?

• =MAX(H2:H30)
• =MAXIMUM(H2:H30)
• =LARGE(H2:H30,29)
• =UPPER(H2:H30,1)

Soru 15: Which formula returns the value in cell A1 of the worksheet named MySheet?

• =MySheet_A1
• =MySheet&A1
• =MySheet!A1
• =MySheet@A1

Soru 16: Which formula correctly counts the number of numeric values in both B4:E4 and G4:I4?

• =COUNT(B4:E4&G4:I4)
• =COUNT(B4:E4,G4:I4)
• =COUNT(B4:I4)
• =COUNT(B4:E4 G4:I4)

Soru 17: You want to apply subtotals per sport in the data below. What should you do before applying subtotals?

• Format the data in column E.
• Sort the data in column E.
• Format the data in column D.
• Sort the data in column D.

Soru 18: Which format setting does not change the background appearance of a cell?

• Cell style
• Fill color
• Pattern style
• Font color

Soru 19: You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?

• =$A1*B3
• =$A$1*B3
• =A1*$B3
• =A1*B3

Soru 20: Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD (B3,6)?

• 4
• 3
• 1
• 5

Soru 21: Which format setting does not change the background appearance of a cell?

• Fill color
• Font Color
• Pattern Style
• Cell Style