Font size
WorksheetsExcel Assessment 2
Total questions: 53
Worksheet time: 17mins
What is the shortcut to save a workbook in Excel?
Ctrl + S
Ctrl + C
Ctrl + V
Ctrl + X
How do you start a formula in Excel?
#
$
@
=
Which function is used to find the average of a range of numbers in Excel?
SUM
AVERAGE
MIN
MAX
What is the result of the formula =SUM(2, 4, 6)?
10
12
8
14
Which symbol is used to lock cell references in Excel?
&
%
$
#
Which feature allows you to quickly fill cells with a series of numbers or dates?
AutoFill
Flash Fill
Series Fill
Quick Fill
How do you insert a new worksheet in an Excel workbook?
File > New Worksheet
Insert > New Worksheet
Right-click a worksheet tab and select Insert
Home > New Worksheet
Which function is used to find the largest value in a range?
MIN
MAX
LARGE
BIG
What does the CONCATENATE function do?
Adds numbers
Joins text strings
Finds the average
Subtracts numbers
Which chart type is best for showing trends over time?
Pie Chart
Column Chart
Line Chart
Bar Chart
What is the default file extension for an Excel workbook?
.xls
.xlsx
.docx
.pptx
How can you quickly adjust the width of a column to fit its contents?
Double-click the right border of the column header
Right-click the column and select Fit Width
Home > Fit Width
Format > AutoFit Column Width
Which function would you use to count the number of cells that contain numbers in a range?
COUNTIF
COUNT
COUNTA
SUM
What does the VLOOKUP function do in Excel?
Looks up a value in a vertical table
Adds values in a column
Looks up a value in a horizontal table
Finds the minimum value
How do you apply conditional formatting to a cell?
Insert > Conditional Formatting
Home > Conditional Formatting
Data > Conditional Formatting
Review > Conditional Formatting
Which function calculates the total of a range of numbers?
SUM
COUNT
ADD
TOTAL
How do you create a drop-down list in a cell?
Data > Data Validation
Insert > Drop-Down List
Home > Drop-Down List
Review > Data Validation
What does the PMT function calculate?
Payment for a loan
Profit margin
Present value of an investment
Percentage growth
Which function would you use to find the smallest value in a range?
SMALL
MIN
LOW
MINIMUM
How can you freeze the top row in Excel?
View > Freeze Panes > Freeze Top Row
Insert > Freeze Panes
Data > Freeze Panes
Home > Freeze Panes
Which of the following is NOT a type of cell reference in Excel?
Relative
Absolute
Mixed
Dynamic
What does the TODAY function return?
The current date and time
The current date
The current time
The start of the week
How do you remove duplicates from a range in Excel?
Data > Remove Duplicates
Home > Remove Duplicates
Insert > Remove Duplicates
Review > Remove Duplicates
Which function would you use to round a number to a specified number of decimal places?
ROUNDUP
ROUNDDOWN
ROUND
ROUNDTO
How do you create a named range?
Formulas > Name Manager
Insert > Named Range
Home > Named Range
Data > Name Manager
What does the IF function do in Excel?
Performs a logical test
Sums values based on a condition
Counts values based on a condition
Finds the average of a range
How can you protect a worksheet in Excel?
Review > Protect Sheet
Home > Protect Sheet
Insert > Protect Sheet
Data > Protect Sheet
Which feature allows you to quickly analyze large amounts of data in a table?
PivotTable
VLOOKUP
Data Table
SUMIF
What does the TRIM function do?
Removes spaces from text
Rounds a number
Converts text to uppercase
Concatenates text
How do you apply a filter to a range of data?
Data > Filter
Insert > Filter
Home > Filter
Review > Filter
Which function is used to return the current date and time?
NOW
DATE
TIME
CURRENT
How do you insert a comment in a cell?
Review > New Comment
Insert > New Comment
Home > New Comment
Data > New Comment
What is the purpose of the Merge & Center feature?
To merge multiple cells into one and center the content
To center text within a cell
To merge rows
To center text across multiple cells
Which function would you use to count the number of blank cells in a range?
COUNTA
COUNTIF
COUNTBLANK
COUNT
How can you quickly duplicate the contents of a cell?
Ctrl + C and Ctrl + V
Ctrl + D
Alt + Enter
Shift + Enter
What does the LEFT function do?
Returns characters from the left of a text string
Returns characters from the right of a text string
Joins text strings
Finds the length of a text string
Which of the following is NOT a valid date format in Excel?
12/31/2020
31-Dec-2020
Dec-31-2020
2020/31/12
How do you create a pivot chart?
Insert > PivotChart
Home > PivotChart
Data > PivotChart
Review > PivotChart
What does the HLOOKUP function do in Excel?
Looks up a value in a horizontal table
Looks up a value in a vertical table
Adds values in a row
Finds the maximum value
Which feature allows you to split the window into multiple panes?
View > Split
Insert > Split
Home > Split
Data > Split
How do you hide a worksheet in Excel?
Right-click the worksheet tab and select Hide
File > Hide Worksheet
Home > Hide Worksheet
Data > Hide Worksheet
What does the SUMIF function do?
Sums values based on a condition
Sums values in a range
Sums values across multiple sheets
Sums values horizontally
How do you apply a border to a range of cells?
Home > Border
Insert > Border
Review > Border
Data > Border
Which function returns the number of characters in a text string?
LEN
LEFT
MID
RIGHT
How do you insert a hyperlink in a cell?
Insert > Hyperlink
Home > Hyperlink
Data > Hyperlink
Review > Hyperlink
What does the FIND function do?
Finds the position of a text string within another text string
Finds the length of a text string
Finds and replaces text
Finds duplicate values
Which feature allows you to view different parts of a large worksheet simultaneously?
Split
Freeze Panes
New Window
View Side by Side
How do you change the orientation of text in a cell?
Home > Orientation
Insert > Orientation
Data > Orientation
Review > Orientation
What does the SUBSTITUTE function do?
Replaces text in a string
Finds text in a string
Joins text strings
Converts text to lowercase
Which function would you use to calculate the number of workdays between two dates?
NETWORKDAYS
WORKDAYS
DAYS
WEEKDAYS
As the Data Analyst in marketing Firm, You are given A dataset. Briefly outline the steps you would carry out before you start analysis.
How will you handle duplicates during the analytic process?
53a. List out 10 excel formulas that you know
b. Outlines the steps to insert a pivot table in a new worksheet in excel.
