Font size
WorksheetsIcebreaker
Total questions: 24
Worksheet time: 8mins
What is filtering in Excel?
viewing data based on certain criteria
removing blank cells from a worksheet
arranging data into categories
sorting data alphabetically
Which chart type would be best for comparing values across categories?
scatter chart
column chart
line chart
area chart
what is a PivotTable?
a type of chart
a tool used to summarize data
a way to create macros
a type of a formula
What is the goal of "What-If" analysis?
to compare different versions of a workbook
to create charts and graphs
to calculate maximum and minimum values in a range
to explore how changing input values affects calculated values
Where is the fill handle located?
in the bottom-right corner of the selected cell
at the beginning of any formula or function
in Backstage view
on the right side of the Home tab on the Ribbon
In this image, why does the value in cell G1 look slightly different from the value in the formula bar?
It is using a formula.
It is using conditional formatting.
It is using the Currency number format.
It is using absolute cell reference
You can click the tabs at the bottom of a workbook to switch between____________
permissions
number formats
formulas
worksheets
Which of the following is an absolute cell reference?
A2
A:2
$A$2
#A2
Which of the formulas below are valid? Select all that apply.
=R2*D2
=5B+6B
=F2+F3+F4-53
A2+100
The four areas in this image are used to create a ____________
PivotTable
complex formula
subtotal
custom filter
What features starts with a desired result, then calculates the input value that will give that result?
Data validation
SmartArt
Reverse formula
Goal seek
How do you apply cell style to a range of cells in Excel?
Use the Insert Tab
Use the Format Cells dialog box.
Click the "Cell Styles" button on the Home tab, then select the style you want to apply.
none of these
What is the purpose of grouping worksheets in Excel?
to move or copy data between multiple worksheets at once
to perform calculation across multiple worksheets at once
to apply formatting changes to multiple worksheets at once
all of these functions
What is an example of a relative cell reference?
A$1
$A1
A1
$A$1
Who is the Chair of the Board of Kepler
Oliver Sabot
Keri Hoyt
Misan Rewane
Dan Gwinnell
Which option allows to lock certain rows and columns in place while scrolling through a large worksheet?
Split Panes
Freeze Panes
View Options
Lock Panes
What is filtering in Excel?
sorting data alphabetically
arranging data into categories
viewing data based on certain criteria
removing blank cells from a worksheet
Which chart type would be best for comparing values across categories?
column chart
line chart
area chart
scatter chart
What is the goal of "What-if" analysis?
to create charts and graphs
to compare different versions of a workbook
to calculate the maximum and minimum values in range
to explore how changing input values affects calculated values
What is the shortcut of enabling filtering
CTLR + Shift + F
CTRL + SHIFT + L
CTRL + SHIFT + S
CTRL + SHIFT + Z
What is the purpose of using absolute cell reference in Excel?
To make the cell value bold and italic.
To prevent the cell reference from changing when copied to other cells.
To automatically calculate the sum of all cells in a column.
To apply a specific number format to the cell.
How can you quickly navigate to the last cell in a worksheet in Excel?
Pressing Ctrl + Home keys.
Pressing Ctrl + End keys.
Double-clicking on the last cell.
Using the Find and Replace feature.
What does the error #DIV/0! indicate in Excel?
It indicates a circular reference error.
It indicates a divide by zero error.
It indicates a missing function error.
It indicates a data validation error.
When Kepler College accredited as a college in Rwanda by the government?
August 2013
January 2007
November 2022
April 2022
