Intro to Excel and Data Visualization
How many actions does the Undo button let you reverse?
100
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)
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)
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.
Quiz2
Excel Module 2
Changing a worksheet window to Normal view changes the contents of the worksheet.
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
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
In a complex formula, how does Excel determine which calculation to perform first?
It follows the order of operations.???
The Clipboard task pane shows the contents of the _____.
Office Clipboard
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
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
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.
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
Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.
True?
Currency is an example of a number format.
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
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
Two
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
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
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
