WorksheetsQuarter 2 Examination - ICF 9 - Multiple Choices (Excel)
Total questions: 25
Worksheet time: 13mins
Which of the following best describes Microsoft Excel?
A word processing program.
A spreadsheet application.
A presentation software.
A database management system.
In Excel, the intersection of a row and a column is called a _____.
Box
Field
Cell
Grid
What is the correct cell address of the cell located in column B, row 5?
5B
B5
5,B
B-5
Which of the following symbols is used to begin a formula in Excel?
+
=
*
#
What is the purpose of the AutoSum (Σ) button?
To automatically add text
To insert symbols
To calculate the total of a range of cells
To align text to the right
What is the result of the formula =SUM(5,10,15)?
15
25
30
35
If you want to copy the contents or formula of a cell to another, which command should you use?
Cut
Paste Special
Copy and Paste
Undo
Which of the following best describes a chart in Excel?
A list of data
A graphical representation of data
A formula that adds numbers
A type of table for sorting
Which of the following is not a valid chart type in Excel?
Line Chart
Pie Chart
Bar Chart
Word Chart
Ms. Cruz wants to calculate the total sales for her store for January. She entered the sales amounts in cells B2 to B10. Which formula should she use to find the total sales?
=ADD(B2:B10)
=SUM(B2:B10)
=TOTAL(B2:B10)
=PLUS(B2:B10)
Mr. Dela Peña created a grade sheet. He wants to copy the formula in cell D2 down to D10 without retyping it. What should he do?
Use the Fill Handle to drag the formula down.
Type the formula in each cell.
Press Delete and Re-enter.
Click the Sort button.
You are forecasting next year’s profit using the formula Revenue – Expenses. If Revenue is in cell B2 and Expenses in C2, which formula should you use in D2?
=B2+C2
=B2−C2
=C2−B2
=SUM(B2:C2)
Which term refers to the horizontal divisions in an Excel worksheet?
Columns
Rows
Ranges
Tables
In Excel, what is a chart?
A function that calculates data
A visual representation of data
A worksheet format
A text style
In Excel, what is the Ribbon?
The area containing tabs and commands at the top of the window
A function used in formulas
The bottom toolbar
The title bar
What does the term Active Cell mean?
The cell with the formula.
The last cell in the worksheet.
The cell with the smallest number.
The cell is currently selected or being edited.
What does the term formula refer to in Excel?
A preset design for a worksheet.
A command to sort data.
An expression that performs a calculation.
A type of formatting.
Which term refers to the vertical divisions in an Excel worksheet?
Columns
Rows
Sheets
Fields
Your company tracks employees in an Excel sheet with columns: Employee ID, Name, Department, and Salary. You need to find the average salary of the employee. Which function should you use?
=AVERAGE(Salary)
=SUM(Salary)
=SUM(Salary/2)
=AVERAGE(Salary/5)
What is the Formula Bar used for?
To display the chart title.
To enter or edit data and formulas in a cell.
To show sheet names.
To add new worksheets.
Which of the following functions would you use to count the number of cells that contain numbers in a range?
=COUNTA(range)
=COUNT(range)
=SUM(range)
=AVERAGE(range)
What keyboard shortcut is used to copy a selected cell or range?
Ctrl + V
Ctrl + C
Ctrl + X
Ctrl + P
Which of the following is the correct file extension for an Excel workbook?
A.
B.
C.
D.
.docx
.xlsx
.pptx
.txt
Anna entered the formula =A1 + B1 in cell C1. What does this formula do?
Copies the values of A1 and B1 into C1
Multiplies the contents of A1 and B1
Adds the values in cells A1 and B1
Displays the text “A1 + B1” in C1
What happens when you use the Merge & Center command on selected cells?
The cells are combined, and text is centered in the new cell
The text is split into multiple columns
The cells become locked
The values are added together
