DCOUNT
DCOUNTA
DSUM
SUM
F1
F2
Ctrl+F1
Ctrl+F2
@
#
$
&
Insert charts
Run slide show
Define a consistent layout and formatting for all slides
Add animations to slides
Ctrl+Shift+ F5
Ctrl+Shift+V
Ctrl+Shift+B
Ctrl+Shift+F1
Match the Categories with Their Example
1 → B, 2 → A, 3 → D, 4 → C
1 → C, 2 → D, 3 → B, 4 → A
1 → D, 2 → C, 3 → E, 4 → F
1 → A, 2 → F, 3 → C, 4 → B
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
Two
Three
Four
Five
2 bits
4 bits
4 bytes
8 bits
Sorts data
Adjusts row/column size automatically
Creates formulas
Protects cells
Yes
No
Can Not Say
None of These
1KB
1MB
128 bytes
None of The Above
ALU
CU
Memory
Register
Barcode Reader
QR Scanner
NFC Device
MICR
RAM
Hard disk
ROM
Cache
Match the following types of memory with their characteristics.
A-1, B-2, C-3, D-4
A-2, B-3, C-4, D-1
A-4, B-1, C-2, D-3
A-3, B-4, C-1, D-2
A3
$A$3
A$3
$A3
Star
Tree
Bus
Tools menu
Insert menu
View menu
Edit menu
Ctrl and V
Ctrl and X
Ctrl and S
Ctrl and P
WordPad
Windows Defender
Google Chrome
Windows Media Player
F5
Shift + F5
Ctrl + F5
F4
To record physical stock transactions
To record manufacturing transactions
To calculate taxes
To manage employee salaries
Processor
Hard Drive
Media Playback
3D settings
Painting
Drawing
OMR
OCR
Optical storage
Magnetic storage
Volatile storage
Flash memory
Space bar
End key
Break key
Esc key
the slides appear
the items in the slide appear
the text looks
the slides look
LCD
USB
SSD
Land line
Dial up service
Digital subscriber line
Cable modem
End-user software
Utility software
Specific software
All of these
Text tool box
Drawing Tool
Auto shapes tool
Line Tool
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
Arrange the following computer technologies in the correct order from first generation to fifth generation:
1️⃣ Transistors
2️⃣ Vacuum Tubes
3️⃣ Artificial Intelligence (AI) & Quantum Computing
4️⃣ Microprocessors
5️⃣ Integrated Circuits (ICs)
2 → 1 → 5 → 4 → 3
1 → 2 → 4 → 5 → 3
5 → 4 → 3 → 2 → 1
2 → 4 → 1 → 5 → 3
To apply predefined templates and designs to slides
To animate objects and text within slides
To navigate between slides during a presentation
To create dynamic effects when transitioning between slides
Normal view
Outline view
Notes view
Slide shorter view
Track density
Height of the hard disk drive
Recording density
Number of plates
Adobe Photoshop
MS Paint
MS Word
MS Powerpoint
Slide Number
Notes
Images
Titles
System
Settings
This PC
Search
IP Address
URL
MAC Address
DNS Address
File menu
Information handling
Data sharing
Data distribution
Data processing
4 Bits
8 Bits
32 Bits
128 Bits
Ctrl+Shift+R
CTRL+S
CTRL+SHIFT+N
Alt+R
Sound Clips
Movie Clips
Both (A) & (B)
None of the above
1
1.5
2
2.5
Slide Layouts
Slide Transitions
Animation Effects
Date
Formula
Cell Value
All the above