Font size
WorksheetsExcel Functions and Features Quiz
Total questions: 25
Worksheet time: 25mins
In Excel, columns are labeled using:
Numbers (1, 2, 3, …)
Letters (A, B, C, …)
Roman numerals (I, II, III, …)
Symbols (@, #, $, …)
Rows in Excel are identified using:
Letters (A, B, C, …)
Numbers (1, 2, 3, …)
Both letters and numbers
Symbols (*, &, %)
Which of the following is NOT a valid way to adjust column width?
Double-clicking the column boundary
Dragging the column boundary
Using Format → Column Width
Pressing Ctrl + W
What function is used to find the highest value in a range?
MIN
MAX
LARGE
HIGH
What function is used to find the lowest value in a range?
LOW
MIN
SMALL
AVERAGE
What does the IF function do?
Counts the number of cells in a range
Returns different values based on a condition
Sorts a list in alphabetical order
Finds the sum of a range
What will the formula =IF(A1>50, "Pass", "Fail") return if A1 contains 30?
Pass
Fail
Error
50
What is the function used to calculate the sum of a range?
COUNT
TOTAL
SUM
ADD
What will =SUM(A1:A5, B1:B5) do?
Add all values in A1:A5 and B1:B5
Multiply A1:A5 by B1:B5
Count the number of non-empty cells in A1:A5 and B1:B5
Find the largest value in A1:A5 and B1:B5
What function calculates the average of a range?
AVG
SUM
AVERAGE
MEAN
What is the difference between SUM and AVERAGE functions?
Write an example of an IF formula that checks if a number is greater than 100.
Which symbol is used to start a formula in Excel?
@
#
=
$
What does the formula =B2+C2 do?
Multiplies B2 and C2
Adds B2 and C2
Divides B2 by C2
Subtracts B2 from C2
What is the correct formula to find the largest number in a range A1:A10?
=MAX(A1:A10)
=LARGE(A1:A10)
=BIG(A1:A10)
=HIGHEST(A1:A10)
If you want to count only the cells in a range that contain numbers, which function should you use?
IF
COUNT
COUNTIF
SUM
What is the cell address at the intersection of column D and row 7?
7D
D7
7, D
D-7
What type of chart is best for comparing parts of a whole?
Bar Chart
Pie Chart
Line Chart
Scatter Plot
Which chart type is most suitable for comparing multiple categories?
Column Chart
Pie Chart
Scatter Plot
Funnel Chart
How can you change the font size of text in a cell?
Format Painter
Font Group on the Home Tab
Data Validation
Freeze Panes
Name two types of charts and explain when you would use each.
What is one way to change the font color of text in Excel?
What is a cell address ? Give an example
How do you apply a border to cells in Excel?
Click the cell, go to the 'Insert' tab, and select 'Border'.
Right-click the cell and select 'Format Cells'.
Select the cells, go to the 'Home' tab, click on 'Borders', and choose a border style.
Go to the 'View' tab and select 'Borders'.
Which operator is used for multiplication in Excel formulas?
-
+
/
*
