Excel 3
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas? a. $A5 b. A5 c. A$5 d. $A$5
$A$5
The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59. Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B? a. =IF(B2<60,"F",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90,"B","A")))) b. =IF(B2</=59,"F",IF(B2</=69,"D",IF(B2</=79,"C",IF(B2</=89,"B", IF(B2</=100"A")))) c. =IF(B2<59,"F",IF(B2<69,"D",IF(B2<79,"C",IF(B2<89,"B","A")))) d. =IF(B2=0-59,"F",IF(B2=60-69,"D",IF(B2=70-79,"C",IF(B2=80-89,"B",IF(B2=90-100,"A"))))
=IF(B2<60,"F",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90,"B","A"))))
The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed? a. =AND(B2>=60, "Pass", "Fail") b. =NOT(OR((B2>=60, "Pass", "Fail")) c. =IF(B2>=60, "Pass", "Fail") d. =OR(B2>=60, "Pass", "Fail")
=IF(B2>=60, "Pass", "Fail")
Nathan wants TRUE to be elicited if either of the statements are true, and FALSE if both are true. Which of the following formula can he use to ensure that? a. =IFERROR(...) b. =IFNA(...) c. =XOR(...) d. =TRUE OR FALSE(...)
=XOR(...)
In the formula =B6*$B$2, which of the following describes $B$2? a. Function b. Relative cell reference c. Average d. Absolute cell reference
Absolute cell reference
Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change? a. Labels b. Analysis c. Background d. Axes
Analysis
To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one. a. ALT b. SHIFT c. ESC d. CTRL
CTRL
Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+) sign > Arrow next to Chart title > X? a. Above Chart b. Over Chart c. Below Chart d. Centered Overlay
Centered Overlay
How can you remove Split panes in a worksheet you are working on? a. Click the Page Layout tab in the Ribbon, then click the Bring Forward button in the Arrange group. b. Click the View tab in the Ribbon, then click the Split button in the Window group. c. Click the View tab in the Ribbon, then click the Split button and then the Hide button in the Window group. d. Click the Page layout tab in the Ribbon, then click the Insert Breaks button and choose from the drop down menu in the Page Setup group.
Click the View tab in the Ribbon, then click the Split button in the Window group
Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK? a. Column b. Bar c. Pie d. Line
Column
Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements? a. Data Callout b. Inside End c. Best Fit d. Outside End
Data Callout
Which of the following is true about inserting cells in a worksheet? a. You cannot insert cells in a worksheet. b. You need to adjust cell references in all formulas that have moved. c. Excel automatically adjusts cell references to reflect new formula locations. d. Cells below the inserted cells are always moved downward.
Excel automatically adjusts cell references to reflect new formula locations
To copy a cell's formatting to another cell, which of the following can you use? a. Format Cells dialog box b. Format as Table c. Format Painter d. Quick Analysis Tool
Format Painter
Which of the following is true about changing worksheet column width? a. When you drag the right column border in Normal view, a ScreenTip displays the exact width in inches. b. When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels. c. In Normal view, the Column Width dialog box lets you set column width to an exact value in inches. d. In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column
Why is it necessary to use care when inserting worksheet cells? a. It might automatically change the functions you are using. b. It can change relative references to absolute references in formulas. c. It may disturb row or column alignment, which can affect worksheet accuracy. d. You will have to manually correct cell references in formulas.
It may disturb row or column alignment, which can affect worksheet accuracy
Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click) Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box? a. Text Options b. Labels c. Number d. Tick Marks
Number
To rotate cell contents to an exact value, you change its _____. a. Orientation b. Font c. Indent d. Width
Orientation
To which of the following chart types can you not add axis titles? a. Area chart b. Line chart c. Pie chart d. Column chart
Pie chart
Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet. Which of the following series of clicks will help her do so? a. Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes b. Row 3 > View tab > Windows group > Freeze Panes > Freeze First Column > View Side by Side c. Row 4 > View tab > Windows group > Freeze Panes > Freeze Top Row d. Row 3 > View tab > Windows group > Freeze Panes > Freeze Top Row > Arrange All
Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes
Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so? a. Select rows 2 to 16 and click View tab > Window group > Split. b. Select row 17 and click View tab > Window group > Split. c. Select row 16 and click View tab > Window group > Split > Arrange All. d. Select rows 2 to 16 and click View tab > Window group > New Window > Split.
Select row 17 and click View tab > Window group > Split
Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break? a. Select the column to the left of the page break you want to delete. b. Select the row below the page break you want to delete. c. Select the column to the right of the page break you want to delete. d. Select the row above the page break you want to delete.
Select the column to the right of the page break you want to delete
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true? a. The Paste Options button then lets you paste specific elements of the copied cells. b. Pointing to the destination cell causes a preview of the cell contents to appear. c. The Auto Fill Options button appears. d. The formula is copied with cell references you must adjust to avoid worksheet errors.
The Paste Options button then lets you paste specific elements of the copied cells.
Which of the following is true about deleting a worksheet row? a. After you delete a row, the rows below it shift down one row. b. To delete a row, you can select the row, then press the DELETE key on the keyboard. c. To delete a row, you can select the row, then use the Delete button in the Cells group. d. If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.
To delete a row, you can select the row, then use the Delete button in the Cells group.
For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell? a. To paste all items on the clipboard. b. To compute the results of a function. c. To erase the cell value from the clipboard. d. To paste the value's number formatting only.
To paste the value's number formatting only.
How can you remove data labels from a chart? a. Click on Delete on the options on the right side of Data Labels. b. Uncheck the box beside Data Labels in Chart Elements. c. Click on Remove on the options on the right side of Data Labels. d. Click to select the Data labels, then click on Edit and then Delete.
Uncheck the box beside Data Labels in Chart Elements
Sala wants to unfreeze the first column of his worksheet. Which of the following series of clicks will help him do so? a. View tab > Windows group > Freeze Panes > Freeze First Column > Unfreeze Panes b. View tab > Windows group > Freeze Panes > Unfreeze Panes c. View tab > Windows group > Freeze Panes > Unfreeze Panes> Arrange All d. View tab > Windows group > Freeze Panes > Freeze Top Column > Arrange All
View tab > Windows group > Freeze Panes > Unfreeze Panes
Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek... from the drop down menu. What is X in the procedure? a. Data Validation b. Relationships c. Consolidate d. What-if Analysis
What-if Analysis
Which of the following is true when you delete a cell? a. Row and column alignment will not be affected. b. You need to manually adjust cell references in surrounding formulas. c. When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. d. You can use the Delete command on the Insert tab.
When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells
Helga wants to reset page breaks in a worksheet to display only automatic page breaks. Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks? :a. X- Normal, Y- Print Area b. X- Custom Views, Y- Background c. X- Page Break Preview, Y- Breaks d. X- Page Layout, Y- Print Tiles
X- Page Break Preview, Y- Breaks
Which of the following is true about moving cell contents? a. You can move cells using the Copy command. b. When you move cell contents, they remain in their original location. c. You cannot move cells from one worksheet to another. d. You can move cells using the drag-and-drop feature.
You can move cells using the drag-and-drop feature
To delete a worksheet column, you can first select it by _____. a. double-clicking anywhere in the column b. double-clicking the column heading c. clicking anywhere in the column d. clicking the column heading
clicking the column heading
You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add? a. a button b. conditional formatting c. a column d. a row
column
You double-click the Format Painter button when you want to _____. a. copy a cell's format to only one cell b. use conditional formatting c. copy a cell's format to more than one cell d. clear a cell's formatting
copy a cell's format to more than one cell
To change the name of a worksheet, you rename the _____. a. sheet tab b. sheet header c. sheet columns d. sheet rows
sheet tab
After you delete a worksheet column, _____. a. only its formats are deleted b. the columns to its right shift left c. the columns to its left shift right d. the row remains but its contents are deleted
the columns to its right shift left
Which of the following is not a way to move cell contents? a. the fill handle in the lower-right corner of an active cell or range b. drag-and-drop c. the CTRL key + the Move pointer d. the Cut and Paste buttons on the Home tab
the fill handle in the lower-right corner of an active cell or range