BCIS 1305 Excel Quiz 1 & 2 & 3 & 4

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so? A. =COUNT(B1:B20) B. =COUNTIF(B1:B20) C. =SUM(B1:B20) D. =CALCULATE(B1:B20)

A. =COUNT(B1:B20)

A student wants to round the number 24.7835 entered in cell A2 to two decimal places. Which of these formulas can she use to do so? A. =ROUND(A5,2) B. =MROUND(A5,2) C. =ROUND(A5,2.0) D. =MROUND(A5,0.2)

A. =ROUND(A5,2)

What feature inserts a function that totals the cells above or to the left of the selected cell? A. AutoSum button B. absolute reference C. reference operator D. mode indicator

A. AutoSum button

How can you distinguish between a manually added page break and an automatic page break in a worksheet? A. Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines. B. Automatic page breaks appear as curved lines while manual page breaks appear as jagged lines. C. Automatic page breaks appear as dashed lines while manual page breaks appear as wavy lines. D. Automatic page breaks appear as zigzag lines while manual page breaks appear as solid lines.

A. Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group? A. Calculate Now B. Calculate Sheet C. Watch Window D. Calculation Options

A. Calculate Now

To accept a suggested spelling for that instance only, which of the following would you click? A. Change B. Change All C. Ignore Once D. Add to Dictionary

A. Change

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document? A. Change All B. Change C. Ignore Once D. Ignore All

A. Change All

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose? A. Click Margins in the Page Setup group on the Page Layout tab and then click on Normal. B. Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab. C. Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab. D. Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.

A. Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK? A. Click on the select button in Rows to repeat at top area and select a title row. B. Click on the select button in Columns to repeat at left area and select a title row. C. Click the check box before Row and column headings under Print. D. Click the check box before Gridlines under Print.

A. Click on the select button in Rows to repeat at top area and select a title row.

How can you remove Split panes in a worksheet you are working on? A. Click the View tab in the Ribbon, then click the Split button in the Window group. B. Click the Page Layout tab in the Ribbon, then click the Bring Forward button in the Arrange 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.

A. Click the View tab in the Ribbon, then click the Split button in the Window group.

To select a single worksheet cell so you can work with it, which of the following would you do? A. Click the cell. B. Move the cell pointer over the cell. C. Click the status bar. D. Click the Name box.

A. Click the cell.

Which of the following is the temporary Windows storage area that holds selections you copy or cut? A. Clipboard B. Backstage C. Name box D. Worksheet window

A. Clipboard

Which of the following is true about inserting cells in a worksheet? A. Excel automatically adjusts cell references to reflect new formula locations. B. You need to adjust cell references in all formulas that have moved. C. You cannot insert cells in a worksheet. D. Cells below the inserted cells are always moved downward.

A. Excel automatically adjusts cell references to reflect new formula locations.

Which of the following tabs lets you set worksheet print options? A. File B. Home C. Page Layout D. View

A. File

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic? A. Formulas B. Proofing C. Language D. Advanced

A. Formulas

What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic? A. Formulas B. Proofing C. Language D. Advanced

A. Formulas

Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation: File < Options < X < Manual? A. Formulas B. Proofing C. Language D. Advanced

A. Formulas

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? A. If it needs an absolute cell reference. B. If it needs a relative cell reference. C. If it needs landscape orientation. D. If it needs a function.

A. If it needs an absolute cell reference.

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 4 > View tab > Windows group > Freeze Panes > Freeze Top Row C. Row 3 > View tab > Windows group > Freeze Panes > Freeze Top Row > Arrange All D. Row 3 > View tab > Windows group > Freeze Panes > Freeze First Column > View Side by Side

A. Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes

Where do you rename a workbook and adjust its save location? A. Save As dialog box B. Home tab C. Name box D. Active cell

A. Save As dialog box

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. The formula is copied with cell references you must adjust to avoid worksheet errors. C. The Auto Fill Options button appears. D. Pointing to the destination cell causes a preview of the cell contents to appear.

A. The Paste Options button then lets you paste specific elements of the copied cells.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next? A. The Undo button on the Quick Access toolbar B. The Cancel button on the Formula bar C. The Enter button on the Formula bar D. The Save button on the Quick Access toolbar

A. The Undo button on the Quick Access toolbar

How can you remove data labels from a chart? A. Uncheck the box beside Data Labels in Chart Elements. B. Click on Remove on the options on the right side of Data Labels. C. Click on Delete on the options on the right side of Data Labels. D. Click to select the Data labels, then click on Edit and then Delete.

A. Uncheck the box beside Data Labels in Chart Elements.

Boris wants to remove a workbook window from his workplace. What series of clicks can he use to hide it?+B12:D44 A. View tab > Window group > Hide B. View tab > Window group > Split C. View tab > Window group > View Side by Side D. View tab > Window group > Switch Windows > Select a file

A. View tab > Window group > Hide

Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so? A. View tab > Window group > Unhide B. View tab > Window group > Uncheck box beside Hide > Check box beside Unhide C. File > Options > Display > Check Show all windows in the Taskbar box D. Home > Format > Visibility > Hide & Unhide > Hide Sheet

A. View tab > Window group > Unhide

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 > Unfreeze Panes B. View tab > Windows group > Freeze Panes > Freeze Top Column > Arrange All C. View tab > Windows group > Freeze Panes > Unfreeze Panes> Arrange All D. View tab > Windows group > Freeze Panes > Freeze First Column > Unfreeze Panes

A. View tab > Windows group > Freeze Panes > Unfreeze Panes

Which of the following is true when you delete a cell? A. When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. B. Row and column alignment will not be affected. C. You need to manually adjust cell references in surrounding formulas. D. You can use the Delete command on the Insert tab.

A. When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells.

Which of the following is true of the Excel spell checker? A. You can change all instances of a flagged word to a selected suggestion. B. You cannot add words to the spell checker dictionary. C. You must accept all spell checker suggested replacement words. D. For multiple instances of a misspelled word, you must change each one individually.

A. You can change all instances of a flagged word to a selected suggestion.

In the formula =SUM(A6:A9), which of the following best describes A6? A. argument B. function C. label D. active cell

A. argument

To format a range so that all values greater than $500 appear in red, which of the following can you use? A. conditional formatting B. cell formatting C. cell styles D. Quick Access toolbar

A. conditional formatting

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. $A$5 C. $A5 D. A$5

B. $A$5

Which of the following inserts a function into a cell? A. mode indicator B. AutoSum button C. argument D. formula prefix

B. AutoSum button

When you cut or copy a cell, it is cut or copied to which of the following? A. Neither the Windows or Office Clipboard B. Both the Windows and Office Clipboard C. Only the Office Clipboard D. Only the Windows Clipboard

B. Both the Windows and Office Clipboard

To change a range's conditional formatting from data bars to icon sets, which of the following can you do? A. Delete the conditional formatting rule. B. Edit the conditional formatting rule. C. Format the range in the Font dialog box. D. Format the range as a table.

B. Edit the conditional formatting rule.

Which of the following options should one choose to prompt Excel to calculate all open workbooks manually? A. F5 B. F9 C. F10 D. F12

B. F9

To print your worksheet at its actual size, which of the following would you select? A. Fit to B. No scaling C. Fit sheet to one page D. Scale to fit

B. No scaling

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. Labels B. Number C. Tick Marks D. Text Options

B. Number

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use? A. Home B. Page Layout C. Insert D. View

B. Page Layout

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 column to the right of the page break you want to delete. C. Select the row above the page break you want to delete. D. Select the row below the page break you want to delete.

B. Select the column to the right of the page break you want to delete.

Which of the following is true when you copy and paste formulas using the fill handle? A. The Paste Options button lets you paste only specific elements of the copied selection. B. The AutoFill Options button lets you fill cells with specific elements of the copied cell. C. The formula is placed on the Office clipboard. D. You need to change the cell references to reflect the new formula location.

B. The AutoFill Options button lets you fill cells with specific elements of the copied cell.

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell? A. To erase the cell value from the clipboard. B. To paste the value's number formatting only. C. To paste all items on the clipboard. D. To compute the results of a function.

B. To paste the value's number formatting only.

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____. A. deleted B. hidden C. cut D. conditionally formatted

B. hidden

Which of the following is not a way to move cell contents? A. the Cut and Paste buttons on the Home tab B. the fill handle in the lower-right corner of an active cell or range C. the CTRL key + the Move pointer D. drag-and-drop

B. the fill handle in the lower-right corner of an active cell or range

Clicking the Percentage style in the Number Format list applies _____ decimal places by default. A. one B. two C. three D. four

B. two

Which of the following is true about adding cell borders? A. You cannot apply borders to all worksheet cells. B. A cell border underlines the cell text, not the entire cell. C. A cell border extends the width of the cell. D. You can only apply a border to the bottom of a cell.

C. A cell border extends the width of the cell.

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. Axes B. Labels C. Analysis D. Background

C. Analysis

Which of the following would you use to print only one page of a multipage worksheet? A. Page Layout tab B. Formulas tab C. Backstage view D. Page Setup dialog box

C. Backstage view

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab. A. Alignment B. Fonts C. Color D. Styles

C. Color

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >? A. Insert Column Chart B. Insert Combo Chart C. Insert Pie or Doughnut Chart D. Insert Stock, Surface or Radar Chart

C. Insert Pie or Doughnut Chart

Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her do so? A. Sheet tab > Window group > Hide B. Sheet tab > Window group > Freeze Panes > Hide C. Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet D. Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Rows

C. Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK? A. Icon Sets B. Color Scales C. Top/Bottom Rules D. Highlight Cells Rules

C. Top/Bottom Rules

How many actions does the Undo button let you reverse? A. 24 B. 50 C. 75 D. 100

D. 100

Which of the following functions would you use to calculate the arithmetic mean of a price list? A. MAX B. COUNT C. SUM D. AVERAGE

D. AVERAGE

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem? A. Hide the column headings. B. Insert a function. C. Copy columns to the next page. D. Change the page orientation to landscape.

D. Change the page orientation to landscape.

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. Pie B. Bar C. Line D. Column

D. Column

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed? A. Normal pointer B. I-beam pointer C. Move pointer D. Copy pointer

D. Copy pointer

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. Best Fit B. Inside End C. Outside End D. Data Callout

D. Data Callout

To print more than one copy of your worksheet, which tab would you go to? A. View B. Page Layout C. Insert D. File

D. File

Which of the following tabs lets you see exactly how your worksheet looks before printing? A. Insert B. View C. Formulas D. File

D. File

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell? A. mode indicator B. Page Break Preview C. scroll bar D. Fill handle

D. Fill handle

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use? A. icon sets B. themes C. Top/Bottom Rules D. Highlight Cells Rules

D. Highlight Cells Rules

Which of the following lets you search for a function or select one from a category? A. Function Arguments dialog box B. clipboard C. formula bar D. Insert Function dialog box

D. Insert Function dialog box

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. You will have to manually correct cell references in formulas. D. It may disturb row or column alignment, which can affect worksheet accuracy.

D. It may disturb row or column alignment, which can affect worksheet accuracy.

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do? A. Leave the workbook closed. B. Open the workbook, change the first worksheet, and save it using the Save command. C. Open the workbook, make changes, and then save it using the same name. D. Open the workbook, make changes, and then save it using a different name.

D. Open the workbook, make changes, and then save it using a different name.

To see a preview of how a pasted value will look, which of the following would you use? A. Fill button B. AutoFill Options button C. Paste button D. Paste List arrow

D. Paste List arrow

Which of the following functions inserts the total of a range? A. ROUND B. AUTOSUM C. AVERAGE D. SUM

D. SUM

Which of the following statements is true about COUNT functions? A. The COUNT function returns the number of calls in a range that are not blank. B. The COUNT function returns the number of calls in a range that contain any data at all. C. Using the COUNT function is useful for computing the average of a cell range. D. The COUNT function returns the number of calls in a range that contain numeric data.

D. The COUNT function returns the number of calls in a range that contain numeric data.

Which of the following is true about moving cell contents? A. You can move cells using the Copy command. B. You cannot move cells from one worksheet to another. C. When you move cell contents, they remain in their original location. D. You can move cells using the drag-and-drop feature.

D. You can move cells using the drag-and-drop feature.

Which of the following is a built-in formula that helps you perform complex calculations? A. clipboard B. mode indicator C. named range D. function

D. function

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C. A. delete B. conditionally format C. edit D. hide

D. hide

To unprotect a workbook, open the Excel file, then click on File > Info > Protect Workbook > Encrypt with Password > OK. True False

True