Font size
WorksheetsWorkforce Spreadsheet
Total questions: 31
Worksheet time: 25mins
What is the name of the worksheet in Excel?
Sheet
Cell
Tab
Block
What function is used to sum a range of numbers in Excel?
Average
Sum
Median
Max
Which feature in Excel can be used to create trend lines for data?
Data Validation
Pivot Tables
Conditional Formatting
Sparklines
What is the shortcut to Bolden text in Excel?
Control Shift B
Control R
Control D
Control B
Which function is used to calculate the average of a range of numbers in Excel?
Median
Average
Max
Sum
How can you rename a worksheet in Excel?
Control D
Control R
Right click and select Rename
Double click on the tab
What does the IF function do in Excel?
Formats the cells
Calculates the sum
Creates a conditional statement
Finds the maximum value
Which feature in Excel can be used to highlight cells based on specific conditions?
Sparklines
Data Validation
Conditional Formatting
Pivot Tables
How can you add a new worksheet in Excel?
Control R
Control D
Hit the plus sign
Control Shift N
Which function is used to find the minimum value in a range of cells?
Average
Min
Sum
Max
What formula will return the total number of items in the cell range?
MIN
COUNT
MAX
Active Cell
If MAX finds the largest number and MIN finds the smallest number, what does MEDIAN find?
Average of all the numbers in the range
Total Number of Cells
The number that falls in the middle
All the numbers added together
What is the name of this Cell ?
6B
A5
6A
B6
To sort names in a worksheet, we can use ____ button
What is the cell address of the pink cell?
A1
1A
D3
3D
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
What is the primary advantage of using XLOOKUP over VLOOKUP?
XLOOKUP is faster
XLOOKUP can handle approximate matches
XLOOKUP can handle multiple criteria
XLOOKUP is an older function
You are working in the worksheet shown below. What will happen in cell C4 if you use the fill handle to drag cell B4 to C4?
The formula =B2-B3 will appear in cell C4.
The result of 300 will appear in the cell.
The formula =C2-C3 will appear in cell C4.
You will receive an error in the cell.
What is the advantage of using the IFS function in Excel compared to nested IF functions?
It allows you to specify multiple conditions and their corresponding results.
It is easier to read and understand.
It is more efficient for complex scenarios.
It can be used for similar purposes as the IF function.
In the picture, why is D2 through D5 placed in paranthesis?
So Excel knows to total the cells before performing the next operation.
So the total of the cells can be multiplied rather than added.
So the calculation will be done last.
Which of the following option is a formula?
A. =SUM(A1:A5)
B. Add A1 - A5
C. Subtract the numbers
D. A1 = A5
Which function can find the highest value in a cell range?
a. MAXVALUE
b. HIGHEST
c. TOP
d. MAX
Which of the following returns one value if the condition is TRUE, or another value if the condition is FALSE
IF function
IFS function
COUNT function
COUNTA function
How are you feeling today?
In the function =IF(SUM(B3:B6)>10, "Yes", "No"), which of the two functions will be evaluated first?
IF()
SUM()
Write a formula when fed in the Yellow cell shall tell us how many rappers like the color yellow.
=count(yellow)
=countifs(rapper,"yellow")
=sumif(B2:B8, "Yellow")
=countif(B2:B7, "Yellow")
Which formula will you use to calculate the Number of people who were absent?
=COUNTBLANK(Attendance)
=SUM(Attendance)
=COUNTA(Attendance)
=COUNT("Attendance")
Which function will give the correct number of quantities (i.e. 4 - excluding 'None')
COUNT(A2:A6)
COUNTA(A2:A6)
COUNTIF(B2:B6)
COUNT(B2:B6)
What function is used to sum a range of numbers in Excel?
Average
Sum
Median
Max
