CIS Test 2

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.

Data bars

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click) Chart Title > Font > Font tab > X> OK?

Enter the desired size of the chart title in the Size box.

Which of the following tabs lets you set worksheet print options?

File

On which tab and button are document properties located for editing?

File tab, Info button

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Fill handle

You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the _____ feature.

Find and replace

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Highlight Cells Rules

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Home

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

hidden

In a complex formula, how does Excel determine which calculation to perform first?

it follows the order of operations.

Which worksheet view shows headers, footers, and rulers?

page layout view

To have Excel enter the lowest price from a range of prices, which of the following would you use?

MIN function

In the formula =SUM(A6:A9), which of the following best describes A6?

NOT Active cell

Which of the following will you select as X in the following series of clicks to change the change the color of a data series: (double-click) Data Series > Format Data Series > Series Options > X > Color > Color of your choice?

NOT Effects

Which of the following will you do in step X in the following series of clicks to change the bounds of a chart axis: Chart > Chart Tools > Format tab > Current Selection > Format Selection > Format Axis > Axis Options > Vertical Axis crosses > At Category number > X?

NOT Expand Tick Marks, and then select the options that you want in the Major type and Minor type boxes.

To copy a cell's formatting to another cell, which of the following can you use?

NOT Format Painter

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?

NOT If it needs a function.

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one

NOT Shift

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

NOT To paste all items on the clipboard.

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box) Show Data table?

NOT format

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?

Shape Fill

The default worksheet text is _____-point Calibri.

11

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$5

What is the correct formula to insert the date January 12, 1998 into a cell?

=DATE(1998,1,12)

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?

=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?

=IF(B2>=60, "Pass", "Fail")

Which formula can you use to extract the month from the date in cell F5: 2016 July 8th?

=MONTH(DATE(2016,7,0))

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?

=ROUND(A5,2)

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

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

What feature inserts a function that totals the cells above or to the left of the selected cell?

Autosum button

Which of the following functions would you use to calculate the arithmetic mean of a price list?

Average

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?

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?

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

To select a single worksheet cell so you can work with it, which of the following would you do?

Click the cell

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?

Colum

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Copy pointer

Where can you see a brief description of a selected function?

Insert Function dialog box

What will you select as X in the following series of clicks/entries to insert a Histogram chart: Range of cells > Insert tab > Charts group > X > Histogram group > Histogram chart icon > OK?

Insert Static Chart

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

Insert Tab

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

Page Layout

You can edit a worksheet footer in _____.

Page Layout view

To which of the following chart types can you not add axis titles?

Pie Chart

You can create conditional cell formats using either the Home tab or the _____.

Quick analysis tool

In the formula =B6*$B$2, which of the following describes $B$2?

Relative cell reference

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select Restrict permission to this workbook, and then assign the access levels that you want for each user.

Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

Select data source dialog box

Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her do so?

Sheet tab home tab cells group format visibility hide and unhide hide sheet

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Sum

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

The formula =SUM(B6:B10)

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

Tredline

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?

What if analysis

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?

Xor(...)

When you underline cell content, you are using _____.

a font style

To format a range so that all values greater than $500 appear in red, which of the following can you use?

conditional formatting

A _______ refers to a collection of characters with a similar, specific design

font

Which of the following is a built-in formula that helps you perform complex calculations?

function

After you delete a worksheet column, _____.

the columns to its right shift left

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

two