CSS Paper Geology 2007 MCQs

Geology is an earth science concerned with the solid Earth, the rocks of which it is composed, and the processes by which they change over time.

This novel, a monologue delivered to an American in Lahore, catapulted Hamid to international fame and was shortlisted for the Booker Prize.

Doris Lessing, born in Persia (Iran) and raised in Southern Rhodesia, became a British citizen and received the Nobel Prize in Literature in 2007.

The TEU and TFEU are the EU's core treaties; the Lisbon Treaty amended and consolidated them.

"Office Vista" does not exist; Office XP and Office 2007 are real versions.

Starting with Excel 2007, Microsoft introduced the Office Open XML file format. The default file extension for Excel workbooks became `.xlsx`. The older `.xls` format was used for versions prior to 2007. A cell is formed at the intersection of a row and column in a spreadsheet. * The actual working area in Microsoft Excel is: (A) Workbook (B) Worksheet (C) Spreadsheet (D) Note sheet In Excel, the actual working area is called a worksheet, where data is input and manipulated. * A cell at the third column and 15th row has a cell address: (A) A15 (B) B15 (C) C15 (D) D15 The third column corresponds to 'C', and the 15th row corresponds to 15, making the address C15. * A collection of related worksheets is called: (A) Spreadsheet (B) Cells (C) File (D) Workbook A workbook contains multiple related worksheets, which are individual pages within the file. * The currently selected cell where data can be entered or edited is called: (A) Idle cell (B) Active cell (C) Passive cell (D) Present cell The active cell is the one currently selected for data entry or editing. * In a worksheet, a bold rectangle border indicates: (A) Present cell (B) Active cell (C) Passive cell (D) Idle cell The active cell is indicated by a bold rectangle border, showing where data will be entered or edited. * A cell in a worksheet, which is not active, is called: (A) Active cell (B) Idle cell (C) Passive cell (D) Present cell A passive cell is not currently selected and is inactive, unlike the active cell where data entry occurs. * Which cell address is correct? (A) Z2 (B) AZ3 (C) 2Z (D) Both a and b Z2 and AZ3 are both valid cell addresses, while 2Z is not a correct cell reference. * In a spreadsheet, rows are labeled by: (A) Letters (B) Numbers (C) Cell references (D) None Rows are labeled numerically in Excel (e.g., Row 1, Row 2, etc.). * In a spreadsheet, columns are labeled by: (A) Letters (B) Numbers (C) Cell references (D) None Columns are labeled alphabetically (e.g., Column A, Column B, etc.). * A workbook is a group of: (A) Many rows (B) Many columns (C) Worksheets (D) None A workbook contains multiple worksheets, which are individual sheets within the file. Absolute references use dollar signs before both the column and row (e.g., $A$1) to prevent them from changing during copying or moving. * Formulas can only be applied on: (A) Values (B) Labels (C) Unmerged cells (D) None Formulas operate on values (numbers or cell references) and not on labels (text) or merged cells. * To add the value of cell 'C9' of worksheet "Sheet3" with the cell 'B2' of the current worksheet, the formula is written as: (A) =C9 + B2 (B) =Sheet3!C9+B2 (C) =Sheet3!B2+C9 (D) =Sheet3!B2+sheet3!C9 To reference cells from another worksheet, use the syntax SheetName!CellAddress. * A mathematical expression used to perform calculations on a worksheet is called: (A) Cell (B) Format (C) Formula (D) Address Bar A formula is a mathematical expression used in Excel to perform calculations. * The absolute reference of cell address A15 is written as: (A) $A15 (B)$ A15 $ (C) A $15 (D)$ A $ 15 An absolute reference uses dollar signs before both the column letter and row number (e.g., $A$15). * Which symbol is used before a formula? (A) & (B) = (C) # (D) $ A formula in Excel begins with the equal sign (=). * The range of cells from C2 to C100 is referenced as: (A) C2-100 (B) C2:C100 (C) C2 to C100 (D) C2 : 100 A cell range is referenced with a colon (:) between the starting and ending cell addresses (e.g., C2:C100). * Which represents a valid range in Excel? (A) C1:C3 (B) C1, C2, C3 (C) =C1+C2+C3 (D) C1 to C3 A valid cell range in Excel is represented by the start and end cell addresses separated by a colon (e.g., C1:C3). * Calling a cell with the reference of its address is called: (A) Absolute referencing (B) Reference address (C) Relative referencing (D) None Relative referencing adjusts the cell reference based on the position of the formula when copied. * Which symbol is used in absolute referencing? (A) & (B) = (C) # (D) $ Correct Answer: (D)$ The dollar sign ($) is used in absolute referencing to lock a row or column in place. * Which function is used to return the current system date? (A) Max (B) Min (C) Today (D) None The TODAY() function returns the current date. * Which function is used to get the current date? (A) Exact() (B) Today() (C) Month() (D) Year() The TODAY() function retrieves the current date.

There is no "Office Vista" version. Office XP, Office 2007, and Office Classic (suite) are valid.

Zoom is available on both the View tab and the status bar in Word 2007.

For many years, the standard file extension for a Microsoft Word document was `.doc`. In more recent versions of Word (since 2007), the default extension is `.docx`, which is based on an XML format. However, `.doc` remains widely recognized.

A macro is a recorded sequence of commands and actions that can be replayed to automate a repetitive task. In Microsoft Word, macros are created using Visual Basic for Applications (VBA), allowing users to significantly improve their workflow efficiency. Ctrl + I is the shortcut for italicizing selected text in MS Word. * Which shortcut key is used to check spelling? (A) F1 (B) F2 (C) F7 (D) F9 F7 is the shortcut to check spelling and grammar in MS Word. * What does Ctrl + B shortcut accomplish in MS-Word? (A) It converts selected text into the next larger size of the same font (B) It adds a line break to the document (C) It makes the selected text bold (D) It applies Italic formatting in the selected text Ctrl + B is the shortcut to make selected text bold in MS Word. * To get help using Word, click the help icon on the ribbon or press the F1 key. (A) True (B) False Pressing F1 or clicking the help icon opens Word's Help feature to assist with various tasks. * To use your keyboard instead of the mouse to select tools on the ribbon, you display the Key Tips by pressing the key. (A) Alt (B) Ctrl (C) Shift + Enter (D) Alt + Enter Pressing the Alt key displays Key Tips, which allow you to navigate the ribbon using your keyboard. * Where can you find the horizontal split bar on the MS Word screen? (A) On the left of the horizontal scroll bar (B) On the right of the horizontal scroll bar (C) On the top of the vertical scroll bar (D) On the bottom of the vertical scroll bar The horizontal split bar appears above the vertical scroll bar to divide the document into sections for easier navigation. * Pressing F8 key for three times selects: (A) A word (B) A sentence (C) A paragraph (D) Entire document Pressing F8 three times selects a paragraph in MS Word. * What happens if you press Ctrl + Shift + F8? (A) It activates extended selection (B) It activates the rectangular selection (C) It selects the paragraph on which the insertion line is (D) None of the above Ctrl + Shift + F8 activates the extended selection mode, allowing you to select text more easily. * How can you disable extended selection mode? (A) Press F8 again to disable (B) Press Del to disable (C) Press Esc to disable (D) Press Enter to disable Pressing the Esc key will disable the extended selection mode. * What is the shortcut key to create a copyright symbol? (A) Alt+Ctrl+C (B) Alt+C (C) Ctrl+C (D) Ctrl+Shift+C Alt + Ctrl + C is the keyboard shortcut to insert the copyright symbol (©). * The keystroke Ctrl+I is used to: (A) Increase font size (B) Insert a line break (C) Indicate the text should be bold (D) Applies Italic format to selected text Ctrl + I is the shortcut to apply italic formatting to the selected text in MS Word. * Which function key activates the speller? (A) F5 (B) F7 (C) F9 (D) Shift + F7 F7 is the shortcut key to run the spell check in MS Word. * To move the cursor page to page of a document: (A) Ctrl + PgDn (B) Ctrl + PgUp (C) Both of the above (D) None of the above Ctrl + PgDn moves the cursor to the next page, and Ctrl + PgUp moves the cursor to the previous page. * You can detect spelling and grammar errors by: (A) Press Shift + F7 (B) Press Ctrl + F7 (C) Press Alt + F7 (D) Press F7 Pressing F7 opens the spelling and grammar checker in MS Word. * Which key should you press if you want to copy while using drag and drop? (A) Shift (B) CTRL (C) ALT (D) Home Hold the CTRL key while dragging to copy text instead of moving it. * Which shortcut keystrokes do you use to create a manual page break? (A) Ctrl + Spacebar (B) Ctrl + Enter (C) Ctrl + Shift + Enter (D) Alt + Enter Ctrl + Enter is the shortcut to insert a manual page break in Word. Subscript refers to text that appears smaller and lowered below the regular text line, like the "2" in H2O. * A First Line indent indents all lines after the first line of the paragraph. (A) True (B) False A First Line indent only indents the first line of the paragraph, not all lines. * The default line spacing for a Word 2007 document is set to multiple with a 15% increase (1.15) over single spacing. (A) True (B) False By default, Word 2007 uses 1.15 line spacing, which is a 15% increase over single spacing. * The vertical space between lines of text is referred to as what? (A) Indenting (B) Line spacing (C) Paragraph padding (D) Internal margins Line spacing refers to the amount of vertical space between lines of text in a paragraph. * An outline numbered list can have up to how many levels? (A) 5 (B) 8 (C) 9 (D) 15 An outline numbered list in Word can have up to 9 levels of indentation. * What is the maximum number of lines you can set for a drop cap? (A) 3 (B) 10 (C) 15 (D) 20 In Word, the maximum number of lines you can set for a drop cap is 10. * What is the default number of lines to drop for a drop cap? (A) 3 (B) 10 (C) 15 (D) 20 By default, Word applies a 3-line drop cap effect to the first letter of a paragraph. * What is the smallest and largest font size available in the Font Size tool on the formatting toolbar? (A) 8 and 72 (B) 8 and 64 (C) 12 and 72 (D) None of the above The Font Size tool in Word allows font sizes from 8 to 72 points. * What is the maximum font size you can apply for any character? (A) 163 (B) 1638 (C) 16038 (D) None of the above The maximum font size that can be applied in MS Word is 1638 points. * A character that is raised and smaller above the baseline is known as: (A) Outlined (B) Raised (C) Superscript (D) Subscript A superscript is a character that appears raised and smaller above the baseline, such as in mathematical notations (e.g., x²). * Why are Drop Caps used in a 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 Drop Caps are used to add a large initial capital letter to the beginning of a paragraph, typically for stylistic purposes. * Superscript, subscript, outline, emboss, engrave are known as: (A) Font styles (B) Font effects (C) Word art (D) Text effects These are various font effects that modify how the text appears in the document. * The feature of Word that automatically adjusts the amount of space between certain combinations of characters so that an entire word looks more evenly spaced is called: (A) Spacing (B) Scaling (C) Kerning (D) Positioning Kerning adjusts the spacing between characters to make text appear more even and visually appealing. * Which of the following is not available in Font Spacing? (A) Normal (B) Loosely (C) Condensed (D) Expanded Loosely is not a standard font spacing option in MS Word. * Which of the following positions is not available for fonts on MS Word? (A) Normal (B) Raised (C) Lowered (D) Centered Centered is not an available font position option. Fonts are typically Normal, Raised, or Lowered. * What is the maximum scale percentage available in the Scale drop-down box? (A) 500 (B) 200 (C) 100 (D) 90 The maximum scaling percentage in MS Word is 200%. * Bold, Italic, Regular are known as: (A) Font styles (B) Font effects (C) Word art (D) Text effects Bold, Italic, and Regular are different font styles that can be applied to text in MS Word. * Changing the appearance of a document is called: (A) Proofing (B) Editing (C) Formatting (D) All of the above Formatting involves changing the appearance of a document, such as adjusting fonts, margins, or text alignment. * How would you make an item in a multi-level list change level? (A) Indent & Outdent (B) Tab & Shift Tab (C) Format Margin (D) Don't know You can change the level of an item in a multi-level list by pressing Tab to indent and Shift + Tab to outdent. * What is a paragraph? (A) A sentence or group of sentences (B) A block of text (C) Any text with a return at the end (D) Don't know A paragraph in Word is defined as any text followed by a paragraph break (pressing Enter). * Which formatting type makes both margins of a block of text equally straight? (A) Right (B) Justified (C) Align (D) Don't know Justified text aligns both the left and right margins by adjusting the spacing between words. * How can you make letters appear Hollow? (A) Choose the white text option (B) Choose the Hollow from the styles drawer (C) Format it to outline (D) Don't know You can make letters appear hollow by formatting them to be outlined, which removes the fill color and leaves the letter outline. * Using the Font tab in the Font dialog box, you can modify the font, font style, font size, and change the default font. (A) True (B) False The Font tab in the Font dialog box provides options for adjusting the font, style, size, and setting the default font. * The Format Painter is used to copy and paste formatted text. (A) True (B) False The Format Painter tool copies formatting from one section of text and applies it to another section. * You only need to tap Enter once between paragraphs when using Word's new spacing, which automatically adds space after a paragraph. (A) True (B) False While Word’s default setting adds space after paragraphs, you can adjust this behavior, and you still need to tap Enter to start a new paragraph. * To copy text formats to several locations in a document, you select the text containing the formats you want to copy, and then... (A) Click the format painter button and select the desired blocks of text (B) Double-click the format painter button and select the desired blocks of text (C) Use the Copy button (D) Double-click the Copy button Double-clicking the Format Painter button allows you to apply the copied format to multiple locations in the document. Headers and footers are used to display repetitive content like page numbers, document titles, or dates at the top or bottom of each page. * A __ marks the point at which one page ends and another begins. (A) Page break (B) Column break (C) Cell break (D) Line break A page break is used to mark where a page ends and the next begins in a document. * You can add a tab stop just by clicking a location on the Word ruler. (A) True (B) False In Word, you can quickly add a tab stop by clicking on the ruler at the desired location. * To reduce the amount of space on the right side of a document, you can __. (A) Increase; Left Margin (B) Decrease; Right Margin (C) Decrease; Left Indent (D) Increase; Right Indent To reduce space on the right, you can decrease the right margin in the document. * You can format a document to contain a maximum of 3 newsletter columns. (A) True (B) False You can create a maximum of 45 columns in Word, not just 3. * How many columns can you insert in a Word document at maximum? (A) 35 (B) 45 (C) 55 (D) 65 You can insert up to 45 columns in a table in Word. * What is the purpose of inserting a header and footer in a document? (A) To enhance the overall appearance of the document (B) To mark the starting and ending of a page (C) To make a larger document more readable (D) To allow page headers and footers to appear on the document when printed Headers and footers are used to add consistent elements, such as page numbers, document titles, or dates, that will appear on printed pages. * The minimum number of rows and columns in an MS Word document is: (A) 1 and 1 (B) 2 and 1 (C) 2 and 2 (D) None of the above The minimum number of rows and columns that can be in a table in MS Word is 1 and 1. * Which option is not available in Insert Table Autofit behavior? (A) Fixed Column Width (B) AutoFit to Contents (C) AutoFit to Window (D) AutoFit to Column There is no option for "AutoFit to Column." The available options are "AutoFit to Contents" and "AutoFit to Window." * To autofit the width of a column: (A) Double-click the right border of the column (B) Double-click the left border of the column (C) Double-click the column header (D) All of the above Double-clicking the right border of a column will automatically adjust its width to fit the content. * From which Ribbon can you insert Header and Footer? (A) Insert (B) View (C) Format (D) Tools You can insert headers and footers from the Insert Ribbon in MS Word. * After typing header text, how can you quickly enter footer text? (A) Press PageDown key and type the text for the footer (B) Click on Switch between Header & Footer, then type the text (C) Both of the above (D) None of the above The "Switch between Header & Footer" option allows you to easily toggle between editing the header and footer sections. * When inserting a page number in the footer, it appeared as '1' but you wish to show 'a.' How can you do that? (A) From the Home Ribbon, choose Bullets and Numbering and configure the necessary setting (B) From the Insert Ribbon, choose Page Number and specify the necessary setting (C) Click on the Page Number Format tool and specify the required setting (D) All of the above You can change the page number format, such as from numbers to letters, by clicking the Page Number Format tool. * Which of the following statement is false? (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 the first page of a section (D) You can set different header and footer for the last page of a section Word allows different headers and footers for even and odd pages, as well as the first page of a section, but not specifically for the last page of a section. * Where can you change the vertical alignment? (A) Formatting Ribbon (B) Paragraph dialog box (C) Page Setup dialog box (D) Insert Ribbon Vertical alignment can be adjusted from the Page Setup dialog box to control text positioning on the page. * Which of the following is used to create newspaper-style columns? (A) Format Tabs (B) Table Insert Table (C) Insert Textbox (D) Page Layout, Columns In MS Word, to create newspaper-style columns, you use the "Columns" feature in the "Page Layout" tab. * Columns dialog box can be opened from: (A) Page Layout, Columns (B) Double-click on the column space in the ruler (C) Press Alt + O + C (D) All of the above The Columns dialog box can be accessed in multiple ways: from the "Page Layout" tab, by double-clicking the column space in the ruler, or using the shortcut Alt + O + C. * You can jump to the next column by: (A) Clicking with your mouse on the next column (B) Pressing Alt + Down-arrow (C) Both of the above (D) None of the above You can jump to the next column either by clicking with the mouse or using the Alt + Down-arrow shortcut. * How can you break the current column and start a new column immediately? (A) Press Ctrl + Shift + Enter (B) Press Alt + Enter (C) Press Ctrl + Enter (D) Press Alt + Shift + Enter Ctrl + Shift + Enter breaks the current column and starts a new column immediately. * What is the smallest width of a column? (A) 0" (B) 0.5" (C) 1" (D) 1.5" The smallest width a column can have is 0.5 inches. * How much space in minimum must be provided between columns? (A) 0" (B) 0.5" (C) 1" (D) 1.5" A minimum of 0.5 inches of space must be provided between columns. * You need one page to be landscaped in a document that is portrait. What do you use? (A) Page breaks (B) Section breaks (C) Orientation breaks (D) Don't know A section break allows you to have different page orientations (portrait or landscape) within the same document. * What makes full stops in currency line up in a tabbed layout? (A) Decimal Tab (B) Left Tab (C) Bar Tab (D) Don't know A Decimal Tab ensures that numbers with decimal points line up correctly in a column. * In a word table, how can you add up a column of figures? (A) =sum(above) (B) Autosum button (C) Insert function sum (D) Don't know To sum a column in a table, you can use the formula "=sum(above)" to calculate the total of the numbers above the cell. * When we don't want a single line of a paragraph to be left on another page, we turn on: (A) Paragraph line control (B) Widow and Orphan control (C) Line Break control (D) Don't know Widow and Orphan control ensures that a paragraph is not split across pages by keeping at least two lines together. * Manual page breaks remain in place until you remove them. (A) True (B) False Manual page breaks stay in place until you manually remove them or adjust the document’s layout. * You can remove a manual page break by clicking it and tapping Delete. (A) True (B) False You can remove a manual page break by selecting it and pressing Delete. The file extension for MS Word documents is .doc (or .docx for newer versions). * Which of the following types of pictures can Word not accept? (A) CDR (B) PNG (C) TIFF (D) JPG CDR is a file format specific to CorelDRAW and cannot be used in MS Word. * Someone using an older version of Word can read your Word 2007 documents by downloading a compatibility pack from the Microsoft website. (A) True (B) False Microsoft provides a compatibility pack that allows users with older versions of Word to open and read Word 2007 documents.