IT Part 7 (101_150)
Master Your IT Skills
Test your knowledge with our comprehensive quiz designed for IT enthusiasts! This quiz covers a wide range of topics, ensuring that you not only challenge yourself but also learn more about essential IT concepts.
Key features of the quiz include:
- 50 carefully crafted multiple choice questions
- Diverse topics ranging from Excel fun
ctions to Word features - Immediate feedback on your answers
101. Which of the following can be customized for quicker access to your most commonly used commands?
Print Preview
Quick Access Toolbar
Printer setup
Workbook
102. When you modify the ribbon, which of the following is created?
Command
Tab
Button
Worksheet
103. Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text fil e
Template
104. Which of the following is not an arithmetic operator?
+
–
*
]
105. Per the order of operations, which of the following is calculated first?
Addition (+) and subtraction (-) (left to right)
Exponentiation (ˆ)
Percent (%)
Negative number (-)
106. Which of the following is an acceptable name for a named range?
C7
Subtotal_west
Subtotal west
Subtotal/west
107. Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
108. Which of the following is an example of a mixed cell reference?
A9
A$9
$A$9
A9:E9
109. Which of the following commands is used to insert a cell into a worksheet?
The Insert command in the Cells group on the Home tab
The Format command in the Cells group on the Home tab
The Format Painter command in the Clipboard group on the Home tab
The Format command in the shortcut menu when you right-click a cell
110. You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which of the following alignment options should be used?
Center
Middle Align
Justify
Top Align
111. Which of the following can you not copy using Format Painter?
Font color
Bold
Font size
Cell content
112. You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?
Apply another style to the cell
Use the Undo command
Clear the cell’s content
Apply the Normal style to the cell
113. Which of the following is not useful for changing the font size?
Font Size drop-down list
Increase Font Size button
Decrease Font Size button
Increase Indent button
114. Which enables us to send the same letter to different persons?
Macros
Template
Mail merge
None
115. Which key deletes the character to the left of the cursor?
End
Backspace
Home
Delete
116. Which key deletes the character to the right of the cursor?
End
Backspace
Home
Delete
117. Which would you choose to save a document with a new name?
Press Ctrl+S
Click File, Save
Click Tools, Options, Save
Click File, Save As
118. Which would you choose to move selected text from one place to another?
Move and Paste
Copy and Paste
Cut and Paste
Delete and Paste
119. Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?
AVERAGE
AutoSum
COUNT
MAX
120. You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?
MIN
AVERAGE
COUNT
MAX
121. You want to calculate the number of nonblank cells in your worksheet. Which function should be used?
SUM
COUNTA
MIN
MAX
122. You want to calculate the number of blank cells in your worksheet. Which function should be used?
SUM
COUNTA
COUNT
COUNTBLANK
123. Which of the following statements accurately describes the default selection for AutoSum?
You must make the selection before clicking AutoSum.
By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.
By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
AutoSum does not have a default selection
124. The COUNT and MIN functions are examples of which category of functions?
Text
Statistical
Financial
Logical
125. The first screen you see when you open Word 2016 is called the ______________.?
Word screen
Recent screen
Start screen
Screen saver
126. Which of the following contains the commands you use most often, such as Save, Undo, and Repeat?
Quick Access Screen
Quick toolbar
Quick Access Toolbar
Quick command
127. The headings that appear on the Ribbon, such as File, Home, and Insert, are called _______.?
Groups
Tabs
Shortcuts
Menus
128. Which command would you use to save a document for the first time?
Save
Save As
Save for the first time
Either A or B
129. Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All are corrects
130. How can you remove borders applied in cells?
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Choose None on Border tab of Format cells and Open the list on Border tool in Formatting toolbar then choose first tool (no border)
No answer
131. Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All are corrects
132. When all the numbers between 0 and 100 in a range should be displayed in Red color, apply ___________.?
Use=if() function to format the required number
Apply Conditional Formatting Command on Format menu
Select the cells that contain number between 0 and 100 then click red color on text color tool
All of above
133. Which one is not a Function in MS Excel?
SUM
AVG
MAX
MIN
134. Which function in Excel checks whether a condition is true or not?
SUM
COUNT
IF
AVERAGE
135. In Excel, Columns are labelled as ___________.?
A, B, C, etc.
1, 2, 3, etc.
A1, A2, etc.
$A$1, $A$2, etc.
136. The basic unit of a worksheet into which you enter data in Excel is called a _________.?
Cell
Table
Box
Column
137. How many sheets are there, by default, when we create a new Excel file?
1
3
5
10
138. In Excel, which one denoted a range from B1 through F5?
B1-F5
B1:F5
B1 to F5
B1$F5
139. An Excel file is generally called a/an __________.?
Worksheet
Sheet
Workbook
E-Spreadsheet
140. Formula in Excel start with ___________.?
#
%
=
+
141. Which of the following methods will not enter data in a cell?
Pressing the Esc key
Pressing the tab key
Clicking the enter button the formula bar
None of the above
142. Formatting a cell in Currency, you can specify _______________.?
Decimal Places
Currency Symbol
Percentage symbol
None of the above
143. Which function will you use to enter current time in a worksheet cell?
= CURRENTTIME()
= TIME()
= NOW()
All of the above
144. What is entered by the function =TODAY()?
Today’s date as Text format
The time value according to system clock
The date value for the day according to system clock
None of the above
145. Which area in an Excel window allows entering values and formulas?
Standard Tool Bar
Title Bar
Formula Bar
None of the above
146. Excel display the current cell address in the _________________.?
Status Bar
Name Box
Formula bar
None of the above
147. END Key used to ___________________.?
Moves the cursor end of the line
Moves the cursor end of the document
Moves the cursor end of the paragraph
Moves the cursor end of the screen
148. “CTR+PageDown” is used to ______________________________.?
Moves to the cursor one Paragraph Down
Moves to the cursor one Page Down
Moves to the cursor one Line Down
Moves to the cursor one Screen Down
149. “CTR+Down Arrow” is used to ______________________________.?
Moves to the cursor one Paragraph Down
Moves to the cursor one Page Down
Moves to the cursor one Line Down
Moves to the cursor one Screen Down
150. Page Up Key uses for ___________________________________.?
Moves the cursor one line up
Moves the cursor one screen up
Moves the cursor one page up
Moves the cursor one paragraph up
{"name":"IT Part 7 (101_150)", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge with our comprehensive quiz designed for IT enthusiasts! This quiz covers a wide range of topics, ensuring that you not only challenge yourself but also learn more about essential IT concepts. Key features of the quiz include: 50 carefully crafted multiple choice questions Diverse topics ranging from Excel functions to Word features Immediate feedback on your answers","img":"https:/images/course7.png"}