Lab 1: Introduction to Microsoft Windows
48 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of using a macro in Microsoft Word?

  • To create complex formulas for data analysis.
  • To improve file compression rates.
  • To merge documents from Excel and Word.
  • To perform a repetitive task automatically. (correct)

    • Which key combination is used to capture a selected area on a Mac?

  • Alt + Shift + S
  • Command + Shift + 4 (correct)
  • Alt + Command + 4
  • Control + Shift + 4

    • In Microsoft Excel, how are formulas initiated?

  • By typing an equal sign (=) (correct)
  • By enclosing in brackets []
  • By typing a period (.)
  • By pressing the F2 key

    • What is the result of the formula =SUM(A1:A5) in Excel?

    <p>It adds all values in cells A1 to A5.</p> Signup and view all the answers

    What does the formula =COUNT(A1:A5) do?

    <p>Counts how many cells are non-empty in the range A1 to A5.</p> Signup and view all the answers

    Which command is used to paste copied content in Excel?

    <p>Control + V</p> Signup and view all the answers

    How can you ensure a specific row remains unchanged when copying a formula in Excel?

    <p>By using $ before the row number.</p> Signup and view all the answers

    What is the benefit of saving Excel files to a USB drive?

    <p>To prevent data loss and ensure portability.</p> Signup and view all the answers

    What is the formula for calculating growth between two periods?

    <p>(Xt - Xt−1) / Xt−1 * 100%</p> Signup and view all the answers

    What should be done when copying a formula in Excel to ensure cell references adjust appropriately?

    <p>Use no $ signs at all.</p> Signup and view all the answers

    What formatting options should be selected to ensure grids are visible when printing a spreadsheet?

    <p>Outline and Inside Borders.</p> Signup and view all the answers

    Why is it important to use cell references when working in Excel?

    <p>It helps updates to data reflect automatically.</p> Signup and view all the answers

    What method can be used to visually differentiate inflation entries in a spreadsheet?

    <p>Select a color fill for the cells.</p> Signup and view all the answers

    When creating a pie chart in Excel, what data can be used for representation?

    <p>Market shares of companies.</p> Signup and view all the answers

    What should be done to calculate the average inflation after initial calculations?

    <p>Use the same formula to calculate average inflation.</p> Signup and view all the answers

    What action should be taken if there is an error in the original data set in Excel?

    <p>Change the original data and observe automatic updates.</p> Signup and view all the answers

    What is the first step to apply a fill color to a shape?

    <p>Use the Shape Styles group under the Home tab.</p> Signup and view all the answers

    How can you confirm text entry within a shape?

    <p>Click outside the shape.</p> Signup and view all the answers

    Which icon allows you to rotate a shape?

    <p>Rotation icon.</p> Signup and view all the answers

    What should you do to resize a shape?

    <p>Select the shape and drag one of the sizing handles.</p> Signup and view all the answers

    How can you access more shape styles than are visible initially?

    <p>Use the More Shape Styles button.</p> Signup and view all the answers

    What is the purpose of the Change Shape button?

    <p>To select a new shape from available stencils.</p> Signup and view all the answers

    What action must you take to select a new stencil after using the Change Shape button?

    <p>Click on the arrow next to the current stencil.</p> Signup and view all the answers

    What can you find in the Page Setup dialog box?

    <p>Settings for page orientation and size.</p> Signup and view all the answers

    What is the first step to apply a theme to selected slides?

    <p>Click the Slides tab</p> Signup and view all the answers

    What action must be taken to add a new slide to a PowerPoint presentation?

    <p>Click the New Slide button in the Slides group on the Home tab.</p> Signup and view all the answers

    Which key do you press to end the slide show and return to PowerPoint?

    <p>Esc</p> Signup and view all the answers

    How can you add a background to your PowerPoint slides?

    <p>By choosing the Design tab, clicking Background Styles, and selecting a background</p> Signup and view all the answers

    How can you change the layout of an existing slide in PowerPoint?

    <p>Right-click the slide layout and select Layout from the menu.</p> Signup and view all the answers

    Which button would you use to create a hierarchy in your outline during a PowerPoint presentation?

    <p>Increase List Level button.</p> Signup and view all the answers

    What is the initial step to create a flowchart from a blank template in Visio 2016?

    <p>Click the File tab</p> Signup and view all the answers

    What happens when you click on the More button in the Themes group after selecting a design?

    <p>It opens a menu enabling theme selection</p> Signup and view all the answers

    What should you do to view shapes associated with a selected stencil?

    <p>Click the stencil</p> Signup and view all the answers

    Which procedure is NOT used for navigating to the previous slide in a PowerPoint presentation?

    <p>Press the Enter key</p> Signup and view all the answers

    What is the purpose of applying a theme to PowerPoint slides?

    <p>To set a background for your slides that includes colors and fonts.</p> Signup and view all the answers

    If you want to place text in two separate columns, which layout should you select?

    <p>Two Content layout.</p> Signup and view all the answers

    To apply a theme to all slides in your PowerPoint presentation, which action do you take?

    <p>Choose the Design tab and click on a theme without selecting slides</p> Signup and view all the answers

    Which tool is used to connect shapes in a flowchart?

    <p>Connector tool</p> Signup and view all the answers

    Which is a feature you can modify when formatting tables in PowerPoint presentations?

    <p>Adjust the cell internal margins</p> Signup and view all the answers

    What should you do if you want to decrease the indent of a bullet point in your outline?

    <p>Click the Decrease List Level button.</p> Signup and view all the answers

    What is a necessary action after selecting a Basic Flowchart template?

    <p>Select the US or Metric units</p> Signup and view all the answers

    What happens when you click to select a shape on the drawing page?

    <p>Connecting arrows appear around the shape</p> Signup and view all the answers

    What does clicking on the Apply to Selected Slides option do?

    <p>It applies the theme to only the slides you have selected</p> Signup and view all the answers

    What can be done if you want to change some existing text on a slide?

    <p>Select the text and type the new text directly.</p> Signup and view all the answers

    Which tab would you select to apply a theme to your entire presentation?

    <p>Design tab.</p> Signup and view all the answers

    How can you add a shape to your diagram in Visio 2016?

    <p>Click and hold the shape, then drag it into your diagram</p> Signup and view all the answers

    What occurs when you add additional stencils to your drawing?

    <p>New stencils appear in the list of stencils</p> Signup and view all the answers

    What is the purpose of the Shapes window in Visio 2016?

    <p>To contain stencils and associated shapes</p> Signup and view all the answers

    Study Notes

    Lab 1: Introduction to Microsoft Windows

    • Objective: By the end of the lab, participants will be able to navigate the Windows interface, use basic Windows tools and features, customize their Windows environment, and manage files and folders effectively.
    • Materials Needed: Computers with Windows installed, a projector and screen (for instructor-led demonstrations), and handouts with step-by-step instructions (optional).
    • Lab Duration: 3 hours

    Part 1: Getting Started with Windows

    1.1 Logging In

    • Objective: To learn how to log into Windows.
    • Instructions:
      • Start the computer and wait for the login screen.
      • Enter the username and password.
      • Click the "Sign In" button.

    1.2 Exploring the Desktop

    • Objective: To familiarize yourself with the Windows desktop environment.
    • Instructions:
      • Identify key desktop components: Start Menu, Taskbar, System Tray, and Desktop Icons.
      • Right-click on the Desktop and select "Personalize" to explore themes and background options.

    1.3 Using the Start Menu

    • Objective: To learn how to access applications and settings.
    • Instructions:
      • Learn how to access applications and settings.

    Part 2: Basic Navigation and Tools

    2.1 File Explorer

    • Objective: To learn how to navigate and manage files and folders
    • Instructions:
      • Open File Explorer by clicking its icon or pressing Windows Key + E.
      • Navigate folders (Desktop, Documents, Downloads, and Pictures).
      • Create, rename, and delete folders.

    2.2 Task Manager

    • Objective: To understand how to manage running applications and processes.
    • Instructions:
      • Open Task Manager (Ctrl + Shift + Esc or right-click the Taskbar).
      • Explore the Processes, Performance, and Startup tabs.
      • End a non-responsive application.

    Part 3: Customizing Your Windows Environment

    3.1 Adjusting System Settings

    • Objective: To learn how to change system settings.
    • Instructions:
      • Open Settings (Windows Key + I).
      • Explore settings in System, Personalization, and Privacy.
      • Adjust display resolution or change the theme.

    3.2 Managing User Accounts

    • Objective: To understand how to manage user accounts.
    • Instructions:
      • Go to Settings > Accounts.
      • Add or manage user accounts and switch between them.

    Part 4: Practical Exercises

    4.1 File Management Exercise

    • Objective: To apply file management skills.
    • Instructions:
      • Download a file from the internet and save it to the Downloads folder.
      • Move the file to the Documents folder and then delete it.

    4.2 Customization Exercise

    • Objective: To apply customization skills.
    • Instructions:
      • Change the desktop background to a picture of your choice
      • Adjust screen saver settings.

    Conclusion

    • Review: Review key points.
    • Q&A: Address any student questions or difficulties.
    • Feedback: Collect feedback to improve the lab.

    Lab 3: Introduction to Microsoft Word (Part II)

    • Objective: To convert documents, write reports, convert Word documents to IEEE templates.
    • Materials Needed: Windows computers with Microsoft Word installed, projector and screen (for instructor demos), and handouts.
    • Lab Duration: 3 hours

    Converting Doc A to Doc B

    • Convert Document A to Document B format, copying data, using figure captions, and referencing.

    Lab 4: Advanced Topics in Word

    • Objective: Master advanced formatting and layout techniques, utilize styles and templates effectively, create and manage complex tables and graphics, use advanced features like mail merge, citations, and references.

    Lab 1 - Introduction to Excel

    • Quick View:
      • Cells are identified by letter and number.
      • Typing enters numbers; formulas start with "=".
      • Common formulas: SUM, AVERAGE, COUNT, VAR, STDEV.

    (A) Opening Microsoft Excel

    • Microsoft Excel opens through the start button.

    (B) Cells

    • Excel spreadsheets consist of cells. Columns are denoted by letters, rows by numbers.

    (C) Filling In Cells

    • Numbers, formulas, and text are entered into cells.
    • Equations follow standard mathematical order of operations.

    (D) Selecting, Copying, Cutting, and Pasting

    • More than one cell is selected by clicking the first and last to be selected, holding the mouse button and dragging through cells.
    • To copy cells: CTL + C or right click, copy
    • To cut cells: CTL + X or right click, cut
    • To paste cells: CTL + V or right click, paste

    (E) Pasting Formulas

    • Copying and pasting a formula automatically adjusts cell references based on the new location.
    • To prevent cells from changing when copied, place a $ before the cell reference(s).

    (F) Inserting or Deleting Row or Columns

    • To insert a row or column, use Insert, Right-click.
    • To delete a row or column, use Delete, Right-click

    (G) Changing Column Width

    • Adjust column width to fit text by dragging the boundary to set desired width.

    (H) Formatting Cells

    • Use the Format Cells function to customize appearance (number, alignment, font, borders, fill, etc.). This can also be accessed through the Home menu.

    (I) Changing Fonts

    • Format Cells or Home menu to change font attributes (type, size, bold, italics).
    • Click and drag to select multiple cells for simultaneous formatting.

    (J) Saving an Excel File

    • Use the File > Save or Save As options.
    • Specify the save location & file name.
    • (File > Save As) Select the file type (e.g. Excel 97 – 2003 Workbook)

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Lab 1_merged.pdf

    Description

    This lab is designed to teach participants the basics of navigating the Windows interface and using its fundamental tools and features. By the end of the session, attendees will be able to effectively manage files, customize their environment, and understand key desktop components. Perfect for beginners learning to use Windows.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser