SIMnet Exam 1 Practice

These questions are part of the practice quiz. Start practicing

• In a one-variable data table, which cell is used as the Column input cell according to the instructions?
• To format cells with a value greater than 400 using a light red fill, which steps are correct?
• Which key do you press to run the Spelling and Grammar checker in Word?
• Where are substitute values for the one-variable data table entered?
• Which function is used to concatenate a range of text values with a delimiter while ignoring empty cells?
• Which sequence of steps correctly saves a document in a new folder named Marketing inside Documents?
• Which command clears the print area?
• What is the purpose of the Slide Master in PowerPoint?
• Which command inserts a centered page number in the footer and excludes the literal word Page?
• How do you name a worksheet?
• Which option describes how to copy a worksheet to a new workbook by using Move or Copy and creating a copy?
• Which steps describe creating a two-variable data table with Row input B3 and Column input B4?
• How do you adjust column width to fit content in Excel?
• Which feature allows you to view four areas of a worksheet at once, with independent scrolling?
• In cell D7, which DB depreciation formula uses Cost and Salvage as the Cost and Salvage arguments, Life from B3, Period from A7, and Month as 5?
• How do you configure a PivotTable value field to use MAX instead of SUM?
• Which function returns the position of a value within a one dimensional array?
• Which reference is a valid way to reference a named range called Cost in a formula?
• Which path describes inserting a slicer for the Category field?
• How do you change the background color of slides?
• In Excel, which command path would you use to insert a page break above a specific row from Page Break Preview view?
• How would you wrap text around an image in Word?
• Which steps describe filtering a table by Category values Coffee or Meals using a slicer?
• To print all columns on a single page without changing column widths, which configuration should you apply?
• How do you apply an animation to an object in PowerPoint?
• How is the Profit-Sharing field added to the PivotTable?
• Which action returns the worksheet to a single view after it has been split into four panes?
• To adjust when an animation plays, which tab do you use?
• In PowerPoint, which sequence creates a hyperlink from selected text or an object?
• How do you apply a transition to a slide in PowerPoint?
• Which action adds slicers to filter the data by Date?
• How do you print PowerPoint slides with notes?
• In cell B9, which formula uses NPV with the rate in B2 and the payments in B11:B14 as a single Value argument?
• To color a worksheet tab, which action is correct?
• What is the primary purpose of sparklines in a worksheet?
• Which nested INDEX and MATCH formula returns the ending balance for the date in C8 using the named range Schedule for the loan payments and PayDates for the payment date column, with Ending Balance as column 6?
• How do you save a PowerPoint presentation as a PDF?
• How do you insert a new slide with a specific layout in PowerPoint?
• Which sequence creates a Line chart using Excel's Quick Analysis feature?
• Where is the Data Table option accessed for What-If Analysis?
• What is a PivotTable used for?
• Which feature in PowerPoint is designed to maintain uniform formatting and layout across slides?
• What is the purpose of the Quick Analysis tool in Excel?
• How do you create a multilevel list in Word?
• What keyboard shortcut inserts a page break in Word?
• What is the Name Box in Excel?
• Which option can be used to record timings for slide timings during a presentation?
• In Excel, what does the formula =SUM(A1:A5) do?
• Which function would you use to find the largest value in a range?
• Which option formats dates as Short Date in Excel?
• Which view is the full-screen presentation when delivering slides?
• Where would you typically find the AutoSum function when summing or averaging a range?
• Which pair of functions is commonly used to look up a value by matching a date and returning a corresponding value from a table?
• Which sequence correctly inserts a chart into a slide?
• Where does Quick Analysis insert totals when calculating totals for the selected cells?
• Which IF formula returns 35000 when B9 is greater than or equal to 470000, otherwise returns 100?
• How do you freeze the top row in Excel?
• What is the Quick Analysis tool used for in Excel?
• Which formula returns the four-digit year from the date in cell A2 by extracting the last four digits of the date?
• Which operation would replace all instances of the word 'Coffee' with 'Office Supplies' in the worksheet?
• Which path correctly opens the header or footer feature in Word?
• Which feature automatically corrects common misspellings as you type?
• Which command sorts data A to Z by the Category column?
• Which command keeps the first row visible while you scroll the worksheet?
• Which action opens the Save As dialog in Excel?
• Which ribbon tab contains the Math & Trig category in Excel's Function Library?
• Which description correctly defines Freeze Panes?
• How do you create a simple chart (e.g., column chart) from data?
• How do you convert a table back to a normal range?
• Where do you apply automatic numbering to a list in Word?
• Which option describes the appearance of the Accounting Number Format in Excel?
• How do you check spelling and grammar in PowerPoint?
• What is the difference between Save and Save As in Word?
• What is the final action to complete an AutoSum operation after selecting Sum from the AutoSum menu?
• Which option would you use to insert a PivotTable based on existing data?
• How do you autofill a series (e.g., months) down a column?
• What is the path to hide the TimeSheets worksheet?
• What keyboard shortcuts are used to copy and paste the selected item to duplicate it in Word?
• How can you move to the second worksheet in a workbook?
• How do you apply currency formatting to a cell?
• How do you record narration for a PowerPoint slide show?
• How do you insert a picture into a PowerPoint slide?
• Which sequence correctly uses AutoSum to total the contiguous cells above the active cell?
• How do you insert a color for a worksheet tab?
• Which Excel command opens the Evaluate Formula dialog in the Formula Auditing group?
• Which font and size are the default in recent Word versions?
• Which path shows the correct location to set the print area for the selected cells?
• Which option adds column sparklines to cells F2:F11 to represent B2:E11 values?
• Which Excel function converts text to all lowercase?
• Which command clears everything (contents and formatting) from the selected cell?
• Which feature removes duplicate rows where all column data match?
• What does the 'Keep with next' option do in paragraph formatting?
• What does the dollar sign ($) do in an Excel cell reference?
• Which action disables Protected View so you can edit a file?
• Which action creates a new folder in the Save As dialog?
• Which feature would you use to quickly generate a PivotTable with a suggested layout?
• How do you insert a new shape or a text box on a slide in PowerPoint?
• In the TEXTJOIN function, what does setting ignore_empty to TRUE do?
• Which action inserts a new column using the Insert option in the Excel Ribbon?
• To customize slide size, which sequence should you use in PowerPoint?
• How do you start a slide show from the beginning in PowerPoint?
• Which option shows formulas in place of calculated values in the worksheet?
• What is the difference between Presenter View and Slide Show View in PowerPoint?
• Which UI element provides the underline options including Double Accounting?
• Which action clears the filter from the Category column?
• Which sequence correctly creates a chart in Excel?
• How do you insert a new row into a worksheet?
• How do you change the orientation of a Word document to Landscape?
• When wrapping text around an image in Word, which wrap option achieves a tight wrap?
• How do you filter data in a table?
• How do you access the Page Setup dialog to adjust margins in Word?
• What is the keyboard shortcut for spelling check in PowerPoint?
• In Excel, which symbol is used to lock a cell reference in an absolute reference?
• How is a 3-D Clustered Column chart created according to the instructions?
• How do you apply the Double Accounting underline to the selected cells?
• If a formula with a relative reference is copied to a different cell, what happens to the reference?
• In cell F2, which formula returns the averaged rank of the value in C4 among the values in C2:C13?
• What is the purpose of Slide Layouts in PowerPoint?
• Which sequence of steps would you use to enter a formula that averages B2:B6?
• What is the default font type and size in recent Word versions?
• What is the purpose of applying a Style in Word?
• In older Word versions, which tab is labeled Page Layout and contains margins options?
• How do you create a 3-D Pie chart from the selected data?
• How do you apply AutoFill to copy a formula from E2 to E3:E6?
• Before using the fill handle to autofill, what must you establish?
• Set the print area so only the selected cells print. Which path is correct?
• In the Save As sequence described, what is the final action to store the file in the new folder?
• What is the correct path to insert an image from your computer into a slide?
• Where is the AutoSum command located in the Excel ribbon?
• How can you quickly insert a table with three columns and four rows in Word?
• Which option ensures the range is treated as having headers when converting to a table?
• How do you convert the cell range to a table with Table Style Light 8 and include headers?
• What happens when you delete a selected cell range with the default option of shifting cells up?
• Which formula in cell H1 computes the mean of the values in E2:E13?
• Which statement best describes the role of Styles in Word?
• How do you insert a chart into a PowerPoint slide?
• Which formula uses TEXTJOIN to combine B2:D2 into a single text string with delimiter '#' and ignores blanks?
• To enter a SUM of cells B2 through B6 in cell B7 using a function, which entry correctly accomplishes this?
• On which tab do you find the option to insert a hyperlink?
• Which command inserts today's date into cell A1 without the time?
• What is the difference between relative and absolute cell references?
• Which option in PowerPoint is used to export a presentation as PDF/XPS?
• Which of the following best describes an absolute reference in Excel?
• When copying a formula down, what happens to relative and absolute references?
• What is the purpose of the Data Table dialog in What-If Analysis?
• Which tool would you use to edit a named range named 'CurrentSalaries' so it refers to B2:B6 on the Salaries worksheet?
• Which steps copy the Salaries worksheet to a new workbook?
• Which formula correctly uses CONCAT to join B2 and C2 with a colon between, producing Rent:Parking?
• How do you duplicate a slide in PowerPoint?
• In cell B7, which SLN depreciation formula uses Cost, Salvage, and Life from B3?
• What is the purpose of the '$' in an Excel formula (absolute reference)?
• How do you insert a column to the left of column E?
• Which formula in cell D5 calculates B5 divided by B4 and rounds the result to four decimal places?
• Which sequence hides gridlines for the worksheet?
• Which PowerPoint view shows notes and upcoming slides on the presenter's screen?
• Which command sets the print area?
• To add a total row to the table, which steps would you perform?
• How do you apply a theme to a PowerPoint presentation?
• To obtain the maximum value from E2:E14 in cell E15, which sequence would you use?
• Which path clears all conditional formatting rules from the worksheet?
• Which of the following is a valid way to insert a new row?
• Which steps would you take to insert a header or footer in Word?
• In VLOOKUP, which argument determines whether to require an exact match rather than an approximate match?
• Where would you navigate to insert the CONCAT function in Excel?
• Which function computes the arithmetic mean of a range of numbers?
• To move a table out of table format but keep data, which action would you perform?
• Which Excel feature allows you to rearrange and summarize data by dragging fields into rows, columns, and values?
• How do you insert a page break in Word?
• What is the method to copy the formatting from D1 to E1 using Format Painter?
• To select the entire Gross Profit data series in a chart, which action should you perform?
• Which action applies a Three Traffic Lights (Unrimmed) icon set to the selected cells?
• Which function would you use to insert the current date that can be used as a static date in a worksheet cell?
• After inserting a column to the left of E, which statement is true?
• Which formula correctly calculates the total expenses for the Office Expense category using the named ranges Category and Cost?
• Which VLOOKUP formula finds the meaning for the abbreviation in A3 using a named table Abbreviation, with exact match and the meaning in column 2?
• Which function counts numeric cells in a range?
• Which steps insert a Recommended PivotTable and choose Sum of Bonus by Employee?
• In a two-variable data table, which cells serve as the Row input and Column input respectively?