WorksheetsChapter 5 MS Excel
Total questions: 33
Worksheet time: 17mins
What is the main file extension for a workbook created in modern Microsoft Excel versions (2010 and above)?
.txt
.xls
.xlsx
In Excel, a single file that contains one or more worksheets is called a:
Document
Workbook
Slide
Presentation
The intersection of a Row (e.g., 5) and a Column (e.g., A) is called a:
Box
Grid
Cell
Data Point
Which bar displays the content of the active cell and allows you to view or edit formulas?
Status Bar
Title Bar
Formula Bar
Scroll Bar
Which keyboard shortcut is typically used to switch between open workbooks or windows?
Ctrl + Tab
Alt + Tab
Ctrl + N
Alt + F4
Which error message appears if a column is not wide enough to display the number inside it?
#VALUE!
#NAME?
######
#DIV/0!
You want to format a number (e.g., 1000) to appear as currency (e.g., $1,000.00). Which formatting option should you choose?
General
Text
Currency or Accounting
Percentage
Which feature allows you to combine multiple selected cells into one larger cell and center the content (often used for titles)?
Wrap Text
Merge & Center
Group Cells
Combine Text
If you want to automatically highlight all cells that contain a value greater than 50 (e.g., turn them red), which feature do you use?
Conditional Formatting
Format Painter
Cell Styles
Filter
You see a green triangle in the corner of a cell containing a number. This usually indicates:
The number is formatted as Text.
The cell is locked.
The calculation is perfect.
The cell has a virus.
You typed "012345" into a cell, but Excel automatically changed it to "12345" (removed the zero). How do you fix this to keep the zero?
Type a space before the number.
Change the cell format to Text before typing.
Change the font color to black.
Use the Bold setting.
You want to lock certain rows or columns so they remain visible while you scroll through the rest of the worksheet. Which feature should you use?
Split Window
Freeze Panes
Hide Rows
Group
Before printing a large spreadsheet, you want to ensure that the row headers (e.g., Name, Date, Amount) appear at the top of every printed page. Which feature do you use?
Print Area
Page Break Preview
Print Titles
Scale to Fit
You want to print a large spreadsheet, but it spills onto two pages horizontally. How can you force it to fit on one page width?
Delete half the columns.
Page Layout > Scale to Fit > Width: 1 Page.
Use a smaller computer screen.
Change the font to white.
Which function is used to add up all the numbers in a range of cells?
=TOTAL()
=ADD()
=SUM()
=COUNT()
If you want to find the largest number in a list of values, which function should you use?
=LARGE()
=MAX()
=UPPER()
=BIG()
What does the function =AVERAGE(A1:A5) do?
Adds the values in cells A1 through A5.
Finds the middle value in cells A1 through A5.
Calculates the average of the values in cells A1 through A5.
Counts how many cells contain numbers.
What happens when you use the "AutoFill" handle (the small square at the bottom-right of a cell) to drag down a formula?
It deletes the formula.
It copies the formula and automatically adjusts the cell references.
It moves the cell content.
It sorts the data.
You have a list of 50 items. You want to number them 1 to 50 automatically without typing each number. What is the fastest way?
Type 1, then type 2, then type 3...
Type 1 and 2 in the first and second cell, select both, and drag the Fill Handle down.
Type 1, Copy it, and Paste it 50 times.
Use the =COUNT() formula.
You want to calculate the Total Price by multiplying Quantity (Cell A2) with Unit Price (Cell B2). What is the correct formula to type in Cell C2?
A2 x B2
=A2 * B2
=MULTIPLY(A2:B2)
=A2 X B2
What is the result of this formula: =10 + 5 * 2?
30
20
15
Error
What does the function =TODAY() display in a cell?
The word "Today".
The current time only.
The current date (based on computer system).
The day of the week (e.g., "Monday").
What happens if you copy the formula =A1+B1 from Row 1 to Row 2?
It remains =A1+B1.
It automatically updates to =A2+B2.
It gives an error.
It changes to =B1+C1.
You want to calculate the average marks of 5 students located in cells C1, C2, C3, C4, and C5. Which formula is WRONG?
=AVERAGE(C1:C5)
=(C1+C2+C3+C4+C5)/5
=SUM(C1:C5)/5
=MEAN(C1:C5)
Which tool allows you to display only the rows that meet certain criteria (e.g., show only sales from "Johor")?
Sort
Filter
Find
Validate
Which type of chart is best for showing the percentage contribution of parts to a whole (e.g., market share)?
Bar Chart
Line Chart
Pie Chart
Scatter Plot
Which chart type is most suitable for showing trends over time (e.g., monthly sales over a year)?
Pie Chart
Line Chart
Radar Chart
Surface Chart
You have a table of "Monthly Sales". You want to create a Bar Chart. What is the FIRST step?
Click Insert > Bar Chart.
Select the data range (including labels) that you want to chart.
Draw a square on the screen.
Save the file.
You created a chart, but the title says "Chart Title". How do you change it to "Yearly Report"?
Delete the chart and make a new one.
Click on the text "Chart Title" and type the new name.
You cannot change it.
Use the formula =TITLE("Yearly Report").
You have a list of sales data with many duplicate regions (e.g., "North", "North", "South"). You want to see a list of unique regions only. What feature can remove duplicates?
Data > Remove Duplicates
Home > Delete
Review > Spell Check
View > Split
You have a list of students mixed up. You want to arrange them alphabetically (A-Z). Which button do you click?
Sort Ascending (A-Z)
Sort Descending (Z-A)
Filter
Find
You only want to see students who scored "A". You don't want to delete the others, just hide them temporarily. What feature do you use?
Sort
Filter
Cut
Group
Which chart is best to show the trend of temperature changes over 7 days?
Pie Chart
Line Chart
Doughnut Chart
Scatter Plot
