NEW
Font size
WorksheetsExcel-O-Mania 2023
Total questions: 30
Worksheet time: 28mins
Which of the following is a valid function in Microsoft Excel?
=SUM(A1:B2)
=FORMAT(A1:B2)
=INSERT(A1:B2)
=SORT(A1:B2)
The bar graph presented above displays the total number of patients in five hospitals, namely P, Q, R, S, and T, along with the number of patients suffering from heart ailments in each of these hospitals.
P
Q
R
S
What is the default file extension for an Excel workbook file?
.xls
.xlsx
.xlsm
.xlam
Which function in Excel is used to find the highest value in a range of cells?
MIN
MAX
AVERAGE
SUM
Which chart type in Excel is best suited for showing trends over time?
Bar chart
Line chart
Pie chart
Scatter chart
What is the keyboard shortcut to autosum a column of numbers in Excel?
Alt + =
Ctrl + =
Shift + =
Tab + =
Which function in Excel is used to count the number of cells in a range that contain numbers?
COUNTA
COUNTIF
SUM
AVERAGE
Which chart type in Excel is used to show the parts of a whole?
Bar chart
Line chart
Pie chart
Scatter chart
What is the function of the VLOOKUP function in Excel?
To search for a value in a range of cells and return a corresponding value in the same row.
To count the number of cells in a range that contain a specific value.
To find the highest value in a range of cells.
To calculate the average of a range of cells.
Which function in Excel is used to round a number to a specific number of decimal places?
ROUND
ROUNDUP
ROUNDDOWN
SUM
What is the keyboard shortcut to open the "Find and Replace" dialog box in Excel?
Ctrl + F
Alt + F
Shift + F
Tab + F
Which function in Excel is used to calculate the future value of an investment based on a series of regular, constant payments?
FV
PV
PMT
RATE
Which chart type in Excel is used to show how much one data series contributes to the whole, while also showing the relationship of each data series to the others?
Stacked column chart
Clustered column chart
100% stacked column chart
Doughnut chart
What is the keyboard shortcut to hide a column in Excel?
Ctrl + H
Ctrl + Shift + H
Ctrl + Alt + H
Ctrl + 0
Which Excel function is used to calculate the net present value of an investment based on a series of regular, constant payments?
NPV
XNPV
IRR
CPV
Which Excel function is used to return the number of days between two dates, excluding weekends?
NETWORKDAYS
WORKDAY
WORKDAY.INTL
DAYS
Which chart type in Excel is best suited for showing the distribution of a dataset, especially when there are many data points?
Histogram
Box and whisker plot
Pareto chart
Waterfall chart
Which Excel function is used to calculate the covariance of two ranges of cells?
COVAR
COVARIANCE.P
COVARIANCE.S
COVARIANCE.R
Which function in Excel is used to concatenate two or more strings into one?
CONCAT
TEXTJOIN
CONCATENATE
JOIN
Which function in Excel is used to find the standard deviation of a range?
STDEV
STDEVA
STDEVP
STDEVPA
Which function in Excel is used to find the value that occurs most frequently in a range?
MODE
MEDIAN
MEAN
MAX
Which function in Excel is used to calculate the sum of a range based on multiple criteria?
SUMIFS
COUNTIFS
MAXIFS
AVERAGEIFS
Which Excel feature allows you to create a new worksheet based on templates
Theme
Style
Format
New workbook
Which function in Excel is used to return the value of the cell one column to the left of the current cell?
OFFSET
INDEX
MATCH
HLOOKUP
Which of the following formulas would you use to divide one cell by another cell in Excel?
QUOTIENT
PRODUCT
MAX
MIN
Which function in Excel allows you to calculate the square root of a number?
SQRT
POWER
SUMSQ
ROUND
Which of the following is NOT a valid data type in Excel?
Number
Date/Time
Boolean
All of the above are valid data types
What is the purpose of the COUNTIF function in Excel?
To calculate the sum of a range of cells
To calculate the average value of a range of cells
To count the number of cells in a range that meet a specific criterion
To look up a value in a table and return a corresponding value from a different column in the same row
Which of the following is NOT a valid way to format a cell in Excel?
Change the font size
Apply bold or italic formatting
Change the cell's value
Change the cell's background color
Which of the following is a valid comparison operator in Excel?
+
*
/
<
