WorksheetsExcel Functions and Features Quiz
Total questions: 45
Worksheet time: 23mins
Which Excel function returns the smallest number in a range from B2 to B20?
=LOW(B2:B20)
=MIN(B2:B20)
=SMALL(B2:B20)
=LOWEST(B2:B20)
In Excel, pressing F4 after selecting a cell reference in a formula will:
Convert it to an absolute reference
Delete the cell content
Refresh the worksheet
Open the Format Cells dialog
Which of the following is an example of Application Software?
Linux
Microsoft Excel
BIOS
Device Driver
Which Excel chart type displays vertical bars for comparing data across categories?
Line Chart
Clustered Column Chart
Pie Chart
Area Chart
Which tool in Excel automatically completes text entries when it detects a pattern?
Data Validation
Flash Fill
Format Painter
AutoCorrect
What is the purpose of Axis Titles in a chart?
To identify the data series
To label the horizontal or vertical axes
To format the chart background
To filter chart data
Which Excel feature allows you to split the worksheet window into multiple panes?
Freeze Panes
Page Break Preview
Split Window
Arrange All
In Excel, which symbol is used for division in formulas?
÷
/
\
DIV
Which shortcut key is used to undo the last action in Windows?
CTRL + Y
CTRL + Z
CTRL + U
CTRL + Q
Which function counts all cells containing numbers in a range?
COUNTA
COUNTIF
COUNT
SUM
When using a Pie to Pie chart, what is the purpose of pulling out an individual slice?
To delete the slice data
To highlight a specific part of the data
To change the chart type
To apply conditional formatting
Which Excel function returns the current system time without the date?
TODAY()
TIME()
NOW()
CLOCK()
Which Excel feature lets you apply multiple conditions in cell formatting?
Filter Tool
Data Validation
Conditional Formatting
Flash Fill
Which of the following is NOT an advantage of questionnaires in research?
Quick data collection
Cost-effective
Measures emotional changes in depth
Easy to quantify
Which of these best describes a Cell in Excel?
A file containing multiple worksheets
A single data point located at the intersection of a row and a column
A type of chart
A set of formatting rules
In Excel, which formula will add values from C1 to C10 only if they are greater than 50?
=ADDIF(C1:C10,">50")
=SUMIF(C1:C10,">50")
=SUM(C1:C10>50)
=TOTALIF(C1:C10,">50")
Which feature in Excel allows for changing a column's width automatically to fit the content?
AutoFit
Format Painter
Wrap Text
Merge & Center
Which Google Docs feature allows real-time document editing by multiple people?
Offline Mode
Collaboration Tool
Version History
Commenting Tool
Which function would you use to find the number of empty cells in a range?
COUNTA
COUNT
COUNTBLANK
COUNTEMPTY
The System Date in Excel can be displayed using which function?
DATE()
TODAY()
NOWDATE()
SYSTEMDATE()
Which element of a worksheet provides the vertical division of data?
Row
Column
Cell
Range
Which type of software manages hardware resources and acts as a platform for applications?
System Software
Application Software
Utility Software
Productivity Software
Which Excel function will return the highest value in a filtered range only?
MAX()
MAXIFS()
LARGE()
TOP()
Which of the following is an example of Meta Search Tools?
Yahoo Directory
Dogpile
Bing
In Excel, which view is best used for adjusting how the worksheet will print?
Page Layout View
Normal View
Page Break Preview
Draft View
What is the shortcut to paste content in Windows?
CTRL + C
CTRL + V
CTRL + X
CTRL + P
Which Excel function counts cells that meet a single condition?
COUNTIF
COUNTIFS
COUNTA
COUNTBLANK
Which feature lets you rename worksheet tabs in Excel?
Sheet Manager
Format Painter
Right-click Menu
Page Setup
Which type of chart is most suitable for showing continuous trends over time?
Column Chart
Pie Chart
Line Chart
Bar Chart
In Excel, the Increase Indent button is used to:
Move text further from the cell border
Increase font size
Add more columns
Expand chart size
In Excel, which function will return the smallest number in a range from A1 to A20?
=MAX(A1:A20)
=LARGE(A1:A20)
=BIGGEST(A1:A20)
=HIGH(A1:A20)
The Relative Reference in Excel changes when:
A cell is moved to a new location
The workbook is saved
Data validation is applied
Conditional formatting is removed
Which of these is an example of a communication device?
Printer
Keyboard
Modem
Monitor
In Excel, the Format Painter is used to:
Copy the value of a cell
Copy only the formatting of a cell
Paint cell backgrounds
Apply conditional formatting rules
Which of the following is an example of System Software?
Microsoft Word
Google Chrome
Windows 11
Adobe Photoshop
The COUNT function in Excel is used to:
Count only text values
Count the number of numeric entries in a range
Count all cells regardless of content
Count empty cells
Which chart type is typically used to display the proportion of parts to a whole?
Line Chart
Pie Chart
Column Chart
Sparkline Chart
What is the main benefit of using Conditional Formatting?
Prevents invalid data entry
Visually highlights data that meets specific conditions
Automatically adjusts column widths
Removes duplicates
Which Excel feature allows you to see which cells are used in a formula by color-coding them?
Flash Fill
Range Finder
AutoFill
Format Painter
In a nested IF formula, how many arguments are allowed in Excel?
3
5
7
10
What is the default orientation of text entered into an Excel cell?
Vertical
Diagonal
Horizontal
Rotated 45°
Which Google Forms feature allows you to send a respondent to a different question based on their answer?
Skip Logic
Data Validation
Conditional Formatting
Form Lock
Which Excel function returns the current date without the time?
NOW()
TIME()
TODAY()
DATE()
The Autocalculate feature in Excel:
Creates charts automatically
Shows a quick calculation result without inserting a formula
Formats worksheets for printing
Locks worksheet cells
Which of the following is NOT a valid method to move or copy cells in Excel?
Drag and drop
Cut and paste
Paste option menu
Format Painter
