bus 1305 exam #1
To apply a cell style, you would use the Cell Styles command on the _____ tab.
home
To enter data in a cell using examples already in your workbook, you can use the flash fill feature.
true
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.
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?
Number
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
Which of the following is true when you copy and paste formulas using the fill handle?
The AutoFill Options button lets you fill cells with specific elements of the copied cell.
You can apply date formats to cells by using the Date category in the Format Cells dialog box.
True
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
When should you use relative cell references?
When you want to preserve the relationship to the formula location.
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 worksheet view shows headers, footers, and rulers?
page layout view
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
Which two of the following is true about deleting a worksheet? Select all the options that apply.
-You can right-click a sheet tab and click Delete. -You can use the Delete list arrow in the Cells group on the Home tab.
What is the correct formula to insert the date January 12, 1998 into a cell?
=DATE(1998,1,12)
When you double-click a cell's right column border, which of the following occurs?
AutoFit resizes the column to the widest cell entry.
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.
Which of the following lets you edit the contents of a cell?
Double-click the cell or click in the formula bar.
To format a range so that all values greater than $500 appear in red, which of the following can you use?
conditional formatting
Changing a worksheet window to Normal view changes the contents of the worksheet.
false
To insert a Scatter chart for a data set, we can click on the following series: Range of cells > Insert tab > Charts group > Insert Scatter (X,Y) or Bubble Charts > Scatter > Chart of choice > OK.
true
To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.
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 move a chart to another location on the sane worksheet, drag it to the location you want.
true
To print a worksheet, you begin by going to Backstage view.
true
To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.
true
To switch chart rows and columns, we can click anywhere in the chart containing the data series that we want to plot on different axes, click on the Design tab in Chart Tools, then in the Data group, and finally click Switch Row/Column.
true
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
true
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)
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?
=HOUR(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<59,"F",IF(B2<69,"D",IF(B2<79,"C",IF(B2<89,"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")
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.
Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click) Text box > Format Options > Text Options > X > Shadow?
Text Effects
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
In the formula =B6*$B$2, which of the following describes $B$2?
absolute cell reference
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?
analysis
Which of the following lets you fill a cell with only specific elements of a copied cell?
auto fill options button
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?
data callout
If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.
false
To add a worksheet to a workbook, you would use the New formula tab below the worksheet.
false
To format text so that it automatically appears in multiple lines within a cell, you can transpose it.
false
When you enter a value in a worksheet cell, it is automatically left-aligned.
false
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
Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click) Text box > Format Options > Text Options > X > Shadow?
text effects
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
To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.
transpose
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
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
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
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
Nadine wants to insert a sparkline in Excel using the Quick Analysis tool. She can do this by selecting the data for which she wants to add Sparklines, then in the empty column to the right side of the data click the Quick Analysis button, click Sparklines and select the type of Sparkline she wants.
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
Rainn wants to switch rows to column in his chart. To do so, he can click on the following series: chart with data series that he wants to plot on different axes > Chart Tools > Design tab > Data group > Switch Row/Column.
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
To fit all worksheet content on one page, you can set page scaling in Backstage view.
true
