Podcast
Questions and Answers
Which of the following is not a valid data type in Excel?
Which of the following is not a valid data type in Excel?
Which action can be performed on a data source before merging?
Which action can be performed on a data source before merging?
What are comments put in cells called?
What are comments put in cells called?
Which menu allows you to insert a header and footer in MS Office?
Which menu allows you to insert a header and footer in MS Office?
Signup and view all the answers
Which of the following is not a valid Zoom percentage in Excel?
Which of the following is not a valid Zoom percentage in Excel?
Signup and view all the answers
Which menu option can be used to split windows into two?
Which menu option can be used to split windows into two?
Signup and view all the answers
To access the 'Symbol' dialog box, which menu do you need to select?
To access the 'Symbol' dialog box, which menu do you need to select?
Signup and view all the answers
How can you activate a cell in Excel?
How can you activate a cell in Excel?
Signup and view all the answers
Which option from the clipboard is used specifically to move data within a document?
Which option from the clipboard is used specifically to move data within a document?
Signup and view all the answers
To drag a selected range of data to another worksheet in the same workbook, which key do you use?
To drag a selected range of data to another worksheet in the same workbook, which key do you use?
Signup and view all the answers
Which of the following statements about comments in Excel is true?
Which of the following statements about comments in Excel is true?
Signup and view all the answers
What feature in the Font Group allows you to apply a strikethrough effect?
What feature in the Font Group allows you to apply a strikethrough effect?
Signup and view all the answers
Where can you find the 'Bullets and Numbering' option in MS Office?
Where can you find the 'Bullets and Numbering' option in MS Office?
Signup and view all the answers
Which button would you click on in MS Office to open an existing document?
Which button would you click on in MS Office to open an existing document?
Signup and view all the answers
In which group can you find the Cut, Copy, and Paste options within the Home tab?
In which group can you find the Cut, Copy, and Paste options within the Home tab?
Signup and view all the answers
Which of the following is a shortcut to access the document views toolbar in MS Office?
Which of the following is a shortcut to access the document views toolbar in MS Office?
Signup and view all the answers
Which menu should be chosen to change the typeface of a document?
Which menu should be chosen to change the typeface of a document?
Signup and view all the answers
What happens when you click on Insert >> Picture >> Clip Art?
What happens when you click on Insert >> Picture >> Clip Art?
Signup and view all the answers
Which of the following options is not available in Insert Table Autofit behavior?
Which of the following options is not available in Insert Table Autofit behavior?
Signup and view all the answers
Which type of border can be applied according to the options provided?
Which type of border can be applied according to the options provided?
Signup and view all the answers
Which of the following is not a font style?
Which of the following is not a font style?
Signup and view all the answers
Where can you change the vertical alignment of text?
Where can you change the vertical alignment of text?
Signup and view all the answers
What was AutoCorrect originally designed to do as you type?
What was AutoCorrect originally designed to do as you type?
Signup and view all the answers
Which option relates to setting different headers and footers?
Which option relates to setting different headers and footers?
Signup and view all the answers
What is the function of the F5 key during a presentation?
What is the function of the F5 key during a presentation?
Signup and view all the answers
Which feature allows you to apply motion effects between slides?
Which feature allows you to apply motion effects between slides?
Signup and view all the answers
Which of the following options is NOT a valid choice when inserting a picture?
Which of the following options is NOT a valid choice when inserting a picture?
Signup and view all the answers
Which font effect cannot be found in the PowerPoint Font dialog box?
Which font effect cannot be found in the PowerPoint Font dialog box?
Signup and view all the answers
What is one of the methods to insert a hyperlink in a slide?
What is one of the methods to insert a hyperlink in a slide?
Signup and view all the answers
Which menu option gives access to Picture, Text Box, and Chart?
Which menu option gives access to Picture, Text Box, and Chart?
Signup and view all the answers
Which of the following is NOT an option available in the Insert >> Picture menu?
Which of the following is NOT an option available in the Insert >> Picture menu?
Signup and view all the answers
What happens if you select Insert >> Picture >> From File?
What happens if you select Insert >> Picture >> From File?
Signup and view all the answers
What type of software is Pagemaker?
What type of software is Pagemaker?
Signup and view all the answers
What is the term for the effect when one slide replaces another in a PowerPoint presentation?
What is the term for the effect when one slide replaces another in a PowerPoint presentation?
Signup and view all the answers
Which master can be used to add headers or footers to your handouts in PowerPoint?
Which master can be used to add headers or footers to your handouts in PowerPoint?
Signup and view all the answers
What tool in PowerPoint changes the pointer to an insertion point for text and highlighting?
What tool in PowerPoint changes the pointer to an insertion point for text and highlighting?
Signup and view all the answers
Where is the layout option found in PowerPoint?
Where is the layout option found in PowerPoint?
Signup and view all the answers
In PowerPoint, which option allows you to view all slides on one screen?
In PowerPoint, which option allows you to view all slides on one screen?
Signup and view all the answers
Which bar displays the name of the current application in PowerPoint?
Which bar displays the name of the current application in PowerPoint?
Signup and view all the answers
Which option in PowerPoint is NOT a type of animation?
Which option in PowerPoint is NOT a type of animation?
Signup and view all the answers
Study Notes
MS Office Competitions Exam Study Notes
- Headers and footers can be inserted via the Insert Menu.
- To access the Symbol dialog box, navigate through the Insert menu.
- The option from the clipboard used to move data within a document is Cut & Paste.
- The Strikethrough option is available in the Font Group.
- Cut, Copy, and Paste functions are in the Clipboard Group within the Home tab.
- To open an existing document, use the MS Office button and select Open.
- Bullets and Numbering can be found in the Home tab.
- AutoCorrect was designed to replace common mistakes as you type.
- To split windows, use the View -> Window -> Split menu option.
- Comments in Excel cells are referred to as Cell Tips.
- AutoFit behaviors in tables include AutoFit to Contents and AutoFit to Window.
- Valid data types in Excel include Number, Character, Label, and Date/Time.
- You can activate a cell by clicking it or using the Tab or arrow keys.
- To start a slideshow in PowerPoint, hit the F5 key or select View Show from the Slide Show menu.
- To add motion effects between slides, utilize Slide Transition or Animation Scheme features.
- To insert a hyperlink in PowerPoint, use Insert >> Hyperlink or press Ctrl + K.
- Insert Picture options include Clipart, Pictures, and Shapes.
- The Title Bar displays the name of the application in Microsoft PowerPoint.
- The Handout Master can be used to add headers or footers to handouts.
- Slide transitions define how one slide replaces another in a presentation.
- Key functionalities for accessibility and navigation in MS Office applications span various toolbars, such as the Formatting toolbar and Menu bar.
- To format the typeface of a document, utilize the Format menu.
- Activating tools like Text Tool changes the pointer to facilitate text entry.
- Understanding the arrangement of toolbars and menu commands is essential for efficient document editing and presentation creation.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Prepare for your MS Office competitions with these comprehensive study notes. This resource covers essential functions, features, and menu navigation that are crucial for mastering MS Office applications. Enhance your understanding of tools like headers, footers, and data management features across different MS Office programs.
