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. (D)</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. (C)</p> Signup and view all the answers

Which command is used to paste copied content in Excel?

<p>Control + V (D)</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. (A)</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. (D)</p> Signup and view all the answers

What is the formula for calculating growth between two periods?

<p>(Xt - Xt−1) / Xt−1 * 100% (C)</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. (A)</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. (D)</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. (A)</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. (C)</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. (B)</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. (B)</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. (B)</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. (A)</p> Signup and view all the answers

How can you confirm text entry within a shape?

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

Which icon allows you to rotate a shape?

<p>Rotation icon. (C)</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. (A)</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. (C)</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. (D)</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. (A)</p> Signup and view all the answers

What can you find in the Page Setup dialog box?

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

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

<p>Click the Slides tab (B)</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. (B)</p> Signup and view all the answers

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

<p>Esc (A)</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 (D)</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. (C)</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. (A)</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 (D)</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 (C)</p> Signup and view all the answers

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

<p>Click the stencil (B)</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 (D)</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. (C)</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. (D)</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 (A)</p> Signup and view all the answers

Which tool is used to connect shapes in a flowchart?

<p>Connector tool (A)</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 (D)</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. (B)</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 (D)</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 (D)</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 (D)</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. (D)</p> Signup and view all the answers

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

<p>Design tab. (B)</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 (A)</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 (C)</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 (A)</p> Signup and view all the answers

Flashcards

Pie Chart in Excel

A chart type in Excel used to show proportional data as slices of a circle. Each slice represents a part of the whole data, and the size of the slice corresponds to its proportion.

Growth Formula

The percentage change in a value over a period, calculated by subtracting the previous value from the current value, dividing the difference by the previous value, and multiplying by 100%.

Bar Chart in Excel

A type of chart that visually displays numerical data as bars. Each bar represents a different category, and the height of the bar corresponds to its value.

Inflation

A general increase in the price of goods and services in an economy over time.

Signup and view all the flashcards

AVERAGE Function in Excel

A function in Excel used to calculate the average of a range of cells. The formula automatically ignores blank cells in the calculation.

Signup and view all the flashcards

Cell References in Excel

A feature in Excel that allows users to automatically update cells with linked formulas. This means that if a source cell is changed, all cells that reference it will update accordingly.

Signup and view all the flashcards

Automatic Updating in Excel

The ability of a software application, such as Excel, to automatically adapt to user actions and changes made within the application.

Signup and view all the flashcards

Saving a File in Excel

The process of saving a file or document to a specific location, such as a USB drive, for later use.

Signup and view all the flashcards

What is a macro?

A macro is like a recorded set of steps that you can play back to automate repetitive tasks in Microsoft Word. It's like training your computer to do things for you.

Signup and view all the flashcards

How to record a macro.

To record a macro in Microsoft Word, you first need to start the recording process. Then, perform the actions you want to automate. Once you are done, stop the recording. The macro will capture all the steps taken.

Signup and view all the flashcards

How to run a macro.

To use the macro you recorded, you'll need to play it back. This will execute the steps in the macro as if you were doing them manually.

Signup and view all the flashcards

What is a cell in Excel?

Each cell in Excel is identified by a combination of a letter (column) and a number (row). For example, A1 refers to the cell in the first column (A) and the first row (1).

Signup and view all the flashcards

How to enter a number into a cell in Excel.

To enter a number into a cell, simply type the number and press Enter. This will store the value in the cell.

Signup and view all the flashcards

How to enter a formula into a cell in Excel.

To enter a formula in Excel, begin by typing the equal sign (=). This tells Excel that you're entering a formula. Then, write the formula using cell references and operators (like +, -, *, /). Press Enter to calculate the result.

Signup and view all the flashcards

What are some common formulas in Excel?

Excel offers various formulas to automate common calculations. =SUM(X:Y) sums all values from cell X to cell Y. =AVERAGE(X:Y) calculates the average of values from cell X to cell Y. You can use other formulas like =COUNT, =VAR, and =STDEV, to count cells, calculate variance, and standard deviation respectively.

Signup and view all the flashcards

How do I fix a column or a row in a formula in Excel?

In formulas, you can fix a column or a row or both by adding dollar signs ($) before the column letter or row number or both.

Signup and view all the flashcards

Slide Layout

A pre-designed layout for a PowerPoint slide, offering placeholders for different content elements, like text or images.

Signup and view all the flashcards

Increase List Level Button

The tool allowing you to create an outline structure within your PowerPoint slide, using bullet points or numbered lists.

Signup and view all the flashcards

Decrease List Level Button

The tool used to decrease the indentation level of text, effectively moving text back to a higher level in an outline.

Signup and view all the flashcards

Two Content Layout

A feature that allows you to position text into two separate columns on a slide, creating a balanced layout.

Signup and view all the flashcards

Applying a Theme

The process of applying a pre-designed set of colors, fonts, and special effects to enhance the visual appeal of your PowerPoint presentation.

Signup and view all the flashcards

Theme

A set of colors, fonts, and special effects that provide cohesive visual styles for PowerPoint slides.

Signup and view all the flashcards

Pie Chart

A graphical representation used to display data in a circular format, where each slice represents a portion of the whole.

Signup and view all the flashcards

Shapes Window in Visio

A window within Visio software that provides users with various shapes and stencils to create visual diagrams.

Signup and view all the flashcards

Flowchart

A visual representation of data that shows relationships between different steps or processes.

Signup and view all the flashcards

Connector Tool

A tool in Visio that allows users to connect shapes together to create visual relationships or flows.

Signup and view all the flashcards

Drawing Page in Visio

The area on a Visio page where shapes can be arranged and connected to create visual representations.

Signup and view all the flashcards

Stencil in Visio

A collection of shapes designed for a particular purpose, such as flowcharts or network diagrams.

Signup and view all the flashcards

Bar Chart

A type of chart that displays data using bars of different lengths to represent the values of each category.

Signup and view all the flashcards

Flowchart Template in Visio

A category of templates in Visio software specifically designed for creating flowcharts.

Signup and view all the flashcards

More Shape Styles Button

A button that allows you to view more shape styles and format your shapes creatively.

Signup and view all the flashcards

Theme Shape Styles

A set of styles that you can apply to your shapes to change their appearance.

Signup and view all the flashcards

Sizing Handles

A tool to adjust the size of a shape by dragging its handles.

Signup and view all the flashcards

Rotation Icon

An icon used to rotate a shape to a specific angle.

Signup and view all the flashcards

Change Shape Button

The option to change the type of shape you're using.

Signup and view all the flashcards

Applying a Theme in PowerPoint

Applying a theme to your PowerPoint presentation changes the overall look and feel of your slides by modifying elements like colors, fonts, and background styles.

Signup and view all the flashcards

What is a PowerPoint Theme?

A theme is a pre-designed set of colors, fonts, and effects that you can apply to your PowerPoint slides, making them visually consistent and attractive.

Signup and view all the flashcards

Applying Themes to Specific Slides

You can apply a theme to all slides in your presentation or just to selected slides, customizing the look of specific sections.

Signup and view all the flashcards

Adding a Background in PowerPoint

Adding a background to your PowerPoint slides lets you enhance the visual appeal by adding images, textures, or colors to create a more engaging experience.

Signup and view all the flashcards

Starting a PowerPoint Slide Show

To start running your PowerPoint slide show, you can press F5, click the Slide Show tab and choose 'From Beginning', or click the Slide Show icon in the bottom-right corner.

Signup and view all the flashcards

Navigating a PowerPoint Slide Show

In a running slideshow, using the Right Arrow key, Enter key, Page Down key, or left click advances to the next slide, while using the Left Arrow key, Backspace key, Page Up key navigates to the previous slide. Pressing Esc ends the slideshow.

Signup and view all the flashcards

Formatting Tables in PowerPoint

PowerPoint allows you to format tables by manipulating columns, rows, cells, borders, colors, and even adding images and shadows.

Signup and view all the flashcards

Applying a Theme to All Slides

To apply a theme to all slides in your presentation, you can choose the Design tab and click the More button in the Themes group. Then, select the desired theme by clicking on it.

Signup and view all the flashcards

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

Mastering Navigation Commands in the Command Prompt
6 questions

Mastering Navigation Commands in the Command Prompt

LucrativeMagenta avatar
LucrativeMagenta
Introduction to Windows Operating System
10 questions

Introduction to Windows Operating System Quiz & Flashcards

CommendableDystopia avatar
CommendableDystopia
Explorador de archivos en Windows 10
10 questions

Explorador de archivos en Windows 10

NoteworthyManganese avatar
NoteworthyManganese
WINDOWSKShortcuts
10 questions

WINDOWSKShortcuts

SumptuousOliveTree avatar
SumptuousOliveTree
Use Quizgecko on...
Browser
Open
Browser
Browser