BARU
Ukuran huruf
Lembar kerjaExcel Expert 1 KA
Total soal: 10
Worksheet time: 4mins
Which of the following is the file extension used for Excel Template files?
.xlsm
.xltx
.xlam
Which of the following demonstrates the general format of a formula that references a cell in a different worksheet?
CellAddress!SheetName
SheetName#CellAddress
SheetName!CellAddress
Which of the following statements best describes how to copy macros from one workbook to another?
Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor.
Use the Record Macro button on the Developer tab.
Use the Add-Ins button on the Developer tab.
Which of the following represents the syntax for a structured reference to a field in an Excel table?
FieldName[TableName]
TableName[FieldName]
[FieldName]TableName
Your co-worker sent you a workbook to update. You have entered new numbers in your worksheet, but the totals are not updating. Which of the following statements best describes how to remedy the problem?
Click the Share Workbook button on the Review tab.
Go to the cells with the totals that are not updating, press the F2 key and then press Enter to re-enter the formulas.
Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.
Which of the following methods is used to display a hidden tab on the ribbon?
On the View tab, in the Show group, click the Tabs button and select the tab you want to display.
On the Home tab, in the Cells group, click Insert and then select Show Hidden Tabs.
Display the Excel Options dialog box, select Customize Ribbon, and then select the check box next to the name of the tab you want to add.
Which of the following statements best describes how to create a custom template of your own?
Click the File tab, select Save As, click Browse, and change the file type to .xltx.
Click the File tab, select Save As, click Browse, and change the file type to .xlsm.
Click the File tab, select Save As, click Browse, and change the file type to .xlam.
What is the name of the feature that saves copies of your files at specified intervals?
Protect Sheet
Track Changes
AutoRecover
Which of the following would be considered a strong password based on the definition in this lesson?
Tsj1961x
927%851*
4Nw9!tP@
What is the name of the separate worksheet that temporarily lists all tracked changes in a shared workbook?
Changes
History
Review
