1) Which formula subtracts B1 from A1? a) =A1-B1 b) =B1-A1 c) =A1+B1 d) =A1*B1 2) How do you calculate the average of A1 to A13? a) =Sum(A1:A13) b) =Average(A1:A13) c) =Mean(A1:A13) d) =Total(A1:A13) 3) Which function finds the largest number? a) =Min(A1:A10) b) =Max(A1:A10) c) =Sum(A1:A10) d) =Avg(A1:A10) 4) What does conditional formatting do? a) Sorts data b) Formats cells c) Highlights cells d) Adds charts 5) Which chart type shows trends over time? a) Pie chart b) Line chart c) Bar chart d) Scatter plot 6) What does the IF function do? a) Calculates sums b) Checks conditions c) Sorts data d) Formats cells 7) How do you sort data in Excel? a) Use filters b) Use sort option c) Use charts d) Use formulas 8) Which function counts cells with numbers? a) =Count(A1:A10) b) =Sum(A1:A10) c) =Avg(A1:A10) d) =Max(A1:A10) 9) How do you apply a data bar? a) Insert chart b) Conditional formatting c) Sort data d) Use formulas 10) Which function adds up a range? a) =Sum(A1:A10) b) =Add(A1:A10) c) =Total(A1:A10) d) =Plus(A1:A10) 11) What is the shortcut for bold text? a) Ctrl+B b) Ctrl+I c) Ctrl+U d) Ctrl+S 12) How do you filter data? a) Use sort option b) Use filter option c) Use charts d) Use formulas 13) Which function finds the smallest number? a) =Min(A1:A10) b) =Max(A1:A10) c) =Sum(A1:A10) d) =Avg(A1:A10) 14) What does the SUM function do? a) Adds numbers b) Subtracts numbers c) Multiplies numbers d) Divides numbers 15) How do you format a cell as currency? a) Use currency format b) Use text format c) Use number format d) Use date format

Excel Basics and Functions Quiz

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?