WorksheetsExcel Basics - Year 7 Quiz
Total questions: 61
Worksheet time: 31mins
Which of the following is a spreadsheet application?
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
What is the intersection of a row and a column called?
Field
Cell
Box
Record
Which of the following is a correct cell reference?
1A
A0
A1
ColumnA1
Which key is used to move to the next cell to the right?
Enter
Shift
Tab
Ctrl
Which symbol is always used at the start of a formula?
+
=
#
@
What is the default file extension of an Excel workbook (newer versions)?
.docx
.xlsx
.pptx
.xlsm
Which option is used to combine two or more cells into one?
Wrap Text
Merge & Center
AutoFit
Fill Handle
Which of these is used to quickly copy a formula to adjacent cells?
Scroll bar
Name box
Fill handle
Status bar
What does the formula bar display?
Only the cell address
Only the value of the active cell
The contents or formula in the active cell
The sheet name
How do you start editing the contents of a cell using the keyboard?
Press F1
Press F2
Press F4
Press Esc
Which of the following is used to change the width of a column automatically to fit content?
AutoFill
AutoFit
Wrap Text
Merge Cells
Which type of data will Excel align to the right by default?
Text
Numbers
Dates
Both numbers and dates
How do you select the entire worksheet quickly?
Press Ctrl + A
Click the rectangle at the top-left corner of the sheet (above row 1 and left of column A)
Press Shift + Enter
Both A and B
Which feature allows you to repeat the last action performed?
Undo
Redo
Save
Paste
Which tab would you use to insert a chart?
Home
Insert
Page Layout
Data
What is the purpose of the “Wrap Text” feature?
To join two cells
To copy text to another cell
To display all text on multiple lines within a cell
To rotate the text
Which option will remove the contents of a cell but keep the formatting?
Delete key
Backspace key
Clear Contents
Clear All
What happens if you insert a new row 3 in a worksheet?
Existing row 3 moves down to row 4
Existing row 3 is deleted
Only the first cell is shifted
Nothing changes
Which tool helps you to arrange data in ascending or descending order?
Filter
Sort
Group
Subtotal
Which of the following will you use to quickly create a series like 1, 2, 3, 4 in Excel?
AutoFill with the fill handle
Copy and Paste
Merge & Center
Find & Replace
Which function adds a range of values in Excel?
=ADD(A1:A5)
=SUM(A1:A5)
=TOTAL(A1:A5)
Which function returns the average of a range of numbers?
=MEAN(A1:A10)
=AVERAGE(A1:A10)
=MID(A1:A10)
=AVG(A1:A10)
Which function returns the smallest number in a range?
=MIN(A1:A10)
=LOW(A1:A10)
=SMALL(A1:A10)
=LESS(A1:A10)
Which function returns the largest number in a range?
=LARGE(A1:A10)
=MAX(A1:A10)
=HIGH(A1:A10)
=BIG(A1:A10)
If cells A1 to A5 contain numbers, which function counts how many cells have numbers?
=COUNT(A1:A5)
=COUNTA(A1:A5)
=COUNTIF(A1:A5)
=SUM(A1:A5)
You want to count how many cells in A1:A10 contain the word "Pass". Which function is suitable?
=COUNT(A1:A10,"Pass")
=COUNTIF(A1:A10,"Pass")
=SUMIF(A1:A10,"Pass")
=AVERAGEIF(A1:A10,"Pass")
In a sales sheet, the range B2:B10 has sales amounts and A2:A10 has salesperson names. Which formula adds sales only for "Ali"?
=SUM(A2:A10,"Ali",B2:B10)
=SUMIF(A2:A10,"Ali",B2:B10)
=COUNTIF(A2:A10,"Ali")
=AVERAGEIF(A2:A10,"Ali",B2:B10)
Which of these is a correct IF function to check if A1 is greater than 50 and display "High" if true, otherwise "Low"?
=IF(A1>50;"High";"Low")
=IF(A1>50,"High","Low")
=IF("High","Low",A1>50)
=IF(A1>50:"High":"Low")
You have marks in B2:B20. Which formula finds the average of marks that are greater than or equal to 50?
=AVERAGE(B2:B20>=50)
=AVERAGEIF(B2:B20,">=50")
=AVERAGEIF(B2:B20,">=50",B2:B20)
=AVERAGEIF(">=50",B2:B20)
In the range C2:C11, you have numbers. Which formula adds only the values greater than 100?
=SUMIF(C2:C11,"100",C2:C11)
=SUMIF(C2:C11,">100")
=SUMIF(">100",C2:C11,C2:C11)
=SUMIF(C2:C11,">100",C2:C11)
What is the main purpose of conditional formatting in Excel?
To sort data
To automatically change cell formatting based on conditions
To protect a worksheet
To print the worksheet
Which menu/tab is commonly used to apply conditional formatting?
Home tab
Insert tab
View tab
Review tab
You want to highlight all marks below 40 in red fill. Which conditional formatting rule type is most suitable?
Text that Contains
Greater Than
Less Than
Equal To
You want to highlight the top 3 highest values in a marks list. Which option would you choose?
Top/Bottom Rules → Top 10%
Top/Bottom Rules → Top 10 Items
To color all cells in a range that contain the word "Absent", which rule is appropriate?
Highlight Cells Rules → Greater Than
Highlight Cells Rules → Text that Contains
Highlight Cells Rules → Between
Color Scales
Which conditional formatting feature uses different shades of color to show higher and lower values?
Icon Sets
Data Bars
Color Scales
Cell Styles
You applied conditional formatting to A1:A10 but want to clear it. Which option will remove the conditional formatting only, but keep the values?
Clear Contents
Clear All
Clear Rules → Clear Rules from Selected Cells
Delete Cells
You want to show green arrows for increasing values, yellow for same, and red for decreasing in a list of results. Which type of conditional formatting should you use?
Color Scales
Data Bars
Icon Sets
Top/Bottom Rules
A teacher wants to highlight all students who have scored 80 or above in a test. Which condition is correct for the rule?
Cell Value < 80
Cell Value = 80
Cell Value >= 80
Cell Value <> 80
Which statement about conditional formatting is TRUE?
It changes the actual value in the cell.
It only works on text, not numbers.
It visually highlights cells based on rules you set.
It cannot be copied to other cells.
What is the shortcut key to save a workbook in Excel?
Ctrl + Z
Ctrl + C
Ctrl + P
Ctrl + S
Which of the following functions can be used to count the number of cells that contain numbers?
=NUMCOUNT(A1:A10)
=SUM(A1:A10)
=COUNTA(A1:A10)
=COUNT(A1:A10)
What does the VLOOKUP function do?
Calculates the average of a range
Counts the number of cells in a range
Looks up a value in a vertical column
Looks up a value in a horizontal row
Which of the following is NOT a valid data type in Excel?
Text
Image
Date
Number
Which function is used to calculate the average of a range of cells?
MAX
COUNT
AVERAGE
SUM
What is the shortcut key to save a workbook in Excel?
Ctrl + S
Ctrl + V
Ctrl + P
Ctrl + C
Which of the following is NOT a valid data type in Excel?
Image
Date
Number
Text
What feature allows you to create a visual representation of data in Excel?
Charts
Tables
Data Validation
Conditional Formatting
Which function counts the number of cells that contain numbers in a range?
=COUNTA(A1:A10)
=COUNT(A1:A10)
=SUM(A1:A10)
=COUNTIF(A1:A10)
What is the shortcut key to open the 'Save As' dialog in Excel?
Alt + F4
F12
Ctrl + A
Ctrl + S
Which of the following functions can be used to find the maximum value in a range?
=MAXIMUM(A1:A10)
=MAX(A1:A10)
=HIGHEST(A1:A10)
=LARGEST(A1:A10)
What feature allows you to create a visual representation of data in Excel?
Charts
Tables
Formulas
Cells
Which function is used to combine text from multiple cells into one cell?
=TEXTJOIN(A1:A10)
=MERGE(A1:A10)
=CONCATENATE(A1,A2)
=JOIN(A1:A10)
What function would you use to count the number of cells in the range D2:D20 that contain numbers?
=COUNTIF(D2:D20,">0")
=SUM(D2:D20)
=COUNTA(D2:D20)
=COUNT(D2:D20)
Which of the following functions can be used to find the maximum value in a range of cells?
=MAXIMUM(D2:D20)
=MAX(D2:D20)
=LARGEST(D2:D20)
=HIGHEST(D2:D20)
In Excel, which shortcut key is used to open the 'Format Cells' dialog box?
Ctrl + Shift + 1
Shift + F1
Alt + F1
Ctrl + 1
Which of the following is NOT a valid Excel function?
=SUMPRODUCT()
=TOTALSUM()
=COUNTIF()
=AVERAGEIF()
What function would you use to find the maximum value in the range B1:B10?
=MAX(B1:B10)
=MIN(B1:B10)
=AVERAGE(B1:B10)
=SUM(B1:B10)
Which of the following shortcuts is used to save a workbook?
Ctrl + V
Ctrl + S
Ctrl + P
Ctrl + C
How can you add a comment to a cell in Excel?
Right-click the cell and select 'Insert Comment'
Both A and C
Use the 'Review' tab and click 'New Comment'
Press Alt + C
Which function would you use to calculate the average of the values in C1:C10?
=SUM(C1:C10)
=MEDIAN(C1:C10)
=AVERAGE(C1:C10)
=COUNT(C1:C10)
