EXCEL MOD 1 (CHAPTERS 1-4)
Which of the following lets you fill a cell with only specific elements of a copied cell?
Auto Fill Options button
To copy a cell's formatting to another cell, which of the following can you use?
Format Painter
Which of the following lets you edit the contents of a cell?
Double-click the cell or click in the formula bar.
Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style).
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
Jack wants to insert a Win/Loss sparkline in Excel. To do this, he can click on the cell he wants to insert a Sparkline in, then click Apps tab, select Win/Loss Sparkline from the Sparklines group and then click OK.
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
Penina wants to insert markers into a sparkline chart. To do so, she can click on the following: Sparkline chart > Design > Line > Markers check box.
False
Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12
False
The Comma Style format adds a comma and a dollar sign to a cell value.
False
To insert a Sunburst chart for a data set, we can click on the following series: Range of cells > Data tab > Charts group > Insert Hierarchy Chart > Sunburst.
False
To insert the current date only in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.
False
To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.
False
To preserve an exact cell address in a copied formula, you can use a relative cell reference.
False
To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval, the formula: =MROUND(A4,0:30) can be used.
False
When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.
False
When you enter a value in a worksheet cell, it is automatically left-aligned.
False
When you select a cell range, the cells must be adjacent to each other.
False
You can use the I-beam pointer to copy cell contents into adjacent cells.
False
Which of the following tabs lets you set worksheet print options?
File
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?
Fill & Line
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 change the color of cell content, you use the ________ color list arrow.
Font
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Home
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?
If it needs an absolute 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
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C
hide
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MIN function
To combine multiple cells into one combined cell, which of the following do you use?
Merge and Center button
To print your worksheet at its actual size, which of the following would you select?
No scaling
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
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
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)
Ian needs to extract the day from the date 5/31/2017 entered in cell A1. Which formula can he use to do this?
=DAY(A1)
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)
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(...)
Which of the following is true about adding cell borders?
A cell border extends the width of the cell.
Which of the following functions would you use to calculate the arithmetic mean of a price list?
AVERAGE
What feature inserts a function that totals the cells above or to the left of the selected cell?
AutoSum button
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.
When you cut or copy a cell, it is cut or copied to which of the following?
Both the Windows and Office Clipboard
To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.
CTRL
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 help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
Color
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?
Column
If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.
Data Bars
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
In a complex formula, how does Excel determine which calculation to perform first?
It follows the order of operations.
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
Layout
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?
Layout
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?
Open the workbook, make changes, and then save it using a different name.
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
Page Break Preview
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
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?
Remove
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?
Select the column to the right of the page break you want to delete.
To enter your name in the lower right corner of a worksheet page, you can _____.
Select the right footer text box and type your name.
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
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
The Paste Options button then lets you paste specific elements of the copied cells.
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
The formula =SUM(B6:B10)
A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.
True
A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.
True
Arrow keys can be used to move any chart element.
True
Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart
True
Changing a worksheet window to Normal view changes the contents of the worksheet.
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
Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, 2/2/2000 will appear in AI5.
True
Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5. Now she wants to add 30 workdays to the start date. She can do this using the following formula: = WORKDAY (E2, 30, F2:F5).
True
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.
True
Rohan wants to create a column containing dates and want to display days beside each date in the next column. He can use the formula '=CHOOSE(WEEKDAY(B5),"Mon", "Tue", "Wed", "Thur", "Fri", "Sat")'.
True
The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.
True
To edit placeholder text in a chart element, select the cell whose placeholder text you want to edit, on Ribbon, click Data > Data Validation > Data Validation > Input Message tab and edit the text in the box.
True
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.
True
To insert a trendline that forecasts future trends into a chart, we need to follow this series: Chart > Data series > Chart > Add Trendline > Options tab > Forecast section > Up arrow in the Forecast box.
True
To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.
True
To move a chart to a different worksheet, click on the Chart > Chart Tools > Design tab > Location group > Move Chart > New sheet, and then in the New sheet box, type a name for the worksheet.
True
To open a workbook after you start Excel, you can use the Open Other Workbooks command on the Navigation bar.
True
To paste only a copied cell's formats, use the Paste Special command.
True
To print a worksheet, you begin by going to Backstage view.
True
To save a workbook for the first time, you use the Save As dialog box.
True
When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.
True
You can apply date formats to cells by using the Date category in the Format Cells dialog box.
True
You can edit cell contents in the Formula bar or in the cell itself.
True
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop
True
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?
Type the number that you want in the text box.
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
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
Igor wants to set margins for a worksheet he has created per his choice. Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top, Header, Left, Right, Bottom and Footer text boxes > OK?
X- Margins, Y- Custom Margins
To select a single worksheet cell so you can work with it, which of the following would you do?
click the cell
To format a range so that all values greater than $500 appear in red, which of the following can you use?
conditional formatting
When you underline cell content, you are using _____.
font style
Which of the following is a built-in formula that helps you perform complex calculations?
function
Which of the following helps you move around a worksheet that is too large to fit on the screen at once?
scroll bars
To change the name of a worksheet, you rename the _____.
sheet tab
Which of the following is not a way to move cell contents?
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.
two