EXCEL MOD 1 (CHAPTERS 1-4)

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

PRAXIS 5205 Practice Exam Questions

View Set

II.C. Asymmetric Information, Market Failure, and Health Care

View Set

Unit-4 Adaptive Quizzing - Glucose Regulation

View Set

Computer Science: Computing Principles, Php, SQL, Java, Javascript, Python, HTML

View Set

AP Comparative Government Unit 2: Great Britain

View Set

Unit 6: Diving into the Finance Instruments

View Set

Microbiology Homework Chapter 9A

View Set

Oceanography Study Guide Chapter 1

View Set