Spreadsheet for Business Modeling Test Questions with Correct Answers 100% Pass
Which of the following formulas totals the cells B6. B7, B8, B9, and B10? - Answers The formula
=SUM(B6:B10)
To print a worksheet, you begin by going to backstage view - Answers True
When you copy cell contents, the data is removed from its original location and placed in the Clipboard?
- Answers False
Which of the following is true about deleting the worksheet? Select all the options that apply. - Answers
-You can right-click a sheet tab and click delete
-You can use the delete list arrow in the Cells group on the home tab
To change the color of cell content, you use the ______ color list arrow - Answers Font
Currency is an example of a number format - Answers True
Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range
of cells: (Select) Range of cells > home tab > styles group > conditional formatting > X > top 10 items >
change value and highlight option in dialog box if required > ok? - Answers Top/bottom rules
To paste a data range so that column data appears in rows and row data appears in column, you can
_____ the data the paste link arrow - Answers transpose
Alba wants to use a watermark image as a background of her worksheet. She goes to page setup group
on page layout tab. What option should she click to begin choosing the image file to use as watermark? -
Answers Background
How can you distinguish from a manually added page break and an automatic page break in a
worksheet? - Answers Automatic page break appears as dashed lines while manual page breaks appear
as solid lines
To rotate cell contents you use the alignment tab in the format cells dialog box - Answers True
To format a range so that all values greater than $500 appear in red, which of the following can you use?
- Answers conditional formatting
When you underline cell content you are using - Answers a font style
To apply formats to data when it meets criteria you specify, you use conditional formatting - Answers
True
Which of the following formulas totals the cells B6. B7, B8, B9, and B10? - Answers The formula
=SUM(B6:B10)
To print a worksheet, you begin by going to backstage view - Answers True
When you copy cell contents, the data is removed from its original location and placed in the Clipboard?
- Answers False
Which of the following is true about deleting the worksheet? Select all the options that apply. - Answers
-You can right-click a sheet tab and click delete
-You can use the delete list arrow in the Cells group on the home tab
To change the color of cell content, you use the ______ color list arrow - Answers Font
Currency is an example of a number format - Answers True
Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range
of cells: (Select) Range of cells > home tab > styles group > conditional formatting > X > top 10 items >
change value and highlight option in dialog box if required > ok? - Answers Top/bottom rules
To paste a data range so that column data appears in rows and row data appears in column, you can
_____ the data the paste link arrow - Answers transpose
Alba wants to use a watermark image as a background of her worksheet. She goes to page setup group
on page layout tab. What option should she click to begin choosing the image file to use as watermark? -
Answers Background
How can you distinguish from a manually added page break and an automatic page break in a
worksheet? - Answers Automatic page break appears as dashed lines while manual page breaks appear
as solid lines
To rotate cell contents you use the alignment tab in the format cells dialog box - Answers True
To format a range so that all values greater than $500 appear in red, which of the following can you use?
- Answers conditional formatting
When you underline cell content you are using - Answers a font style
To apply formats to data when it meets criteria you specify, you use conditional formatting - Answers
True
