Technology Microsoft Part 1
Which of the following format can you decide to apply or not in AutoFormat dialog box? A. Number format B. Border Format C. Font Format D. All of the above
D. All of the above - Number Format, Border Format and Font Format
When working in the page break preview, you can A. view exactly where each page break occurs B. Add or remove page breaks C. Change the print area D.All the above
D. All the above
The spelling tool is placed on ____________________ toolbar A. Standard B. Formatting C. Drawing D. Reviewing
A. Standard
_______________ is an option in Font Group A. Srtikethrough B. Find C. Replace D. Change Styles
A. Strikethrough
To drag a selected range of data to another worksheet in the same workbook use A. Tab key B. Alt Key C. Shift Key D. Ctrl Key
D. Ctrl Key
To drag a selected range of data to another worksheet in the same workbook, use the A. Tab Key B. Alt Key C. Shift Key D. Ctrl Key
D. Ctrl Key
To drag a selected range of data to another worksheet in the same workbook, use the A. Tab key B. Alt Key C. Shift Key D. Ctrl Key
D. Ctrl Key
Formatting a cell in Number format you can't set A. Decimal Places B. Use 1000 separator C. Negative Numbers D. Currency Symbol
D. Currency Symbol
You can open the consolidate dialog box by choosing Consolidate from the _______________________ menu A. Insert B. Format C. Tools D. Data
D. Data
Each Excel file is a workbook that contains different sheets. Which of the following can bot be a sheet in a workbook? A. Work sheet B. Chart Sheet C. Module Sheet D. Data Sheet
D. Data Sheet
To activate the previous cell in a pre-selected range, press A. The Alt Key B. The Tab Key C. The Enter Key D. None of the above
D. None of the above
When a range is selected, how can you activate the previous cell? A. Press the Alt Key B. Press Tab C. Press Enter D. None of the above
D. None of the above
Which of the following Excel screen components can NOT be turned on or off? A. Formula Bar B. Status Bar C. Tool Bar D. None of the above
D. None of the above
You can add an image to a template by clicking the Insert Picture From File button on the _______________ Toolbar A. Standard B. Formatting C. Drawing D. Picture
D. Picture
Which of the following options is NOT available in Paste Special dialog box? A. Add B. Subtract C. Divide D. Sort
D. Sort
To create a formula, you can use A. Values but not cell references B. Cell references, but not values C. Values or cell references although not both at the same time D. Value and cell references
D. Value and cell references
You can set Page Border in Excel from A. From Border tab in Format Cells dialog box B. From Border tool in Formatting toolbar C. From Line Style tool in Drawing toolbar D. You can not set page border in Excel
D. You can not set page border in Excel
An excel workbook is a collection of A. workbooks B. worksheets C. charts D. worksheets and charts
D. worksheets and charts
You can open the Sort dialog box by choosing Sort from the _____________ menu A. View B. Format C. Tools D. Data
Data
In Word, the mailing list is known as the ________________________ Data sheet Source Data Source Sheet
Data source
What button do you click to add up a series of numbers? A. The AutoSum button B. The Formula button C. The Quicktotal button D. The Total button
A. The AutoSum button
What is entered by the function =today() A. The date value for the day according to system clock B. The time value according to system clock C. Today's date as Text format D. All of the above
A. The date value for the day according to system clock
_______________________ is used to convert from upper case to lower case and vice versa A. Toggle case B. Sentence case C. Lower case D. Upper case
A. Toggle case
To edit in an embedded excel worksheet object in a word document A. Use the excel menu bar and toolbars inside the word application B. Edit the hyperlink C. Edit the data in an excel source application D. Use the word menu bar and toolbars
A. Use the excel menu bar and toolbars inside the word application
Excel files have a default extension of A. Xls B. Xlw C. Wk1 D. 123
A. Xls
When you print preview a worksheet A. The entire worksheet is displayed B. The selected range is displayed C. The active portion of the worksheet is displayed D. A, B & C
All of the above
Which of the following is not available on the Ruler of the MS Word screen? Tab stop box Left indent Right indent Center indent All of them are available
All of them are are available on the Ruler - Tab stop box, Left indent, Right Indent and Center Indent
Question 1 From which menu can you insert Header and Footer A. Insert Menu B. View Menu C. Format Menu D. Tools Menu
Answer 1 A. Insert Menu
Question 2 To get the "Symbol" dialog box, click on the __________ menu and choose "Symbol" A. Insert B. Format C. Tools D. Table
Answer 2 A. Insert
They keystrokes Ctrl + I is used to A. Increase font size B. Inserts a line break C. Indicates the text should be bold D. Applies italic format to selected text
Apply italic format to selected text
Which of the following is the second step in creating a macro? Start recording Using your mouse or keyboard to perform the task you want to automate Assign a keyboard shortcut to the macro Give the macro a name
Assign a keyboard shortcut to the macro
Which option is not available in Insert Table Autofit behavior? Fixed Column width AutoFit to Contents AutoFit to Window Autofit to Column
Autofit to Column
Which of the following is an absolute cell reference? A. !A!1 B. $A$1 C. #a#1 D. A1
B. $A$1
Which function will you use to enter current time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime()
B. =now()
______________ option from the clipboard is used to move data from one place to another in a document A. Copy & Paste B. Cut & Paste C. Bold D. Justify
B. Cut & paste
The auto calculate feature A. Can only add values in a range if cells B. Provides a quick way to view the result of an arithmetic operation on a range of cells C. Automatically creates formula sand adds them to a worksheet D. A and C
B. Provides a quick way to view the result of an arithmetic operation on a range of cells
In a worksheet you can select A. The entire worksheet B. Rows C. Columns D. All of the above
B. Rows
Shortcut for document views toolbar is situated in __________________ bar A. Task bar B. Status bar C. Tool bar D. Title bar
B. Status Bar
A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets
C. A group of cells
You can check the conditions against _____________________ when applying conditional formatting A. Cell value B. Formula C. Both of above D. None of the above
C. Both of above - Cell value & Formula
Formatting a cell in Currency, you can specify A. Decimal Places B. Currency Symbol C. Both of the above D. None of the above
C. Both of the above (Decimal Places & Currency Symbol)
How can you remove borders applied in cells? A. Choose None on Border Tab of Format Cells B. Open the list on the Border tool in Formatting toolbar then choose first tool (no border) C. Both of the above D. None of the above
C. Both of the above - Choose None on Border Tab of Format Cells and Open the list on the Border tool in Formatting toolbar then choose first tool (no border)
Cut, copy and Paste is in _______________________ Group in the Home tab A. Font B. Page setup C. Clipboard D. Editing
C. Clipboard
Excel uniquely identifies cells within a worksheet with a cell name A. Cell names B. Column numbers and row letters C. Column letters and row numbers D. Cell locator coordinates
C. Column letters and row numbers
Status indicators are located on the A. Vertical scroll bar B. Horizontal scroll bar C. Formaula bar D. Standard toolbar
C. Formaula bar
Which area in an excel window allows entering values and formulas? A. Title Bar B. Menu Bar C. Formula Bar D. Standard Toolbar
C. Formula Bar
Which of the cell pointers indicates that you can fill a series? A. Doctor's symbol (Big Plus) B. Small thin plus icon C. Mouse pointer with anchor at the tip D. None of the above
C. Mouse pointer with anchor at the tip
How is data organized in a spreadsheet? A. Lines and spaces B. Layers and planes C. Rows and columns D. Height and width
C. Rows and columns
Macros are "run" or executed from the _________________ menu A. Insert B. Format C. Tools D. Data
C. Tools
Comments put in cells are called Smart Tip Cell Tip Web Tip Soft Tip
Cell Tip
Borders can be applied to Cells Paragraphs Text All of the above
Cells, Paragraph, Text (All the above)
Which of the following is not a type of page margin? Left Right Center Top
Center
Which of the following is NOT a valid data type in Excel? Number Character Label Date/Time
Character
To AutoFit the width of a column Double click the right border of a column Double click the left border of a column Double click the column header All of the above
Double click the right border of column
A feature of MS Word that saves the document automatically after certain interval is available on A. Save tab on Options dialog box B. Save As dialog box C. Both of the above D. None of the above
Save tab on Options dialog box
Which of the following buttons will allow you to add, delete or change records in your data source? "Data Source" button "Edit" button "Edit Data Source" button "Data Editing" button
"Edit Data Source" button
Which is the default left margin in Word 2003 document? 1" 1.25" 1.5" 2"
1.25"
Which of the following is NOT a valid Zoom percentage in Excel? 10 100 300 500
500
What is the smallest and largest font size available in he Font Size tool on the formatting toolbar? A. 8 & 72 B. 8 & 64 C. 12 & 72 D. None of the above
A. 8 & 72
Which symbol must all formula begin with? A. = B. + C. ( D. @
A. =
Which of the following formulas will Excel NOT be able to calculate? A. =SUM(Sales)-A3 B. =SUM(A1:A5)*.5 C. =SUM(A1:A5)/(10-10) D> =SUM(A1:A5)-10
A. =SUM(Sales)-A3
Pressing F8 key for three times selects A. A word B. A sentence C. A Paragraph D. Entire Document
A. A sentence
What is the shortcut key you can press to create a copyright symbol? A. Alt + Ctrl + C B. Alt + C C. Ctrl + C D. Ctrl + Shift + C
A. Alt + Ctrl + C
Which of the following is graphics solution for Word Processors? A. Clipart B. WordArt C. Drop Cap D. All of the above
A. Clipart
Merge cells option can be applied form? A. Format Cells dialog box Alignment Tab B. Formatting Toolbar C. Both of the above D. None of the above
A. Format Cells dialog box Alignment Tab
Bullets and Numbering is in ____________________ tab A. Home tab B. Insert tab C. Page layout tab D. View tab
A. Home Tab
Except for the _______________ function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result A. IF B. AND C. OR D. NOT
A. IF
To open an existing document, click on the ___________________ and then select Open A. MS Office button B. Quick Access Toolbar C. Document Views D. Ribbon
A. MS Office button
A function inside another function is called a __________________ function A. Nested B. Round C. Sum D. Text
A. Nested
Which function calculates your monthly mortgage payment? A. PMT (payments) B. NPER (number of periods) C. PV (present value) D. All of the above
A. PMT (payments)
It is possible to _________________ a data source before performing a merge Create Modify Sort All of the above
Create, Modify and Sort (all the above)
What is the shortcut key to open the Open dialog box? A. F12 B. Shift F12 C. Alt + F12 D. Ctrl + F12
Ctrl + F12
Which of the following formulas is NOT entered correctly? A. =10+50 B. =B7*B1 C. =B7+B14 D. 10+50
D. 10+50
Which of the following is not a valid Zoom percentage in Excel? A. 10 B. 100 C. 300 D. 500
D. 500
Gridlines A. May be turned off for display but turned on for printing B. May be turned on or off for printing C. Must be turned off for display printing D. A, B and C
D. A, B and C
Hyperlinks cannot be - A. Special shapes like stars and banners B. Drawing objects like rectangles and ovals C. Pictures D. All can be hylerlinks
D. All can be hyperlinks
Hyperlinks can be A. Text B. Drawing Objects C. Pictures D. All of the above
D. All of the above
When the formula bar is activated, you an see A. The Edit Formula button B. The Cancel button C. The Enter button D. All of the above
D. All of the above
When the formula bar is active, you can see A. The edit formula button B. The cancel button C. The enter button D. All of the above
D. All of the above
If you need to change the typeface of a document, which menu will you choose? Edit View Format Tools
Format
You cannot close MS Word application by A. Choosing File menu then Exit submenu B. Press Alt + F4 C. Click X button on title bar D. From File menu choose Close submenu
From File menu choose Close submenu
Thesaurus tool in MS Word is used for A. Spelling suggestions B. Grammar options C. Synonyms and Antonym word D. All of the above
Grammar options
The F12 key opens a A. Save as dialog box B. Open dialog box C. Save dialog box D. Close dialog box
Save As dialog box
Comments can be added to cells using Edit - Comments Insert - Comments File - Comments View - Comments
Insert - Comment
What happens when you click on Insert - Picture - Clip Art? It inserts a clipart picture into a document It lets you choose clipart to insert into a document It opens ClipArt taskbar None of the above
It opens the Clip Art taskbar
AutoCorrect was originally designed to replace _____________ words as you type Short, repetitive Grammatically incorrect Misspelled None of the above
Misspelled
Which of the following is not a valid version of MS Office? A. Office XP B. Office Vista C. Office 2007 D. None of the above
Office Vista
Portrait and Landscape are Page Orientations Paper Size Page Layout All of the above
Page Orientation
Where can you change the vertical alignment? Formatting toolbar Paragraph dialog box Page Setup dialog box Standard toolbar
Page Setup dialog box
You an activate a cell by Pressing the tab key Clicking the cell Pressing an arrow key All of the above
Pressing the Tab Key, Clicking the cell and Pressing an arrow key (all the above)
Background color or effects applied on a document is not visible in Web layout view Print Layout view Reading view Print preview
Print Preview
When you use the fill effects in the format data series dialog box, you can NOT Rotate text on the chart Select a fore ground color Select a pattern Select a background color
Rotate text in the chart
Which is a portion of a document in which you set certain page formatting options? Page Document Section Page Setup
Section
To insert three columns between columns D and E you would Select column D Select column E Select columns E, F & G Select columns D, E & F
Select column E
Which of the following is not one of the three "Mail Merge Helper" steps? Merge the two files Create the main document Set the mailing list parameters Create the data source
Set the mailing list parameters
The spelling tool is placed on _______________ toolbar Standard Formatting Drawing Reviewing
Standard
A character that is raised and smaller above the baseline is known as A. Outlined B. Raised C. Superscript D. Subscript
Superscript
Which of the following is not a font style? Bold Italics Regular Superscript
Superscript
Why Drop Caps are used in document? A. To drop all the capital letters B. To automatically begin each paragraph with a capital letter C. To begin a paragraph with a large dropped initial capital letter D. None of the above
To begin a paragraph with a large dropped initial capital letter
A bookmark is an item or location in document that you identify as a name for future reference. Which of the following tasks is accomplished by using bookmarks? A. To add anchors in a web page B. To mark the ending of a paragraph of document C. To quickly jump to a specific location in a document D. To add hyperlinks in a webpage
To quickly jump to a specific location in a document
If you want to keep track of different editions of a document, which features will you use? Editions Versions Track change All of the above
Versions
Which menu option can be used to split windows into two? Format - Window View - Window -Split Window - Split View - Split
Window - Split
Which file starts MS Word? Winword.exe Word.exe Msword.exe Word2003.exe
Winword.exe
Which of the following is a FLASE statement? A. You can set different header footer for even and odd pages B. You can set different page number formats for different sections C. You can set different header footer for first page of a section D. You can set different header and footer for last page of a section
You can set different header and footer for last page of a section