Help

Hello I am taking a class right now in college that has to do with microsoft office... I have an assignment that i have been working on but i cant seem to get more than a 70% on it... It strictly Excel questions.... I was wondering if anyone could help me with the questions.

1)In a multiple sheet file, to quickly change something on all sheets, it would be best to use Group mode.

True

False

2)Excel automatically updates the result of a formula when you change a value referenced in the formula.

True

False

3)If you hide rows or columns, they still print.

True

False

4)=FirstQtr!D2 is a valid formula (assume FirstQtr is a sheet name).

True

False

5)Which type of chart is best suited for showing a single data range?

Pie chart

Line chart

Bar chart

HLCO

6)When =B1+$B$7 is copied one cell to the right, it becomes =C1+$C$7.

True

False

7)Which of the following formats cannot be applied using the formatting toolbar?

currency

comma

percent

date
8)You can use the NOW function to display the current date.

True

False

9)Which symbol(s) are used to change the order of operations in a formula?

=

( )

[ ]

^

10)When first entered into a cell, text is right-aligned and numbers are left aligned.

True

False

11)The column headings in an Excel worksheet begin with A and end with IV.

True

False

12)You may copy a cell's format by using the Format Painter button located on the toolbar.

True

False

13)If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function
=IF(E5>4*F5,"Deductions","No deductions"),
then cell G5 displays the message, ____________.

Deductions

No deductions

#REF!

F5

14)Which of the following is a valid function?

=avg(b5:b15)

=sum(b5:b15)

both a and b

none of the above

15)To freeze worksheet titles use the ___________ command on the ___________ menu.

Split, Format

Split, Window

Freeze Panes, Window

Freeze Panes, Tools

16)When you insert a column in a worksheet, Excel ____________ at the location of the insertion point.

copies over the existing column

shifts the existing columns up

shifts the existing columns down

shifts the existing columns to the right

17)Use the Merge and Center button to center data in one column.

True

False

18)Spreadsheet rows are labeled with letters; columns are labeled with numbers.

True

False

19)When you apply formatting, it applies to the data in the cell, rather than the cell itself. Thus when you delete the cell contents, the formatting is also removed.

True

False

20)To select non adjacent sheets, press Shift while clicking on the sheet names.

True

False

21)Double-click a sheet name to rename it.

True

False

22)F61 is an absolute reference, and $F$61 is a relative reference.

True

False

23)You should sort a list on the subtotal field if you want to use Data, Subtotals.

True

False

24)A business executive who creates a spreadsheet to project quarterly losses and gains is as example of using the computer for "computer modeling".

True

False

25)Which chart element identifies the color asigned to the bars?

legend

data labels

chart title

X-axis labels

26)Pie charts are most often used to show trends or relationships over time.

True

False

27)Use the Format menu to change margins.

True

False

28)When you copy a formula with relative cell references down a row, ____________.

the row references change in the formula

the column references change in the formula

no references are changed in the formula

the cell reference of the formula remains the same

29)Which of the following is not true about conditional formatting?

A formatting change occurs when the value of formula in a cell meets a spcified criteria.

Conditional formatting can be based on more than one condition.

Conditional formatting can include borders.

Choosing Edit, Clear, Formats does not clear conditional formatting.

30)Which of the following is not a formula?

B2+C5

=B2+C4

=.5*B3

=A1+B1/C1