Can somebody help me with rthis quiz?

1.


Excel automatically right-aligns text when displaying it in a cell.





TF 2.


A range of cells can be indicated in a formula by separating the first and last cell with a semicolon.





TF 3.


To correct a typing error while entering data into a cell, press the Delete key.





TF 4.


If you click the Active sheet(s) option button in the Print dialog box, all the entire workbook will be printed.





TF 5.


For adjacent ranges, the range reference identifies the cells in the upper-left and lower-right corners of the rectangle with the individual cell references separated by a comma.





TF 6.


You can right-click the dividing line of the column to change the width of the column.





TF 7.


A function is a predefined formula for a commonly used calculation.





TF 8.


In the function SUM(D4:D8), the argument is D4:D8.





TF 9.


If you omit an optional argument, Excel will not include it in the function.





TF 10.


When you create a series of dates, the series of dates that Excel fills in depends on the dates you start with.





TF 11.


When you create a series of dates, if you start with dates separated by a single month, Excel will fill in a series of months.





TF 12.


The ANNUAL(date) function extracts the year number from the date value.





TF 13.


Formatting changes both the appearance of a worksheet and the data stored in its cells.





TF 14.


If your text extends beyond the width of a cell, you must widen the cell in order to view the text in its entirety.





TF 15.


You can rotate cell contents, displaying the cell entry at almost any angle.





TF 16.


The gridlines that appear in the worksheet window are displayed on the printed page by default.





TF 17.


You can apply a background image to all of the sheets in a workbook at the same time.





TF 18.


The background color of worksheet tabs is visible at all times.





TF 19.


Each chart type has its own collection of sub-types that provide various alternate formats for the selected chart type.





TF 20.


A data marker is a graphic representing a data point in a chart.





TF 21.


Category values are usually displayed on the Y-axis.





TF 22.


A chart placed on a separate sheet from its originating worksheet is called an embedded chart.





TF 23.


When creating an Excel chart, first activate the Chart Wizard, and then select the cells containing the data that the chart will display.





TF 24.


The Chart Wizard presents every available option concerning your chart’s appearance.











Multiple Choice





Identify the letter of the choice that best completes the statement or answers the question.





ABCD 25.


To select a large range of cells, click the first cell in the range, press and hold down the ____ key, and then click the last cell in the range.


a. Esc


b. Ctrl


c. Shift


d. F3











ABCD 26.


Copying a range of cells is similar to moving a range, except that you must press the ____ key while you drag the selection to its new location.


a. Shift


b. F3


c. Esc


d. Ctrl











ABCD 27.


To insert multiple rows or columns, select multiple cells before applying the ____ command.


a. Add


b. New


c. Insert


d. Rows and Columns











ABCD 28.


The ____ key moves the insertion point backward through a cell’s content in edit mode.


a. F2


b. Home


c. Left arrow


d. Alt











ABCD 29.


What is the value of the expression =3+4*5?


a. 60


b. 35


c. 23


d. -5











ABCD 30.


In ____ orientation, a page is wider than it is tall.


a. natural


b. landscape


c. portrait


d. basic











ABCD 31.


A source cell is sometimes called a source ____.


a. format


b. target


c. destination


d. range











ABCD 32.


Which of the following are categories of Excel functions?


a. Financial


b. Algebraic


c. Relational


d. All of the above











ABCD 33.


The expression ____ returns the maximum value in the range A1:A100 and then divides the value by 100.


a. MAX(A1:A100)/100


b. =MAX(A1:A100)/100


c. MAXIMUM(A1:A100)/100


d. =MAX(100)/(A1:A100)











ABCD 34.


Click the Insert Function button on the ____ to open the Insert Function dialog box.


a. toolbar


b. Formula bar


c. menu bar


d. Standard toolbar











ABCD 35.


In the Insert Function dialog box, if you enter a text description in the Search for a function text box and click the ____ button, Excel will search for functions that match your description.


a. Search


b. Find


c. Look for


d. Go











ABCD 36.


Excel stores dates as ____.


a. text


b. logicals


c. decimals


d. integers











ABCD 37.


The ____ tab in the Format Cells dialog box is used to create borders around selected cells.


a. Patterns


b. Border


c. Cells


d. Tables











ABCD 38.


If you want an interactive way of drawing borders on your worksheet, you can use the ____ button on the Borders palette.


a. Create Borders


b. Borders


c. Draw Border


d. New Borders











ABCD 39.


The ____ button on the Borders toolbar specifies the style of a border line.


a. Border Style


b. Line Style


c. Lines


d. Line Format











ABCD 40.


The ____ button on the Borders toolbar specifies a border's color.


a. Line Hue


b. Line Format


c. Line Color


d. Line Style











ABCD 41.


To change the background color in a worksheet, you can use the ____ button on the Formatting toolbar.


a. Fill Color


b. Background


c. Pattern


d. Any of the above











ABCD 42.


Excel automatically ____ text when you enter it into a cell.


a. centers


b. justifies


c. right-aligns


d. left-aligns











ABCD 43.


____ fonts do not include small lines stemming from and at an angle to the upper and lower ends of characters.


a. Textured


b. Kerned


c. Leading


d. Sans serif











ABCD 44.


An object in an Excel chart that is used to identify which data markers represent each data series is called a ____.


a. slice


b. bar


c. column


d. legend











ABCD 45.


Examples of text that Excel classifies as unattached text include ____.


a. the chart title, the X-axis title, and the Y-axis title


b. formulas and functions


c. tick marks labels, the category names, and the legend


d. any additional text included in the chart


























Figure 4-10





ABCD 46.


The item labeled 4 in Figure 4-10 is a(n) ____.


a. chart title


b. gridline


c. legend


d. data marker











ABCD 47.


The item labeled 2 in Figure 4-10 is a(n) ____.


a. legend


b. tick mark


c. chart title


d. axis map











ABCD 48.


You can change the rotation of a 3-D pie chart in the ____ dialog box.


a. Orientation


b. Perspective


c. View


d. 3-D View











ABCD 49.


Pie slices used in pie charts and the points used in XY charts are examples of ____.


a. gridlines


b. tick marks


c. legends


d. data markers











ABCD 50.


A data ____ is a group of related data points.


a. cluster


b. aggregate


c. series


d. roster

Can somebody help me with rthis quiz?
you obviously are pretty wise because i never ever seen a question be that long and take up that much space ...take that wisdom and do the best you can at this quiz...you can do it ...get the A+ !! best of luck !!!
Reply:do ur own home work u slacker
Reply:Dude, thats a lost cause.
Reply:youre really gonna have to make this shorter for ANYONE to actually help
Reply:So lazy, why don't you just google the answers?
Reply:LMAO, yeah I'll do your homework for $20
Reply:Study and you'll find the answers.

birthday flowers