Worksheets4/4/25
Total questions: 39
Worksheet time: 23mins
By Default, how many pages is on a new excel workbook?
4
2
1
Rows in excel are recognized by:
Letters
Numbers
Blanks
To change the color on a worksheet tab:
Right click
Left click
Click on the font tab
Which tab should you click to align a cell?
File
Home
Page Layout
What is the name of the arrow to the right of each group?
Name Box
Formula Bar
Dialogue Box
Where is the quick access tool bar located?
Top of the workbook
Middle of the workbook
Bottom of the workbook
What should you do to accept the information which as been typed in a cell?
Press the enter key
Press the tab key
Click the check mark
All of the above
By default, what is the color the the sheet tabs?
Blue
Green
Black
Gold
What does the word "Time New Roman" represent?
Number
Letters
Fonts
Rows
What is the name of the object that joins a column and a row?
(a)
Function used to find the largest number in the cell range B4 through J4.
=MAX(B4:J4)
=LARGEST(B4:J4)
=MAX(B4-J4)
@MAX(B4:J4)
Which function in Excel 2019 is used to find the highest value in a range of cells?
MAX
SUM
AVG
MIN
In Excel 2019, what keyboard shortcut is used to insert a new worksheet?
Ctrl + N
Ctrl + Shift + N
Ctrl + W
Ctrl + I
Which Excel feature allows you to visually represent data through charts and graphs?
Formulas
PivotTables
Sparklines
SmartArt
What does the COUNTIF function in Excel 2019 do?
Which ribbon tab in Excel 2019 is specifically dedicated to dealing with formulas and functions?
Home
Formulas
Data
Insert
What is the purpose of the VLOOKUP function in Excel?
Vertical lookup
Horizontal lookup
Logical lookup
Lookup for text values
In Excel 2019, what is the shortcut for "Paste Special"?
Ctrl + P
Ctrl + V
Ctrl + Alt + P
Ctrl + Shift + V
Which chart type is suitable for displaying the percentage contribution of each data point to the whole in Excel?
Pie Chart
Bar Chart
Line Chart
Scatter Plot
What does the CONCATENATE function do in Excel 2019?
Adds up values in a range
Combines multiple text strings into one string
Calculates the average of a range
Divides values in a range
In Excel 2019, what does the Freeze Panes feature allow you to do?
Lock specific cells to prevent editing
Hide selected rows or columns
Keep selected rows or columns visible while scrolling
Split the worksheet into multiple panes
What is the default file extension for an Excel 2019 workbook?
.xlsx
.xlsm
.csv
.xls
Which function in Excel 2019 is used to count the number of cells that contain numbers?
COUNTIF
COUNTBLANK
COUNTA
COUNT
In Excel 2019, which feature allows you to automatically fill cells with a series of data?
Data Fill
Quick Fill
AutoFill
Flash Fill
Which Excel function is used to calculate the average of a range of cells?
MODE
SUM
MEDIAN
AVERAGE
In Excel 2019, which feature allows you to combine multiple cells into one cell?
Conditional Formatting
Text to Columns
Wrap Text
Merge & Center
What is the shortcut key for saving a workbook in Excel 2019?
Ctrl + A
Ctrl + Z
Ctrl + C
Ctrl + S
Which Excel function is used to find the smallest value in a range of cells?
LEAST
MIN
LOW
SMALL
What is the shortcut key for undoing an action in Excel 2019?
Ctrl + Y
Ctrl + Z
Ctrl + U
Ctrl + R
In Excel 2019, which feature allows you to apply a specific format to cells that meet certain criteria?
Data Validation
Format Painter
Conditional Formatting
Cell Styles
In Excel 2019, which feature allows you to quickly apply the same formatting to multiple cells?
Data Validation
Format Painter
Conditional Formatting
Cell Styles
What is the shortcut key for creating a new workbook in Excel 2019?
Ctrl + N
Ctrl + W
Ctrl + Shift + N
Ctrl + Alt + N
Which Excel function is used to count the number of blank cells in a range?
COUNTBLANK
COUNTA
COUNT
COUNTIF
What is the purpose of the SUM function in Excel 2019?
To add up all the numbers in a range
To find the maximum value in a range
To find the minimum value in a range
To count the number of cells in a range
Which feature in Excel 2019 allows you to create a chart from selected data?
Data Analysis
Data Validation
Chart Wizard
Insert Chart
What is the shortcut key for opening a new worksheet in Excel 2019?
Ctrl + O
Ctrl + N
Ctrl + W
Ctrl + Shift + N
Which function in Excel 2019 is used to calculate the average of a range of cells?
SUM
AVERAGE
MEDIAN
MODE
In Excel 2019, which feature allows you to filter data based on specific criteria?
Conditional Formatting
Filter
Sort
Data Validation
What is the shortcut key for closing a workbook in Excel 2019?
Ctrl + F4
Alt + F4
Ctrl + W
Ctrl + Q
