NEW
Font size
WorksheetsMS Excel Basics Quiz
Total questions: 10
Worksheet time: 50secs
What is MS Excel?
Spreadsheet
Database Management
Presentation
Workbook
What is the keyboard shortcut for copying cells in Excel?
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + Z
In Excel, what does the function COUNTA() do?
Counts the number of cells in a range that are not blank
Counts the number of cells in a range that are greater than zero
Counts the number of cells in a range that contain text
Counts the total number of cells in a range
What does the term "cell" refer to in Microsoft Excel?
A group of worksheets
The intersection of a row and column
A type of chart
A formatting option
Which function is used to sum a range of cells in Excel?
AVG()
MAX()
SUM()
TOTAL()
What is the purpose of the AutoSum button in Excel?
It adds up a range of cells
It multiplies a range of cells
It calculates the average of a range of cells
It finds the maximum value in a range
What are the shortcut keys for AutoSum
ALT and S
ALT and =
CTRL and S
CTRL and =
How do you insert a new worksheet in Excel?
Press Ctrl + N
"Insert" Go to the "Home" tab and click "Insert Sheet"
Right-click on a sheet tab and choose
Both A and B
How can you merge cells in Excel?
Use the "Merge & Center" button
Apply a cell style
Use the "Merge Cells" option in the Format menu
Both A and C
In Microsoft Excel spreadsheets, rows are designated as _______.
1, 2, 3, ....
A, B, C, ....
A1, B1, C1, ....
I, II, III, ....
