Font size
Worksheets4th QUARTER EXAM in T.L.E 9 - ICT
Total questions: 40
Worksheet time: 20mins
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.
When you freeze panes, which of the following is NOT true?
You can navigate in all panes.
One of the two panes is locked in place.
One of the two panes is locked in place.
You can navigate in only one of the panes.
Sheet tabs on the bottom of a workbook can be formatted with which of the following?
Color Coded
Reordered
Renamed
All of the above.
Which of the following is NOT true about hidden worksheets?
You can't hide all worksheets in a workbook.
You can hide a worksheet by choosing the appropriate option from the worksheet tab's shortcut menu.
You can print hidden worksheets.
Hidden worksheets are not deleted from the workbook.
Which of the following is a valid method for changing a worksheet name?
Click the sheet tab, choose Rename from the menu, type a name, and press Enter.
Double-click the sheet tab, choose Rename from the menu, type a name, and press Enter.
Single-click the sheet tab, type a name, and press Enter.
Double-click the sheet tab, type a name, and press Enter.
If you had a very long list, and wished to see two sections at the same time, with independent scroll bars for each, which feature would you use?
Zoom
Arrange All
Freeze Panes
Split Window
You are trying to write macros, but do not see the developer tab. How do you get the tab back to access the tools?
Reinstall Excel
Your version did not come with that tab, use the customize ribbon commands to bring the individual commands to the ribbon that you need.
Use the customize ribbon tab, and place a checkmark next to Developer.
Customize the Quick Access toolbar to find the commands you need.
What is a Microsoft Office module that, when installed, adds custom commands and new features to Microsoft Office 2013?
An Add-in
An Advanced Formula
A Quick Access Toolbar
None of the above
Which of the following is a technique for accessing the Excel Options dialog box?
File, Options
File, Customize
File, Backstage
File, Change Interface
The address that is obtained by the combination of the Row number and the Column alphabet is called ________.
Worksheet
Cell
Workbox
Cell Address
Excel workbook is a collection of _____________ and ______________.
Worksheet and charts
Graphs and image
Sheets and images
Video and audio
What type of chart is useful for comparing values over categories?
Bar Graph
Column Chart
Pie Chart
Line Graph
There is an option to add comments in an Excel worksheet, what are the cells called in which comments can be added?
Cell Tip
Comment Tip
Smart Tip
Point Tip
Which keyboard key is used for Help in MS Excel?
Ctrl+H
F2
F1
Shift+H
If you wish to find formatting in a worksheet and clear it, how is this best done?
Under Review tab, choose Go to Formatted Cells.
Print the worksheet as reference at 25% and look for locations, use EditClear
Use Find and Customize the Quick Access toolbar to find the commands you need, and choose the format under find what, and leave the replace with blank.
None of the above.
What Excel feature allows you to replace text, values and even formulas?
Search and Replace
Delete and Replace
Find and Replace
None of the above
If the text that you enter into a cell is longer than the width of the cell, what happens?
Excel will throw an error.
Nothing
It will appear to go into the next cell if that adjacent cell is empty.
The text is deleted.
What are cell styles and table styles?
Predefined combinations of formats that you can apply only to formulas.
Predefined combinations of formats that you must create yourself.
Quick ways to enter data.
Predefined combinations of formats that you can apply in a single step.
A ___________ is a block of text or graphical data that is displayed at the top of a printed page.
Header
Page Layout
Print Area
Footer
If you had a very long list, and wished to see two sections at the same time, with independent scroll bars for each, which feature would you use?
Zoom
Arrange All
Freeze Panes
Split Window
Sheet tabs on the bottom of a workbook can be formatted with which of the following?
Reordered
Renamed
Color Coded
All of the above.
A workbook consists of rows and columns that intersect to form cells that contain various kinds of data, and a worksheet consists of multiple workbooks.
TRUE
FALSE
When a cell address is interpreted in relation to the location of the formula, this is called a relative reference.
TRUE
FALSE
Using the AutoCorrect feature enables you to fill cells with a series of data.
TRUE
FALSE
The Mini toolbar that hovers over selected text can be minimized.
TRUE
FALSE
If you wish to have a Sheet Background Graphic, it will not print when you print the standard worksheet.
TRUE
FALSE
Excel enables you to apply a picture to act as a background for an entire worksheet. The background is for display purposes and does not print when you print the worksheet.
TRUE
FALSE
When you split a window, you can navigate in each pane.
TRUE
FALSE
The AutoRecover feature automatically saves your work, including the state of your workspace if possible, at a time interval that you can specify in the Save category of the Excel Options dialog box.
TRUE
FALSE
The AutoRecover feature automatically saves your work, including the state of your workspace if possible, at a time interval.
No.39 sa EXAM kay BUNOS
No.39 sa EXAM kay BUNOS
A Ribbon is a collection of tools arranged on a tab.
TRUE
FALSE
