Quiz1 Excel Module 1 &2

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

Edit the conditional formatting rule.

A predesigned combination of formats, such as font size and color, is called a cell default.

False

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

False

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

False

Decreasing a cell's indent moves its contents to the right one space.

False

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

False

In formulas, calculations in square brackets are calculated first.

False

Jim frequently prints out the same section of a worksheet. To do so, he selects the cells he wants to define as print area, then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

False

Miley wants to perform calculations on four worksheets with identical structures at the same time. So, in order to group them and perform the task faster, she can press the Ctrl + Alt key and click the worksheet tabs she wants to group and then modify either of the worksheets for automatic change in the other one.

False

The Comma Style format adds a comma and a dollar sign to a cell value.

False

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

False

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

File tab, Info Button

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

Font

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

Home

The Clipboard task pane shows the contents of the _____.

Office Clipboard

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Accounting

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

=COUNTA(B1:B20)

The default worksheet text is _____-point Calibri.

11

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

39

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?

=COUNT(B1:B20)

How many actions does the Undo button let you reverse?

100

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.

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

Click Custom Views and double-click on the display settings she wants to see.

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.

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

It follows the order of operations.???

Amari wants to paint the format of one object onto a target object. She selects the first object, then clicks on Format Painter, on the Clipboard group in the Home tab. She then observes the cursor change to a specific icon. Which of the following is the icon into which the cursor changed?

Paintbrush

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

Relative cell reference

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 & Unhide > Hide Sheet

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

TRUE

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

The Undo button on the Quick Access toolbar

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

To paste the value's number formatting only.

Currency is an example of a number format.

True

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

True

To change the size of text to a particular percentage of the original text size in a Power View report, click on Power View tab > Themes group > Text Size.

True

Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.

True? I believe it False

Betty wants to choose the list to create a custom number format. To do so, what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom

Type

Boris wants to remove a workbook window from his workplace. What series of clicks can he use to hide it?

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?

View tab > Window group > Unhide

Luis wants to unhide and view all rows and columns in a worksheet. Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name ) > Include in view (Tick check box- Hidden rows, columns and filter settings ) > OK

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?

X- Page Break Preview, Y- Breaks

A worksheet named Income (2) is most likely which of the following?

a copy of another worksheet named Income

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

argument

For use as watermark, Alba wants to insert a picture as a worksheet background. For this, she clicks the worksheet she wants to display with a background, then selects an option X from the Page Layout tab in the Page Setup group. Alba then selects the picture for use as background, and then clicks Insert. What can X in her series of selections be?

background

Sven wants to create a custom theme font set for the heading and body of a presentation. Under tab X, he selects Fonts, and then selects Create New Theme Fonts. Then he selects a heading font, a body font, types in a name for his theme font set and clicks Save. Which of the following can tab X be in the above mentioned procedure?

design

Musa wants to choose a standard color theme for an Excel worksheet he is working on. He clicks on the Page Layout tab and then clicks Colors. What should he do next to complete the procedure?

pick the color set he wants

To change the name of a worksheet, you rename the _____.

sheet tab

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