Exam 8: Excel

A shopkeeper creates an Excel sheet to list different items he sold today.Rows A1 to A3 contain headings-Order ID, Selling price, and Quantity, respectively.Cells B1 to H1 list the order ID for the items sold-1001,1002,1003,1004, and 1005, respectively.Cells B2 to H2 list their respective selling price-$10, $12.5, $14, $7.5, and $8.Cells B3 to H3 list their respective quantities-10, 12, 6, 5, and 13.If he enters the formula in cell J1 as: =HLOOKUP (1004, A1: H3, 2, FALSE), what will the formula return?

Rogelio wants to use a named range formula in a cell.To do so, he can select the cell, press F2 to edit the cell, then select (Insert > Name > Paste) and select the name for the cell.

Why is it necessary to use care when inserting worksheet cells?

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Which of these keys will you hold to select more than one item while inserting a slicer into a PivotTable?

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?

To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6.This means that row 4 is _____.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros.To find the problem, what should you check for in your original formula?

Right-click the pivot item, then click Collapse to collapse a field in a PivotTable.

Bella wants to insert a hyperlink to a location in the current file.Which of these can be X in the following series of clicks she can use to solve her purpose: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Select heading (current document only), bookmark, slide, custom show, or cell reference to link to in the list?

George wants to apply the time number format to time entered in a cell as '11:30'.Which of the following options, when chosen as X, will help him to do? Ctrl+1 < Category < X < Type < 13:30?

Changing a worksheet window to Normal view changes the contents of the worksheet.

Cedric has a list of data that he wants to group and summarize, For this, he can create an outline of up to eight levels, one for each group.

Esperanza wants to record a macro to automate a repetitive task.Which of the following combinations of keys should she press to open the Macro name box?

From how many theme options can you choose to change the theme of a Power View report?

In the formula =A8*$A$1, which of the following describes A8?