Quiz on Excel-10.2022

Which action CANNOT be reversed using the Undo command?

• Deleting more than 20 rows of data in the workbook

• Typing over the contents of a cell in your workbook

• Deleting a tab in the workbook

• Deleting a column in the workbook

You have a worksheet with multiple hidden columns and you need to view all of the data that is hidden. What is the best way to unhide the columns?

• Select the entire worksheet and double-click any column boundary.

• Double-click the column boundary for each hidden column

• Select the entire worksheet, then click Tools in the ribbon and select Unhide.

• Right-click the column to the right of each hidden column and select Unhide.

Your worksheet includes data for your company's IT department. How can you use Find and Select to quickly capitalize the many instances of IT appearing in the worksheet?

• Drag the capitalized version over each uncapitalized version.

• Use the Match case option under Replace.

• Use the Match entire cell contents option under Find.

• Use the Match entire cell contents option under Replace.

Before you create a chart in Excel, how would you have the chart appear?

• Remove any column headings.

• Remove any zero values.

• Remove any totals next to your data.

• Remove any row headings.

If you accidentally delete a sheet that you wanted to keep, which action should you take?

• Retrieve the sheet from a saved version of the file.

• Click the File tab, and then select Restore Deleted Sheet.

• Choose Undo or click Ctrl+Z.

• Right-click any sheet tab, and then select Unhide.

You can _____ multiple sheets at the same time by _____ them first.

• move; grouping

• group; splitting

• zoom-in on; dragging

• edit; grouping

An Excel workbook tracks the sales data for a company. A pivot table is in the adjacent tab and provides a high level view of the sales by department. The sales numbers are updated in the workbook, but the pivot table is not reflecting these changes. What is most likely causing this problem?

• You need to refresh the tab with the raw data to send the changes to the pivot table.

• You need to create a new pivot table to reflect the changes.

• You need to refresh the pivot table to include the updated data.

• There is an error in the updated data that prevents it from updating the pivot table.

If you have a worksheet containing data you do not want to be sorted, what must you do before sorting?

• Use Print Area to identify only the data you want to be sorted.

• Highlight the data you do not want to be sorted.

• Delineate the data you do not want to be sorted.

• Click the column or row you do not want to be sorted.

Which sequence will add 5 to each number in cells A1, A2, and A3?

• Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, and then select OK.

• Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+V, select Add, and then select OK.

• Enter 5 in cell A4. Select A4, select Ctrl+X, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.

• Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.

What is the correct function to show the formula in cell A2?

• FORMULA(TEXT(A2))

• FORMULATEXT(A2, FORMULATEXT)

• FORMULATEXT()

• FORMULATEXT(A2)