Technology Microsoft Part 1

Ace your homework & exams now with Quizwiz!

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


Related study sets

Physical Geography 111 Final Exam

View Set

RN Pharmacology Online Practice 2019 A

View Set

Cystic Fibrosis, Pneumothorax. and Chest tubes

View Set

Chapter 2 Cisco version 6 Static Routing

View Set