Lecture 3 Flashcards

1
Q

What is an operating system?

A

An interface between software and computer hardware that manages resources and operations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are examples of operating systems?

A

Windows, GNU/Linux, macOS, Android, and iOS.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is Windows used for?

A

A GUI-based operating system for PCs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is GNU/Linux used for?

A

Personal computers, workstations, servers, and client/server models.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is macOS used for?

A

Apple’s personal computers and workstations like MacBook and iMac.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is Android?

A

Google’s operating system for smartphones, tablets, and smartwatches.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is iOS?

A

Apple’s operating system for iPhone, iPad, and iPod Touch.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is resource management in an OS?

A

Manages hardware resources like CPU, memory, and I/O devices.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is process management in an OS?

A

Handles processes, allocating resources for smooth execution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is memory management in an OS?

A

Manages memory allocation and deallocation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is security in an OS?

A

Protects data and resources from unauthorized access.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is file management in an OS?

A

Handles file storage, retrieval, and organization.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is device management in an OS?

A

Coordinates input/output devices for smooth operation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is networking in an OS?

A

Facilitates communication between connected devices.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the user interface in an OS?

A

Provides a graphical or command-line interface for users.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is backup and recovery in an OS?

A

Ensures data recovery in case of system failure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is virtualization in an OS?

A

Supports the creation of virtual environments.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is Microsoft Office?

A

A suite of applications designed to help with productivity and common computer tasks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is MS Word?

A

A word processor developed by Microsoft, part of the Microsoft Office suite.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What are the file extensions of MS Word?

A

.doc and .docx.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is WYSIWYG in MS Word?

A

What-You-See-Is-What-You-Get ensures the screen display matches printed output.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is spell check in MS Word?

A

A built-in dictionary that identifies and corrects spelling errors.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What are text-level features in MS Word?

A

Bold, italic, underline, and strike-through formatting.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What are page-level features in MS Word?

A

Indentation, paragraphing, justification, headers, footers, page numbers, and watermarking.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What editing features does MS Word provide?

A

Cut, copy, paste, find, replace, and spell check.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What is the default layout in MS Word?

A

Includes a title bar, menu bar, toolbars, rulers, and status bar.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What are the two text insertion modes in MS Word?

A

Insert mode (adds text) and overwrite mode (replaces existing text).

28
Q

What shortcuts are used for selecting text in MS Word?

A

Double-click: Word; Triple-click: Paragraph; Ctrl + Click: Sentence; Ctrl + A: Document.

29
Q

What is MS Excel?

A

A spreadsheet program included in Microsoft Office.

30
Q

What are the file extensions of MS Excel?

A

.xls and .xlsx.

31
Q

What features does MS Excel provide?

A

Data analysis tools, charts, graphs, functions, and large data handling.

32
Q

What is a workbook in MS Excel?

A

A file containing worksheets related to a project.

33
Q

What is OLE support in MS Excel?

A

Allows embedding objects like documents and pictures within Excel.

34
Q

How many rows and columns can MS Excel support?

A

65,536 rows and 256 columns per worksheet.

35
Q

What are functions in MS Excel?

A

Built-in formulas for calculations and data analysis.

36
Q

What are common mathematical functions in MS Excel?

A

SUM, ABS, SQRT, LOG, and FACT.

37
Q

What are common statistical functions in MS Excel?

A

AVERAGE, STDEV, MAX, MIN, and COUNT.

38
Q

What is the autofill feature in MS Excel?

A

Automatically fills cells with repetitive data like dates or numbers.

39
Q

What is hyperlinking in MS Excel?

A

Links files or web pages within a workbook.

40
Q

What is Clip Art in MS Excel?

A

Allows adding images and audio/video clips.

41
Q

What is the spell check feature in MS Word?

A

Checks for spelling errors and provides suggestions for corrections.

42
Q

What is the purpose of MS Excel charts and graphs?

A

Converts tabular data into graphical formats for analysis.

43
Q

What is the Analysis Toolpack in MS Excel?

A

A set of tools for advanced data analysis.

44
Q

What is the SORT function in MS Excel?

A

Arranges data in ascending or descending order.

45
Q

What is Data Validation in MS Excel?

A

Allows restricting and validating data entry in cells.

46
Q

What is the Page Layout feature in MS Excel?

A

Controls themes, colors, margins, scaling, and print settings.

47
Q

What does Ctrl + Z do in MS Word?

A

Performs the undo action.

48
Q

What does Ctrl + Y do in MS Word?

A

Performs the redo action.

49
Q

What does Ctrl + X do in MS Word?

A

Cuts the selected text.

50
Q

What does Ctrl + C do in MS Word?

A

Copies the selected text.

51
Q

What does Ctrl + V do in MS Word?

A

Pastes the copied or cut text.

52
Q

What does Ctrl + F do in MS Word?

A

Finds specific text in the document.

53
Q

What does Ctrl + H do in MS Word?

A

Replaces specific text with another text.

54
Q

What is the Paste Special feature in MS Word?

A

Pastes text as an uneditable object.

55
Q

What does Ctrl + G do in MS Word?

A

Navigates to a specific page, line, or paragraph.

56
Q

What are the default rulers in MS Word used for?

A

Measurement purposes with inches as the default unit.

57
Q

What is the status bar in MS Word?

A

Displays details like page number, line number, and section information.

58
Q

How do you perform a comprehensive spell check in MS Word?

A

Click Review > Spelling & Grammar.

59
Q

How do you start a new page in MS Word?

A

Insert a page break using Ctrl + Enter.

60
Q

How do you add images in MS Word?

A

Insert > Picture to add images from your computer.

61
Q

How do you create a chart in MS Excel?

A

Insert > Chart to create a graphical representation of data.

62
Q

How do you calculate the average in MS Excel?

A

Use =AVERAGE(range) to find the average of values in the specified range.

63
Q

How do you find the maximum value in MS Excel?

A

Use =MAX(range) to find the highest value in a range.

64
Q

How do you calculate the sum of values in MS Excel?

A

Use =SUM(range) to calculate the total of values in a range.

65
Q

How do you calculate the square root in MS Excel?

A

Use =SQRT(number) to find the square root of a number.

66
Q

How do you calculate the logarithm in MS Excel?

A

Use =LOG(number) to calculate the logarithm of a number.