WorksheetsMs. Excel - Final Quiz
Total questions: 32
Worksheet time: 16mins
What is the purpose of the SUM function in Excel?
To find the average
To add numbers together
To count cells
To find the maximum value
How do you start a formula in Excel?
With an equals sign (=)
With a plus sign (+)
With a minus sign (-)
With a colon (:)
Which function would you use to find the average of a range of numbers?
SUM
AVERAGE
COUNT
MAX
How can you quickly sum a column of numbers?
Use the SUM function
Use the MAX function
Use the MIN function
Use the AVERAGE function
What does the MIN function do?
Adds numbers
Finds the smallest number
Counts cells
Finds the largest number
Which function returns the highest value in a range?
MAX
MIN
SUM
AVERAGE
What is the purpose of the COUNT function?
To count the number of cells with numbers
To add numbers
To find the average
To find the maximum value
How do you refer to a cell in Excel?
By its row number only
By its column letter only
By its row number and column letter
By its cell color
What is the default alignment for text in Excel cells?
Left
Right
Center
Justify
What is the default alignment for numbers in Excel cells?
Left
Right
Center
Justify
How do you create a new worksheet in an Excel workbook?
Click the plus sign (+) next to the sheet tabs
Press Ctrl + N
Go to File > New
Right-click on the sheet tab and select "Insert"
Which function would you use to combine text from two or more cells?
A. COMBINE
B. CONCATENATE
C. JOIN
D. MERGE
How do you format cells to display numbers as currency?
Use the Number Format dropdown in the Home tab
Manually type the currency symbol
Use the MAX function
Use the SUM function
Which key combination is used to copy the contents of a cell?
Ctrl + X
Ctrl + V
Ctrl + C
Ctrl + Z
Which key combination is used to paste the copied contents of a cell?
Ctrl + X
Ctrl + V
Ctrl + C
Ctrl + Z
What is the function of the AutoSum button?
To find the average of a range
To count the number of cells in a range
To add a range of numbers automatically
To find the minimum value in a range
How do you insert a chart in Excel?
Go to the Insert tab and select a chart type
Right-click and select "Insert Chart"
Use the AutoSum button
Press Ctrl + C
What does the Fill Handle do in Excel?
Copies data to adjacent cells
Deletes the contents of a cell
Formats cells
Inserts a new worksheet
How do you rename a worksheet?
Double-click the sheet tab and type the new name
Right-click the sheet tab and select "Rename"
Go to File > Rename
Both A and B
How do you sort data in Excel?
Use the Sort button in the Data tab
Manually rearrange the rows
Use the Filter button in the Home tab
Press Ctrl + S
What is the shortcut for undoing an action in Excel?
Ctrl + Y
Ctrl + Z
Ctrl + X
Ctrl + C
How do you apply a filter to a column?
Use the AutoSum button
Use the Sort button in the Home tab
Press Ctrl + F
Use the Filter button in the Data tab
How do you merge cells in Excel?
Use the Merge & Center button in the Home tab
Use the AutoSum button
Use the Filter button in the Data tab
Press Ctrl + M
What is the purpose of the Format Painter?
To copy formatting from one cell to another
To copy data from one cell to another
To create charts
To sort data
How do you insert a new column in Excel?
Right-click the column header and select "Insert"
Use the Insert button in the Home tab
Press Ctrl + Shift + Plus (+)
All of the above
How do you delete a row in Excel?
Right-click the row header and select "Delete"
Use the Delete button in the Home tab
Press Ctrl + Minus (-)
All of the above
What does the Freeze Panes feature do?
Keeps selected rows and columns visible while scrolling
Sorts data
Filters data
Inserts charts
How do you adjust the width of a column?
Drag the boundary on the right side of the column header
Use the Format button in the Home tab
Double-click the boundary on the right side of the column header
Both A and C
What does the Conditional Formatting feature do?
Changes the formatting of cells based on specific criteria
Inserts charts
Sorts data
Copies formatting from one cell to another
How do you save a workbook in Excel?
Press Ctrl + S
Go to File > Save
Click the Save button on the Quick Access Toolbar
All of the above
How do you merge cells in Excel?
Use the Merge & Center button in the Home tab
Right-click and select "Merge Cells"
Press Ctrl + M
Use the AutoSum button
What is the purpose of the IF function in Excel?
To find the average of a range
To add numbers together
To perform logical tests and return values based on the result
To count cells
