NEW
Font size
WorksheetsICT 9 – Microsoft Excel MCQs (Extraction)
Total questions: 50
Worksheet time: 25mins
What does MS Excel primarily work with?
Text
Spreadsheets
Presentations
Databases
What is a cell in MS Excel?
A row
A column
The intersection of a row and a column
A formula
How do you save a workbook in MS Excel?
Ctrl + P
Ctrl + S
Ctrl + C
Ctrl + V
What is the shortcut to create a new workbook?
Ctrl + O
Ctrl + N
Ctrl + W
Ctrl + S
What symbol is used to start a formula in MS Excel?
=
+
-
/
Which function finds the average of numbers?
=MAX()
=MIN()
=SUM()
=AVERAGE()
What is the function of rows in MS Excel?
To divide the sheet vertically
To divide the sheet horizontally
To create headers
To create cells
How do you identify a cell in Excel?
By its color
By its formula
By its row and column address
By its value
Which of the following is used to calculate the minimum value in a range?
=MAX()
=MIN()
=AVERAGE()
=COUNT()
What is the primary purpose of a graph in Excel?
To store data
To calculate numbers
To visually present data
To delete data
What is the default file extension for Excel files?
.xls
.xlsx
.docx
.csv
Which function adds all numbers in a range?
=ADD()
=SUM()
=AVERAGE()
=COUNT()
What is the purpose of the "Merge & Center" feature in Excel?
Combines and centers the content of selected cells into one cell
Merges multiple worksheets into one
Centers text across all worksheets
Deletes empty cells automatically
What does the formula =A1+A2 do?
Adds the values of A1 and A2
Subtracts A1 from A2
Multiplies A1 by A2
Divides A1 by A2
Which function would you use to find the largest value in a dataset?
=LARGEST()
=MAX()
=HIGH()
=BIGGEST()
What does the formula =A1*A2 return?
The sum of A1 and A2
The product of A1 and A2
The difference between A1 and A2
The division of A1 by A2
What does "Text Alignment" in Excel allow you to modify?
The font type
The background color
The positioning of text inside a cell
The size of a worksheet
How do you make text ITALIC in Excel?
Ctrl + I
Ctrl + U
Ctrl + B
Ctrl + O
What is the shortcut to undo an action in Excel?
Ctrl + Y
Ctrl + Z
Ctrl + X
Ctrl + U
What will the formula =AVERAGE(A1:A5) calculate?
The sum of values in A1 to A5
The average of values in A1 to A5
The largest value in A1 to A5
The smallest value in A1 to A5
What do you press to save your work in Excel?
Ctrl + S
Ctrl + Z
Ctrl + C
Ctrl + F
Which function is used to calculate the average of a range of numbers in Excel?
=MAX()
=AVERAGE()
=SUM()
=MEDIAN()
What does the MAX function do in Excel?
Returns the smallest number in a range
Returns the largest number in a range
Multiplies all the numbers in a range
Displays the average of the range
What is the purpose of the MIN function in Excel?
Finds the minimum formatting settings in a cell
Returns the smallest number in a range
Displays the difference between the largest and smallest numbers
Adds all numbers in a range
What is the difference between a row and a column in Excel?
Rows are horizontal, and columns are vertical
Columns are horizontal, and rows are vertical
Both rows and columns are vertical
Both rows and columns are horizontal
Which option is used to align text in the middle of a cell?
Middle Align
Wrap Text
AutoFit
Merge & Center
Which option is used to add borders around a cell?
Fill Color
Borders
Merge Cells
Wrap Text
Which alignment places text at the bottom of a cell?
Top Align
Middle Align
Bottom Align
Justify
What happens if you merge cells that contain data in Excel?
All data from the merged cells is retained
Only the upper-left cell data is retained; others are deleted
Data from all cells is combined into one
Excel creates a summary of all cell data
If a range of cells includes the numbers 5, 15, 25, and 35, what is the result of the formula =SUM(A1:A4)?
20
35
55
80
What will the function =MIN(A1:A5) return if the values are 12, 7, 19, 22, and 9?
12
9
7
19
In Excel, what is the shortcut to COPY?
Ctrl + M
Alt + H + M + M
Ctrl + Shift + M
Ctrl + C
If the numbers 10, 20, 30, 40 are in cells A1, A2, A3, and A4, what will =MAX(A1:A4) return?
10
20
30
40
Which of the following statements about rows and columns is TRUE?
Columns are numbered, and rows are lettered
Rows and columns can only hold numbers
Rows are numbered, and columns are lettered
Rows are used only for formatting
How do you underline text in Excel?
Ctrl + U
Ctrl + I
Ctrl + B
Ctrl + O
A store owner wants to calculate the total sales, profit, and remaining inventory using Microsoft Excel. He tracks the following details: Items in column A (Pen, Notebook, Eraser), Price in column B (Pen 10, Notebook 25, Eraser 5), Quantity Sold in column C (Pen 50, Notebook 30, Eraser 40), and Total Sales in column D. What formula should be used in D2 to calculate the total sales for the first item (Pen)?
=B2+C2
=B2*C2
=B2-C2
=B2/C2
Using the same store table where Total Sales are placed in column D for each item, what will the result be in D5 if the total sales for the items are 500, 750, and 200?
1000
2000
1450
300
What formula should be entered in E3 to calculate the remaining inventory for Notebooks, assuming an initial stock of 60 units and the quantity sold is in C3?
=C3+60
=C3*60
=60-C3
=60/C3
If the price of an item is 20 and 4 items are sold, what will the total sales be?
5
80
24
16
What is the purpose of the MAX function in Excel?
To calculate the average of numbers in a range
To find the smallest value in a range
To find the largest value in a range
To count the number of cells in a range
A teacher tracks the scores of her students in a recent exam: John 85, Sarah 90, Mark 78, Alice 92, Bob 88 (names in column A and scores in column B). If the formula =MIN(B2:B6) is used, what value will it return based on the given scores?
85
90
78
92
Based on the student scores table (John 85, Sarah 90, Mark 78, Alice 92, Bob 88 in column B), what is the result of the formula =AVERAGE(B2:B6)?
80
86.6
90
92
Which formula calculates the highest score in the list of student scores (85, 90, 78, 92, 88 in cells B2:B6)?
=MAX(B2:B6)
=MIN(B2:B6)
=AVERAGE(B2:B6)
=SUM(B2:B6)
Which of the following formulas correctly calculates the average of the values in cells B1, B2, and B3?
=MEAN(B1:B3)
=SUM(B1:B3)/3
=AVERAGE(B1:B3)
Both B and C
What will the formula =MAX(A1:A5) return?
The smallest value in the range A1:A5.
The largest value in the range A1:A5.
The average of the values in A1:A5.
The sum of the values in A1:A5.
If you want to divide the value in cell A1 by the value in cell B1, which formula should you use?
=A1:B1
=DIVIDE(A1,B1)
=A1/B1
=A1-B1
What shortcut key can you use to save a file in Excel?
Ctrl + S
Ctrl + A
Ctrl + P
Alt + S
How can you quickly apply bold formatting to a selected cell or text?
Ctrl + B
Ctrl + I
Ctrl + U
Ctrl + Shift + B
Which formula is used to find the average of all numbers in cells A1 through A10?
=AVERAGE(A1:A10)
=MEAN(A1:A10)
=AVG(A1:A10)
=SUM(A1:A10)/10
To sort data in ascending order in Excel, which command should you use?
Sort A to Z
Sort Z to A
Group
Filter
