suggestions/cca
1. CF (scroll down for the answers; given at the end of the page ) :
(2). Which of the following is NOT a characteristic of a computer? - a) Speed / b) Feeling / c) Accuracy / d) Diligence
(3). GIGO means: - a) Good In, Good Out / b) Garbage In, Garbage Out / c) Great Input, Great Output / d) Graphics In, Graphics Out
(4). Which generation of computers used Vacuum Tubes? - a) First / b) Second / c) Third / d) Fourth
(5). Microprocessor was invented in which generation? -a) Second / b) Third / c) Fourth / d) Fifth
(6). Which is the fastest and most expensive type of computer? -a) Mainframe / b) Minicomputer / c) Microcomputer / d) Supercomputer
(7). A computer designed for a single user is called: - a) Mainframe / b) Minicomputer / c) Microcomputer / d) Supercomputer
(8). Which device is used to enter data and instructions? - a) Monitor / b) Printer / c) Keyboard / d) Speaker
(9). What does CPU stand for? - a) Central Processing Unit / b) Computer Personal Unit / c) Central Program Unit / d) Control Processing Unit
(10). Which part of the CPU performs arithmetic and logical comparisons? - a) CU / b) Register / c) ALU / d) Cache
(11). RAM is a _______ memory. - a) Non-volatile / b) Permanent / c) Volatile / d) Read-only
(12). Which memory stores the BIOS/boot instructions? - a) RAM / b) ROM / c) HDD / d) SSD
(13). 1 KB is equal to: - a) 1000 Bytes / ) 1024 Bytes / c) 1000 Bits / d) 1024 Bits
(14). Which of the following is an impact printer? - a) Inkjet / b) Laser / c) Dot Matrix / d) Thermal
(15). The mouse was invented by: - a) Charles Babbage/ b) Douglas Engelbart / c) Bill Gates / d) Steve Jobs
(16). What does OS stand for? - a) Operating Software / b) Output System / c) Operating System / d) Open Source
(17). Which is not an operating system? - a) Windows / b) Linux / c) MS Word / d) Android
(18). Which software helps protect against viruses? -a) Word processor / b) Antivirus / c) Spreadsheet / d) Browser
(19). What does ALU stand for? - a) Arithmetic Logic Unit / b) Automatic Logic Unit / c) Arithmetic Local Unit d) Address Logic Unit
(20). Which of the following is an example of general-purpose application software? - a) Hospital Management / b) Tally c) MS Excel / d) ATM software
(21). VLSI stands for: - a) Very Large Scale Integration / b) Very Low Scale Integration / c) Vertical Large System Integration / d) Variable Logic System Interface
(22). Which key is typically used for Refresh? - a) F1 / b) F3 / c) F5 / d) F12
(23). A printer that produces the best quality and is fastest for offices is:- a) Dot Matrix / b) Inkjet / c) Laser / d) Daisy Wheel
(24). Which of the following is a mobile operating system by Apple? - a) Android / b) Windows / c) iOS / d) Chrome OS
(25). What is the function of the Control Unit (CU)? - a) Performs calculations / b) Stores data permanently c) Directs all operations d) Displays output
(26). ENIAC was an example of which generation? - a) First / b) Second / c) Third d) Fourth
(27). An ECG machine is an example of which type of computer by technology? -a) Analog / b) Digital / c) Hybrid / d) Special purpose
(28). Which storage device is the fastest? - a) HDD / b) Pen Drive /c) SSD / d) Cloud
(29). Which of the following is an input device for capturing live video? - a) Scanner / b) Microphone / c) Webcam / d) Plotter
(30). The temporary high-speed memory inside the CPU is called: - a) RAM / b) ROM / c) Cache / d) Register
(31). India's supercomputer PARAM is an example of which type by size? - a) Mainframe / b) Minicomputer / c) Supercomputer / d) Microcomputer
(32). GUI stands for: - a) Graphical User Interface / b) General User Interface / c) Graphic Unit Input / d) Global User Integration
(33). Which of the following is not a function of an OS? - a) Memory Management / b) Printing documents / c) Process Management / d) File Management
(34). What type of software is a disk defragmenter? - a) Application / b) Utility / c) Operating System / d) Custom
(35). Which memory is non-volatile and can be erased and reprogrammed multiple times? - a) ROM / b) PROM / c) EPROM / d) RAM
(36). The resolution of a monitor is measured in: - a) Bytes / b) Hertz / c) Pixels / d) DPI
(37). Which of the following is not hardware? - a) CPU / b) Windows 11 / c) Mouse / d) Scanner
(38). A barcode reader is used in: - a) Schools / b) Hospitals for surgery / c) Shopping malls/billing / d) Weather forecasting
(39). The characteristic "Versatility" means: a) Computer never gets tired / b) Computer can do different types of work / c) Computer is very fast / d) Computer has no IQ
(40). Which generation introduced AI and parallel processing? - a) Third / b) Fourth / c) Fifth / d) Second
(41). What does "P" in IPOS cycle stand for? - a) Program / b) Procedure / c) Processing / d) Peripheral
(42). Which printer uses toner powder? - a) Inkjet / b) Dot matrix / c) Laser d) Thermal
(43). Which of the following is a cloud-based OS by Google? - a) Android / b) iOS / c) Chrome OS / d) Linux
(44). The speed of a computer is measured in:- a) Pixels / b) GB / c) GHz / d) DPI
(45). Which of the following is NOT a secondary storage device? - a) HDD / b) RAM / c) Pen drive / d) SSD
(46). The UNIVAC belongs to which generation? - a) 1st / b) 2nd / c) 3rd / d) 4th
(47). Which device converts physical documents to digital images? - a) Webcam / b) Microphone / c) Scanner / d) Plotter
(48). What is the full form of BIOS? - a) Basic Input Output System / b) Binary Input Output System / c) Basic Internal Operating System / d) Built-in Operating System
(49). Which type of software is Tally? - a) General purpose / b) Custom/Specific purpose / c) System software / d) Utility
(50). The complete computer system consists of Hardware, Software, Data, and: - a) Network / b) User / c) Internet / d) CPU ]
2. T/F [ Command prompt:
A-Internal Commands (DIR, MD, COPY,
DEL, etc.):
1-The DIR command displays a
list of files and subdirectories, 2-MD and MKDIR are used to
delete a directory, 3-The CD command changes the current directory, 4-COPY command
is used to move files from one location to another, 5-DEL command deletes
one or more files, 6-ATTRIB command displays or changes file attributes, 7-CACLS is
used to display or modify access control lists (ACLs) of files, 8-CHDIR and CD are
different commands with different functions, 9 - REN and RENAME both
rename files, 10-REPLACE command is used to delete old files, 11-RMDIR removes
a directory, 12-The TREE command displays the contents of a text file,
13-TYPE command displays the contents of a text file, 14-XCOPY copies
only files, not directory trees,
15-ERASE and DEL both delete files, 16- FC compares two files and displays differences, 17- FIND searches for a text string in a file, 18- FINDSTR is used to delete strings in files, 19- FOR runs a command for each file in a set of files, 20- MOVE moves files from one directory to another, 21- OPENFILES displays files opened by local users only, 22- PATH displays or sets a search path for executable files, 23- PAUSE command terminates a batch file immediately, 24- RD is an alternative to RMDIR, // B-External Commands (CLS, DATE, TIME, FORMAT, etc.): 25- CLS is an external command that clears the screen, 26- The DATE command displays or sets the system date, 27- TIME command displays or sets the system time, 28- VER displays the Windows version, 29- VOL displays a disk volume label and serial number, 30-ASSOC displays or modifies file extension associations, 31- CHKDSK checks a disk and displays a status report, 32- CMD command closes the command interpreter, 33- The COLOR command sets console foreground and background colors, 34- COMPACT displays or alters compression of files on FAT partitions only, 35- CONVERT converts NTFS volumes to FAT, 36- DISKPART displays or configures Disk Partition properties, 37- DOSKEY edits command lines and creates macros, 38- COMP compares the contents of two files or sets of files, 39- DRIVERQUERY displays current device driver status, 40- ECHO command turns command echoing on or off, 41- EXIT quits the CMD.EXE command interpreter, 42- TASKLIST displays all currently running tasks including services, 43- TASKKILL is used to start a new process. 44- FORMAT formats a disk for use with Windows, 45- FTYPE displays or modifies file types in file extension associations, 46- IF performs conditional processing in batch programs, 47- LABEL creates, changes, or deletes the volume label of a disk, 48- MORE displays output all at once without pausing, 49- SHUTDOWN allows proper local or remote shutdown of a machine, 50- SYSTEMINFO displays machine specific properties and configuration]
3. Windows: // [Desktop, Start Menu & Taskbar (Questions 1-8)
Q1. What
are the 9 Desktop elements listed in the text?
A1. Desktop, Desktop Icons, Wallpaper, Taskbar, Start Button,
Search Box, Task View, Notification Center, System Tray.
Q2. How
do you change the wallpaper in Windows 11?
A2. Right-click Desktop → Personalize.
Q3. What
is the keyboard shortcut to open the Start Menu?
A3. Press the Win key.
Q4. How
do you open Settings from the keyboard?
A4. Press Win + I.
Q5. How
can you pin an app to the Start Menu?
A5. Right-click the app → Pin to Start.
Q6. What
are the two Taskbar alignment options in Windows 11?
A6. Left or Center (default is Center).
Q7. What
is the keyboard shortcut to show the desktop?
A7. Win + D (or click the far-right thin vertical line on the
taskbar).
Q8. How
do you open Task View?
A8. Press Win + Tab.
File
Explorer & File Management (Questions 9-18)
Q9. What
is the fastest way to open File Explorer?
A9. Press Win + E.
Q10. Name
the 4 sections in File Explorer structure.
A10. Quick Access, OneDrive, This PC, Network.
Q11. What
is the keyboard shortcut to create a new folder?
A11. Ctrl + Shift + N.
Q12. Which
7 characters are NOT allowed in file/folder names?
A12. \ / : * ? " < > |
Q13. What
are the 3 methods to rename a file?
A13. (1) Slow double-click, (2) Right-click → Rename, (3) Select →
press F2.
Q14. How
do you select multiple non-adjacent files?
A14. Hold Ctrl and click each item.
Q15. What
is the keyboard shortcut for Copy, Cut, and Paste?
A15. Copy = Ctrl + C, Cut = Ctrl + X, Paste = Ctrl +
V.
Q16. How
do you permanently delete a file without sending it to Recycle Bin?
A16. Select the file → press Shift + Delete.
Q17. How
do you restore a file from Recycle Bin?
A17. Open Recycle Bin → Right-click item → Restore.
Q18. What
are the 4 ways to sort files in File Explorer?
A18. By Name, Date, Size, or Type.
Settings,
Display, Audio & Date/Time (Questions 19-24)
Q19. What
is the difference between Windows Settings and Control Panel?
A19. Settings is modern/touch-friendly for daily settings; Control
Panel is traditional/detailed for advanced system settings.
Q20. What
is the recommended display resolution for standard laptops/monitors?
A20. 1920×1080 (Full HD / 1080p).
Q21. What
are the 4 display shortcuts mentioned?
A21. (1) Ctrl + Alt + ↓ (rotate upside down),
(2) Ctrl + Alt + ↑ (normal), (3) Win + P (project options),
(4) Win + Ctrl + C (color filters).
Q22. How
do you open Volume Mixer?
A22. Right-click speaker icon on taskbar → Open Volume mixer.
Q23. What
are the recommended settings for time and time zone?
A23. "Set time automatically" = ON, "Set time zone
automatically" = ON.
Q24. How
do you add clocks for different time zones?
A24. Settings → Time & language → Date & time → Related
links → Add clocks for different time zones.
Device
Manager & Drivers (Questions 25-29)
Q25. What
is a device driver?
A25. Software that allows Windows to communicate with hardware
devices (printer, graphics card, mouse, etc.).
Q26. What
are the 3 methods to open Device Manager?
A26. (1) Right-click Start (Win + X) → Device Manager, (2) Search
"Device Manager" in Start, (3) Win +
R → devmgmt.msc → Enter.
Q27. What
does a yellow exclamation mark (⚠) icon indicate in Device
Manager?
A27. Driver problem (update needed).
Q28. What
are the 4 safe sources to get drivers?
A28. (1) Windows Update, (2) Manufacturer website, (3) Device
Manager Update, (4) NOT third-party updaters (often malware).
Q29. What
is the rule for downloading drivers?
A29. Only download drivers from official manufacturer websites
(Dell, HP, Lenovo, NVIDIA, Intel, AMD).
Programs
& OneDrive (Questions 30-33)
Q30. How
do you uninstall a program using Settings?
A30. Win + I → Apps → Installed apps → Search for program →
Click three dots (⋮) → Uninstall → Confirm.
Q31. What
are the 3 safe software sources mentioned?
A31. (1) Microsoft Store, (2) Official developer website, (3)
Reputable download sites (Ninite, FileHippo).
Q32. What
is OneDrive?
A32. Microsoft's cloud storage service, included with Microsoft
account (5 GB free), syncs files across devices.
Q33. Which
3 folders can OneDrive back up?
A33. Desktop, Documents, Pictures folders.
Microsoft
Edge (Questions 34-38)
Q34. When
was Internet Explorer retired?
A34. June 15, 2022.
Q35. What
is the keyboard shortcut for a new tab in Edge?
A35. Ctrl + T.
Q36. How
do you reopen a closed tab in Edge?
A36. Ctrl + Shift + T.
Q37. What
is the shortcut to bookmark the current page?
A37. Ctrl + D (or click the star icon).
Q38. What
keyboard shortcut opens InPrivate browsing?
A38. Ctrl + Shift + N.
Paint with
AI (Questions 39-43)
Q39. What
is Microsoft Paint?
A39. Basic image editing app included in Windows, originally from
Windows 1.0 (1985), now includes AI features via Co-creator.
Q40. How
do you open Paint using Run?
A40. Win + R → type MS Paint → Enter.
Q41. What
are the minimum requirements for AI features in Paint?
A41. (1) Copilot+ PC (with NPU), (2) Latest Paint version, (3)
Signed in with Microsoft account, (4) Internet connection.
Q42. Which
AI feature in Paint works on ANY PC (does not require Copilot+ PC)?
A42. Background Removal.
Q43. How
many free Co-creator credits do you get to start?
A43. 50 free credits (each generation uses 1 credit).
Notepad with
AI (Questions 44-47)
Q44. What
type of files does Notepad create?
A44. Plain text files with .txt extension (no formatting
– just raw text).
Q45. What
are the 3 AI features in Notepad (on Copilot+ PCs)?
A45. Summarize, Write, Rewrite.
Q46. What
is the keyboard shortcut to insert current time and date in Notepad?
A46. F5.
Q47. How
do you create a table in Notepad?
A47. Use Markdown syntax (e.g., | Column1 | Column2 |) OR
Right-click → Insert → Table.
Accessibility,
Tools & Shortcuts (Questions 48-50)
Q48. How
do you open Magnifier, and how do you close it?
A48. Open: Win + + (plus key). Close: Win + Esc.
Q49. What
are the 4 Snap Layout shortcuts?
A49. (1) Win + ← (left half), (2) Win +
→ (right half), (3) Win + ↑ (maximize/top half), (4) Win +
↓ (minimize/bottom half). Win + Z opens Snap Layouts menu.
Q50. What
are the two Reset This PC options and when to use them?
A50. (1) "Keep my files" – Windows reinstalls, apps
removed, personal files kept (for slow computer/software issues). (2)
"Remove everything" – Clean Windows installation (for selling
computer or major problems)]
4. html :
[General HTML & Basics (Questions 1-6)- HTML
stands for Hyper Text Markup Language.
- To
create a simple web page, you need specialized paid software like Adobe
Dreamweaver.
- An
HTML file must be saved with the extension .html or .htm.
- The
shortcut key to refresh a web page after editing is F1.
- A web
browser (like Chrome, Edge, or Firefox) is needed to preview HTML files.
- XML is
the primary language used for basic web design according to the
text.
Document Structure Tags (Questions 7-12)
- The <!DOCTYPE
html> declaration declares the document as HTML4.
- The <html> tag
is the root element that wraps all HTML content.
- The <head> tag
contains all visible page content.
- The <title> tag
sets the browser tab title.
- The <body> tag
contains meta-information about the page like CSS.
- The
complete HTML document template includes <meta
charset="UTF-8"> in the head section. )
Text Formatting Tags (Questions 13-22)
- <h1> is
the smallest heading tag and <h6> is the largest.
- The <p> tag
creates a paragraph of text.
- <br> is
a self-closing tag that creates a line break.
- <strong> and <b> both
create bold text, but <strong> indicates importance.
- <em> and <i> both
create italic text, but <em> indicates emphasis.
- The <mark> tag
is used to strikethrough text.
- The <del> tag
displays underlined text.
- <hr> creates
a horizontal rule (divider line).
- The <small> tag
makes text larger than normal.
- The
output of <del>$100</del> $80 shows as ~~$100~~
$80.
List Tags (Questions 23-26)
- <ul> creates
an unordered list with numbers.
- <ol> creates
an ordered list with bullets.
- The <li> tag
defines a list item inside <ul> or <ol>.
- <dl>, <dt>,
and <dd> are used to create definition lists.
Link and Navigation Tags (Questions 27-30)
- The <a> tag
is used to create hyperlinks (anchors).
- To
open a link in a new tab, you use target="_self".
- An
email link is created
using href="mailto:name@email.com".
- The <nav> tag
is a container for navigation links.
Image and Media Tags (Questions 31-33)
- The <img> tag
is used to display images and does not require a closing tag.
- The alt attribute
in an <img> tag is optional and not important for
accessibility.
- The <video> tag
can embed video players using the <source> tag.
Table Tags (Questions 34-37)
- <table> creates
a table.
- <tr> defines
a table header cell (bold by default).
- <tr> defines
a table data cell.
- The
table example shows border="0" creates visible
borders.
Form and Input Tags (Questions 38-44)
- The <form> tag
is a container for user input fields.
- <input
type="password"> displays typed characters as hidden
dots.
- <input
type="checkbox"> allows single selection only.
- <input
type="radio"> with the same name attribute
allows multiple selections.
- <textarea> creates
a multi-line text input.
- The <button> tag
creates a clickable button.
- The <label> tag
is used to label form fields and uses the for attribute to link
to an input's id.
Structural, Semantic & Special Tags (Questions 45-48)
- <div> is
a generic block container.
- <span> is
a generic inline container.
- <footer> and <header> are
semantic tags that should be used instead of
generic <div> when possible.
- The <pre> tag
ignores spaces and line breaks.
HTML Entities & Interactive Tags (Questions 49-50)
- © displays the copyright symbol (©).
- 50. The <details> and <summary> tags create collapsible content containers. ]
5.1. HN Layout :
5.1.1. T/F [ ]5.1.2. Fill the blanks [ ]
5.1.3. Multiple choice []
5.1.4. Multiple answer questions []
5.1.5. Match the following []
5.1.6. Short answer []
5.1.7. Identify Picture []
5.1.8. Drag-n-drop []
- The Ribbon is the band at the top of the Word window.
- The Dialog Launcher is a large square arrow in the top left corner of a group.
- The "Insert" tab contains groups such as Pages, Tables, and Illustrations.
- The Font group contains the Styles and Editing commands.
- Clicking the Dialog Launcher in the Font group opens advanced font settings.
PART 2: The Home Tab – Clipboard Group (Questions 6-9)
- The keyboard shortcut for Paste is Ctrl + V.
- Cut removes selected text and saves it to the clipboard using Ctrl + C.
- Format Painter copies the format of selected text and applies it to another section. Double-clicking locks it to apply multiple times.
- The shortcut for Format Painter is Ctrl + Shift + C (copy format) and Ctrl + Shift + V
PART 2: The Home Tab – Font Group (Questions 10-15)
- The keyboard shortcut for Bold is Ctrl + B.
- Subscript (e.g., H₂O) uses the shortcut Ctrl + Shift + =.
- Clear All Formatting resets text to the default "Normal" style using Ctrl + Space.
- Underline has dropdown options including double and dotted lines.
- Strikethrough draws a line through selected text.
- Text Highlight Color typically marks text with yellow like a marker pen.
PART 2: The Home Tab – Paragraph Group (Questions 16-22)
- Bullets and Numbering are found in the Paragraph group.
- The keyboard shortcut for Center alignment is Ctrl + R.
- Justify alignment spreads text evenly between both margins using Ctrl + J.
- Single line spacing shortcut is Ctrl + 1, and Double line spacing is Ctrl + 2.
- The Show/Hide button (¶) reveals hidden formatting characters like spaces, tabs, and paragraph marks.
- The shortcut to show/hide formatting marks is Ctrl + Shift + 8.
- Decrease/Increase Indent shortcuts are Ctrl + M (increase) and Shift + Ctrl + M (decrease).
PART 3: The Insert Tab (Questions 23-27)
- The Illustrations group includes Pictures, Shapes, Icons, 3D Models, SmartArt, and Chart.
- SmartArt is used for visual representation of information like lists, processes, and hierarchies.
- Headers appear at the bottom of every page.
- Page Numbers can be inserted from the Header & Footer group on the Insert tab.
- 3D Models can be inserted and rotated within a Word document.
PART 4: The Design & Page Layout Tabs (Questions 28-32)
- Themes are a set of coordinated colors, fonts, and effects that update the whole document instantly.
- A Watermark inserts faint text like "CONFIDENTIAL" or "DRAFT" behind document content.
- Normal margins are set to 0.5 inches.
- Orientation can be Portrait (Tall) or Landscape (Wide).
- Section Breaks allow different formatting (headers/margins) within the same document.
PART 5: The References Tab (Questions 33-36)
- Word generates a Table of Contents automatically based on Heading Styles (Heading 1, Heading 2).
- The Bibliography generates the "Works Cited" page at the end of a document.
- Citation styles available include APA 7th, MLA, and Chicago.
- The shortcut for inserting a footnote is Ctrl + Alt + F.
PART 6: The Mailings Tab (Questions 37-39)
- Mail Merge combines a Main Document (Letter) + Data Source (Excel List) to create personalized copies.
- Insert Merge Field places markers like «First_Name» in the letter.
- Finish & Merge is the step that prints or emails the individualized letters.
PART 7: The Review Tab (Questions 40-43)
- The keyboard shortcut for Spelling & Grammar check is F7.
- Thesaurus finds synonyms for selected words using Shift + F7.
- Track Changes records every deletion, addition, or formatting change, and the author can later Accept or Reject changes.
- New Comment adds a note in the margin without changing the text.
PART 8: Advanced & AI Tools (Copilot) (Questions 44-47)
- Copilot (Draft with Copilot) generates text based on a description you provide.
- Copilot cannot change the tone of selected text (e.g., make it "More Professional").
- Summarize allows Copilot to read long documents and generate a summary bullet list.
- After Copilot generates content, you can click "Keep It" to insert it into the document.
Shortcuts & Final Capstone (Questions 48-50)
- The keyboard shortcut for Save As is F12.
- Manual Page Break shortcut is Ctrl + Shift + Enter.
- The keyboard shortcut for Find & Replace is Ctrl + H. ]
7. Excel :
PART 1:
Excel Interface & Basic Navigation
- The Name Box is located to the right of the Formula
Bar and displays the active cell's formula.
- Column headers are identified by letters (A, B, C...)
and row headers by numbers (1, 2, 3...).
- The keyboard shortcut to switch between open
workbooks is Alt + Tab.
- Ctrl + Home moves the cursor to the last used cell in
the worksheet.
- The Quick Access Toolbar is located above the ribbon
and contains customizable shortcut buttons like Save, Undo, and
Redo.
- Sheet tabs are located at the bottom-left of the
Excel window and allow navigation between worksheets.
- The
shortcut to insert today's date is Ctrl + Shift + ; (semicolon).
PART 2: Home
Tab – Clipboard & Font Groups
- Format Painter copies formatting and can be locked
for multiple applications by double-clicking it.
- Paste Special options include Formulas, Values,
Formats, and Transpose (switches rows to columns).
- The keyboard shortcut for double underline is Ctrl +
Shift + D.
- Fill Color (bucket icon) changes the color of the
text, not the cell background.
- The shortcut for Bold is Ctrl + B, for Italic is Ctrl
+ I, and for Underline is Ctrl + U.
- Increase
Font Size shortcut is Ctrl + Shift + < (less than).
PART 2: Home
Tab – Alignment & Number Groups
- Center alignment horizontally uses the shortcut Ctrl
+ E.
- Merge Across merges all selected cells into one
single cell and centers the content.
- Wrap Text (shortcut Alt + H + W) makes text wrap
within a cell without changing column width.
- The shortcut for Currency format is Ctrl + Shift + 4
($).
- Percentage
format shortcut is Ctrl + Shift + 5 (%).
PART 2: Home
Tab – Styles, Cells & Editing Groups
- Conditional Formatting includes Highlight Cell Rules,
Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets.
- The shortcut to insert cells, rows, or columns is
Ctrl + - (minus).
- AutoSum shortcut is Alt + = (equals sign).
- The Fill Down shortcut is Ctrl + D, and Fill Right is
Ctrl + R.
- Sort
& Filter can be applied using the shortcut Ctrl + Shift + L.
PART 3:
Insert Tab – Tables, Charts & Sparklines
- The shortcut to create a formatted table is Ctrl +
T.
- Table benefits include automatic formatting, filter
dropdowns, automatically expanding ranges, and structured references in
formulas.
- A Pie chart is best used for showing trends over
time.
- Sparklines are mini charts that are placed inside a
single cell.
- Sparklines have three types: Line, Column, and
Win/Loss.
- A PivotTable is created using Insert tab → PivotTable
(or Alt + N + V).
- Slicers
can be added from the PivotTable Analyze tab to filter data
interactively.
PART 4: Page
Layout Tab
- Normal margins are set to 1 inch on all sides.
- Landscape orientation makes the page wider than tall,
which is useful for tables and charts.
- Print Area is set by selecting a range and clicking
Page Layout → Print Area → Set Print Area.
- To repeat header rows on every printed page, use Page
Layout → Print Titles → Rows to repeat at top.
- The
Scale to Fit options allow shrinking a worksheet to fit on one page, but
scaling below 70% may become unreadable.
PART 5:
Formulas Tab – Functions
- The SUM function adds numbers, and AVERAGE calculates
the mean.
- The IF function follows the syntax: =IF(condition,
value_if_true, value_if_false).
- VLOOKUP searches for a value in the first column of a
table and returns a value from the same row in a specified column.
- XLOOKUP is only available in older versions of Excel
before 2019.
- COUNTIF counts cells that meet a condition, and SUMIF
adds cells that meet a condition.
- DATEDIF calculates the difference between two dates
and can return years ("Y"), months ("M"), or days
("D").
- The TODAY() function returns the current date and
time.
- Formula
Auditing tools include Trace Precedents, Trace Dependents, and Show
Formulas (Ctrl + ~).
PART 6: Data
Tab
- Text to Columns (Alt + D + E) can split a single
column into multiple columns using delimiters like commas or spaces.
- Flash Fill (Ctrl + E) automatically fills data based
on a pattern you demonstrate.
- Remove Duplicates keeps the first occurrence of a
duplicate and deletes subsequent ones.
- Data
Validation can create drop-down lists, restrict numbers to a range, or
require a specific text length.
PART 7:
Review & View Tabs
- Protect Sheet locks the worksheet; users can only
edit unlocked cells (cells with Protection → Locked unchecked).
- Freeze Panes keeps specified rows and/or columns visible while scrolling; options include Freeze Top Row, Freeze First Column, and Freeze Panes (both).
- The shortcut for Spell Check is F7.
8. Power Point:
PART 1: Home
Tab (Questions 1-10)
- The keyboard shortcut for a new slide is Ctrl +
M.
- Format Painter can be used for single use by clicking
it once, or for multiple uses by double-clicking it.
- Sections in PowerPoint allow you to collapse/expand
groups of slides, reorder entire sections at once, and print specific
sections only.
- The keyboard shortcut to decrease font size is Ctrl +
Shift + > (greater than).
- The Change Case command (Shift + F3) can change text
to UPPER, lower, Title Case, and Sentence case.
- The keyboard shortcut for bullets is Ctrl + Shift +
L.
- To demote a list item (increase indent), press Shift
+ Tab.
- The Justify alignment (Ctrl + J) makes text evenly
spread between left and right margins.
- The Drawing group includes Shape Fill, Shape Outline,
Shape Effects, and Quick Styles.
- The
keyboard shortcut for Find is Ctrl + H, and for Replace is Ctrl + F
PART 2:
Insert Tab (Questions 11-20)
- SmartArt types include List, Process, Cycle,
Hierarchy, Relationship, Matrix, and Pyramid.
- 3D Models inserted into PowerPoint can be rotated in
all directions using the rotation handle (circular arrow).
- The Morph transition is available in all versions of
PowerPoint including PowerPoint 2010.
- The keyboard shortcut for inserting a hyperlink is
Ctrl + K.
- Screen Recording can be inserted from Insert → Media
→ Screen Recording.
- Audio can be set to "Play in Background"
which will play music across multiple slides.
- The keyboard shortcut for a new comment is Ctrl + Alt
+ M.
- Header & Footer can add slide numbers, date, and
footer text to all slides at once.
- The Equation editor shortcut is Alt + = (equals
sign).
- Online
Pictures can be searched and inserted directly from the Insert tab using
Alt + N + F.
PART 3:
Design & Transitions (Questions 21-30)
- The default slide size for modern presentations is
Standard (4:3).
- The Morph transition can animate position, size,
rotation, color, transparency, and even 3D model rotation between two
slides.
- For business presentations, it is recommended to use
transitions from the "Exciting" category like Curtains and
Ferris Wheel.
- The keyboard shortcut to start a slideshow from the
current slide is Shift + F5.
- The recommended transition duration for business
presentations is between 0.50 and 1.00 seconds.
- Animation types are divided into four categories:
Entrance, Emphasis, Exit, and Motion Paths.
- The Animation Pane allows you to reorder animations
and adjust timing (Start, Duration, Delay).
- "Start: With Previous" means the animation
waits for a mouse click before starting.
- The recommended delay between bullet points in an
animation sequence is 0.25 seconds.
- The
keyboard shortcut F5 starts the slideshow from the beginning.
PART 4:
Slide Show & Review Tabs (Questions 31-38)
- During a slideshow, pressing B displays a black
screen, and pressing W displays a white screen.
- The keyboard shortcut to jump to a specific slide
during a slideshow is typing the slide number followed by Enter.
- Rehearse Timings records how long you spend on each
slide and saves those timings for auto-advance.
- Presenter View shows speaker notes, a timer, and the
next slide on the presenter's screen only.
- The keyboard shortcut for Spell Check is F7, and for
Thesaurus is Shift + F7.
- Hide Slide removes the slide completely from the
presentation file.
- Compare allows you to compare your current
presentation with another version and accept or reject changes.
- Custom
Slide Show allows you to create a subset of slides for specific audiences
without deleting the original slides.
PART 5: View
Tab & Slide Master (Questions 39-44)
- Slide Sorter view (Alt + V + D) shows thumbnails of
all slides and allows reordering and adding sections.
- The keyboard shortcut to toggle guides is Alt +
F9.
- In Slide Master, changes made to the top-most master
slide affect ALL slides in the presentation.
- To add a company logo to every slide, you should
insert the logo on an individual slide and copy-paste it to each
slide.
- The shortcut Shift + F9 toggles gridlines.
- Notes
Page view (Alt + V + P) shows one slide with a notes area below for
printing speaker notes.
PART 6:
Drawing Tools, File Tab & Capstone (Questions 45-50)
- Ink to Shape converts a hand-drawn rough shape (like
a circle or arrow) into a perfect shape.
- The Protect Presentation option "Mark as
Final" is a security feature that permanently prevents anyone from
editing the file.
- To create a video (MP4) from a presentation, use File
→ Export → Create Video.
- The Tell Me feature (Alt + Q) allows you to search
for commands by typing natural language like "add a
picture".
- In the capstone Business Pitch Deck project, a Pie
chart is required for the Market Size slide.
- The recommended handouts print layout for audience
members is 6 slides per page.
9. Cyber security :
9.1. T/F [Network Basics (Questions 1-4)- A network is defined as two or more computers
connected to share data or resources.
- LAN (Local Area Network) typically covers a city-wide
area.
- WAN (Wide Area Network) is the largest type of
network, and the Internet is the largest example of a WAN.
- PAN (Personal Area Network) has a range of
approximately 10 meters, with Bluetooth as an example.
Internet
Devices (Questions 5-6)
- A router converts ISP signals to internet (analog ↔
digital).
- A repeater amplifies signals to extend network
range.
Mobile
Networks (Questions 7-8)
- 5G networks offer speeds up to approximately 100
Mbps.
- 1G networks provided analog voice only (no data).
Internet
Terms & Protocols (Questions 9-11)
- URL stands for Uniform Resource Locator, and its
structure is Protocol://Domain/Path?Query.
- IPv4 uses 128-bit addressing, while IPv6 uses 32-bit
addressing.
- HTTPS stands for HTTP Secure and provides encrypted
web traffic (indicated by a lock icon).
Cyber
Threats (Questions 12-15)
- A worm requires user action to spread, such as
opening an infected file.
- Ransomware encrypts files and demands payment for
decryption; WannaCry (2017) is a famous example.
- A keylogger secretly monitors user activity but does
not record keystrokes.
- The first PC virus was called "Creeper"
(1971).
Protection
& Safety (Questions 16-18)
- A strong password should have a minimum of 8
characters with only lowercase letters.
- The 3-2-1 backup rule means: 3 copies, 2 media types,
1 offsite.
- You should never share OTP (One-Time Password) with
anyone.
Cyber Laws
& Miscellaneous (Questions 19-20)
- The primary cyber law of India is the IT Act
2000.
- 95% of cyber breaches are caused by technical software flaws, not human error. ]
9.3. Multiple choice []
9.4. Multiple answer questions []
9.5. Match the following []
9.6. Short answer []
9.7. Identify Picture []
9.8. Drag-n-drop []
Comments
Post a Comment