Information Technology Questions and Answers

academic
285 resources

Find Information Technology questions and answers with clear, step-by-step explanations to help you understand technical concepts and improve exam performance. These solutions cover topics commonly included in coursework and technical assessments.

Browse IT practice questions covering areas such as programming logic, database queries, networking concepts, and system operations. Each answer explains both the concept and the reasoning behind the solution.

These resources are useful for assignments, exam preparation, and strengthening problem-solving skills. You can also explore study notes and materials for deeper explanations, or use flashcards to reinforce key concepts.

Question:

A group of biotechnology students is planning a “Plant Growth Observation Activity” as part of their introductory biology course. They will grow simple plants (such as mint, beans, mustard, or green peas) and record basic observations such as height, number of leaves, watering schedule, and growth status. Your task is to apply Microsoft Excel, Word, and PowerPoint to help students record, document, and present their plant growth observations. Complete all tasks in Parts A, B, and C (this is ONE single question). 🌱 PART A — Excel: Plant Growth Observation Sheet Create a basic Plant Growth Tracker in Microsoft Excel. 1. Create a simple data table Include at least 5 plants, with columns:  Plant Name (e.g., Mint, Bean Plant, Aloe Vera, etc.)  Date Planted  Height (cm)  Watering Status (Daily / Alternate Day / Twice a Week)  Growth Status (Growing / No Change / Wilting) 2. Data Validation (Required) Apply Data Validation to:  Watering Status column → Three options only  Growth Status column → Three options only Add:  An Input Message  An Error Alert 3. Use simple formulas Insert formulas such as:  AVERAGE() → average plant height  MIN() and MAX() → shortest and tallest plant  IF() → e.g., =IF(C2>10,"Healthy","Needs Attention") 4. Record a simple macro Record a macro named FormatPlantSheet that:  Applies borders to the whole table  Auto-fits columns Assign the macro to a button or shape. Submission Requirements  Screenshots: o Data Validation window o Formula Bar o Macro recording window o Button triggering the macro  Submit the Excel file 🍃 PART B — Word: Plant Growth Observation Report (C-3 Application) Prepare a 1–2 page simple report using Microsoft Word. The report should include: 1. A small table Summarize the plant names and their current height. 2. One picture Insert a picture of any plant (real or downloaded). Apply:  Tight text wrapping  Alt Text  Caption 3. Basic formatting Include:  A Header with your name  A Footer with page number  One paragraph describing the plant growth activity  Use of line spacing or alignment formatting Submission Requirements Screenshots showing:  Alt Text panel  Caption dialog  Ribbon showing formatting Submit the Word file. 🌻 PART C — PowerPoint: Present the Plant Growth Activity (C-3 Application) Create a 4-slide basic PowerPoint presentation describing the plant observation activity. Required Slides: 1. Title Slide 2. Slide showing a picture of one plant + short description 3. Slide explaining what information was recorded in Excel 4. Slide explaining how Word helps document the activity Technical Requirements:  Apply one theme  Apply one variant  Add one slide transition  Add one animation  Add a small logo (any leaf or plant icon) using Slide Master Submission Requirements:  Screenshot of Slide Master  Screenshot of Animation Pane  Screenshot of Theme used  Submit the PPT file

...
Solution
Homework
5 months ago
View Answer
Question:

### What is the cause? You're nodding, but now hard shows into your network attached storage device. Your director asks that they be put into a RWD solution that offers redundancy over performance. #### Which would you use? - RWD 0 - RWD 1 - RWD 5 - RWD 6 - RWD 10 A Windows user is locked out of her computer, and you must log into the local administrator account HelpdeskAdmin. #### Which would you use in the username field? - iHelpdeskAdmin - iHelpdeskAdmin - iHelpdeskAdmin - HelpdeskAdmin - iHelpdeskAdmin ### What is the cause? - 55L certificate is invalid or self-signed - User needs to change the URL to http:// from https:// - Web server doesn't support HTTPS sites - Domain is improperly configured at the registrar - User's browser doesn't support secure websites The web development team is having difficulty connecting by SSH to your local web server, and you notice the proper rule is missing from the firewall. #### What port number would you open on your webserver? - 1et j1 - 1et j2 - 1et j3 - 1et j4 - 1et j5 1et j6 1et j7 1et j8 1et j9 Your internet is out, and devices connected by RIM (and ethernet will not connect. You check several websites, and all your packets list. You then ping a website with an IP address, and to your surprise, it's a success. #### Which would you do next? - Open the Network settings on your router and try turning off your firewall - Open the DNS settings on your router and try using a different DNS - Open the DHCP settings on your router and try using a different pool of private IP addresses - Open the Port Forwarding settings on your router and try turning on UPoP - Open the Network settings on your router and try adjusting the default gateway Your manager asks you to set up a secure network connection at a remote site to move over some backups. #### Which protocol would you use? - IP - SSH - SFTP - FTP - DHCP

...
Solution
Homework
11 months ago
View Answer
Showing 1 to 40 of 285 results