Computer Part 5 2023

Total Questions: 50

1 - In a Excel worksheet, you can apply Formatting to:

A ) Row
B ) Column
C ) Cell
D ) All of these ✅

2 - The main element in Microsoft Excel is the:

A ) Workbook
B ) Worksheet
C ) A&B ✅
D ) Spreadsheet

3 - In Excel,the function " Today ()" is used to display:

A ) The current time
B ) The current year
C ) The current data ✅
D ) The current weather

5 - "Format Painter " is a feature commonly found in:

A ) Microsoft Word ✅
B ) Microsoft Excel
C ) Adobe Photoshop
D ) Microsoft Power Piont

6 - In Excel ,the error message "#Value!" typically means:

A ) Invalid Input ✅
B ) Calculation Error
C ) Data Corruption
D ) Low Memory

8 - Borders can be applied to which of the following elements in a document:

A ) Cell, Table & Paragraph ✅
B ) Images
C ) Hyperlinks
D ) Footnote

10 - The time and date are displayed on which bar in computer's interface:

A ) Task Bar ✅
B ) Menu Bar
C ) Status Bar
D ) Title Bar

11 - Page orientation options,such as portrait or landscape,are typically found in the:

A ) Page layout ✅
B ) Page setup
C ) Format
D ) Page design

12 - What are the items inside the parentheses in an MS Excel syntax called:

A ) Variables
B ) Parameters
C ) Arguments ✅
D ) Conditions

13 - "If function " typically refers to a function used in:

A ) Programming
B ) Mathematics
C ) Spreadsheets ✅
D ) Database

14 - To change the case of tax in a document ,you would typically use:

A ) Formatting ✅
B ) Capitalization
C ) Spell Check
D ) Alignment

15 - A ghost text like "Confidential" in Microsoft Word is often referred to as a:

A ) Watermark ✅
B ) Shadow text
C ) Placeholders text
D ) Hidden text

16 - The symbol ">" is often used to represent a:

A ) Logic function /operation ✅
B ) Arithmetic function
C ) Text formatting option
D ) Bullet point

17 - To insert of formula, you would typically use the:

A ) Formula icon ✅
B ) Function wizard
C ) AutoSum
D ) Equation editor

18 - A reference that remains unchanged after copying is called_______:

A ) Absolute reference ✅
B ) Relative reference
C ) Static reference
D ) Dynamic reference

19 - The bar at the top of the document that provides the name of the document:

A ) Menu bar
B ) Title bar ✅
C ) Quick Access Toolbar
D ) None of these

20 - The act of retrieving existing data from memory is called:

A ) Read Out
B ) Read from
C ) Read
D ) All of these ✅

21 - Which of the following is not essential component to perform a mail merge operation?

A ) Main document
B ) Data source
C ) World field ✅
D ) Merge Fields

23 - Which of the following is not the correct method of editing the cell content?

A ) F2
B ) Double press the cell
C ) Pressing the Alt key ✅
D ) Click the formula bar

24 - The shortcut Ctrl+E is often used to apply which text alignment in document:

A ) Central Align ✅
B ) Left Align
C ) Right Align
D ) None of these

25 - To fill data in respect of a selected range, you would typically use:

A ) Auto fil ✅
B ) Data Entry
C ) Auto sum
D ) Copy-paste

26 - The shortcut Ctrl+U is often used to:

A ) Underline text ✅
B ) Undo the last action
C ) Italicize text
D ) Cut text

27 - To put mark that reader , restart reading from there?

A ) Hyperlink
B ) Reference
C ) Cross Reference
D ) Bookmark ✅

28 - The shortcut key for ” Italicize text"

A ) Ctrl +I ✅
B ) Ctrl+U
C ) Ctrl+H
D ) Ctrl+M

29 - The shortcut key for marking a citation is:

A ) Alt+Shift+V
B ) Alt+Shift+P
C ) Alt+Shift+I ✅
D ) Alt+Shift+L

30 - What is the shortcut-key for manual line break in MS Word?

A ) Space +Enter
B ) Shift+Enter ✅
C ) Alt+Enter
D ) Ctrl+Enter

33 - Shortcut key for underline in MS-WORD.

A ) Ctrl+B
B ) Ctrl+U ✅
C ) Ctrl+A
D ) Ctrl+Z

34 - Command for creating the "New Document".

A ) Ctrl+M
B ) Ctrl +N ✅
C ) Ctrl+O
D ) Ctrl+A

35 - In MS Word, "Ctrl+End " is used to:

A ) Moves the cursor to the end of Document ✅
B ) Move the cursor to the end of line
C ) Moves the cursor to the end of paragraph
D ) None of these

36 - Move the cursor to the top of the next page.

A ) Page Down
B ) Ctrl+Page up
C ) Ctrl+page down ✅
D ) Page up

37 - 8 bits equal to________.

A ) 1KB
B ) 1 Byte ✅
C ) 1 Nibble
D ) None of these

38 - In Excel ,the chart wizard _________?

A ) Can place a chart on a new chart sheet or on any sheet in the workbook ✅
B ) Can only place a chart on a new chart sheet
C ) Can only be used to create embedded charts
D ) None of these

39 - What program runs first after the computer is booted and loading GUI?

A ) Desktop Manager
B ) File Manager
C ) Window Explorer
D ) Authentication ✅

41 - What category do desktop computers belong to?

A ) Supercomputer
B ) Minicomputer
C ) Microcomputer ✅
D ) Mainframe

42 - What is the function of "Insert " tab do have ,among the following?

A ) Chart ✅
B ) Page layout
C ) View
D ) None of these

43 - A computer cannot "boot" if it does not have the ________ system?

A ) Assembler
B ) Operating ✅
C ) Compiler
D ) Loader

44 - What is the shortcut key to quickly insert a new workbook in Excel?

A ) Shift
B ) Alt+Enter ✅
C ) Control
D ) Shift+A

45 - " Which of the following you can paste selectively using paste special command?

A ) Validation
B ) Formats
C ) Formulas
D ) All of above ✅

46 - How often does MS Excel auto-save a file by default every _______ minutes?

A ) Every 10 minutes ✅
B ) Every 20 minutes
C ) Every 30 minutes
D ) None of these

47 - Which of the following is not a relevant term in MS Excel?

A ) Pencil work ✅
B ) Rows and cells
C ) Worksheets
D ) None of these

48 - What type of computer is commonly used in small organizations?

A ) Microcomputer ✅
B ) Mainframe
C ) Supercomputer
D ) None of these

49 - " Where is the on/off power button typically located?

A ) Front of the device
B ) Back of the device
C ) Side of the device ✅
D ) Top of the device

50 - What does " one page down " mean in a document or web page?

A ) Scrolling down by one screen
B ) Scrolling down by one page ✅
C ) Moving down by one paragraph
D ) Scrolling down all pages