Download SIMnet Excel Ultimate Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which file extension is used for a macro‑enabled workbook? A) .xlsx B) .xlsm C) .xlsb D) .xltx Answer: B Explanation: .xlsm denotes a workbook that can contain VBA macros. Question 2. To view two parts of a worksheet simultaneously, which feature should you use? A) Freeze Panes B) Split C) Hide D) Group Answer: B Explanation: The Split command divides the window so you can scroll each pane independently. Question 3. Which Ribbon tab can you customize to add the “Quick Analysis” tool? A) Home B) Insert C) File D) View Answer: A Explanation: The Quick Analysis tool is found on the Home tab and can be added to the Quick Access Toolbar. Question 4. How do you change the tab color of a worksheet? A) Home → Format → Tab Color B) Right‑click the sheet tab → Tab Color → Select color C) Page Layout → Sheet Options → Tab Color
D) Data → Properties → Tab Color Answer: B Explanation: Right‑clicking the sheet tab opens a menu where Tab Color can be chosen. Question 5. Which command removes all hidden rows and columns from a worksheet view? A) Unhide B) Delete C) Clear All D) Show All Answer: D Explanation: “Show All” (Home → Find & Select → Show All) reveals any hidden rows or columns. Question 6. When using AutoFill, which of the following will fill a series of dates incremented by one day? A) Drag the fill handle while holding Ctrl B) Drag the fill handle while holding Shift C) Drag the fill handle without any key D) Drag the fill handle while holding Alt Answer: C Explanation: AutoFill automatically continues a recognized pattern, such as sequential dates, without extra keys. Question 7. Which Paste Special option will keep the original formatting of the destination cells? A) Values B) Formulas C) Formats D) None of the above Answer: D Explanation: None of the listed options preserve destination formatting; they replace it.
C) Duplicate Values D) Bottom 10% Answer: B Explanation: “Text that Contains” lets you specify a string to highlight. Question 12. Which icon set would you use to flag values as “Low”, “Medium”, and “High”? A) 3 Arrows (Colored) B) 4 Traffic Lights C) 5 Rating D) 3 Symbols (Circled) Answer: A Explanation: The 3‑arrow set visually represents low, medium, and high values. Question 13. In a formula, what does the dollar sign ($) before a column letter indicate? A) Relative column reference B) Absolute column reference C) Mixed reference with absolute row D) Mixed reference with relative row Answer: B Explanation: $A1 locks the column (absolute) while the row stays relative. Question 14. Which function returns the larger of two numbers? A) MIN B) MAX C) LARGE D) BIGGER Answer: B Explanation: MAX returns the greatest value among its arguments.
Question 15. Which logical function evaluates multiple conditions and returns a value for the first true condition? A) IF B) AND C) IFS D) OR Answer: C Explanation: IFS tests conditions sequentially and returns the associated result for the first TRUE. Question 16. If you need to count only cells that contain numbers, which function should you use? A) COUNTA B) COUNT C) COUNTBLANK D) COUNTIF Answer: B Explanation: COUNT tallies cells with numeric data only. Question 17. Which function calculates the monthly payment for a loan? A) PV B) FV C) PMT D) IPMT Answer: C Explanation: PMT returns the periodic payment amount based on rate, periods, and principal. Question 18. What does the VLOOKUP fourth argument (range_lookup) set to FALSE do? A) Forces an exact match search B) Allows approximate matches C) Searches horizontally
Question 22. To calculate the number of working days between two dates, excluding weekends and holidays, which function is appropriate? A) NETWORKDAYS B) WORKDAY C) DAYS D) DATEDIF Answer: A Explanation: NETWORKDAYS counts weekdays and can subtract a list of holidays. Question 23. In formula auditing, which pane shows the cells that depend on the active cell? A) Precedents B) Dependents C) Watch Window D) Error Checking Answer: B Explanation: Dependents are cells that use the active cell in their formulas. Question 24. Which feature allows you to monitor the value of a specific cell while working elsewhere in the workbook? A) Trace Precedents B) Watch Window C) Goal Seek D) Data Validation Answer: B Explanation: The Watch Window displays selected cells and updates them in real time. Question 25. When converting a range to a Table, which default element is added automatically? A) Data Validation list
B) Total Row (optional) C) Filter arrows on each header D) Conditional Formatting rule Answer: C Explanation: Tables include filter drop‑downs on each header row by default. Question 26. What is the 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) =A1:A Answer: A Explanation: Named ranges require absolute references; the equal sign precedes the reference. Question 27. Which option in a Table’s design tab adds a row that automatically calculates totals for numeric columns? A) Header Row B) Total Row C) Banded Rows D) First Column Answer: B Explanation: The Total Row provides aggregate functions like Sum, Average, etc. Question 28. To sort data first by “Region” ascending and then by “Sales” descending, which method should you use? A) Sort by Region only B) Use a custom sort with two levels C) Apply a filter and then sort D) Use the Sort dialog and select “Add Level” twice
Question 32. When creating a line chart, which axis typically represents time? A) Primary Vertical Axis B) Secondary Horizontal Axis C) Primary Horizontal Axis D) Secondary Vertical Axis Answer: C Explanation: The horizontal (category) axis is commonly used for chronological data. Question 33. Which chart type is best suited for showing the proportion of categories that sum to 100%? A) Clustered Column B) Stacked Bar C) Pie D) Scatter Answer: C Explanation: A pie chart displays parts of a whole as slices. Question 34. To move a chart to a separate sheet, which command should you use? A) Move Chart → New Sheet B) Cut and Paste to a new worksheet C) Right‑click → Format Chart Area → Move to Sheet D) Insert → Chart Sheet Answer: A Explanation: The “Move Chart” dialog offers the option to place the chart on a new chart sheet. Question 35. Which Sparkline type is best for showing trends without showing individual data points? A) Column B) Win/Loss
C) Line D) Scatter Answer: C Explanation: Line Sparklines display a continuous trend line. Question 36. What does the “Fit to” scaling option do when printing a workbook? A) Adjusts column widths to fit the page width B) Scales the sheet to a specified number of pages tall and wide C) Prints only the used range D) Changes the orientation to landscape automatically Answer: B Explanation: “Fit to” forces the printout to occupy the defined number of pages. Question 37. Which header/footer code inserts the current file name? A) &[File] B) &[Path] C) &[FileName] D) &[Tab] Answer: C Explanation: &[FileName] is the field code for the workbook’s name. Question 38. To repeat the top row of a worksheet on every printed page, you should set which page‑setup option? A) Print Area B) Print Titles C) Page Breaks D) Margins Answer: B Explanation: Print Titles let you designate rows/columns to repeat on each printed page.
B) TEXT
C) VALUE
D) CONVERT
Answer: A Explanation: DATEVALUE interprets a date string and returns the serial number. Question 43. Which of the following is NOT a valid way to reference the same workbook from a different worksheet? A) Sheet2!A B) 'Sheet 2'!A C) [Workbook1]Sheet2!A D) Workbook2!Sheet2!A Answer: D Explanation: A reference cannot contain another workbook name unless that workbook is open; “Workbook2!” is invalid in the same file. Question 44. What does the “Wrap Text” alignment option do? A) Shrinks the font to fit the cell B) Displays text on multiple lines within the same cell C) Merges adjacent cells automatically D) Aligns text vertically in the center Answer: B Explanation: Wrap Text forces line breaks so all content is visible inside the cell. Question 45. Which of these number formats will always display four decimal places, even if the value is an integer? A) 0.#### B) #,##0. C) 0. D) General
Answer: C Explanation: “0.0000” forces four decimal places regardless of the actual value. Question 46. In a Table, what does the “Total Row” option’s “Count” function return? A) Number of non‑blank cells in the column B) Number of rows in the Table C) Sum of numeric entries D) Average of numeric entries Answer: A Explanation: COUNT counts numeric entries; COUNTA counts all non‑blank cells. In a Table’s Total Row, “Count” counts non‑blank cells. Question 47. Which function can be used to round a number to the nearest multiple of 5? A) ROUND B) MROUND C) CEILING D) FLOOR Answer: B Explanation: MROUND rounds to the nearest multiple specified (e.g., MROUND(A1,5)). Question 48. When using the “Goal Seek” dialog, which cell must contain a formula? A) Set Cell B) To Value C) By Changing Cell D) All three must contain formulas Answer: A Explanation: Goal Seek changes the “By Changing Cell” to achieve the desired result in the “Set Cell,” which must be a formula.
C) Use Review → Protect Sheet and check “Select unlocked cells” only D) Use Review → Allow Users to Edit Ranges Answer: C Explanation: Allowing selection of unlocked cells only prevents changes to locked cells. Question 53. Which option in the “File → Info” screen lets you add custom document properties? A) Check for Issues B) Properties → Advanced Properties → Custom C) Protect Workbook D) Convert Answer: B Explanation: The Custom tab under Advanced Properties is where you define new document properties. Question 54. What does the “Transpose” option in Paste Special do? A) Switches rows to columns and vice versa B) Changes the cell format to text C) Pastes only the formulas, not the values D) Pastes data with a diagonal orientation Answer: A Explanation: Transpose flips the orientation of the copied range. Question 55. Which of these functions can be used to count cells that meet multiple criteria? A) COUNTIF B) COUNTIFS C) SUMIF D) AVERAGEIF Answer: B Explanation: COUNTIFS allows multiple criteria across different ranges.
Question 56. When you apply a Table Style, which element is NOT automatically formatted? A) Header Row B) Total Row C) Banded Rows D) First Column Answer: B Explanation: The Total Row appears only if you enable it; it isn’t automatically styled. Question 57. Which of the following is a valid way to reference a cell on a different workbook that is currently closed? A) =[Book1.xlsx]Sheet1!A B) ='C:\Folder[Book1.xlsx]Sheet1'!A C) Book1!Sheet1!A D) =Book1.xlsx!A Answer: B Explanation: A full external reference includes the path, workbook name in brackets, and sheet name. Question 58. Which function returns the text representation of a number formatted as a currency? A) TEXT B) DOLLAR C) FORMAT D) CURRENCY Answer: B Explanation: DOLLAR converts a numeric value to a text string with currency formatting. Question 59. In a chart, which axis is considered the “Category (X) Axis”? A) Primary Vertical Axis B) Secondary Horizontal Axis C) Primary Horizontal Axis
Question 63. Which feature lets you quickly copy the formatting of a cell to a non‑adjacent cell without using the Format Painter? A) Ctrl + C then Ctrl + Alt + V → F B) Double‑click the fill handle C) Right‑click → Copy Format D) Use the Clipboard pane Answer: A Explanation: Using Paste Special → Formats (Ctrl + Alt + V, then F) copies only formatting. Question 64. Which chart element can you add to display the average of a data series? A) Data Labels B) Trendline → Moving Average C) Error Bars D) Legend Answer: B Explanation: A Moving Average trendline shows the calculated average over a specified period. Question 65. When you set a print area, which cells are printed? A) All cells on the worksheet B) Only the cells inside the defined area C) The used range of the worksheet D) Cells that are not hidden Answer: B Explanation: The print area restricts printing to the selected range. Question 66. Which function returns the day of the week as a number (1‑7) for a given date? A) WEEKDAY B) DAY
C) DATEPART
D) DOW
Answer: A Explanation: WEEKDAY returns a numeric representation of the day of the week. Question 67. Which of the following is the correct syntax for the SUMIFS function? A) SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) B) SUMIFS(criteria_range1, criteria1, sum_range, [criteria_range2, criteria2]) C) SUMIFS(sum_range, criteria1, criteria_range1, …) D) SUMIFS(criteria_range1, criteria_range2, sum_range, criteria1, criteria2) Answer: A Explanation: SUMIFS starts with the range to sum, then pairs of criteria ranges and criteria. Question 68. What does the “Allow Editing Directly in Cells” option control? A) Whether users can edit cells in protected worksheets B) Whether double‑clicking a cell enters edit mode C) Whether formulas can be edited in the formula bar D) Whether cell comments can be edited Answer: B Explanation: This option toggles the ability to edit a cell by double‑clicking it. Question 69. Which of the following will convert the value 0.75 to a fraction format? A) 3/ B) =TEXT(0.75,"# ?/?") C) =FRAC(0.75) D) Format Cells → Number → Fraction Answer: D Explanation: Selecting the Fraction number format changes display to a fractional representation.
