4th QUARTER EXAM in T.L.E 9 - ICT

If you need to convert a basic worksheet to a PDF on the desktop of your computer, which of the following sequences are in the correct order to accomplish this? Choose one.

• Formats, Save As, PDF, Convert

• Data, Convert to PDF, Browse, Desktop, Save

• File, Save As, Computer, Browse, Desktop, Save File as Type: PDF

• File, Convert to PDF

How do you designate a mixed reference?

• Place a dollar sign in front of both the column letter and the row number.

• Place a dollar sign in front of only the column letter or only the row number.

• Place an equal sign in front of both the column letter and the row number.

• Place an equal sign in front of only the column letter or only the row number.

If you have a very complicated cell that has formatting, contents, and comments, and you only want to clear the comments, what is the best way to get rid of the formatting and comments?

• Copy the contents of the cell to another location, delete the cell, and copy just the text back.

• Use the Clear options under the editing group.

• Simply type the contents over in the cell to replace what is there.

• Use the format menus to clear the formatting and comments.

If the text that you enter into a cell is longer than the width of the cell and the adjacent cell is not empty, what happens?

• The overflowing text will appear to go into the next cell.

• The overflowing text is truncated to fit the width of its cell.

• The overflowing text overwrites the contents of the adjacent cell.

• The overflowing text is deleted.

If you enter a value into a cell that is longer than the width of the cell, what happens?

• The value is converted to text.

• A row of # characters is displayed in the cell.

• The value is truncated to fit the width of its cell.

• A row of dashes appears.

When a worksheet contains data that runs across multiple pages, you can use what feature to repeat the row and column titles on each printed page?

• Print Titles

• Orientation

• Find and Replace

• Scaling

Which of the following is a way that you can make a worksheet with several columns print on one page?

• On the Find and Replace screen, you can select Landscape Orientation.

• On the Print screen, you can select Landscape Orientation.

• On the Print screen, you can select Vertical Orientation.

• All of the above.

You want your worksheet with several columns to print on one page, so you select Landscape Orientation. If landscape orientation is not enough to allow all columns to print on one page, you can use what feature?

• Scalling

• Orientation

• Tinting

• Find and Replace

What are the spaces between the edges of a page (worksheet) and its content?

• Margins

• Headers

• Orientations

• Gutters

In order to print a portion of a worksheet as the only printable version every time you print, which of the following options do you use?

• Highlight the area, choose File-Print Selection.

• File, Print, Selection, and click browse to highlight.

• Highlight the area, go to Page Layout Options, choose Set Print Area.

• Highlight the area, choose File-Preview. Click Selection only. Choose Print.