NEW
Font size
WorksheetsMicrosoft Excel Review Quiz
Total questions: 20
Worksheet time: 10mins
What does the equal sign (=) signify in Excel formulas?
It is used to multiply values
It is used to add values
It is required as the first symbol for all formulas
It is used to subtract values
What is the purpose of the asterisk (*) in Excel?
To add values
To subtract values
To multiply values
To divide values
What is the function of Autofill in Excel?
To change the color of cells
To copy a formula into multiple cells
To adjust the column width
To create a chart
What type of chart uses vertical bars to display data?
Line Chart
Pie Chart
Column Chart
Scatter Plot
Which chart is best for visualizing trends and shifts in data?
Column Chart
Line Chart
Pie Chart
Bar Chart
What function is used to count cells with numbers, including negative numbers and percentages?
SUM
MAX
COUNT
MIN
Which function is used to find the highest number in a batch of cells?
MIN
SUM
MAX
AVERAGE
What does the 'Sum' function do?
Subtracts numbers
Divides numbers
Multiplies numbers
Sums two or more cells of data
What is a workbook in Excel?
A single page in Excel
A file containing one or more worksheets
A tool for creating charts
A function for calculating data
What symbol is used at the beginning of all formulas and functions in Excel?
+
-
=
*
Which function is used to find the lowest number in a batch of cells?
MAX
SUM
MIN
AVERAGE
What is a worksheet in Excel?
A file containing multiple workbooks
A single page in Excel where you can enter data and perform calculations
A tool for creating charts
A function for calculating data
What is the function of the '+' symbol in Excel formulas?
To subtract numbers
To add numbers
To divide numbers
To multiply numbers
What is the function of the '-' symbol in Excel formulas?
To add numbers
To subtract numbers
To divide numbers
To multiply numbers
What is the function of the '*' symbol in Excel formulas?
To add numbers
To subtract numbers
To divide numbers
To multiply numbers
What type of chart helps organize and show data as a percentage of a whole.
Pie Chart
Column Chart
Line Chart
Bar Chart
What symbol appears when a column is not wide enough?
Hashtag: ####
Forward Slash: ////
At Sign: @@@@
Currency Sign: $$$$
What does Autofill do?
Allows you to copy a formula to other cells
Fills a cell with a desired symbol
Fills the cell with the specified color
What type of chart uses horizontal bars to present the data?
Bar Chart
Line Chart
Column Chart
Pie Chart
A cell reference refers to the location of a specific cell (e.g. A1, C17, D5, etc.)
True
False
