1. How to run font settings in Microsoft PowerPoint?

1. Home - group paragraph

2. Home - group font

3. Home - group symbol

4. Home - group home

2. Which key must be pressed to print a comma when the English

alphabet is installed on the computer?

1. where the Russian letter Б is written

2. where the Russian letter Ю is written

3. where the Russian letter Ж is written

4. where the Russian letter Ы is written

3. Mac OS is a line of operating systems created by:

1. Microsoft

2. Samsung

3. Google

4. Apple
 4.To insert a formula in a text document, you must go to the following
tabs:

1. File - Page Settings - Insert formula

2. Insert - Symbols - Formula

3. Insert - Illustrations - Insert the formula

4. To see the height and width of the currently graphic, as shown in the
accompanying figure, look in the __________ group on the Picture
Tools Format tab.

1. Measurements

2. Options

3. Size

4. Dimensions

6. What does “apply design template” do

1. Adds functionality to the slide

2. Changes the look of the slide without changing the

content

3. None of the all

4. Changes the content of the slide

 7.Comments put in cells are called …..

1. Smart Tip

2. Cell Tip

3. Web Tip

4. Soft Tip

8.'.MOV' extension refers usually to what kind of file?

1. Image file

2. MS Office document

3. Audio file

4. Animation/movie file

5. Image file

9. What is the function of the small arrow in the bottom right-hand corner
of the Font group?

1. This is called a Dialogue Box Launcher. Clicking it in the Font

group will launch a dialogue box with more Font
options

2. This is called a Ribbon Expander button. It enlarges the

visible area of the Ribbon and display hidden buttons

3. This is called a Group Expander button. You can drag it to

make the Font group bigger
 4. None of the above options are correct

5. You can drag it to make the Font group bigger

10. The Slides Area is located on the left-hand side of the screen and
contains thumbnails of each slide in a presentation.

Which of the following actions can be performed using the Slides Area?

1. It can be used to move slides around to change the sequence

of slides, by simply dragging slides to a new position

2. It can be used to duplicate slides from the Presentation, by

right-clicking a slide and selecting Duplicate Slide from the list

3. It can be used to delete slides from a presentation, by right-

clicking and selecting Delete Slide from the list

4. It can be used to delete slides from a presentation

5. All of the above options are correct

11. Computers calculate numbers in what mode?

1. Hexedecimal

2. Binary

3. Decimal

4. Octal

5. None of the above

12.To remove a portion of text from a document, you can ___________.

 1. Cut it

2. Paste it

3. Undo it

4. Redo it

5. Copy it

13. Getting data from a cell located in a different sheet is called….

1. Accessing

2. Referencing

3. Updating

4. Functioning

5. None of the above

14. This memory is for short term storage and is lost when the computer
is turned off

1. Icon

2. CPU

3. Hard drive

4. RAM

15. What is the name of the document in Excel?

 1. worksheet

2. book

3. page

4. sheet

16. Suman often needs to print, change page set-up and spellcheck
slides.

She hates having to search for these function buttons in different places
on the Ribbon every time she wishes to use them. What is the solution?

1. She could add the buttons for the above functions to the
Quick Ribbon Status Bar at the bottom of the screen

2. She can add the buttons to the Quick Access Toolbar at the
top left-hand corner of the screen

3. She could create shortcuts on her desktop for the above

functions to ensure quick access

4. She could add all of the above functions to the Status Bar at
the bottom of the PowerPoint screen

5. She could add the buttons for the above functions to the
Quick Ribbon Status Bar

17.The process of starting or restarting computer is called:

1. Start up point

2. Booting

3. Connecting

4. Adding
 5. Changing

18. The workbook consists of ...

1. several working pages

2. several worksheets

3. several cells

4. one worksheet

19. Where on the PowerPoint Ribbon will you find the Spelling Check
function?

1. Under the Language and Proofing tab on the Ribbon

2. Under the View tab on the Ribbon

3. There is no Spelling Check function in PowerPoint as we are

dealing with slides, not a document

4. Under the Review tab on the Ribbon

5. Under the Language

20. What is the purpose of the Status Bar in PowerPoint?

1. It gives information about the slideshow such as slide

number, theme applied and language
 2. It gives information about the status of publication of slides in
a presentation

3. It shows you how close to completion a slideshow is

4. None of the above options are correct

5. It gives information about the slideshow

21. The smallest structural unit within the table is ..

1. string

2. cell

3. column

4. range

22. Which of the following is not a valid data type in Excel?

1. Number

2. Character

3. Label

4. Date/Time

5. Time

23. A cell cannot contain data in the form of ...

1. text
 2. formulas

3. numbers

4. pictures

24.HDD is:

1. DVD-RW

2. Hard Drive Doc

3. Hard Drive Disk

4. High Drive Disk

25. A coating of dust on a computer's main circuit boards has this

probable consequence

1. Overheating

2. Short circuits

3. Hard disk

4. None

5. Microcircuits

26. Specify the correct cell address.

1. 87
2. P6

3. 7B

4. there is no correct answer

27. One component of the motherboard is:

1. Keyboard

2. Bios

3. Speakers

4. Cooler

28. Formula - begins with a sign ...

1. "

2. No

3. =

4. there is no correct answer

29. Times New Roman, Comic Sans and Calibri are called_______

1. Fonts

2. Variations

3. Font sizes
 4. Font resizes

30. What would you do to highlight a word? You position the cursor next
to the word and then _____.

1. Drag the mouse while holding the left mouse button

2. Roll mouse around

3. Click the mouse three times

4. Click the mouse four times

5. Roll mouse around

31. What cell is called active?

1. any

2. the first one

3. filled

4. there is no correct answer

32. Which of the items is an input device?

1. Computer Monitor

2. Keyboard

3. Display Board

4. Projector
33. MS Word is:

1. text editor

2. a spreadsheet

3. database management

34. What sorting sort does not exist in Excel?

1. in descending order

2. in size

3. ascending

4. all types exist

35. How can I round a number in a cell?

1. using the cell format

2. using the function

3. both of the previous answer are correct

4. there is no correct answer

36. What happens in the document when the "cut" command is used?

1. Only half the screen is seen

2. The application stops running

 3. Selected text or graphics are removed

4. Selected text or graphics are appear

5. The application start running

37. What category does the IF function belong to?

1. mathematical

2. statistical

3. logical

4. calendar

38. What are the main data types in Excel?

1. numbers, formulas

2. text, numbers, formulas

3. numbers, dates, numbers

4. sequence of actions

39.Which part of the computer shows you information from the

computer?

1. Mouse

2. Keyboard
 3. Camera

4. Monitor

5. All of the above

40. Presentation is ...

1. A graphic document that has the extension .txt or .pcx

2. A set of slide pictures on a specific topic with the extension

.ppt

3. A tool that allows you to create picture slides with text

4. A set of slide pictures on a specific topic with the extension

.exe

41. Which one is not a tab in Microsoft Word 2010?

1. File

2. Insert

3. Table

4. View

42.What does the appearance of ####### mean when performing

calculations?
 1. the width of the cell is less than the length of the
result

2. an error in the calculation formula

3. lack of result

4. there is no correct answer

43. Which area in Excel window allows entering values and formulas?

1. Title Bar

2. Menu Bar

3. Formula Bar

4. Standard Tool Bar

5. Tool Bar

44. Which one of the following is not in the drop-down menu when you
click the File tab in Microsoft Word?

1. Save As

2. Open

3. New

4. Cut

5. Print
45. In spreadsheets you cannot delete:

1. Text data cells

2. Columns

3. Cell names

46. In spreadsheets, the cell name is formed:

1. Arbitrarily

2. By joining row and column names

3. By joining column and row names

47.Which part of the computer we can call the brain of the computer?

1. Monitor

2. Keyboard

3. Speakers

4. CPU (Central processing unit)

48.The table processor is:

 1. A group of applications that are designed to carry out
calculations in tabular form

2. The Word application team, the call of which leads to the

execution of calculations on the data entered into the table

3. A special computer program that helps to convert data arrays

from text to tabular

4. The Paint application team, the call of which leads to the

execution

49. The speed of your net access is defined in terms of...

1. RAM

2. Kbps

3. Ghz

4. Pegabytes

5. MHz

50. Given a fragment of a spreadsheet with numbers and formulas

1. 180

2. 110
 3. 135

51. . _______, ________ and _______ are what you see when you open
Excel

1. Columns, rows, and charts

2. Columns, rows, and formulas

3. Columns, rows, and cells

4. Non of the above

52.The extension of files created in Microsoft Excel is:

1. .doc

2. .xls

3. .bmp

4. .ppt

53. Which tab do you choose to change the font size of word from 12 to
18?

1. File

2. Home

3. Insert

4. Page Layout
 5. View

54. Indicate the correct formula entry:

1. B9C9 + 64

2. = D3 * D4-D5

3. A1 = A3 + 2 * B1

4. D3 * D4-D5

55. Which computer part can you point and click with?

1. Monitor

2. Mouse

3. CPU

4. Keyboard

5. All of the above

56. What is the maximum number of Excel worksheets a workbook can

contain?

1. 3

2. 10
3. 256

4. not limited

57. What program can be used for multimedia presentations?

1. Windows Word

2. Microsoft Word

3. Microsoft Excel

4. Microsoft PowerPoint

58. Which of the images matches the Microsoft PowerPoint logo?

1.

2.

3.

4.

59. Which of the images matches the Microsoft Word logo?

1.

2.

3.

4.

60. Which of the images matches the Microsoft Excel logo?

1.

2.

3.

4.

61. Which computer parts gives you sound from the computer?

1. Speakers

2. Mouse
3. Laptop

4. All of the above

62. Which of these is a search engine?

1. FTP

2. Google

3. HTTP

4. ARPANET

63. How can you catch a computer virus?

1. Sending e-mail messages

2. Using a laptop during the winter

3. Opening e-mail attachments

4. Using a laptop during the summer

64. Which component would be located inside the computer case?

1. monitor

2. printer

3. RAM

4. USB hard drive

 65. If you want to add a table or a radial diagram to your document, which
tab would you choose?

1. File

2. Home

3. Insert

4. Save

5. Save as

66. What is the function of this key?

1. Paste

2. Copy

3. Delete

4. Undo

5. Redo

67. Which hardware component must be installed in a PC to provide network

connectivity?

1. PCI bus

2. serial port

3. network interface
4. expansion slot

68. "DOS" stand for...

1. Data Out System

2. Disk Out System

3. Disk Operating System

4. Data Operating System

69. What is the function of this key?

1. Left Align

2. Justify

3. Center

4. Right Align

5. Left Align

70. What password would be considered a strong password?

1. password123

2. Excellent

3. 18273645
 4. Il0veMyj0b

71. If you want to save a file you should

1. Click X to close then click no

2. Click X to close then click cancel

3. Click X to close then click yes, click file save as, click the
floppy disk icon in the ribbon

72. Which type of interface should a customer choose if connecting a

single cable from a Microsoft Windows computer to output both audio and
video to a high definition television?

1. DVI

2. HDMI

3. PS/2

4. DB-15

73. To print the Document, press

1. Ctrl + E

2. Ctrl + S

3. Ctrl + P
 4. Ctrl + K

74. 'OS' computer abbreviation usually means?

1. Order of Significance

2. Open Software

3. Operating System

4. Optical Sensor

5. Open system

75. What key combination should be used to insert today's date into the
document?

1. Ctrl + Alt + A

2. Shift + Ctrl + V

3. Shift + Alt + D

4. Shift + Ctrl + U

76. The footer is:

1. The area that is in the upper and lower fields and is intended
to place the name of the work on the text of each page
 2. The appearance of the printed characters that the user sees
in the window of a text editor

3. The top line of the Word editor window, which contains a

command bar (for example, "Insert", "Designer", "Layout", etc.)

77. To insert a link into a text document, you need to go to the following
tabs:

1. Insert - Insert link - Create a source

2. Links - Insert a link - Add a new source

3. File - Page Settings - Insert link

78. What is the default font installed in Word 2007?

1. Times New Roman

2. Calibri

3. Microsoft Ya Hei

4. Cambria

79. The floppy disk icon is shown on the top line of the taskbar. What
happens if you click on it?

1. the document is deleted

2. the document will be saved

3. the document will be written to a disk or flash drive inserted

into the computer will be cutted
 80. What key do you need to hold while copying different text elements of
one document?

1. Alt

2. Ctrl

3. Shift

4. Tab

81. To create a new page, you must simultaneously press the following
keys:

1. Ctrl and Enter

2. Shift and space

3. Shift and Enter

4. Ctrl and Esc

82. To quickly paste the copied item, use the following key combination:

1. Ctrl + V

2. Ctrl + C

3. Ctrl + X

4. Ctrl + Esc

83. To insert a hyperlink, select the desired word and press:

 1. the right mouse button with the subsequent selection of the
"Hyperlink" tab

2. the left mouse button with the subsequent selection of the tab
"Hyperlink"

3. double-click on the left mouse button and then select the

"Hyperlink" tab

84.How many bits in 1 byte?

1. 16 bits

2. 8 bits

3. 24 bits

4. 12 bits

5. 18 bits

85. How can you stop a slide show?

1. Press the right arrow

2. Press Escape

3. Press the left arrow

4. Press the down arrow

86. What does mean CPU?

1. Central Processing Unit

2. Critical Processing Unit

3. Crucial Processing Unit

4. Central Printing Unit

87. The main element of spreadsheets is:

1. Figures

2. Cells

3. Data

4. Calls

88. What program is not a spreadsheet?

1. Excel

2. Quattropro

3. Superkalk

4. Word

89. What is the name of the document in Excel?

1. worksheet

2. book

3. page

4. Sheet

90. Which key do you press to check spelling?

1. F3

2. F5

3. F7

4. F9

5. F1

91. You can find the icon to 'Underline' a word in this 'Ribbon'.

1. Home

2. Insert

3. Review

4. View

5. Preview

92.This is a type of computer that sets on a table or desk.

1. Keyboard

2. Laptop

3. Hard Disk

4. Desktop

5. Hard Drive

93.A JPG is...

1. A Jumper Programmed Graphic

2. A type of hard disk

3. A format for an image file

4. A unit of measure for memory

94.In Microsoft Word what is the default font size?

1. 8

2. 11

3. 14

4. 16

5. 13
95. Which of the following are document views in Word

1. Draft

2. Text Preview

3. Print Layout

4. Full Screen Reading

5. View

96. In MS Word what does a red line under a word indicate?

1. The word is spelled wrong

2. The word is not in the computers dictionary

3. The computer likes the color red

4. The computer doesn’t like the color red

5. The word is spelled right

97. Select the correct sequence when inserting a picture on a slide

1. Insert - Picture

2. Edit - picture

3. Image - picture

4. Animation – picture
 98. Microsoft PowerPoint is needed for:

1. Creating and editing texts and drawings

2. To create tables

3. To create presentations and films from slides

99. What is a slide like?

1. Presentation paragraph

2. A line of presentation

3. The main element of the presentation

100. What key / key combination do you need to press to start the slide
show?

1. Enter

2. F5

3. Hold down the key combination Ctrl + Shift

4. F6

101. What key / key combination do you need to press to start the
presentation slide show from the current slide?

1. Enter

2. Hold down the key combination Shift + F5

3. Hold down the key combination Ctrl + F5

4. Hold down the key combination Ctrl + F3

 102. Which of these are valid e-mail address? (choose 3 answer)

(Шумораи ҷавобҳои дуруст 2 )

1. professor.at.learnthenet

2. www.learnthenet.com

3. suman@gmail.com

4. suman@mail.ru

103.Which two devices are output devices? (Choose two.)

(Шумораи ҷавобҳои дуруст 2 )

1. keyboard

2. video camera

3. monitor

4. mouse

5. printer

104. Which two operating systems are used in smartphones? (Choose

two.)

(Шумораи ҷавобҳои дуруст 2 )

 1. iOS

2. OS X

3. Android

4. Snow Leopard

5. Windows 7
105. How do you open the Start Menu in Windows?
a) Press Ctrl + P
b) Click the Windows icon or press the Windows key
c) Press Shift + S
d) Press Alt + Enter

106. What is the purpose of the Recycle Bin?

a) Store deleted files temporarily

b) Permanently delete files

c) Store downloaded files

d) Create new folders

107. What file extension is used for Microsoft Word documents?

a) .txt
b) .docx
c) .exe
d) .jpg

108. What does the Alt + Tab shortcut do?

a) Closes a program

b) Switches between open applications

c) Opens Task Manager

d) Takes a screenshot
109. Which tool is used to uninstall programs?
a) Task Manager
b) Control Panel
c) Windows Defender
d) File Explorer

110. What is the primary function of Microsoft Word?

A) Creating and editing text documents

B) Playing music
C) Browsing the internet
D) Watching videos

111. What is the default file extension of a Microsoft Word document?

A) .txt

B) .pdf

C) .docx

D) .xlsx

112. How can you quickly create a new document in MS Word?

A) Press Ctrl + P
B) Press Ctrl + N
C) Press Ctrl + X
D) Press Ctrl + Z

113. What does the "Undo" command do in MS Word?

A) Deletes the entire document

B) Restores the document to its original format
C) Reverses the last action
D) Saves the document automatically

114. Which tab in MS Word contains font formatting options?

A) Insert
B) Layout
C) Home
D) Review

115. How do you make text bold in MS Word?

A) Press Ctrl + U
B) Press Ctrl + B
C) Press Ctrl + I
D) Press Ctrl + P

116. How do you insert an image into a Word document?

A) Click Insert > Pictures

B) Click File > Open
C) Click Home > Font
D) Click Review > Spell Check

117. What happens when you press "Ctrl + P" in MS Word?

A) The document is printed

B) The document is saved
C) A new document is created
D) The document is closed

118. Which feature is used to create a list with bullet points?

A) Numbering
B) Bullets
C) Margins
D) Alignment

119. What is the purpose of the "Find and Replace" feature?

A) To locate and change specific words in a document

B) To check spelling mistakes
C) To add images to a document
D) To save a document in another format

120. How do you insert a table in a Word document?

A) Click Insert > Table

B) Click Layout > Columns
C) Click Home > Styles
D) Click File > Open

121. What is the function of the "Header and Footer" feature in MS Word?

A) Adds images to the document

B) Adds text at the top and bottom of pages
C) Changes the font size
D) Deletes the first page of the document

122. What is Microsoft Excel used for?

A) Writing essays
B) Creating and managing spreadsheets
C) Editing images
D) Watching videos

123. What is the default file extension for an Excel workbook?

A) .docx
B) .pptx
C) .xlsx
D) .txt

124. What is the intersection of a row and a column called?

A) Chart
B) Table
C) Cell
D) Formula

125. Which symbol is used to start a formula in Excel?

A) $
B) =
C) #
D) @

126. What is the function of the AutoSum (Σ) button in Excel?

A) It inserts images
B) It sums up a range of numbers
C) It deletes a row
D) It copies a formula

127. What is the shortcut to save a file in Excel?

A) Ctrl + P
B) Ctrl + S
C) Ctrl + X
D) Ctrl + Z

128. What does "Merge & Center" do in Excel?

A) Merges two workbooks

B) Merges selected cells and centers the text
C) Creates a new worksheet
D) Deletes a column

129. Which function is used to find the average of a range of numbers?

A) =SUM()
B) =AVG()
C) =MEAN()
D) =AVERAGE()
130. How do you apply a filter in Excel?

A) Click Data > Filter

B) Click Home > Sort
C) Click Insert > Table
D) Click View > Freeze Panes

131. What happens when you press "Ctrl + Z" in Excel?

A) Redoes an action
B) Undoes the last action
C) Saves the file
D) Deletes the selected cell

132. How do you create a chart in Excel?

A) Click Insert > Chart

B) Click Home > Chart
C) Click View > Chart
D) Click File > New

133. What is Microsoft Windows?

A) A web browser
B) An operating system
C) A spreadsheet software
D) A word processor

134. What is the shortcut to copy a file or text in Windows?

A) Ctrl + X
B) Ctrl + C
C) Ctrl + V
D) Ctrl + P

135. Which of the following is NOT an operating system?

A) Windows
B) macOS
C) Linux
D) Google Chrome

136. What is the shortcut to open "Task Manager" quickly?

A) Ctrl + Alt + Del

B) Ctrl + P
C) Ctrl + S
D) Ctrl + X

137. What is the function of the "Recycle Bin" in Windows?

A) Stores deleted files temporarily
B) Plays media files
C) Saves documents automatically
D) Installs new software

138. What happens when you press "Alt + Tab" in Windows?

A) Opens the Start menu

B) Switches between open applications
C) Takes a screenshot
D) Opens File Explorer

139. What is the shortcut to take a screenshot in Windows?

A) Ctrl + P
B) Alt + Tab
C) Print Screen (PrtScn)
D) Ctrl + Z

140. What does "Right-Click" on a file do?

A) Deletes the file immediately

B) Opens a context menu with options
C) Copies the file automatically
D) Runs the file as a program

141. What happens when you press "Windows + D"?

A) Opens the Start menu

B) Minimizes all windows and shows the desktop
C) Opens Task Manager
D) Closes all applications

142. What is the latest version of Microsoft Windows (as of 2025)?

A) Windows 7
B) Windows 8
C) Windows 10
D) Windows 11

143. What is the main function of the Windows desktop?

A) To display open applications

B) To provide shortcuts to files, folders, and programs
C) To browse the internet
D) To manage printer settings

144. What is the function of the Windows key on the keyboard?

A) Opens the Start menu
B) Closes all applications
C) Opens File Explorer
D) Takes a screenshot

145. Which of the following is NOT a Windows utility program?

A) Disk Cleanup
B) Task Manager
C) Control Panel
D) Adobe Photoshop

146. What does the "Sleep" mode do in Windows?

A) Shuts down the computer completely

B) Puts the computer in a low-power state while keeping work open
C) Logs out the user and locks the screen
D) Deletes temporary files

147. What does the "Alt + F4" shortcut do in Windows?

A) Closes the current window or application

B) Opens the Start menu
C) Takes a screenshot
D) Refreshes the desktop

148. What is the purpose of "Windows Update"?

A) To install new fonts

B) To keep Windows and security features up to date
C) To upgrade Windows automatically to the latest version
D) To delete system files

149. What does "This PC" in Windows show?

A) Open applications
B) The list of installed printers
C) Storage drives, documents, and system folders
D) Running background processes

150. What happens when you right-click on an empty space on the desktop?

A) The computer shuts down

B) A context menu appears with options like "New Folder" and "Display Settings"
C) A search bar opens
D) All open windows minimize

151. How do you safely remove a USB drive in Windows?

A) Just pull it out
B) Click on "Safely Remove Hardware" in the system tray and eject it
C) Shut down the computer first
D) Delete all files on the USB before removing

152. What is the shortcut to lock your computer?

A) Ctrl + Alt + Delete

B) Windows + L
C) Alt + Tab
D) Ctrl + P

153. How do you change the screen resolution in Windows?

A) Right-click on the desktop > Display settings > Change resolution

B) Open Task Manager > Performance
C) Open File Explorer > System settings
D) Press Ctrl + Alt + Delete

154. What does "Ctrl + A" do in Windows?

A) Selects all items in a document or folder

B) Copies the selected text
C) Opens a new window
D) Deletes all files

155. What is "Windows Defender" also known as?

A) Microsoft Word
B) Windows Security
C) Windows Media Player
D) Windows Taskbar

156. What is Microsoft Word primarily used for?

A) Editing images
B) Creating and editing text documents
C) Playing videos
D) Managing databases

157. How do you add page numbers in MS Word?

A) Go to Insert > Page Number

B) Go to Home > Page Setup
C) Go to Layout > Margins
D) Go to File > Save As

158. What happens when you press "Ctrl + U" in Word?

A) Underlines selected text
B) Saves the document
C) Prints the document
D) Copies text

159. How can you check the word count in a document?

A) Click Review > Word Count

B) Click Insert > Excel Count
C) Click Layout > Picture
D) Click Home > Save

160. What does "Justify" alignment do to text in Word?

A) Aligns text to the left

B) Aligns text to the right
C) Aligns text evenly on both left and right margins
D) Centers the text

162. Which option is used to divide a document into multiple columns?

A) Page Layout > Columns

B) Home > Font
C) Insert > Table
D) View > Split

163. How do you insert a footnote in Word?

A) Insert > Page Number

B) References > Insert Footnote
C) Home > Font
D) Layout > Margins

164. What happens when you double-click a word in MS Word?

A) It selects the entire sentence

B) It selects the entire word
C) It deletes the word
D) It opens a new document

165. What happens when you press "Ctrl + Enter" in MS Word?

A) Creates a new page (Page Break)

B) Deletes the previous paragraph
C) Opens a new document
D) Copies text

166. What is "Print Layout" view in MS Word?

A) A view that shows how the document will look when printed
B) A mode that hides all images
C) A tool for adjusting font size
D) A view for making web pages

167. What is the function of the "AutoFill" feature in Excel?

A) Automatically saves the worksheet

B) Fills a series of cells with a pattern or sequence
C) Deletes duplicate values
D) Merges multiple cells into one

168. Which symbol is used in formulas to make a cell reference absolute?

A) * (asterisk)
B) $ (dollar sign)
C) # (hashtag)
D) @ (at sign)

169. What is the purpose of the "Conditional Formatting" feature in Excel?

A) To apply colors or styles to cells based on specific conditions

B) To merge two or more cells
C) To check for grammar mistakes
D) To convert a spreadsheet into a text file

170. What is the shortcut for inserting the current date in a cell?

A) Ctrl + T
B) Ctrl + D
C) Ctrl + ; (semicolon)
D) Ctrl + Shift + D

171. What is the default alignment of text in Excel cells?

A) Center
B) Right
C) Left
D) Justify

172. How do you merge multiple selected cells into one in Excel?

A) Click "Format" > "Merge Cells"

B) Click "Home" > "Merge & Center"
C) Click "Data" > "Merge Sheets"
D) Press Ctrl + M

173. What is the maximum number of rows in an Excel worksheet (Excel 2016
and later)?

A) 65,536
B) 1,048,576
C) 100,000
D) 500,000

174. How can you quickly remove duplicate values in Excel?

A) Use "Conditional Formatting"

B) Click "Data" > "Remove Duplicates"
C) Press Ctrl + Shift + D
D) Use the "Find and Replace" tool