WorksheetsMicrosoft Excel Quiz
Total questions: 20
Worksheet time: 7mins
Microsoft Excel is mainly used for ________.
Creating text documents
Managing and analyzing numerical data
Designing presentations
Drawing graphics
The intersection of a row and a column in Excel is called a ________.
Table
Field
Cell
Grid
In Excel, columns are labeled with ________.
Numbers
Letters
Symbols
Words
Rows in Excel are labeled with ________.
Numbers
Letters
Words
Dates
The **active cell** in Excel is identified by ________.
A bold border around it
A red highlight
A gray shade
A blinking cursor
Which of the following is the **cell address** for the intersection of column B and row 5?
5B
B5
Row5B
B-5
Which tab on the Ribbon contains tools for copying, cutting, and pasting data?
Home
Insert
Page Layout
Data
To select an entire column, click on ________.
The column letter
Any cell in that column
The first cell of the column
The row number
To select an entire row, click on ________.
The row number
The first cell in that row
The column letter
The Name Box
Which command is used to quickly copy the contents of one cell to another?
Delete
Copy and Paste
Move
Shift
To make text **bold** in Excel, you can use the shortcut ________.
Ctrl + I
Ctrl + U
Ctrl + B
Ctrl + E
You can change the **font size and color** using the options found on the ________ tab.
Insert
Home
Page Layout
Review
Which alignment option places text evenly between the left and right sides of a cell?
Left Align
Right Align
Center
Justify
The **Merge & Center** button is used to ________.
Add a border
Combine several cells into one and center the text
Split cells
Create a table
To add a **border** around selected cells, you use the Border button found on the ________ tab.
Insert
Home
Formulas
View
Formulas in Excel always begin with a ________.
+ (plus sign)
= (equal sign)
- (minus sign)
* (asterisk)
What will the formula `=A1+B1` do?
Add the values in cells A1 and B1
Multiply the values in A1 and B1
Subtract B1 from A1
Divide A1 by B1
Which of the following is the correct syntax for the **SUM** function?
=SUM(A1, A5)
SUM=A1:A5
=SUM(A1:A5)
=ADD(A1:A5)
The **SUM** function is used to ________.
Calculate the total of selected cells
Count the number of cells
Find the average value
Sort data in ascending order
You can use the **AutoSum** button (Σ) to quickly ________.
Sort data alphabetically
Add a group of numbers
Merge cells
Format a table
