computer concepts: final exam review
Questions and Correct Answers, 2024.
which tab and button are document properties located for editing?
file tab, info button
to align currency symbols and decimal points in a column of numbers, you can
apply the _____ number format.
accounting
to apply a cell style, you would use the cell styles command on the ____ tab
home
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
to return cell contents to its default font and style, you can use the ______
command
clear formats
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
your worksheet is too wide to fit on one portrait page, what is the best way to fix
this problem?
change the page orientation to landscape
a predesigned combination of formats, such as font size and color, is called a cell
default
true
the comma style format adds a comma and a dollar sign to a cell value
false
you can start excel using the start button on windows taskbar or a shortcut on
your desktop
true
you can use the DELETE key to clear cell contents
true
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)
amanda needs to manually calculate an open worksheet. Which of the following
options should she click on in the formulas tab in the calculation group?
calculate now
, sam wants to count the number of cells between B1 and B20 that contain
numbers in them. Which of the following formulas should he use to do so?
=COUNT(B1:B20)
to change a range's conditional formatting from data bars to icon sets, which of
the following can you do?
delete the conditional formatting
what feature inserts a function that totals the cells above or to the left of the
selected cell?
autosum button
when should you use relative cell references?
when you want to enter sequential values in a range of cells
which of the following inserts a function into a cell?
autosum button
which of the following statements is true about COUNT functions?
the COUNT function returns the number of calls in a range that contain numeric data.
to view a worksheet without headers, margins, and rulers, use page layout view
true
when you copy and paste a formula to a new location, the formula's relative
references do not change
true
to enter data in a cell using examples already in your workbook, you can use the
flash fill feature
true
when you run the spell checker in a workbook, excel automatically checks the
spelling in all worksheets at once
false
for which of the following would you use the paste list arrow on the ribbon when
pasting a copied cell?
to paste the value's number formatting only
to change the name of a worksheet, you rename the _______
sheet tab
which of the following is true when you delete a cell?
when you delete a cell using the delete list arrow, you can choose which way to move
adjacent cells.
to move cell contents one space to the right, you can use the increase space
button
false, indent
to see how copied contents will look with both values and number formatting,
you would use paste numbers
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
decreasing a cell's indent moves its contents to the right one space.
false
Questions and Correct Answers, 2024.
which tab and button are document properties located for editing?
file tab, info button
to align currency symbols and decimal points in a column of numbers, you can
apply the _____ number format.
accounting
to apply a cell style, you would use the cell styles command on the ____ tab
home
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
to return cell contents to its default font and style, you can use the ______
command
clear formats
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
your worksheet is too wide to fit on one portrait page, what is the best way to fix
this problem?
change the page orientation to landscape
a predesigned combination of formats, such as font size and color, is called a cell
default
true
the comma style format adds a comma and a dollar sign to a cell value
false
you can start excel using the start button on windows taskbar or a shortcut on
your desktop
true
you can use the DELETE key to clear cell contents
true
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)
amanda needs to manually calculate an open worksheet. Which of the following
options should she click on in the formulas tab in the calculation group?
calculate now
, sam wants to count the number of cells between B1 and B20 that contain
numbers in them. Which of the following formulas should he use to do so?
=COUNT(B1:B20)
to change a range's conditional formatting from data bars to icon sets, which of
the following can you do?
delete the conditional formatting
what feature inserts a function that totals the cells above or to the left of the
selected cell?
autosum button
when should you use relative cell references?
when you want to enter sequential values in a range of cells
which of the following inserts a function into a cell?
autosum button
which of the following statements is true about COUNT functions?
the COUNT function returns the number of calls in a range that contain numeric data.
to view a worksheet without headers, margins, and rulers, use page layout view
true
when you copy and paste a formula to a new location, the formula's relative
references do not change
true
to enter data in a cell using examples already in your workbook, you can use the
flash fill feature
true
when you run the spell checker in a workbook, excel automatically checks the
spelling in all worksheets at once
false
for which of the following would you use the paste list arrow on the ribbon when
pasting a copied cell?
to paste the value's number formatting only
to change the name of a worksheet, you rename the _______
sheet tab
which of the following is true when you delete a cell?
when you delete a cell using the delete list arrow, you can choose which way to move
adjacent cells.
to move cell contents one space to the right, you can use the increase space
button
false, indent
to see how copied contents will look with both values and number formatting,
you would use paste numbers
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
decreasing a cell's indent moves its contents to the right one space.
false
