jwarrior05
New Member
- Joined
- Jul 9, 2006
- Messages
- 3
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
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
