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?
| A | B | C | |
|---|---|---|---|
| 1 | 8.5% | 2018 Commission | |
| 2 | Sales Rep | 2018 Sales | Comenion Earned |
| 3 | Jordan Hinton | $123,938.00 | |
| 4 | Lilah Douglas | 5594,810.00 | |
| 5 | Karyn Reese | $235,954.00 | |
| 6 | Chiquita Walsh | $684,760.00 |
- =$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