IC3 Spark - Key Applications Benchmark Assessment

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Jennifer
J
Jennifer
Community Contributor
Quizzes Created: 7 | Total Attempts: 5,531
Questions: 87 | Attempts: 267

SettingsSettingsSettings
IC3 Spark - Key Applications Benchmark Assessment - Quiz

This assessment is used as a benchmark to see if you have mastered the Key Applications concepts for the IC3 Spark Certification Exam! You must pass this benchmark assessment with a 90% or higher to show mastery of Key Applications. When you pass at 90% or higher, you will then move on to learning about the Living Online portion of IC3 Spark. Good Luck! You can do this. . . You are AWESOME!


Questions and Answers
  • 1. 

    In Excel, which filter command would you use to display any sales that are $40,000 or more?

    • A.

      Greater Than

    • B.

      Less Than

    • C.

      Equals

    • D.

      Greater Than or Equal To

    Correct Answer
    D. Greater Than or Equal To
    Explanation
    The "Greater Than or Equal To" filter command in Excel would be used to display any sales that are $40,000 or more. This filter will include values that are equal to or greater than the specified amount, in this case, $40,000.

    Rate this question:

  • 2. 

    How can you start Microsoft Excel?

    • A.

      Click Start, All Programs, Microsoft Excel 2010

    • B.

      Click Start, Microsoft Office, Microsoft Excel 2010

    • C.

      Click Start, Programs, Microsoft Excel 2010

    • D.

      Click Start, All Programs, Microsoft Office, Microsoft Excel 2010

    Correct Answer
    D. Click Start, All Programs, Microsoft Office, Microsoft Excel 2010
    Explanation
    To start Microsoft Excel, you need to click on the Start button, then go to the All Programs option, and from there select Microsoft Office. Finally, click on Microsoft Excel 2010 to open the program.

    Rate this question:

  • 3. 

    Which three buttons appear on the Quick Access Toolbar by default, before any customizing is performed?

    • A.

      Save

    • B.

      Open

    • C.

      Undo

    • D.

      Redo

    • E.

      Print

    • F.

      New

    Correct Answer(s)
    A. Save
    C. Undo
    D. Redo
    Explanation
    The three buttons that appear on the Quick Access Toolbar by default, before any customizing is performed, are Save, Undo, and Redo. These buttons are commonly used and provide quick access to essential functions. The Save button allows users to save their work, the Undo button allows users to undo their previous action, and the Redo button allows users to redo an action that was previously undone. These buttons are included by default to enhance user productivity and efficiency while working with documents.

    Rate this question:

  • 4. 

    What are these called outlined in red in the image below?

    • A.

      Ribbon

    • B.

      Groups

    • C.

      Tabs

    • D.

      Menus

    Correct Answer
    C. Tabs
    Explanation
    The items outlined in red in the image are called tabs. Tabs are used to organize and categorize different sections or functions within a larger interface or application. They allow users to easily navigate and switch between different sets of content or features.

    Rate this question:

  • 5. 

    Which one is a gallery in the below image? 

    • A.

      A

    • B.

      B

    • C.

      C

    Correct Answer
    B. B
    Explanation
    In the given image, option B is a gallery.

    Rate this question:

  • 6. 

    Which button displays the Help Table of Contents?

    • A.

      A

    • B.

      B

    • C.

      C

    • D.

      D

    • E.

      E

    Correct Answer
    D. D
    Explanation
    The correct answer is D. The button that displays the Help Table of Contents is button D.

    Rate this question:

  • 7. 

    What is the name of the feature you can use to manage files within an Office program?

    • A.

      File Options view

    • B.

      Office File Manager

    • C.

      Windows Explorer

    • D.

      Backstage view

    Correct Answer
    D. Backstage view
    Explanation
    Backstage view is the correct answer because it is a feature in Office programs that allows users to manage files. It provides options for creating, opening, saving, and printing files, as well as other file-related tasks like sharing and protecting files. Backstage view is accessed by clicking on the File tab in the ribbon, and it provides a centralized location for managing files within the Office program.

    Rate this question:

  • 8. 

    What happens when you press Ctrl+N in an Office program?

    • A.

      A new blank file is created

    • B.

      The Save a New Document screen appears

    • C.

      A new session of the program starts

    • D.

      The New file screen appears

    Correct Answer
    A. A new blank file is created
    Explanation
    When you press Ctrl+N in an Office program, a new blank file is created. This keyboard shortcut is commonly used to quickly start a new document without having to go through the menu options. It is a convenient way to begin working on a new project or document within the program.

    Rate this question:

  • 9. 

    What happens when you press Ctrl+C in an application program?

    • A.

      The selected item is centered between the margins

    • B.

      The selected item is copied to the Office Clipboard

    • C.

      The selected item is colored with the last color selected in the color palette

    • D.

      The selected item is removed from its current location

    Correct Answer
    B. The selected item is copied to the Office Clipboard
    Explanation
    When you press Ctrl+C in an application program, the selected item is copied to the Office Clipboard. This means that a duplicate of the selected item is stored in the clipboard, allowing you to paste it elsewhere in the program or in a different program. This is a common shortcut for copying content and is widely used in various applications for efficient data transfer or duplication.

    Rate this question:

  • 10. 

    Select three methods you can use to share files so other can access these files quickly and easily:

    • A.

      Store the files on a portable drive

    • B.

      Save the files to a shared location such as an organization network

    • C.

      Save the files to a Web destination such as SkyDrive or iCloud

    • D.

      Save the files on your local drive only for security purposes

    • E.

      Send the files as email attachments

    Correct Answer(s)
    B. Save the files to a shared location such as an organization network
    C. Save the files to a Web destination such as SkyDrive or iCloud
    E. Send the files as email attachments
    Explanation
    The three methods mentioned in the answer are effective ways to share files quickly and easily. Saving the files to a shared location such as an organization network allows multiple users to access the files simultaneously. Saving the files to a Web destination like SkyDrive or iCloud provides easy access to the files from any device with an internet connection. Sending the files as email attachments is a common method to share files with individuals or small groups. These methods ensure efficient file sharing and accessibility for different scenarios and requirements.

    Rate this question:

  • 11. 

    When should you press the Enter key when entering text?

    • A.

      When you reach the end of the first line to start word wrap for every following line

    • B.

      When you reach the end of every line at the right margin

    • C.

      When you reach the end of a paragraph or when you want to insert a blank line

    • D.

      When you first open the document to move the insertion point out of the header area

    Correct Answer
    C. When you reach the end of a paragraph or when you want to insert a blank line
    Explanation
    Pressing the Enter key when you reach the end of a paragraph or when you want to insert a blank line is the correct answer because it is a common practice to start a new paragraph or create a blank line by pressing Enter. This helps in maintaining proper formatting and readability in the text. Pressing Enter at the end of every line at the right margin is not necessary as word wrap automatically moves the text to the next line. Pressing Enter when opening a document to move the insertion point out of the header area is not a standard practice.

    Rate this question:

  • 12. 

    Which key can you use to select non-consecutive text?

    • A.

      Shift

    • B.

      Fn

    • C.

      Alt

    • D.

      Ctrl

    Correct Answer
    D. Ctrl
    Explanation
    Ctrl is the correct answer because it is commonly used to select non-consecutive text. By holding down the Ctrl key and clicking on different parts of the text, you can select multiple sections that are not next to each other. This is a useful feature when you want to edit or format specific parts of a document without affecting the rest of the text.

    Rate this question:

  • 13. 

    What does the following mouse cursor indicate?

    • A.

      The clipboard contains text that can be pasted into the current location

    • B.

      You can click here to position the insertion point and type new text into the document

    • C.

      The mouse cursor is in the Selection Bar area and ready to select a block of text

    • D.

      The mouse cursor is in the document and ready to select a block of text

    Correct Answer
    C. The mouse cursor is in the Selection Bar area and ready to select a block of text
    Explanation
    The given answer states that the mouse cursor is in the Selection Bar area and ready to select a block of text. This means that the cursor is positioned in a specific area of the document where text can be selected. It suggests that the user can click and drag the cursor to highlight a block of text for various purposes such as copying, cutting, or formatting. This cursor indicates the user's ability to manipulate the text in the document.

    Rate this question:

  • 14. 

    Which file name extension identifies a Word 2010 document?

    • A.

      .pdx

    • B.

      .docx

    • C.

      .pdf

    • D.

      .doc

    Correct Answer
    B. .docx
    Explanation
    The file name extension .docx identifies a Word 2010 document. This extension is used to indicate that the file is in the XML-based document format introduced in Word 2007 and continued in Word 2010. The .docx extension signifies that the file is compatible with Word 2010 and can be opened and edited in this version of the software.

    Rate this question:

  • 15. 

    Why does Word display "Document #" whenever you create a new file?

    • A.

      To remind you that the file has not been saved with a descriptive name

    • B.

      To remind you to close the files that do not need changes

    • C.

      To let you know how many documents are open on the screen

    • D.

      To provide you with blank documents so you can add new text

    Correct Answer
    A. To remind you that the file has not been saved with a descriptive name
    Explanation
    Word displays "Document #" whenever you create a new file to remind you that the file has not been saved with a descriptive name. This serves as a prompt for you to save the file with a meaningful name that accurately represents its content. By displaying "Document #", Word encourages users to avoid leaving files unnamed or with generic names, making it easier to locate and identify specific documents in the future.

    Rate this question:

  • 16. 

    Select two occasions when you might use the Recent command in the File tab:

    • A.

      To open a file you worked on recently from this list

    • B.

      To view files that other users have made changes

    • C.

      To pin a file you work on frequently to the list so that it will always remain in the list

    • D.

      To view only the files you've worked on during the current session of Word

    Correct Answer(s)
    A. To open a file you worked on recently from this list
    C. To pin a file you work on frequently to the list so that it will always remain in the list
    Explanation
    The Recent command in the File tab can be used to open a file that you have worked on recently from the list. This is helpful when you want to quickly access a file that you have been working on without having to search for it. Additionally, the Recent command can also be used to pin a file that you work on frequently to the list. By pinning the file, it will always remain in the list, making it easily accessible for future use.

    Rate this question:

  • 17. 

    Which button is the Page Layout button:

    • A.

      A

    • B.

      B

    • C.

      C

    • D.

      D

    • E.

      E

    Correct Answer
    A. A
    Explanation
    The correct answer is A because the Page Layout button is typically located on the top toolbar or menu of a software application, and it is usually represented by an icon that resembles a page or a document. In this case, button A is the only option provided, so it is likely to be the correct answer.

    Rate this question:

  • 18. 

    Which view is applied to documents you receive externally via e-mail?

    • A.

      Web Layout view

    • B.

      Protected view

    • C.

      Full Screen Reading view

    • D.

      Read Only view

    Correct Answer
    B. Protected view
    Explanation
    Protected view is the correct answer because it is a security feature in Microsoft Office that helps protect your computer from potentially harmful content in email attachments. When you open a document that is received externally via email, it is automatically opened in protected view. In this view, the document is opened in a restricted mode, which disables editing and the execution of potentially malicious code. This helps to prevent any potential harm to your computer system.

    Rate this question:

  • 19. 

    How does the Paste All command work from the Office Clipboard?

    • A.

      Pastes everything in the Clipboard in the same order you collected them

    • B.

      Empties the Clipboard

    • C.

      Pastes everything in the Clipboard into the current location but as plain text only

    • D.

      Applies the collective formatting of all items in the Clipboard to the selected text

    Correct Answer
    A. Pastes everything in the Clipboard in the same order you collected them
    Explanation
    The Paste All command in the Office Clipboard allows you to paste everything that you have collected in the Clipboard in the same order in which you collected them. This means that if you have copied or cut multiple items, such as text or images, they will be pasted in the order in which you copied or cut them. This can be useful when you want to preserve the original order of the items when pasting them into a document or presentation.

    Rate this question:

  • 20. 

    What happens when you change the font size of text characters?

    • A.

      The text characters adjust in height only

    • B.

      The text characters adjust in width only

    • C.

      The text characters adjust in height and width

    • D.

      More space is added between the characters to accommodate the new font size

    Correct Answer
    C. The text characters adjust in height and width
    Explanation
    When you change the font size of text characters, the characters adjust in both height and width. This means that they become larger or smaller in both dimensions to accommodate the new font size.

    Rate this question:

  • 21. 

    Identify which formatting attributes have been applied to the following:

    • A.

      Company name is bold

    • B.

      Paragraph is justified

    • C.

      Paragraph is justified, company name is bold with with small caps

    • D.

      Company name is bold with small caps

    Correct Answer
    C. Paragraph is justified, company name is bold with with small caps
    Explanation
    The given answer correctly identifies that the paragraph is justified, and the company name is bold with small caps. This means that the text is aligned evenly on both the left and right margins, and the company name is in bold and in small capital letters.

    Rate this question:

  • 22. 

    Why might you want to customize a bullet style for a list?

    • A.

      To create a different look for the document

    • B.

      To change the list style from numbers to bullets

    • C.

      To indent the points from the left margin

    • D.

      To change the list style from bullets to numbering

    Correct Answer
    A. To create a different look for the document
    Explanation
    Customizing a bullet style for a list allows you to create a different look for the document. By customizing the bullet style, you can choose unique and visually appealing bullet designs that match the overall theme or style of the document. This can help make the document more visually interesting and engaging for the reader.

    Rate this question:

  • 23. 

    Which option refers to the amount of space between lines of typed text?

    • A.

      Line spacing

    • B.

      Paragraph spacing

    Correct Answer
    A. Line spacing
    Explanation
    Line spacing refers to the amount of space between lines of typed text. It determines the vertical distance between each line of text and can be adjusted to make the text more readable or to fit more content on a page. By increasing or decreasing the line spacing, the overall appearance and readability of the text can be altered.

    Rate this question:

  • 24. 

    Which feature can you use when you need to format several text blocks that share the same formatting options?

    • A.

      Home tab

    • B.

      Font dialog box

    • C.

      Styles

    • D.

      Copy and Paste

    Correct Answer
    C. Styles
    Explanation
    Styles is the correct answer because it allows you to format multiple text blocks with the same formatting options. With styles, you can create a set of formatting attributes such as font, size, color, and apply them to different sections of text in your document. This saves time and ensures consistency throughout the document. Styles can be accessed and applied from the Home tab in most word processing software.

    Rate this question:

  • 25. 

    Where is the default paper size determined on your system?

    • A.

      Language and Regional settings for your system

    • B.

      Page Layout tab

    • C.

      Advanced category in Word Options

    • D.

      Printer settings

    Correct Answer
    A. Language and Regional settings for your system
    Explanation
    The default paper size on your system is determined by the Language and Regional settings. These settings control various aspects of your system, including the default paper size for printing. By selecting a specific language and region, you are also specifying the default paper size that will be used when printing documents.

    Rate this question:

  • 26. 

    In Word, what is the purpose of setting margins?

    • A.

      To determine the type of printer you have installed for your system

    • B.

      To determine the amount of space between the edges of paper and where text prints

    • C.

      To change the orientation of text on the page

    • D.

      To center every line of text horizontally

    Correct Answer
    B. To determine the amount of space between the edges of paper and where text prints
    Explanation
    Setting margins in Word allows the user to determine the amount of space between the edges of the paper and where the text will be printed. This is important for formatting and ensuring that the text is aligned properly on the page. By adjusting the margins, the user can control the width of the text area and create visually appealing documents.

    Rate this question:

  • 27. 

    What is the keyboard shortcut to Paste?

    • A.

      Ctrl+C

    • B.

      Ctrl+P

    • C.

      Ctrl+S

    • D.

      Ctrl+V

    Correct Answer
    D. Ctrl+V
    Explanation
    The keyboard shortcut to Paste is Ctrl+V. This shortcut is used to paste the copied or cut content into a new location or document. When you want to transfer text or other content from one place to another, you can use this shortcut instead of right-clicking and selecting the "Paste" option from the context menu. It is a commonly used shortcut in various applications and operating systems.

    Rate this question:

  • 28. 

    What is the keyboard shortcut to Undo?

    • A.

      F2

    • B.

      Ctrl+Z

    • C.

      F7

    • D.

      Ctrl+U

    Correct Answer
    B. Ctrl+Z
    Explanation
    The correct answer is Ctrl+Z. This keyboard shortcut is commonly used to undo the previous action in various software applications, including word processors, spreadsheets, and graphic design programs. By pressing Ctrl+Z, the user can quickly revert back to the previous state or undo any changes made. This shortcut is widely known and used because it provides a convenient and efficient way to undo mistakes or unintended actions.

    Rate this question:

  • 29. 

    In Word, which tab on the Ribbon do you use to work with page numbers?

    • A.

      The Page Layout tab

    • B.

      The View tab

    • C.

      The Insert tab

    • D.

      The References tab

    Correct Answer
    C. The Insert tab
    Explanation
    The Insert tab in Word is used to work with page numbers. This tab contains various options related to inserting and formatting page numbers, such as inserting page numbers at different locations, customizing the format of page numbers, and managing page number settings.

    Rate this question:

  • 30. 

    In Word, which view displays the columns of text as one column, enabling you to focus on editing the text instead of the layout?

    • A.

      Full Screen Reading

    • B.

      Print Layout

    • C.

      Draft

    • D.

      Normal

    Correct Answer
    C. Draft
    Explanation
    The Draft view in Word displays the columns of text as one column, allowing the user to concentrate on editing the text rather than the layout. This view is useful when working on the content of the document without distractions from formatting or design elements.

    Rate this question:

  • 31. 

    In Word, which print option you would click to specify which pages to print: 

    • A.

      A

    • B.

      B

    • C.

      C

    • D.

      D

    • E.

      E

    Correct Answer
    B. B
    Explanation
    In Word, you would click option B to specify which pages to print. This option allows you to select specific pages or a range of pages that you want to print, rather than printing the entire document.

    Rate this question:

  • 32. 

    How can you tell if an object is selected in the document?

    • A.

      Eight handles appear around the object

    • B.

      The object appears in its own window for editing

    • C.

      The object changes to black and white if it has color

    • D.

      The object appears with highlighting as does selected text

    Correct Answer
    A. Eight handles appear around the object
    Explanation
    When an object is selected in the document, eight handles appear around it. These handles serve as a visual indicator that the object is currently selected and can be manipulated or edited. The presence of these handles allows the user to easily identify which object is selected among others in the document.

    Rate this question:

  • 33. 

    In Word, which Ribbon tab would you use to place an object into a document?

    • A.

      A

    • B.

      B

    • C.

      C

    • D.

      D

    • E.

      E

    Correct Answer
    C. C
    Explanation
    The correct answer is C. In Word, the Ribbon tab that you would use to place an object into a document is the "Insert" tab. This tab contains various options for inserting objects such as pictures, shapes, charts, and tables into the document.

    Rate this question:

  • 34. 

    Which feature would you use to flow text around a picture?

    • A.

      A

    • B.

      B

    • C.

      C

    • D.

      D

    • E.

      E

    Correct Answer
    D. D
    Explanation
    To flow text around a picture, you would use the "D" feature. This feature allows you to wrap the text around the image, creating a visually appealing layout. By selecting this option, the text will automatically adjust its position to accommodate the picture, creating a professional and organized look.

    Rate this question:

  • 35. 

    In Word, which option would you use to automatically create a table with 12 evenly sized columns and 7 evenly sized rows?

    • A.

      On the Insert tab, in the Tables group, click Draw Table

    • B.

      On the Insert tab, in the Tables group, drag in the palette to specify the rows and columns

    • C.

      On the Insert tab, in the Tables group, click Table, and then click Insert Table

    Correct Answer
    C. On the Insert tab, in the Tables group, click Table, and then click Insert Table
    Explanation
    The correct answer is "On the Insert tab, in the Tables group, click Table, and then click Insert Table." This option is the most appropriate because it specifically mentions the steps to create a table with 12 evenly sized columns and 7 evenly sized rows. The other options do not provide the same level of detail and may not result in the desired table format.

    Rate this question:

  • 36. 

    Select two reasons why you should click to indicate a header row exists in your table data:

    • A.

      To display the names of each column when choosing the sort order

    • B.

      To include a separator line between the row titles and the data

    • C.

      To not include the column titles row in the sort

    • D.

      To include a separator line between the column titles and the data

    Correct Answer(s)
    A. To display the names of each column when choosing the sort order
    C. To not include the column titles row in the sort
    Explanation
    Clicking to indicate a header row exists in the table data is important for two reasons. Firstly, it allows the names of each column to be displayed when choosing the sort order. This helps in easily identifying and selecting the desired column for sorting. Secondly, by indicating a header row, it ensures that the column titles row is not included in the sort. This is important as including the column titles row in the sort can lead to incorrect sorting results.

    Rate this question:

  • 37. 

    In Word, which ribbon tab would you use to insert a comment?

    • A.

      A

    • B.

      B

    • C.

      C

    • D.

      D

    • E.

      E

    Correct Answer
    E. E
    Explanation
    In Word, the ribbon tab that is used to insert a comment is the "Review" tab. This tab contains various tools and options related to reviewing and editing documents, including the "New Comment" button which allows users to insert comments into the document.

    Rate this question:

  • 38. 

    How can you generate a copy of only the markups in a document?

    • A.

      Change the document view to final and then print the document

    • B.

      Use the List of Markup command from the Print All Pages option

    • C.

      Print the entire document

    • D.

      Use the Print option from the Reviewing Pane

    Correct Answer
    B. Use the List of Markup command from the Print All Pages option
    Explanation
    To generate a copy of only the markups in a document, you can use the "List of Markup" command from the "Print All Pages" option. This command will allow you to print a list of all the markups in the document without including the actual content. This is useful when you only want to review or share the changes made to the document without printing the entire document.

    Rate this question:

  • 39. 

    In Excel, how is a workbook different than a worksheet?

    • A.

      A workbook is the entire file that includes worksheets

    • B.

      A workbook can be shared automatically by others

    • C.

      A workbook is a term that is used once you use more than one worksheet in a file

    • D.

      A worksheet can be used in other spreadsheet programs

    Correct Answer
    A. A workbook is the entire file that includes worksheets
    Explanation
    A workbook in Excel refers to the entire file that contains multiple worksheets. It is the main container that holds all the worksheets and other data. Each workbook can have one or more worksheets, which are individual sheets where data can be entered and manipulated. Therefore, the correct answer is that a workbook is the entire file that includes worksheets.

    Rate this question:

  • 40. 

    Which setting determines how dates are displayed in Excel by default?

    • A.

      Default setting through the Office installation

    • B.

      Advanced category in Excel options

    • C.

      Default date format in Cell Format command

    • D.

      Region and Language in Control Panel

    Correct Answer
    D. Region and Language in Control Panel
    Explanation
    The Region and Language setting in the Control Panel determines how dates are displayed in Excel by default. This setting controls the formatting of dates according to the specific region and language preferences selected. By adjusting this setting, users can customize the default display format for dates in Excel based on their preferred regional and language conventions.

    Rate this question:

  • 41. 

    In Excel, which keyboard shortcut moves you quickly to cell A1?

    • A.

      Home

    • B.

      Ctrl+Home

    • C.

      PgUp

    • D.

      Ctrl+Up arrow

    Correct Answer
    B. Ctrl+Home
    Explanation
    The keyboard shortcut Ctrl+Home in Excel moves the user quickly to cell A1. This shortcut is used to navigate to the top-left corner of the worksheet, which is cell A1. It is a convenient way to quickly return to the starting point of the spreadsheet, especially when working with large data sets or when navigating through different sections of the worksheet.

    Rate this question:

  • 42. 

    What is the default file type applied to Excel 2010 workbooks?

    • A.

      .xls

    • B.

      .xlst

    • C.

      .xlsx

    • D.

      .xlsm

    Correct Answer
    C. .xlsx
    Explanation
    The default file type applied to Excel 2010 workbooks is .xlsx. This file type was introduced in Excel 2007 and is the default format for saving workbooks in Excel 2010 and later versions. The .xlsx file type is an XML-based format that allows for better data storage and improved compatibility with other applications. It supports all the features and functionality of Excel, including macros and formulas, making it the preferred file type for most users.

    Rate this question:

  • 43. 

    Which key enables you to activate edit mode?

    • A.

      Enter

    • B.

      F4

    • C.

      F2

    • D.

      F1

    Correct Answer
    C. F2
    Explanation
    Pressing the F2 key enables you to activate edit mode. This key is commonly used in various software applications, including text editors, spreadsheets, and file managers. In edit mode, you can modify or edit the selected item or text, such as renaming a file, editing a cell in a spreadsheet, or making changes to a document. The F2 key is a convenient shortcut that allows users to quickly access and start editing the selected content without the need for additional clicks or menu navigation.

    Rate this question:

  • 44. 

    In Excel, which key enables you to select multiple cell ranges as seen in the image?

    • A.

      F4

    • B.

      Shift

    • C.

      F8

    • D.

      Ctrl

    Correct Answer
    D. Ctrl
    Explanation
    The Ctrl key enables you to select multiple cell ranges in Excel. By holding down the Ctrl key and clicking on different cells or ranges, you can select them simultaneously. This is useful when you want to perform operations on multiple cells or ranges at once, such as formatting or applying formulas.

    Rate this question:

  • 45. 

    What is important to remember about the Undo history list?

    • A.

      You can undo the entry of numbers but not text

    • B.

      The history list exists until you click Save

    • C.

      Once you undo an action, you cannot use the Repeat function

    • D.

      You can only undo commands in the same sequence they were performed

    Correct Answer
    D. You can only undo commands in the same sequence they were performed
    Explanation
    The important thing to remember about the Undo history list is that you can only undo commands in the same sequence they were performed. This means that if you want to undo a specific action, you need to undo all the actions that were performed after it in the same order. The Undo history list does not allow you to selectively undo individual commands, but rather follows a sequential order.

    Rate this question:

  • 46. 

    When you see the following symbol in Microsoft Excel, what does it indicate?

    • A.

      You can drag to adjust the width of column I

    • B.

      You can drag to adjust the width of column H

    • C.

      You can insert a new column in this location

    • D.

      You can drag to adjust the width of columns H and I

    Correct Answer
    B. You can drag to adjust the width of column H
    Explanation
    The given answer suggests that the symbol in Microsoft Excel indicates the ability to drag and adjust the width of column H.

    Rate this question:

  • 47. 

    In Excel, why would you rename a worksheet?

    • A.

      To match the name of the workbook

    • B.

      To help identify the contents

    • C.

      To help identify this as a 2010 workbook

    • D.

      To be able to add a color to the worksheet later

    Correct Answer
    B. To help identify the contents
    Explanation
    Renaming a worksheet in Excel helps to identify the contents of that particular sheet. By giving a descriptive name to the worksheet, users can easily understand what information is stored in that specific sheet. This can be particularly useful when working with multiple sheets within a workbook, as it allows for easy navigation and organization of data.

    Rate this question:

  • 48. 

    In Excel, what do you need to enter to begin a formula in a cell?

    • A.

      "

    • B.

      '

    • C.

      \

    • D.

      =

    Correct Answer
    D. =
    Explanation
    To begin a formula in a cell in Excel, you need to enter the equals sign (=). This signifies to Excel that you are entering a formula and not just a regular value. By starting with the equals sign, you can perform calculations, reference other cells, and use various functions to manipulate data within the spreadsheet.

    Rate this question:

  • 49. 

    In Excel, which tab would you use to merge three cells together and also align the text at the top of the merged cell:

    • A.

      Number

    • B.

      Alignment

    • C.

      Font

    • D.

      Border

    • E.

      Fill

    • F.

      Protection

    Correct Answer
    B. Alignment
    Explanation
    The Alignment tab in Excel allows users to merge three cells together and also align the text at the top of the merged cell. This tab provides options to adjust the horizontal and vertical alignment of cell content, as well as options to wrap text, merge cells, and distribute text evenly across merged cells.

    Rate this question:

  • 50. 

    Why you would apply cell borders when there are gridlines in the worksheet in Excel?

    • A.

      The gridlines do not print with the worksheet automatically

    • B.

      You must apply cell borders if you want to print the worksheet

    • C.

      You cannot use color in the worksheet unless you apply cell borders

    Correct Answer
    A. The gridlines do not print with the worksheet automatically
    Explanation
    Gridlines in Excel are used to help users visually distinguish between cells, but they do not appear when the worksheet is printed. Therefore, if you want the gridlines to be visible in the printed version of the worksheet, you need to apply cell borders. This allows you to have a clear visual representation of the cells and their boundaries when the worksheet is printed.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.