Font size
WorksheetsExcel Basics Quiz
Total questions: 118
Worksheet time: 1hrs 2mins
How can you create a new workbook in Microsoft Excel?
Right-click on an existing sheet and choose "New Workbook"
Press Ctrl + S
Go to File > New
Close an existing workbook
What is the shortcut key combination to save a workbook in Excel?
Ctrl + S
Ctrl + C
Ctrl + X
Ctrl + P
To change the name of a sheet in Excel, you should:
Right-click on the sheet and choose "Rename"
Press Ctrl + R
Delete the sheet and create a new one with the desired name
Use the Format Painter
How can you add a new sheet to an existing Excel workbook?
Click the "Delete" button on the Ribbon
Go to File > New
Right-click on an existing sheet and select "Add New Sheet"
Click the " + " button at the bottom of the sheet tabs
Which feature in Excel automatically saves your workbook at regular intervals?
AutoFormat
AutoSum
AutoFill
Autosave
Which data type is appropriate to enter a phone number in Excel?
Date
Formula
Numeric
Text
To enter a numeric value "250" into a cell, you would:
Type "=250"
Type "250"
Type "two fifty"
Type "2e2"
How can you navigate to the last cell in a worksheet containing data?
Press Ctrl + Home
Use the arrow keys
Press Ctrl + End
Click on the cell
How can you edit the content of a cell in Excel?
Right-click the cell and choose "Edit"
Press Enter
Press Ctrl + E
Double-click the cell or press F2
What is the correct cell address for the cell located at the intersection of column B and row 5?
B4
A5
C5
B5
How can you insert a new column in Excel?
Click the "Delete" button on the Ribbon
Press Ctrl + C
Right-click on a column header and choose "Insert Column"
Press Ctrl + V
How can you align the text within a cell to be centred both horizontally and vertically?
Click the "Bold" button on the Ribbon
Use the alignment buttons in the Alignment group
Use the "Merge & Center" option
Apply a cell border
Which option is used to clear the contents of selected cells in Excel?
Format Cells dialog box
Ctrl + Delete
Backspace key
Delete key
Which formatting option allows you to change the appearance of the cell borders in Excel?
Font style
Borders and shading
Numeric formats
Cell alignment
When you insert a new cell within a column, the existing cells will shift __________ the inserted cell:
To the left of
Above
To the right of
Below
When inserting a new cell in a row, the existing cells will shift __________ the inserted cell:
Above
To the right of
To the left of
Below
What is the purpose of pinning regions in Excel?
To group multiple sheets together
To highlight a cell with color
To freeze a section of the worksheet
To hide the Ribbon
Which option is used to apply a shading color to the background of a cell in Excel?
Font Color
Text Format
Border Color
Fill Color
Autocomplete in Excel refers to:
Automatically saving the workbook
Predictive text suggestions while typing
Converting text to numbers
Auto-formatting the cells
How can you hide an Excel window temporarily without closing it?
Click the "Minimize" button on the window
Use the "Hide Window" option from the View menu
Press Ctrl + H
Press Alt + F4
What is the purpose of text concatenation in Excel?
To split text into multiple columns
To merge text from multiple cells into one cell
To highlight text using bold formatting
To create a new sheet for text data
Which Excel function is used to count the number of cells that meet a specific condition?
MINIF()
SUMIF()
AVERAGEIF()
COUNTIF()
How does the SUMIF() function work in Excel?
It calculates the average of cells that meet a condition.
It counts the number of cells that meet a condition.
It adds up values in a specified range that meet a condition.
It finds the smallest value in a specified range.
What does the NOT() function in Excel do?
Returns a random number
Inverts the logical value (True to False or False to True)
Converts text to uppercase
Multiplies values
Which type of conditional formatting uses icons to represent data values?
Data bars
Icon packs
Color scales
Cell styles
What is a histogram in the context of conditional formatting?
A way to highlight duplicate values
A visual representation of data distribution in columns or bars
A formula-based rule
A range validator
What is the purpose of using color scales in Excel's conditional formatting?
To change font color
To split cells
To hide values
To visualize data using color gradients based on cell values
Which Boolean function is used to check if multiple conditions are simultaneously true?
OR()
NOT()
TRUE()
AND()
What does the IF() function in Excel do?
Combines text
Checks if a condition is true or false and returns values based on the result
Creates graph
None of the above
What does the IF() function in Excel do?
Checks if a condition is true or false and returns values based on the result
Combines text
Creates graphs
Applies filters
What is the main purpose of a PivotTable in Excel?
To organize and summarize large amounts of data
To create dropdown lists
To protect worksheet
To merge cells
What are functions and their codes in the context of subtotals in Excel?
Descriptions of different subtotal functions available in Excel
Shortcuts to apply filters
Color codes only
Reference styles
How can you display dates and times more effectively in a PivotTable using a graphical representation?
By adding a Timeline
By sorting manually
By creating a formula
By merging columns
What is the purpose of using slices in Excel's PivotTables?
To provide a user-friendly way to filter and interact with data
To divide content
To delete empty rows
To lock ranges
What is a PivotChart in Excel?
A visual representation of PivotTable data
A type of slicer
A comment
A macro
What is the working principle of 'Interim Results' in subtotals?
It calculates intermediate totals at various levels of grouping.
It converts values to percentage
It merges columns
It filters
What does the order of calculation refer to in Excel?
The order in which cells are arranged on the worksheet
The order in which Excel performs calculations in a formula
The sequence in which you enter data
The order of formatting applied to cells
What is the shortcut key to quickly apply the SUM function in Excel?
Ctrl + A
Alt + S
Ctrl + S
Alt + =
Which basic function is used to count the number of cells that contain numerical values within a range?
AVERAGE()
TOTAL()
COUNT()
MAX()
In Excel, what symbol is used to represent the multiplication operation in a formula?
*
+
-
/
Which Excel function is used to add up a range of numbers?
MAX()
MIN()
SUM()
AVG()
What is the purpose of linking cells from one sheet to another in Excel?
To create a copy of the data in the target sheet
To apply formatting to cells in the target sheet
To hide the data in the source sheet
To display data from another sheet without duplicating it
In Excel, what is an absolute cell reference indicated by?
A dollar sign ($) before the column letter and row number
An asterisk (*) before the cell address
An exclamation mark (!) before the cell address
A pound sign (#) before the cell reference
When you copy a formula in Excel with relative addressing, how are cell references adjusted?
They update based on the new position of the formula
They convert to R1C1 style references
They remain fixed as they are
They become absolute references
In Excel, what is the purpose of creating a note (comment) in a cell?
To highlight the cell with color
To display additional information or context about the cell's content
To lock the cell and prevent further editing
To change the font size of the cell's content
How can you link to a cell in another workbook in Excel?
Right-click the cell and choose 'Link to Workbook.'
Use the 'Insert Hyperlink' option from the Ribbon
Press Ctrl + L to open the Link dialog box
Type the workbook name in the formula bar followed by an exclamation mark
When using 'Paste Special: Values' in Excel, what is copied and pasted?
Only the numerical values from the cells
The original formatting of the cells
Formulas and their calculated results
The comments and notes in the cells
In Excel, what is the purpose of using numeric filters?
To filter data based on numeric criteria
To change the font color of numeric values
To hide all text values
To sort data in ascending order
What is the purpose of Quick Sort in Excel?
To sort data numerically from high to low
To automatically apply cell formatting
To quickly alphabetize text in a range
To sort data based on multiple criteria
What does the 'Paste Special: Transpose' option do in Excel?
Swaps rows and columns of the selected range
Changes the font style of the copied data
Copies the selected range to a different sheet
Copies the formula in reverse order
What is the title of a chart in Excel?
Chart Axis
Chart Series
Chart Title
Chart Legend
What are Sparklines in Excel?
Animated shapes in a worksheet
Placeholder images for missing data
A type of data validation rule
Small, simple charts displayed within cells
In an Excel chart, what do you call the horizontal and vertical lines that help define the data points?
Markers
Axis Lines
Gridlines
Reference Lines
In Excel, what are the options available for searching data within a worksheet?
Bold and Italic, Fill Color
Case Sensitive, Whole Word
Rows and Columns, Conditional Format
In Excel, what are the options available for searching data within a worksheet?
Bold and Italic, Fill Color
Case Sensitive, Whole Word
Rows and Columns, Conditional Formatting
Charts and Graphs, Validation
What is the purpose of the "Find and Replace" feature in Excel?
To locate specific data and replace it with new values
To sort data based on specific criteria
To find and replace formatting in cells
To search for formulas within a worksheet
When using the "Remove Duplicates" feature in Excel, can you remove duplicates from one column at a time?
No, duplicates can only be removed from the entire worksheet
Yes, only one column at a time
Yes, but only if the data is sorted alphabetically
No, duplicates can only be removed from entire rows
What does "fixed-width division" refer to in Excel?
Distributing text evenly across multiple rows
Using a fixed font size for text in cells
Dividing numbers with fixed decimal places
Dividing cells into columns based on a specific width
How can you replace values in Excel without using the "Find and Replace" dialog?
Use the "Fill Series" command from the Ribbon.
Right-click the cell and choose "Replace."
Delete the values and manually enter the new ones.
Press the "Ctrl + R" shortcut key combination.
How can you split text into columns in Excel using a delimiter?
Press Ctrl + Shift + C.
Use the "Convert Text to Columns" wizard and specify the delimiter.
Right-click the cell and choose "Split Text."
Apply the "Text to Columns" cell style.
Which function returns the highest value in a range?
MIN()
MAX()
SUM()
AVERAGE()
Which function returns the number of non-empty cells in a range?
COUNT()
COUNTA()
COUNTBLANK()
COUNTIF()
What happens if you press Ctrl + Z in Excel?
Undo the last action
Redo the last action
Save the workbook
Zoom in
How do you apply a filter to data in Excel?
Insert > Filter
Click the Filter button on the Data tab
Use the Review tab
Use the Sort command
Which tab contains the option to insert a chart?
Review
Home
Insert
View
How do you make a cell's contents bold?
Ctrl + U
Ctrl + B
Ctrl + I
Ctrl + E
Which tool would you use to analyze "what-if" scenarios?
PivotTable
What-If Analysis
Macro
Solver
What does the NOW() function return?
Current date
Current date and time
Current worksheet name
Today's time only
Which menu helps you protect a worksheet?
File
Review
Insert
View
What is the use of Goal Seek?
To find the input needed to achieve a desired result
To format tables
To create a pivot chart
What does Flash Fill do in Excel?
Automatically formats charts
Sorts data in ascending order
Automatically fills in values based on patterns
Applies filters to data
How can you rename an Excel workbook file?
Press F2 inside Excel
Right-click the file in File Explorer and choose "Rename"
Use the File > Save As option
Edit the title bar in Excel
Which chart is best for showing parts of a whole in Excel?
Pie Chart
Line Chart
Column Chart
Scatter Chart
What does the IF function do in Excel?
Filters only numeric values
Performs a logical test and returns values based on condition
Creates a dropdown list
Finds and replaces text
What is conditional formatting used for?
To apply formatting based on cell values
To set row height
To import data
To hide formulas
Which function is used to combine text from two or more cells?
CONCATENATE()
SUM()
TEXTJOIN()
SPLIT()
How do you lock a cell reference in a formula?
Use parentheses
Use "!"
Use the $ symbol
Use #
What is a macro in Excel?
A charting tool
A recorded sequence of commands
A conditional format
A filter
What tool can you use to ensure only numbers are entered in a cell?
Data Validation
Conditional Formatting
Filter
AutoCorrect
How do you select an entire worksheet?
Ctrl + A
Select row 1
Click the Select All button (top-left corner)
Shift + Space
What is the default file extension for Excel 365 workbooks?
.xls
.xlt
.xlsx
.docx
Which function rounds numbers to a specified number of digits?
INT()
ROUND()
SUM()
FLOOR()
Which formula finds the average of a group of numbers?
MEAN()
SUM()/COUNT()
AVERAGE()
MID()
How can you insert today's date in Excel?
=TIME()
=NOW()
=TODAY()
=DATE()
What is the keyboard shortcut to insert a new worksheet?
Ctrl + N
Shift + F11
Alt + Enter
Ctrl + W
What does the TRIM function do?
Removes extra spaces from text
Truncates numbers
Deletes rows
Adds spaces to data
How can you make Excel formulas show instead of results?
View tab > Show Formulas
Ctrl + ` (grave accent)
Ctrl + F
Alt + =
How can you make Excel formulas show instead of results?
View tab > Show Formulas
Ctrl + ` (grave accent)
Ctrl + F
Alt + =
Which function checks whether a value is numeric?
ISTEXT()
ISNUMBER()
ISLOGICAL()
ISEMPTY()
Which feature in Excel fills a series automatically (like days or months)?
Autofill
Flash Fill
Fill Handle
Filter
What does the LEN() function return?
Line height
Number of characters in a text string
Total cells in a range
Position of a value
Which key combination is used to start a new line in a cell?
Ctrl + Enter
Alt + Enter
Shift + Tab
Ctrl + Shift
What does the TEXT function do in Excel?
Converts a number to text in a specific format
Translates words
Extracts part of a string
Deletes text
Which of the following is NOT a valid chart type in Excel?
Line
Area
Dot Matrix
Combo
What is the purpose of the "Freeze Panes" feature?
To keep rows or columns visible while scrolling
To hide rows
To protect formulas
To lock formatting
How can you combine cells without losing data?
Use CONCATENATE or TEXTJOIN functions
Merge & Center
Data Validation
Paste Special
What does the AND() function return?
TRUE if all conditions are TRUE
Only text
The opposite of OR
Cell references
What does the OR() function return?
TRUE if any condition is TRUE
FALSE always
The opposite of NOT
FALSE if one is false
Which error indicates a divide-by-zero problem?
#NAME?
#VALUE!
#DIV/0!
#REF!
Which function returns the current time only (without date)?
=TEXT(NOW(),"hh:mm:ss")
=NOW()
=TIME()
=TODAY()
In Excel, what is the working principle of "Interim Results" in subtotals?
It calculates intermediate totals at various levels of grouping.
It adds cell formatting to the subtotal results
It calculates an average of data points
It performs a multiplication operation
What is complex sorting in Excel?
Sorting data using only one criterion
Sorting data in random order
Sorting data based on multiple criteria
Sorting data using a custom formula
In Excel, if you want to test multiple conditions to ensure they are all met within a range, you would use:
Range check
Cell check
Condition check
Value check
When using the COUNT function, which argument represents the condition you're checking against?
Sum_range
Range
Criteria
Average_range
In Excel, which reference style refers to cell A1 as R1C1?
A1 style references
Named range style
R1C1 style references
RICI style references
How can you link data from cell A1 in Sheet2 to cell A1 in Sheet1?
'Sheet2'!A1
Sheet2A1
'Sheet1A1
Sheet2!A1
How do you copy the text of a formula without copying the actual formula?
Copy formula text
Drag the fill handle
Use the "Paste Values" option
Use the "Copy function"
If you want to determine the smallest number in a data set, which function is best suited?
AVERAGE
MIN
SMALL
COUNT
If a formula contains both absolute and relative references, it's referred to as which type of reference?
Mixed
Absolute
External
Relative
Which feature provides a chronological filter for PivotTables?
Date Selector
ChronoFilter
Timelines
PivotTime
If you want to create an interactive slider to filter dates in a PivotTable, you should use:
TimeFilter
DateBar
Timelines
DateSlider
What is a key feature of a Smart Table in Excel?
It can only contain numeric data
It has built-in calculations and formatting options
It allows for advanced sorting but not filtering
It automatically updates its format based on data changes
What formula feature allows data from one sheet to dynamically update in another sheet when the original data changes?
Embedding sheets
Linking cells
Merging cells
Grouping cells
What hotkey can you use to quickly auto-sum selected cells?
Ctrl + S
Alt + S
Alt + =
Ctrl + =
How do you include additional information about a cell without altering its content?
Which Excel function returns TRUE only if all arguments are TRUE?
OR
IF
NOT
AND
How do you use text filters in Excel to display specific data?
By converting text to numbers
By filtering out numeric values
By selecting specific text values to show
By sorting data alphabetically
What options are available for searching data within a worksheet using "Find and Replace"?
Sort Ascending, Sort Descending
Delete, Format Cells
Bold, Italic
Whole Word, Case Sensitive
