Download Workbooks Project management Practice Exam and more Exams Technology in PDF only on Docsity!
Exam
Question 1. Which workbook option enables automatic saving of a backup copy at a set interval? A) AutoRecover B) AutoSave C) Version History D) Save As Answer: A Explanation: AutoRecover creates a temporary backup at regular intervals to help recover work after a crash. Question 2. To protect a workbook from being opened without a password, you should set which type of password? A) Modify password B) Read‑only password C) Opening password D) Structure password Answer: C Explanation: An opening password is required before the workbook can be opened. Question 3. Which feature lets you view two different areas of the same worksheet simultaneously? A) New Window B) Split C) Freeze Panes D) Arrange All Answer: B
Exam
Explanation: Split divides the worksheet window into separate panes that can scroll independently. Question 4. When you want to copy a macro from Workbook A to Workbook B, which action is required? A) Drag the macro module between workbooks B) Export the module as a .bas file and import it C) Use the Copy Worksheet command D) Record a new macro in Workbook B Answer: B Explanation: Exporting the module creates a file that can be imported into another workbook. Question 5. Which of the following is NOT a valid custom number format? A) “$#,##0.00” B) “0.00%” C) “dd‑mm‑yyyy” D) “###‑##‑####” Answer: D Explanation: Custom number formats cannot contain the “#” character after a hyphen in that pattern. Question 6. The Fill Handle is most useful for which task? A) Applying conditional formatting B) Creating a chart series C) Extending a recognized data pattern D) Inserting a new worksheet
Exam
C) Full Screen view D) Page Break Preview Answer: C Explanation: Full Screen view hides interface elements for a distraction‑free view. Question 10. When you mark a workbook as “Final,” what is the primary effect? A) It locks the workbook with a password B) It disables editing and adds a notice C) It converts the file to PDF automatically D) It removes all macros Answer: B Explanation: Marking as Final makes the workbook read‑only and adds a “Final” watermark. Question 11. Which command removes duplicate rows based on all columns in a selected range? A) Remove Duplicates (Data tab) B) Find & Replace → Duplicate C) Data Validation → Duplicate D) Sort → Advanced → Unique Answer: A Explanation: The Remove Duplicates tool eliminates rows that are identical across selected columns. Question 12. Which function would you use to return the number of whole days between two dates, excluding weekends? A) NETWORKDAYS
Exam
B) DATEDIF
C) WORKDAY
D) DAYS
Answer: A Explanation: NETWORKDAYS counts weekdays between two dates, optionally excluding holidays. Question 13. In a VLOOKUP formula, the fourth argument set to FALSE indicates that the function should: A) Perform an approximate match B) Return the nearest smaller value C) Perform an exact match D) Search horizontally Answer: C Explanation: FALSE (or 0) forces VLOOKUP to find an exact match. Question 14. Which of the following is a correct way to create a named range that refers to cells A1:A10 on Sheet2? A) =Sheet2!$A$1:$A$ B) Sheet2!A1:A C) =Sheet2!A1:A D) Sheet2!$A$1:$A$ Answer: A Explanation: Named ranges require absolute references with the sheet name and dollar signs.
Exam
Answer: A Explanation: Custom lists are defined in Excel Options under the Advanced tab. Question 18. Which function can combine text from multiple cells without using the CONCATENATE function? A) TEXTJOIN B) MERGE C) COMBINE D) CONCAT Answer: D Explanation: CONCAT joins text strings from a range or multiple arguments, similar to CONCATENATE. Question 19. What does the “Trace Dependents” tool show? A) Cells that a selected cell references B) Cells that reference the selected cell C) All cells in the same row D) All cells with formulas Answer: B Explanation: Trace Dependents highlights formulas that rely on the selected cell’s value. Question 20. Which of the following is true about the “Freeze Panes” command? A) It can freeze rows and columns simultaneously B) It only works in Page Layout view C) It hides the selected rows and columns
Exam
D) It permanently locks the cells from editing Answer: A Explanation: Freeze Panes can lock both rows above and columns to the left of the active cell. Question 21. When creating a PivotTable, which option allows you to filter data without affecting the source data? A) Report Filter B) Slicer C) Timeline D) All of the above Answer: D Explanation: Report Filters, Slicers, and Timelines filter the PivotTable view only. Question 22. Which conditional formatting rule would highlight cells that are above the average of the selected range? A) Greater Than → =AVERAGE(range) B) Top 10 Items → 10% C) Data Bar → Gradient Fill D) Color Scale → Red‑White‑Green Answer: A Explanation: “Greater Than” with a formula referencing AVERAGE highlights cells above the mean. Question 23. The function =INDEX(A1:C5,3,2) returns the value located in which cell? A) B
Exam
A) Use Relative References button (on the Developer tab) B) Choose “Relative” in the Record Macro dialog C) Press Alt+F11 before recording D) No option; all recordings are absolute Answer: A Explanation: The “Use Relative References” button toggles the recording mode. Question 27. In a chart, which element is used to display the exact value of each data point? A) Axis Title B) Data Labels C) Legend D) Trendline Answer: B Explanation: Data Labels show the numerical value or text for each point. Question 28. Which function can be used to calculate the number of months between two dates? A) DATEDIF with “M” unit B) MONTHS C) NETWORKDAYS D) EOMONTH Answer: A Explanation: DATEDIF(start, end, “M”) returns whole months between dates.
Exam
Question 29. To change the default language for formula functions in a workbook, you would adjust which setting? A) File → Options → Language → Editing Languages B) Review → Language → Set Proofing Language C) Data → Get & Transform → Language Settings D) View → Workbook Views → Language Answer: A Explanation: Editing languages determine the language of built‑in function names. Question 30. Which of the following actions will NOT affect the calculation order of a formula? A) Changing the cell format to Text B) Adding parentheses to group operations C) Using the ORDER function (hypothetical) D) Inserting spaces between operators Answer: D Explanation: Spaces are ignored in formulas and do not affect calculation order. Question 31. When you apply a “Top 10%” filter on a numeric column, what does Excel actually do? A) Shows the 10 highest values B) Shows values greater than the 90th percentile C) Shows the top 10 rows only D) Shows values above the average Answer: B Explanation: “Top 10%” displays items whose values are in the top 10 percent of the data set.
Exam
Explanation: TEXT converts numbers to formatted text using a format code. Question 35. The “Split” command differs from “Freeze Panes” in that it: A) Allows independent scrolling of each pane B) Locks rows only C) Is only available in Mac Excel D) Saves the workbook automatically Answer: A Explanation: Split creates separate scrollable panes, whereas Freeze panes lock rows/columns in place. Question 36. Which of the following formulas correctly sums the values in column B only when column A equals “East”? A) =SUMIF(A:A,"East",B:B) B) =SUMIFS(B:B,A:A,"East") C) Both A and B D) Neither A nor B Answer: C Explanation: Both SUMIF and SUMIFS can accomplish the conditional sum; syntax differs. Question 37. What does the “Evaluate Formula” tool allow you to do? A) Step through each part of a formula to see intermediate results B) Automatically correct errors in formulas C) Convert a formula to a value D) Record a macro of the formula calculation
Exam
Answer: A Explanation: Evaluate Formula shows how Excel computes a formula step‑by‑step. Question 38. Which option ensures that a workbook’s macros are enabled when the file is opened? A) Save the file with a .xlsm extension B) Save as .xlsx C) Turn on “Enable AutoRecover” D) Set the workbook to “Read‑Only” Answer: A Explanation: .xlsm files are macro‑enabled; .xlsx files cannot contain macros. Question 39. Which of the following chart elements can be directly edited to change its font size? A) Plot Area B) Legend C) Data Series D) Gridlines Answer: B Explanation: Legend text can be formatted like any other text object. Question 40. To display a worksheet in landscape orientation when printed, you would adjust which setting? A) Page Layout → Orientation → Landscape B) File → Print → Portrait C) View → Page Break Preview → Landscape
Exam
B) =SUMPRODUCT(A1:A5,B1:B5)
C) Both A and B produce the same result D) None of the above Answer: C Explanation: Both the CSE array formula and SUMPRODUCT yield the dot product of the two ranges. Question 44. Which option allows you to protect the structure of a workbook so that users cannot add, delete, or rename worksheets? A) Review → Protect Workbook → Structure B) File → Info → Protect Workbook → Password C) Home → Format → Protect Sheet D) Data → Data Validation → Workbook Answer: A Explanation: Protecting the workbook’s structure restricts worksheet management actions. Question 45. When using the “Custom Sort” dialog, you can sort by a list that you have defined. Which of the following is NOT a step in creating a custom list? A) File → Options → Advanced → Edit Custom Lists B) Enter the list items in the “List entries” box C) Click “Add” to save the list D) Use the “Sort by Color” option to apply the list Answer: D Explanation: “Sort by Color” is unrelated to custom list creation.
Exam
Question 46. Which function can be used to return the weekday name of a given date? A) WEEKDAY B) TEXT(date,"dddd") C) DAY D) DATEVALUE Answer: B Explanation: TEXT with the format “dddd” converts a date to its full weekday name. Question 47. To quickly change the case of text in a cell (e.g., to uppercase), which function would you use? A) PROPER B) UPPER C) LOWER D) CASE Answer: B Explanation: UPPER converts all letters in a string to uppercase. Question 48. Which of the following statements about slicers is true? A) Slicers only work with PivotTables, not regular tables B) Slicers can filter multiple PivotTables that share the same data source C) Slicers replace the need for filters altogether D) Slicers cannot be resized Answer: B Explanation: A slicer can control several PivotTables linked to the same cache.
Exam
Answer: A Explanation: Data Bars visually compare each value to the rest of the selected range. Question 52. Which of the following best describes the purpose of the “Goal Seek” tool? A) To find the input value that produces a desired result in a formula B) To sort data automatically C) To create a dynamic named range D) To generate a forecast chart Answer: A Explanation: Goal Seek iteratively changes a cell to achieve a target result. Question 53. In a PivotTable, where would you place a field to group data by month automatically? A) Rows area B) Columns area C) Filters area D) Values area Answer: A Explanation: Placing a date field in Rows and then grouping by month creates month‑level rows. Question 54. Which function can be used to round a number to the nearest even integer? A) ROUND B) MROUND C) EVEN
Exam
D) ROUNDEVEN
Answer: C Explanation: EVEN rounds a number up to the nearest even integer. Question 55. To protect a worksheet but still allow users to insert rows, which setting must be enabled? A) Allow inserting rows (in protection options) B) Unprotect the worksheet C) Use a macro to unlock rows D) Disable the Protect Sheet command Answer: A Explanation: When protecting a sheet, you can select specific actions (like inserting rows) to remain allowed. Question 56. Which of the following is NOT a valid way to reference a cell on another worksheet? A) Sheet2!A B) 'Sheet 2'!A C) [Sheet2]A D) =Sheet2!A1 (within a formula) Answer: C Explanation: The correct syntax uses an exclamation mark; brackets are not used for worksheet references. Question 57. What does the “Show Formulas” command (Ctrl+`) do? A) Displays the results of formulas as text
